Policy Based Management has 4 evaluation modes and if you are not already familiar with them you can go HERE to get more information. Today I want to talk about the “On Change: Prevent” mode and why you don’t always see it as an option.
The options you see available… Read more
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 actually have had the laptop renamed for awhile without any issues, but it’s not production and I don’t use it every day. I first encountered… Read more
I blogged about this back in September of 2010, but technology changes so it’s time to revisit this again. Now I’m not anything even close to a marketing expert, but I’ve been the Director of Logistics and Communications for the North Texas SQL Server User Group for the past… Read more
This post is a live blog of the PASS Summit 2012 keynote from day 2 on 11/8/2012. This post is intended to be a live note taking.
Douglas McDowell opens day 2 by giving an overview of the health of the PASS organization. This year PASS has added an additional… Read more
This post is a live recap of the keynote at the PASS Summit 2012 conference.
Bill Graziano opens Summit 2012 with 3894 attendees.
Bill recognizes local and virtual chapter leaders as well as SQLSaturday event organizers.
The PASS BA conference is announced to be in Chicago in April.
Bill introduces… Read more
I’m not a politically minded person and this is not the type of post I would normally write. However, I’m deeply involved with the PASS organization (read chronic volunteer) and I have a vested interest in it’s success. The reason I decided to write this is because I have very… Read more
I ran across the following error in SQL Reporting Services 2008 R2 a few weeks ago:
The report execution has expired or cannot be found. [rsExecutionNotFound]
This report contains a very large dataset, so my first inclination was that there was some query tuning and indexing review that needed to… Read more
I’m officially on the slate and running for the PASS 2012 Nomination Committee!
I love the SQL Community and everything it embodies. I am very involved at the local and regional level and gained a unique view into PASS working on SQLRally. I know most of the current and past… Read more
I was fortunate enough to get to present not 1 but 2 sessions at SQLRally 2012 in Dallas last week. As a core organizer of the event, this really made it a special week to present twice and see it all come together. My first session was a community choice… Read more
Things have been quiet around here lately and I have a one word explanation….SQLRally. There’s work and family and several other community commitments, but mostly SQLRally. The good news is that the time has come and I couldn’t be more excited. I haven’t been to a SQLSaturday or community event… Read more
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 much easier to hunt down. I did some digging through the SQL logs and DMVs, but did not find anything that indicated SQL was dropping… Read more
I just found out that I will be speaking at SQLRally Dallas in May. I submitted 3 sessions. As an event organizer, all 3 automatically went to community vote. I am very excited that my Mirroring session was voted in. Thank you to everyone who voted for me!
I will be speaking for the PASS DBA Virtual Chapter on February 22nd, 2012. I will be delivering my presentation on Mirroring.
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… Read more
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… Read more
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… Read more
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… Read more
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… Read more
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… Read more