Do you have a policy that is supposed to include “Every Database” as part of its condition, but for some reason it never includes the […]
Category: SQLServerPedia Syndication
All posts in this category get syndicated to SQLServerPedia.com
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 […]
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 SQLSaturday in Houston, where John […]
syspolicy_purge_history Job Fails
The syspolicy_purge_history SQLAgent job is used by Policy Based Management in SQL server to clear out the policy evaluation history kept by PBM. The job consists […]
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 mirroring. Mirroring is easy to […]
SQLRally 2012 Dallas
It’s Official !! The host for SQLRally 2012 has officially been given to Dallas and the North Texas SQL Server User Group. NTSSUG is elated […]
Don’t develop SSRS reports in the wrong version
I had an interesting issue a couple of months ago while creating an SSRS report. I developed my report in BIDS, built it, and previewed […]
You must be logged in to post a comment.