Move over Poseidon. I’m hitting the sea with my own trident (assuming I can get it through the TSA). My trident is made from the culmination of my favorite three things. My wife, SQL Server, and cruising. Let me explain. Back in October of last year, Idera ran a contest called the “Get a life [...]
Ryan Adams Blog
SQL, Active Directory, ScriptingSQLServerPedia
Browsing Posts in SQL Server
The PASS Performance Virtual chapter is getting a reboot. We all know that responsibilities and schedules change, and that meant this chapter needed some additional hands on deck. Erin Stellato (Blog|Twitter) valiantly volunteered to take the helm and she put out an SOS for volunteers. The response was great with some wonderful people volunteering to help. I [...]
PBM raises errors for policy violations. We can create alerts on those errors to be notified of policy violations. In order to setup alerts on these errors there are three prerequisites. Note that violations for the “On Demand” evaluation mode do not raise errors. A policy must be set to “Enabled” to raise an error, [...]
The Professional Association for SQL Server and the North Texas SQL Server User Group have been working hard behind the scenes to bring SQLRally 2012 in Dallas Texas to the SQL Community. We are excited to announce that event registration opens November 30, 2011. Make sure to get registered soon and take advantage of the [...]
We will walk through creating a policy to evaluate the status of “Auto Create Statistics” on our server named “File2”. First we need to open SQL Server Management Studio and connect to our server. Then we need to enable Policy Management by expanding the Management node, right clicking on Policy Management, and selecting Enable. You [...]
Let’s take a look at how to import the Microsoft Best Practice Policies into your Policy Based Management Server. You can also import policies that you have exported from other servers. The Microsoft Best Practice Policies are a great place to start learning what you can do with PBM, by simply importing them and inspecting their [...]
I will be live blogging the SQLPASS Summit keynote again today. Today’s keynote will be delivered by community favorite Dr. David Dewitt. Rick Heiges opens us up and introduces a special musical number by Rob Farley and Buck Woody. It was hilarious with a special lyrical shout out to Paul Randal. Rick is now walking [...]
I was chosen to sit at the blogger table and live blog the keynote tomorrow so plan to be here at 8:15pt and I’ll refresh the post that day as often as possible. I may not be at the table today, but that won’t stop me from blogging anyway. Keynote Rushab Mehta starts us out [...]
Today was my travel day. I don’t travel much at all so it’s always an exciting adventure for me. I left the house with plenty of time and made it to the Parking Spot in about 40-45 minutes. If you travel out of DFW international airport I highly suggest using these guys for parking. The airport [...]
This morning I headed over to Top Pot doughnuts to hang out with Andy Warren, Steve Jones, Bill Fellows, David Fargo, Tim Radney, and many others. It was a nice time of networking and a good small crowd. The doughnuts were good with a large and interesting selection and the coffee was good as well. [...]
