T-SQL Tuesday #88: My Top WTF Moments
Welcome to T-SQL Tuesday #88 being hosted this month by Kennie Nybo Pontoppidan (blog|@KennieNP). This month’s topic is the “daily...
2017-03-14
570 reads
SQL Server Soldier :: News from the frontlines of the database wars
2016/2017 Whitepaper Updates
One of the problems with whitepapers is that they get out of date pretty quickly. It’s important to update them...
2017-03-13
511 reads
The Costs of Hiring Cheaper Consultants
From time to time, I see posts in forums from people complaining about how much some consultants charge. A really...
2017-02-17
582 reads
T-SQL Tuesday #87 – New Way to See Wait Stats for a Single Query
Welcome to T-SQL Tuesday #87 being hosted this month by Matt Gordon (blog|@sqlatspeed). This month’s topic is “Fixing Old Problems...
2017-02-14
662 reads
Warning: Not a valid checkpoint file name
One of the other DBAs I work with noticed a warning message that was flooding the log files on one...
2017-01-30
1,707 reads
Finding Automatic Soft-NUMA
If you already know about Automatic Soft-NUMA in SQL Server 2016, then you probably already read the blog post SQL...
2017-01-04 (first published: 2016-12-30)
2,189 reads
T-SQL Tuesday #85 Part Deux: Backup Myth Restoring Differential Backups
Welcome to T-SQL Tuesday #85 being hosted this month by Kenneth Fisher (blog|@SQLStudent144). This month’s topic is “Backup and Recovery”....
2016-12-13
707 reads
T-SQL Tuesday #85: Backup Log With NoRecovery
Welcome to T-SQL Tuesday #85 being hosted this month by Kenneth Fisher (blog|@SQLStudent144). This month’s topic is “Backup and Recovery”....
2016-12-13
760 reads
T-SQL Tuesday #83: Resource Governor CAP_CPU_PERCENT: It just runs faster?
Welcome to T-SQL Tuesday #83 being hosted this month by Andy Mallon (blog|@AMTwo). This month’s topic is “We’re still dealing...
2016-10-11
692 reads
T-SQL Tuesday #81 – Migrating Databases with Dell LiteSpeed
It’s time for T-SQL Tuesday again, and this month’s host is fellow Certified Master and Data Platform MVP Jason Brimhall...
2016-08-09
643 reads
Blogs
Announcing a New Book on SQL from 3Cloud Authors
By DataOnWheels
I am proud to announce the launch of a new book, centered around the...
Identify the (Top 20) most expensive queries across your SQL Server using Query Store
Script to identify the most expensive queries on your database server using the Query...
Setting Up Always Encrypted
In this post we're going to go through the steps to set up Always...
Forums
TOP with Order By alternative, performance results look mixed
Hi I have a situation where I am testing two versions of the same...
Upgrading an Always on Availability Group two node from SQLServer 2016 to 2019
I'm looking for best practice here and these are Azure VMs by the way....
Azure availability groups requirements question
Does anyone know if Azure absolutely requires windows clustered services to support availability groups?...
Ask SSC