How Do I Move SQL Database Files Around?
Introduction
Today’s script is one that I had not planned on blogging so soon but since Paul Randal just talked about...
2010-05-11
601 reads
Adventures in SQL
How Do I Move SQL Database Files Around?
Here is a script that will generate a script to move database files around in SQL 2005/2008. Continue reading ?
2010-05-11
19 reads
How Do I Move SQL Database Files Around?
Here is a script that will generate a script to move database files around in SQL 2005/2008. Continue reading ?
The post How Do I Move SQL Database Files Around?...
2010-05-11
2 reads
Where Do I Start with PowerShell?
Introduction
This morning I set out to get some information about getting started in PowerShell for a coworker. Rather than spend...
2010-05-06
3,219 reads
Where Do I Start with PowerShell?
This morning I set out to get some information about getting started in PowerShell for a coworker. Rather than spend a bunch of time searching for different sites I...
2010-05-06
13 reads
Where Do I Start with PowerShell?
This morning I set out to get some information about getting started in PowerShell for a coworker. Rather than spend a bunch of time searching for different sites I...
2010-05-06
3 reads
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
413 reads
What is a Good Way to Get the SQL Server Log Directory?
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
420 reads
What is a Good Way to Quickly Disable SQL Agent Job Schedules?
Introduction
I recently blogged about a Stored Procedure to Sequentially Run SQL Agent Jobs and have been meaning to blog about...
2010-04-22
460 reads
Whats a Good Rule for Max Degree of Parallelism?
Introduction
I am one of those people that believe that anything worth doing is worth having a script to do it....
2010-04-20
555 reads
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers