Windows Cluster : Understanding the Quorum settings
In my earlier post, I have explained about the windows cluster and how Sql server works on cluster environment. In...
2012-07-18
3,956 reads
In my earlier post, I have explained about the windows cluster and how Sql server works on cluster environment. In...
2012-07-18
3,956 reads
In my last post I have explained,how to setup alert for blocking using WMI. In this post let us see how...
2012-07-17 (first published: 2012-07-16)
5,558 reads
It was long time I was searching for simple solution to get notification alert in my inbox when ever fail...
2012-07-16 (first published: 2012-07-05)
5,056 reads
As a DBA, it is important for all of us to get real time alert on various issues in our...
2012-07-13
6,666 reads
While troubleshooting the performance issues of SQL server, you might have seen the sessions are in different state like SUSPENDED,RUNNING,RUNNABLE etc....
2012-07-12
8,638 reads
I have heard many time people talking about the NOLOCK hint. Some of them says it improves the performance and...
2012-07-12 (first published: 2012-07-04)
6,713 reads
Two days back one of my colleque came to me and started complaining about the performance of an Stored Procedure....
2012-06-29 (first published: 2012-06-25)
8,939 reads
In my last post , we have gone through the parameter sniffing and possible solutions for parameter sniffing. In the possible...
2012-06-27
3,372 reads
In my earlier post I have explained the steps that we have followed to move the MSDTC and Quorum drive...
2012-06-18 (first published: 2012-06-12)
4,199 reads
What is a Connection Pool?
A connection pool is a group of database connections (with same connection properties) maintained in the...
2012-06-15
7,982 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Dears, Hope this message finds you well We have a log table which is...
Comments posted to this topic are about the item The Backup File Extension
Comments posted to this topic are about the item Ingest and Retrieve data from...
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers