How Can I Tell if SQL Agent is Running via SQL?
Introduction
Today’s post is a continuation in my on-going effort to document all of the scripts I use to manage my...
2010-05-04
395 reads
Introduction
Today’s post is a continuation in my on-going effort to document all of the scripts I use to manage my...
2010-05-04
395 reads
Introduction
Today’s post is going to be a quick one to get back in the saddle again. I have been on...
2010-05-03
394 reads
Introduction
I recently blogged about a Stored Procedure to Sequentially Run SQL Agent Jobs and have been meaning to blog about...
2010-04-22
435 reads
Introduction
I am one of those people that believe that anything worth doing is worth having a script to do it....
2010-04-20
533 reads
Introduction
If you are using SQL Storage for your SSIS packages and have multiple folders to make life easier then there...
2010-04-19
292 reads
Introduction
The stored procedure I am posting today will kill all sessions for users that are members of a given domain...
2010-04-14
477 reads
Introduction
Today I am taking a little detour from the scripts I have been posting to take part in “T-SQL Tuesday...
2010-04-13
424 reads
Introduction
Here is another utility stored procedure that I use. This stored procedure will tell you how a user has access...
2010-04-12
312 reads
Introduction
Trying to keep the streak alive so here is my 5th blog post in 5 days. This one is another...
2010-04-09
1,749 reads
Introduction
I recently moved a database from SQL 2000 to SQL 2005. It was really just a matter of detaching the...
2010-04-08
382 reads
By Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
My knowledge of Extended Events is limited, but I am trying to capture some...
I've got something I'm not aware of performing backups of my dbs at random...
Dear all, I was just wondering: Can you change the default behaviour as illustrated...
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