Creation & Deletion of Database Snapshot by SQL Agent Job
Some days back, I received one query on my facebook page that user want to create Database Snapshot frequently & want...
2014-09-15
480 reads
Some days back, I received one query on my facebook page that user want to create Database Snapshot frequently & want...
2014-09-15
480 reads
Some days back, I received one query on my facebook page that user want to create Database Snapshot frequently & want to delete the oldest with same frequency. Quite...
2014-09-15
1 reads
Sometime, We caught in a situation where we need to run SQL server in single user mode. Issues like Master...
2014-09-08 (first published: 2014-09-04)
43,755 reads
Sometime, We caught in a situation where we need to run SQL server in single user mode. Issues like Master DB restore, Sysadmin locked out etc. Steps to start...
2014-09-04
3 reads
The 3rdcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 3 contains all the hotfixes released since the...
2014-08-26
The 3rdcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative...
2014-08-26
699 reads
Today, I face issue during one database restore. I am not able to restore because “Database is in use, Not...
2014-08-25
7,018 reads
Today, I face issue during one database restore. I am not able to restore because “Database is in use, Not able to take exclusive lock”. I have killed all...
2014-08-25
24 reads
Renaming or Changing SQL Server cluster instance process is bit different from renaming a stand-alone instance.
Refer : Rename or Change SQL...
2014-08-12 (first published: 2014-08-04)
16,206 reads
Error : Database backup is getting fail with below reason.
The backup of full-text catalog ‘FullTextCatalog’ is not permitted because it is...
2014-08-11
1,126 reads
By Steve Jones
Here are the slides from my talk today: CI in Azure DevOps If you...
By Steve Jones
I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email,...
By Steve Jones
hickering – n. the habit of falling hard for whatever pretty new acquaintance happens...
Comments posted to this topic are about the item Are We Dinosaurs?
Sample query reply appreciated Getting the following error: Conversion failed when converting the varchar...
For the last few weeks every time I get into SSMS 20.2 I am...
What happens with this code:
DECLARE @Iteration INT = 0; WHILE @Iteration < 10 SELECT CustomerName, CustomerStatus FROM dbo.Customer WHERE CustomerID > 3; SET @Iteration += 1;See possible answers