All of our SQL Server instances need benchmarks! So the title is somewhat of a trick question… I hear and sense a lack of priority around taking periodic benchmarks in a system with a lot of folks. How often do you take benchmarks? Do you know what “normal” means for your system? Do you know … Read more
It is August First. The opening day of #active august (twitter search, my initial post on it). There are several others participating which makes it good for encouragement and accountability. I am going to weigh in every Saturday and try and keep the daily progress notes on twitter. I have not done a SQL blog … Read more
I occassionally post some blog entries about my faith and family or both. These posts may or may not touch on SQL Server and this is one of them. I discussed this when I first blogged about Jesus’ last words on the cross (Tetelestai). I welcome you to read or skip and I won’t be … Read more
Alright so the other day I was congratulating SQL Server Extraordinare Chuck Boyce on twitter. He has lost some weight following a low carb diet and he is doing great with it. In the process I joked about how I fell off the wagon for “Fit February” and thought aloud of starting to have an … Read more
How many times have you heard or uttered those words? You work hard and understand the business requirements, you try and get the logic to work to make the procedure return what was expected or update the data as expected. You do some unit tests in your environment, it may not scream but it comes … Read more
Lately there have been a lot of great blog articles with active discussions talking about questions to ask potential SQL Server DBA or Developer candidates. Off the top of my head (and by means no offense implied to the many others, check out my blog roll for some of the blogs I try and keep … Read more
So I wrote a lot of posts around shrinking (Here, here, here). Some of my posts were turned into a wiki article on SQLServerPedia. I thought I was done posting about this but one more. I talked about why we shouldn’t do it on a regular basis. Why it should really be reserved for use … Read more