Why does sqlpackage.exe not compare after the pre deployment script has run?
It isn’t a Pre compare script
When you use SSDT to deploy your dacpac, a pre deployment script lets you run...
2015-06-24
83 reads
Adding Extended Properties to a Table
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2015-07-03 (first published: 2015-06-24)
6,418 reads
Why does sqlpackage.exe not compare after the pre deployment script has run?
It isn't a Pre compare script
When you use SSDT to deploy your dacpac, a pre deployment script lets you run some T-SQL scripts before the script which brings your...
2015-06-24
25 reads
Some simple examples of querying xml with sql
XML is a beast if you've never tackled it. Here are some simple examples of what I discovered as I...
2015-06-30 (first published: 2015-06-24)
2,920 reads
Use 100% Fill Factor on Insert Only Tables
SQL Server has the concept of fill factor for leaving extra space in pages to reduce the number of page...
2015-06-24
809 reads
SQL Cruise Mediterranean+
This is a post that is looooong overdue. I have intended to write some of this at least since the first SQL Cruise I attended back in 2013 (in...
2015-06-24
22 reads
SQL Cruise Mediterranean+
This is a post that is looooong overdue. I have intended to write some of this at least since the...
2015-06-24
668 reads
Which user function do I use?
Earlier this week I was scripting out a table with some legacy columns (InsertDate and InsertBy for example). If you...
2015-06-30 (first published: 2015-06-24)
2,097 reads
SQL Code Guard - Developer build: just as planned
Well, not exactly just as planned, but at last!
Few minor fixes
[*] fixed unparsed with CONTAINS condition[*] fixed xtra "ST010 Use...
2015-06-24
636 reads
Some simple examples of querying xml with sql
XML is a beast if you’ve never tackled it. Here are some simple examples of what I discovered as I...
2015-06-24
299 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions
Comments posted to this topic are about the item Stairway to DAX and Power...
AI Is Improving Security
Comments posted to this topic are about the item AI Is Improving Security
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers