How to move the MSDB database
First we need to know the name and file location of the MSDB database files. When you change the location, make...
2011-07-13
953 reads
Ryan Adams
How to move the Model Database
First we need to know the name and file location of the Model database files. When you change the location, make...
2011-07-12
6,518 reads
How to move the Master database
The catch to moving the Master database is that you must also move the Resource database. Microsoft states that the...
2011-07-11
1,366 reads
How to add your CMS server to a group
You cannot add a connection to your CMS server, on your CMS server. Well that is what I thought until...
2011-07-06
1,313 reads
T-SQL Tuesday Mirroring and SSWUG
This month’s T-SQL Tuesday is hosted by Allen Kinsel (Blog|Twitter) and covers “disasters and recovery”. My favorite DR solution is...
2011-06-14
697 reads
Blogs
Scooby Dooing Episode 9: The Case of the Artificially Intelligent Villain
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
The Book of Redgate: Don’t be an a**hole
By Steve Jones
This was one of the original values: The facing page has this text: No...
Beyond Pipelines: How Fabric Reinvents Data Movement for the Modern Enterprise
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Are things getting beyond reason?
My wife apparently ask her phone a question and below is what she sent...
I Love Editorials
Comments posted to this topic are about the item I Love Editorials
Question of the Day
A Common Split
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers