Have you ever had an error when using a SQL Server Proxy Account? I ran across a misleading error. Let me qualify that a little. It wasn’t misleading in the sense of it saying one thing and meaning another. It was misleading because it’s one of those errors you see… Read more
How do I assign and enforce a service account for the SQL Server Services with Active Directory Group Policy?
The answer to this question requires that we step outside the DBA comfort zone since it requires the use of Active Directory and Group Policy Objects. There are many different ways… Read more
I presented for the PASS DBA Virtual Chapter several weeks ago and talked about different ways that Active Directory can affect your SQL Server. We only had an hour so I had to scale the content back and because of that I had a ton of questions. I answered what… Read more
It was recently brought to my attention that a post with the script I talk about below could not be found on my blog. Either I thought I blogged about it and never did or it got lost when I had to change hosting providers late last year. My apologies… Read more
Things have been too quiet here on the blog, but there’s a reason (a few actually). This year has been nuts for me, but it’s all good stuff! We just moved, and moving a family is not fun. It was a long process from selling the old house to searching… Read more
I am beyond excited to announce that I have been accepted to speak at the annual SQL PASS Summit 2013 in Charlotte, NC. This will be my first time to speak at this event and I can’t wait! The session I will be presenting is titled “How Active Directory Affects… Read more
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.