Default Backups and Feature Awareness
Default backup schemes for databases would be a nice enhancement.
2019-05-08
251 reads
Administration
SQL SERVER – Script to Kill All Inactive Sessions – Kill Sleeping Sessions from sp_who2
I consider myself fortunate that I get to work with so many different clients while engaged in Comprehensive Database Performance Health Check. Recently we found out that one of...
2019-05-06
Error -2068643839 / 1602 Installing msoledbsql.msi and msodbcsql.msi for SQL Server 2019 CTP 2.5
(last updated: 2019-05-05 @ 11:55 EST / 2019-05-05 @ 15:55 UTC ) I had gone through the process of uninstalling the now obsolete SQL Server 2019 CTP, and then...
The...
2019-05-05
Track SQL Server Database Recovery Progress – ErrorLog
This question has come up many times how to capture the SQL Server Database Recovery Progress or Total time take to recover a database. It will help to plan...
The...
2019-05-04
Don’t Forget RoboCopy
On occasion you have to find means to get around an issue. John Morehouse shows why Robocopy can be a useful tool in testing circumstances.
2019-05-03
Find-and-Replace for SQL Server Agent Jobs
Once in a while you might need to make common changes to a lot of SQL Server Agent Jobs.
2019-05-03
Is Your Availability Group ‘REALLY’ Ready To Failover?
You know what it’s like, you need to fail your AG over but is it safe to fail over? Even if your AG says it is, there are other thing to consider...
2019-05-03
491 reads
Minimal Logging with INSERT…SELECT into Heap Tables
Achieving minimal logging with INSERT...SELECT can be a complicated business.
2019-05-02
No, This is not a Bug in T-SQL
Gail Shaw keeps seeing this in all sorts of places. People getting an unexpected result when working with a subquery, typically an IN subquery, and assuming that they’ve found...
2019-05-02
Generate script to recreate indexes
For me, this particular code to generate a script to recreate indexes has more practical use in a replication environment.
For example, the default replication setting is to exclude the...
The...
2019-04-26
Blogs
A Couple Quick GENERATE_SERIES Tests
By Steve Jones
I had someone reach out about generate_series() recently, saying they hadn’t realized this was...
How I passed the DP-700 Exam
I recently took and passed the DP-700 exam, which is required for the Microsoft...
Which approach to take: Build it, buy it, cloud it?
As a Consultant, I would typically answer with – it depends! Then a typical...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
How to Download and Restore AdventureWorks 2019 Database
Comments posted to this topic are about the item How to Download and Restore...
Tracking Table Sizes
Comments posted to this topic are about the item Tracking Table Sizes
Question of the Day
Counting Bits IV
What does this code return in SQL Server 2022+?
select bit_count(2.4)See possible answers