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
599 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
8 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,216 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
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
415 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
456 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
546 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers