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
945 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,216 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,346 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,288 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
695 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...