Yes, it is. As I mentioned a few months back, it is important to pay attention to when Microsoft releases Cumulative Updates for SQL Server. This past week, on Tuesday, Microsoft release an update to SQL Server 2008: Cumulative update package 10 for SQL Server 2008 Service Pack 1 If you haven’t, take the time … Continue reading Is It that Time Again?
This past weekend I went to SQL Saturday 50 – this is a day long SQL training event that is put together by community volunteers. I was fortunate enough that I was selected to present at this event. Since others have already shared their experiences at the event I figured I should as well. Some … Continue reading SQL Saturday 50 (#sqlsat50) – A Tale
As I mentioned in my TSQL2sDay index summary post, the I am writing a few posts on the information that is contained in sys.dm_db_index_operational_stats. The posts will be the following: Index Black Ops Part 1 – Locking and Blocking Index Black Ops Part 2 – Page IO Latch, Page Latch Index Black Ops Part 3 … Continue reading Index Black Ops Part 2 – Page IO Latch, Page Latch
As I mentioned in my TSQL2sDay index summary post, the next few posts will be on sys.dm_db_index_operational_stats and the information that the DMV contains. In this post, we are going to look at the locking and blocking columns. Base Columns Before we jump over to the meat and potatoes, let's first take a look at … Continue reading Index Black Ops Part 1 – Locks and Blocking
Here we are with another T-SQL Tuesday and time for my entry into the fray. This month we are talking about indexes. This is great timing because I’ve been meaning to write about indexes for a while. A few months back I had outlined a number of articles I wanted to write and have been … Continue reading An Index on Indexing #TSQL2sDay
Have you taken the time to plan a fall get-away for some free SQL Server training? You can do this through some of the one-day SQL Server training event happening across the country. These are great opportunities to learn more about SQL Server and network with your peers that are using it every day. Whether … Continue reading SQL Saturday Glory
A couple weeks back someone asked me some questions about data types. Apparently, while implementing some financial data, each developer on the project had chosen their own data type. This was a bit of a problem that can lead to serious problems. When financial data is rounded unexpectedly - bad things can sometimes happen and … Continue reading Find Tables and Columns by Data Type
It’s been a busy week and I haven’t been able to put the time in to picking the winner for the MSDN Ultimate Subscription contest I was running through July 31st. I know I suck. Tonight during a client’s SQL Server 2008 migration I took a couple minutes to write down the names of each … Continue reading MSDN Ultimate Subscription Winner
I’ll be speaking for the SQL PASS Database Administration Virtual Chapter next week. It’ll be on July 28 at 12 PM Eastern time. The topic will be Using XML to Query Execution Plans. The abstract for the event is the following: SQL Server stores its execution plans as XML in dynamic management views. The execution … Continue reading Webcast Next Week – Using XML to Query Execution Plans
I’ll be speaking for the SQL PASS Performance Virtual Chapter later today starting at 12 PM Eastern time. The topic will be Performance Impacts Related to Different Function Types. The abstract for the event is the following: User defined functions provide a means to encapsulate business logic in the database tier. Often the purpose of … Continue reading Webcast Today – Performance Impacts Related to Different Function Types
Strate SQL 