Archives: May 2010
A holiday in the US, commemorating the men and women who have died in the service of our country.
Most years in the US, I’ve spent the day with family, starting summer, and while we remember those in the military, it’s primarily been a time where we spend time… Read more
One of my favorite people in the SQL community, Andy Leonard, posted a blog criticizing the selection process for the pre and post cons at PASS. http://sqlblog.com/blogs/andy_leonard/archive/2010/05/30/pre-conference-sessions-at-the-pass-summit.aspx . Andy says, hey why don't they just make it by invitation only since that what they will do anyway?
I disagree. As someone… Read more
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if you are viewing this from a syndicated newsfeed). And don’t forget to enter your e-mail address when you post your response, so I can contact you if you win.
I’ll… Read more
Taking a Medical Approach to Performance Troubleshooting
I find it difficult sometimes to explain to someone how to have a take a good approach to performance troubleshooting. I had the stomach flu a few weeks ago, and the same day I visited my doctor, there were many people trying to… Read more
8 comments, 1,688 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 31 May 2010
Are you a DBA? You might Be!
On Twitter, people do a lot more than gossip and post messages about mundane, trivial tasks. As DBA’s, we help people having problems (#sqlhelp), we have in-depth discussions, we promote upcoming events (#sqlpass, #sqlsat43, #sqlcruise, etc.), we… Read more
4 comments, 1,419 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 29 May 2010
Blogs are a great way to learn new things about SQL Server, and just in case you have missed them, I want to recommend the following two blog series that I feel every DBA should read.
I’m always trying to find out about the DBAs who visit my blog, as it helps me to better understand them, which helps me to better target the blog posts I write. While I use Google Analytics to help me find out more about my audience (such as how often… Read more
I found a post of setting up database access in the following site and I responded there and I wanted to share with you all about the problem and the solution that I came with.
I have 2 database on a sql server name 1) Medical 2) Insurance.… Read more
AnandTech has an interesting review up about some new models of Core i5 and Core i7 processors that are designed to be easier for system OEMs to “factory overclock”. What I found interesting is the new Core i7 875K processor, which runs at 2.93GHz, and can go to 3.60GHz with… Read more
Not too often, someone asks for a strange request like wanting to pivot on every single value inside a table. No aggregations at all, just a listing of the columns as shown in the screenshot below. This happened for a colleague of mine recently. As such, a few of us… Read more
I've been published! My article Troubleshooting Transactional Replication is featured in the June 2010 issue of SQL Server Magazine (subscription required to read the article online). In it I talk about how to use Replication Monitor, tracer tokens, and replication alerts to discover and diagnose problems. I also present three… Read more
It’s the classic question faced by everyone in Information Services. I know how to do this and I could build software to do it, but I’m a lazy b_____d so I’d rather just pick up a piece of software that does it for me. I love working for large companies… Read more
I have gotten a number of emails over the past few days asking about how I import binary files into SSIS as well as how to improve throughput by making tasks parallel. I have, scattered throughout this blog, articles which show bits and pieces. I have articles on how…
The Yankee Years by Joe Torre ($12 @ Amazon) was a gift, and I enjoyed it more than expected. When it first came out there was a lot of hoopla about it being an expose, and while I guess there is some of that, to me it wasn’t the point… Read more
With the release of SQL Server 2008 R2 there have been claims that sqlps is really PowerShell V1 under the covers or that sqlps is PowerShell V2 because it returns $psversiontable information. Although, technically, sqlps neither PowerShell V1 nor V2, the answer to this question is a little more complicated… Read more
This is an old topic, and there have been quite a few blogs (and following comments) that illustrate how to quickly find the information, mainly by checking tempdb creation time (http://www.sqlservercentral.com/blogs/sqldbauk/archive/2010/04/29/when-was-sql-server-last-restarted_3F00_.aspx) and check session_id=1 information (http://www.sqlservercentral.com/blogs/joewebb/archive/2010/04/28/how-to-tell-when-sql-server-started_3F00_.aspx). However, as a DBA, one of the common post-event reports I have to… Read more
Help enter demonstration data for the Microsoft BI Conference.
Go to the shopping demo web form and enter some transactions.
No personal information is collected or reused for any purpose. Please enter realistic information and select purchase items that you would normally buy in a trip to the grocery store.…
I have received a number of requests for an explanation of my winning query of TSQL Challenge 19. This involved traversing a hierarchy of employees and rolling a count of orders from subordinates up to superiors.
The first concept I shall address is the hierarchyId , which is constructed… Read more