Failed SSIS Build – DtsRuntimeException
Hello!
I was helping a team debug a failed build today. Despite the fact that the build compiled on the devs...
2017-10-06
319 reads
Automate Parameterising SSIS Connection Managers
Hello!
Back when SQL Server 2012 was known as Denali, one of the new and exciting features released was that all...
2017-10-11 (first published: 2017-10-06)
2,418 reads
SQL Server Features Comparison at IaaS vs PaaS vs On Premise
Hello friends, Please find the link for my blog here – https://social.technet.microsoft.com/wiki/contents/articles/40295.sql-server-features-and-basic-comparison-at-iaas-vs-paas-vs-on-premise.aspx
2017-10-05
538 reads
girls + data is coming to SQL Saturday Charlotte
I am so excited to be part of the organizing team for SQL Saturday Charlotte again this year, the CBIG...
2017-10-05
371 reads
Visual Studio 2017 Irritants From the SSIS Developer View
I was among the many Integration Services (SSIS)/Database (DB) developers out there that cheered when Microsoft finally announced support for...
2017-10-05
812 reads
Compound FKs with SQL Data Generator
This is a series on SQL Data Generator, covering some interesting scenarios I’ve run into. If you’ve never tried it,...
2017-10-05
1,329 reads
How Far Has My Update Got? Finding Out How Many Rows Your Long Running Insert, Update or Delete Has Actually Modified So Far
I’m pretty sure that we’ve all found ourselves in the situation where we’ve run an INSERT, UPDATE or DELETE script...
2017-10-05
191 reads
Ebook: Putting Your Head in the Cloud: An Introduction to Cloud Computing and Azure SQL Database
David is delivering his Microsoft Azure for the SQL DBA talk this weekend in SQL Saturday Denmark. Go and see...
2017-10-05
505 reads
Toolbox - Fix Your FILEGROWTH
One of the items we usually flag in reports is FILEGROWTH by percentage. It doesn't help that for most versions...
2017-10-10 (first published: 2017-10-05)
1,838 reads
dbatools Badge Ribbons at PASS Summit
One of the (many) fun things to do at PASS Summit is to check out the ribbons people have attached to their badges. Some are witty or goofy, others...
2017-10-05
13 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