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,862 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,941 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)
37,950 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,933 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,624 reads
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Hi All, Can an INSERT statement block SELECT statements? not sure why ? Can...
Hi! How\Steps to setup Extended events to capture query causing tempdb log getting full?...
Hi, I have a table that stores event transactions, the sample data see the...
Ask SSC