Archives: December 2012
This blog post is in response to a request/comment from Thato in this previous article. Hence, I have taken much of the logic used in the aforementioned article and changed it from static to dynamic file compression. Thus, I am still using SQL Server Integration Services‘s Execute… Read more
5 comments, 87 reads
I don't have much knowledge on Nosql and Linux system, so I am going to setup a testing environment on my laptop in holidays
1. download CentOS Linux setup iso file
2. download java jdk 1.6
As you might be aware, SQL Server 2012 Standard Edition has some hardware-related licensing limits that I think should be adjusted in light of the capabilities of modern, commodity server hardware.
As a DBA and consultant, I would like to see everyone running SQL Server 2012 Enterprise Edition. It has… Read more
Here is the December 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to a couple of the existing queries. There is also one new query at the very end, adapted from my colleague, Erin Stellato.
To go with it is…
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront. As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.
Some posts from… Read more
Last week, I presented on extended events at the Minnesota SQL Server user group (PASSMN). The turnout was quite excellent and I expect at least a few people will be interested in the materials that were presented.
Last week I mentioned that I had put up a few new versions of my index analysis script. Turns out a few people downloaded it and found some issues. I also have been playing with it some more and noticed some quirks that were a bit irritating to me, so… Read more
If you blog and call yourself a blogger then you probably have a pretty full RSS reader. Mine has been added to considerably over the years. Well I signed into my Google reader account today and I realised that there is a lot of blogs that either I don’t read… Read more
Microsoft today announced the latest round of SQL Server Cumulative Updates
SQL Server 2012 CU 5 – You can get more information here
SQL Server 2008 SP2 CU 4 – You can get more information here
SQL Server 2008 SP1 CU10 – You can get more information here
This might… Read more
This is a guest post by David Postlethwaite.
I’ve been wondering how to do this for years. At SQL Bits and SQL Saturday the presenters make the results window disappear with a keyboard click but I could never work it out.
Well today I was working on a query and…
With the upcoming PASS Business Analytics Conference, it only makes sense for there to be a 24 Hours of PASS to go a long with it. And have no fear, that is what is coming your way on January 30, 2013.
In a bit of a departure from previous… Read more
Last Friday I went for a quick run before we packed up and headed to Steamboat Springs for a week’s vacation skiing with the family. Saturday I snowboarded, came back to the condo, found no treadmill, slippery, icy conditions on the roads, and just stopped running.
No fanfare, no complaints,… Read more
If you are interested in viewing the recorded sessions for the PASS Summit 2012, you can order them on a USB flash drive or view them online. You can purchase the Regular Summit Sessions as well as the Pre-Conference Sessions. However, if you are interested in the sessions from 2011… Read more
I’m on holiday, but I have a set of predictions for 2013 coming on Jan 1. This is a little notice in hopes that a few of you might join in to the meme and make a few predictions for 2013.
Database related, technology related, car related, write a few… Read more
We know that we need to take special attention about NULL values while writing queries because they may lead us into writing incorrect query logics. NULLs may also affect the performance of aggregation function MAX() and MIN(). I have submitted this issue to Microsoft Connect. There are number of… Read more
I sincerely wish that everyone enjoyed their recent holidays and recent downtime with family, and pass on my hope for peace, happiness and health for 2013.
The goal of this post is to aid in the understanding of the procedure cache and execution plans to ensure we use fewer resources,… Read more
- Elements(can be used with raw,auto,path)