tSQLt Test Adapter for Visual Studio 2017
So Visual Studio 2017 has been released a while and I had created a version of the test adapter (which...
2017-10-03
628 reads
tSQLt Test Adapter for Visual Studio 2017
So Visual Studio 2017 has been released a while and I had created a version of the test adapter (which...
2017-10-03
87 reads
tSQLt Test Adapter for Visual Studio 2017
So Visual Studio 2017 has been released a while and I had created a version of the test adapter (which...
2017-10-03
94 reads
tSQLt Test Adapter for Visual Studio 2017
So Visual Studio 2017 has been released a while and I had created a version of the test adapter (which lets you run tSQLt tests from within Visual Studio...
2017-10-03
15 reads
Setting up Change Data Capture (CDC)
As mentioned in my post Auditing Data Access in SQL Server for GDPR Compliance CDC can be a useful tool for...
2017-10-03
17,709 reads
Introduction to SQL Server replication
This time I'll talk about some basis with SQL Server replication, whether you need it for High availability (HA), Disaster...
2017-10-03
729 reads
VS Code: PowerShell and focusConsoleOnExecute
If you're used to the behavior of SSMS or PowerShell ISE where upon executing code in the script panel, your...
2017-10-03
498 reads
Always update your views
I last posted about changing a table without changing a view that represents the table and how this may affect...
2017-10-03
364 reads
Book Review: High Performance SQL Server
As SQL Server professionals, we sometimes encounter some issues that we haven’t seen before or have seen already but forgot...
2017-10-03
395 reads
The New CU Schedule
Is my math right? The new CU servicing schedule for SQL Server 2017 is:
1 CU per month for the first...
2017-10-03
1,081 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