Reputation
558
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 6 16
Newest
 Commentator
Impact
~43k people reached

  • 0 posts edited
  • 0 helpful flags
  • 16 votes cast
Apr
4
awarded  Commentator
Apr
4
comment Is there a concept of an “include file” in SQL Server?
SSDT scripts are sqlcmd scripts. That's how it handles parameters, both user-defined and things like the database name. If you want to deploy the DACPAC using SqlPackage.exe, this link shows how to pass along sqlcmd parameters. msdn.microsoft.com/en-us/…
Apr
3
comment Is there a concept of an “include file” in SQL Server?
I don't think SQLCMD will be depreciated because it is so vital to how SQL Server Data Tools and DACPACs work.
Apr
3
comment Is there a concept of an “include file” in SQL Server?
I am using it heavily in SQL Server Data Tools projects. It really helps when I'm trying to organize the sample data that runs as a post script.
Apr
1
awarded  Nice Question
Feb
9
awarded  Nice Question
Jan
18
comment Is there a penalty for using BINARY(16) instead of UNIQUEIDENTIFIER?
I can't say I completely follow the explanation about byte ordering, but it is making me think about indexing. Would uniqueidentifier be more or less likely to result in index fragmentation than binary?
Jan
18
comment Is there a penalty for using BINARY(16) instead of UNIQUEIDENTIFIER?
I would assume the GUIDs are generated in the application, as I don't see them in the database.
Jan
18
awarded  Curious
Jan
17
awarded  Nice Question
Jan
17
comment Is there a penalty for using BINARY(16) instead of UNIQUEIDENTIFIER?
Yes, thankfully I don't have to deal with implicit casts as well.
Jan
17
accepted Is there a penalty for using BINARY(16) instead of UNIQUEIDENTIFIER?
Jan
17
comment Is there a penalty for using BINARY(16) instead of UNIQUEIDENTIFIER?
Yes, it was migrated from I think MySQL. And yes, there are lots of... interesting things to look at.
Jan
17
asked Is there a penalty for using BINARY(16) instead of UNIQUEIDENTIFIER?
Jan
15
comment Perform admin tasks (e.g. create database, add diagram support) in SQL Server when not connected to domain
That doesn't work any more. I don't know if it is a change in SSMS or Windows, but it is most frustrating.
Oct
5
awarded  Notable Question
Jul
6
awarded  Custodian
Jul
6
reviewed Approve Unexpected SELECT permissions
Jul
6
answered Unexpected SELECT permissions
Jul
6
asked Unexpected SELECT permissions