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)
435 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)
5,876 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
964 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,704 reads
When you are working on the AlwaysOn feature, it is crucial to understand how the AlwaysOn commit process works. This...
2018-08-15
3,195 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)
17,220 reads
There are many times you as DBA or Developer needs to get all row count from all tables or row...
2018-08-13
1,459 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,366 reads
In this blog, I am NOT going to discuss the SQL Server licensing model. If you are looking for that...
2018-08-03
1,302 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
32,140 reads
“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...
One of the most powerful permissions available in SQL Server is control. But what...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hello, I'm trying to get the server name programmatically. Even after I do this:...
Hello, I'm trying to determine if there's a way to get a server's alias...
I have created a second instance of a tabular server on the same server...
Ask SSC