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...
2019-05-16 (first published: 2019-05-04)
443 reads
An interesting issue regarding SQL Server Transaction Replication/CDC log reader agent job can’t be started with the following error:
Msg 18752, Level...
2018-09-19 (first published: 2018-09-10)
7,949 reads
I was playing with SQL Azure on my brand new Surface pro device. I open the Windows Powershell ISE as administrator to...
2018-09-19
1,104 reads
As the business requirement, It is very common to see a request for adding a new article or subscription to...
2018-08-22 (first published: 2018-08-06)
1,863 reads
When you are working on the AlwaysOn feature, it is crucial to understand how the AlwaysOn commit process works. This...
2018-08-15
4,944 reads
With SQL Server 2016, Microsoft is installing SQL Server Telemetry or CEIP (Customer Experience Improvement Program) Services by default. It...
2018-08-13 (first published: 2018-07-30)
38,072 reads
There are many times you as DBA or Developer needs to get all row count from all tables or row...
2018-08-13
5,959 reads
In the SQL Server AlwaysOn setup, whenever you are using a listener to connect to a secondary node, you have...
2018-08-10 (first published: 2018-07-26)
2,535 reads
In this blog, I am NOT going to discuss the SQL Server licensing model. If you are looking for that...
2018-08-03
2,441 reads
Yesterday, I was doing SQL Server Database stress and benchmarking testing on the client side. When I started ramping-up more...
2018-08-02
87,915 reads
By Steve Jones
Next week I’m heading to the Lowry Conference Center in Denver for the RMOUG...
By Steve Jones
Today’s coping tip is to go to bed in good time and allow yourself...
By SQLBalls
Hello Dear Reader! After a weekend with a lot of activities, it was a...
Hi folks, I have a single Postgres instance on RDS that in the past...
hi, IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME ='abc' AND COLUMN_NAME IN...
Comments posted to this topic are about the item Coaching the Digital Transformation
Ask SSC