I dont use the Visual Studio SSDT Publish
I see questions pretty regularly on stack overflow and the ssdt msdn forum that is some variation on “I am...
2015-08-19
44 reads
Blog Posts
I don't use the Visual Studio SSDT Publish
I see questions pretty regularly on stack overflow and the ssdt msdn forum that is some variation on "I am...
2015-08-19
878 reads
Tables, Columns and Defaults Oh My!
The joys of inheriting a new database and being thrown into the fire to quickly assimilate as much information about the database as possible can be troublesome. This script...
2015-08-19
2 reads
Time to Change
I recently spent two days consulting with a company on their database development and deployment processes. They are a small, capable, team...
2015-08-19
756 reads
We Don’t Trust This Data
“Learning to trust is one of life’s most difficult tasks.” – Isaac Watts
As data professionals, there are times when our jobs...
2015-08-19 (first published: 2015-08-14)
2,989 reads
Why You Should Care About Microsoft APS and Azure SQL Data Warehouse
Last week, I gave a presentation about SQL Server’s data warehouse capabilities, and specifically about APS (Analytics Platform System) and...
2015-08-19
1,132 reads
Are you Ready to Use Power BI?
What! NO? Get with it, my friend. Power BI is for everyone. All the kids are doing it… not to...
2015-08-18
468 reads
Are you Ready to Use Power BI?
What! NO? Get with it, my friend. Power BI is for everyone. All the kids are doing it… not to...
2015-08-18
254 reads
Create a SQL Azure Database–Old Portal
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2015-08-18
1,011 reads
Generating Estimated Plan and the Plan Cache
Does generating an Estimated Plan cause that plan to be loaded into the plan cache?
No.
What? Still here? You want more?...
2015-08-18 (first published: 2015-08-10)
1,784 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers