RYANJADAMS
-
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 the same location as the Master database. You can see their instructions HERE on how to move the Master database. However, on my cluster I did not find the Resource…
-
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 Sterrett (Blog|Twitter) pointed out that you can use an IP address. I think Microsoft prevents this primarily because you already have a connection defined for it simply by virtue of it…
-
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 three steps. First to check to see if PBM is enabled and exit if it is not. Run the msdb.dbo.sp_syspolicy_purge_history system stored procedure to clear the history Use…
-
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, if implemented properly. It’s a database level solution that allows you to keep a remote copy of your database in sync with your principal database. Everything is…
-
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 chosen as the host for this event. We have hosted three SQLSaturdays in the last 12 months, so we are prepared to dig in our heals. Well,…
-
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. I was also able to deploy it to my RS server just fine, but when I viewed the report from the browser I got a cryptic error…
-
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 VBScript to make it easy to find these accounts for anyone with little AD experience. I posted the script in the Microsoft Scripting Guys’ community script repository…
-
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 can be accessed from this computer” Old Solution This is certainly not the first time I have seen this error, and the situation is always different. Most…
-
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 the first and only BI focused event) in twelve months for the North Texas SQL Server User Group and we’re proud of that. I’m on the board of directors…
-
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 the board of directors for the group as the Director of Logistics and Communication, and he wanted the point of view from a user group leader. I…