-
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 of the following… Continue Reading
-
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 setup and fast,… Continue Reading
-
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 to have been… Continue Reading
-
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 it just fine. … Continue Reading
-
AD Password Never Expires Utility
A few years ago I had a need to find all accounts in Active Directory that had the “Password Never Expires” option set. I wrote an HTA with… Continue Reading
-
SQL Reporting Services – The report server is not responding
Today I received the following error on one of my SQL Reporting Services Servers. “The report server is not responding. Verify that the report server is running and… Continue Reading
-
SQLSaturday 63 Wrap-up
If you have ever helped organize a SQLSaturday you know how hard it can be and how much time is required. This was the third (one of which was… Continue Reading
-
TechNet Radio Interview
A couple months ago, one of our local Microsoft Evangelists asked me if I would do a TechNet Radio interview about the North Texas SQL Server User Group. I’m on… Continue Reading
-
My DSN Does Not Work on Windows 64bit
How to create a DSN on Windows 64bit for your 32bit application Continue Reading
-
SQL Naming Conventions with PBM – SPs
How to enforce a stored procedure naming convention with policy based management. Continue Reading
-
SQL Nomenclature
You should have a SQL object naming convention. Enforce it with Policy Based Management. Continue Reading
