Changing the version of an SSIS package.
Of all of the annoying parts of SSIS, the major version sensitivity has to be the most annoying. Let’s say...
2017-09-06 (first published: 2017-08-23)
3,524 reads
Blog Posts
Connect Windows 10 client to a VPN on Windows Server 2012 R2
I got a strange request in a Slack channel the other day. A colleague in South Africa, who uses Windows,...
2017-09-06
395 reads
Dynamic Threshold for Statistic Update - SQL Server 2016
By default, on a SQL Server Database, statistics are updated automatically when one hits a threshold of changes. If the Auto Update Statistics setting is turned on by default,...
2017-09-06
1,596 reads
Dynamic Threshold for Statistic Update - SQL Server 2016
By default, on a SQL Server Database, statistics are updated automatically when one hits a threshold of changes. If the Auto Update Statistics setting is turned on by default,...
2017-09-06
27 reads
Exploring the Kubernetes dashboard in Azure Container Services
Last week I went through how to run SQL Server in Kubernetes on Azure Container Services (ACS)
This week I want...
2017-09-06
844 reads
Runtime Metrics In Execution Plans
Capturing query execution metrics is much easier now that you can see the runtime metrics in execution plans when you’re...
2017-09-06 (first published: 2017-08-22)
1,609 reads
SQL Server on VMware VMworld USA Videos Now On YouTube
I just realized that our two SQL Server on VMware sessions that I co-presented on Tuesday at VMworld USA, both of which made the top...
2017-09-06
143 reads
Game Night is Back at the Summit
Last year Andy Warren and I worked out a deal with the PASS organization to sponsor a game night on...
2017-09-05
783 reads
How to Safely Parameterize Table Names
Protecting against SQL Injection Part 2
Watch this week's video on YouTube
Last week we talked about building dynamic SQL queries and how doing so might leave you open to SQL injection...
2017-09-05
25 reads
Learn how to unit test SQL Server T-SQL code
A free email course on how to use tSQLt including the technical aspects of writing unit tests AND the art...
2017-09-05
402 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
does anyone used https://github.com/ktaranov/sqlserver-kit
Could you please let me know if anyone is used https://github.com/ktaranov/sqlserver-kit github for deployment...
How Can Database Performance Improve the Overall Website Experience?
I’ve been looking into ways to improve the connection between a website and its...
When And How to Automate?
Comments posted to this topic are about the item When And How to Automate?
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers