I recently had to rename my laptop on which I have two SQL server instances. I have a default instance and a named instance. I […]
Tag: SQL Server
Configure Anti-Virus on your SQL Server
This week I had an application team report the error “SQL Connection Lost”. Fortunately they also reported the exact times of occurrence, which made it […]
How to move Cluster MSDTC Drive
I recently had the need to move the MSDTC for a cluster to a new SAN drive. It’s a quite simple thing to do, but you can’t redirect […]
SQLAgent Error 435
Do you get error 435 in the Application event log and your SQLAgent fails to start? The reason you’re getting this error is that the SQLAgent […]
How to move the TempDB Database
Note that TempDB is recreated every time SQL starts. Why is this important? It means we don’t have to move the physical file on the file […]
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 sure to keep the same name. […]
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 sure to keep the same name. […]
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 Resource database must reside in […]
My DSN Does Not Work on Windows 64bit
How to create a DSN on Windows 64bit for your 32bit application
SQL Naming Conventions with PBM – SPs
How to enforce a stored procedure naming convention with policy based management.
You must be logged in to post a comment.