SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: May 2010

Memorial Day

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

2 comments, 1,518 reads

Posted in The Voice of the DBA on 31 May 2010

PASS Pre/Post Con Selections

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

1 comments, 1,771 reads

Posted in Advice from Aunt Kathi on 31 May 2010

June Question: What is your best advice for boosting index performance?

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

0 comments, 1,378 reads

Posted in SQL Aloha on 31 May 2010

Taking A Medical Approach to Performance Troubleshooting

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

Using the Data Viewer Intelligently in SSIS Data Flows

If you've ever needed to debug a fairly complex Data Flow, you've probably wanted to take a peek at what data is moving through the flow at various points.  The data viewer in Integration Services is how you do that - but it has a major drawback.  You may be processing…

Read more

0 comments, 2,060 reads

Posted in Todd McDermid's Blog on 31 May 2010

Are you a DBA? You might Be!

 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

Two Blog Series You Don’t Want to Miss

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.

The first blog series is from Glen Berry, and is called the April 2010… Read more

1 comments, 1,577 reads

Posted in SQL Aloha on 28 May 2010

Are You a Full-Time or Part-Time DBA?

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

0 comments, 1,563 reads

Posted in SQL Aloha on 28 May 2010

Permission Issue

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

0 comments, 1,726 reads

Posted in DatabaseExpertise.com on 28 May 2010

New Unlocked CPUs From Intel

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

0 comments, 1,446 reads

Posted in Glenn Berry's SQL Server Performance on 28 May 2010

Flipping a Table Sideways

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

0 comments, 1,558 reads

Posted in BrianKMcDonald on 28 May 2010

"Troubleshooting Transaction Replication" Published In SQL Server Magazine

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

2 comments, 1,913 reads

Posted in Kendal Van Dyke on 28 May 2010

Buy vs. Build

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

0 comments, 1,593 reads

Posted in The Scary DBA on 28 May 2010

Auditing Failed Logins – SQL Server 2008

I wrote about setting up a basic server audit recently. That showed about how a server level audit is set up, but that’s a just a shell. The audit itself is just a container in which you can store various audited items. Like a SQL Server Agent job, it doesn’t…

Read more

1 comments, 3,549 reads

Posted in The Voice of the DBA on 28 May 2010

Importing binary files with SSIS

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…

Read more

0 comments, 2,223 reads

Posted in SQLRunner on 28 May 2010

Book Review: The Yankee Years

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

0 comments, 1,401 reads

Posted in SQLAndy on 28 May 2010

The Truth about SQLPS and PowerShell V2

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

0 comments, 4,749 reads

Posted in Chad Miller on 28 May 2010

When did SQL Server start and how long is the downtime window?


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

1 comments, 3,417 reads

Posted in DBA Philosophy on 27 May 2010

BI Conference Grocery Shopping Demo

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.…

Read more

0 comments, 1,430 reads

Posted in SQL Server BI Blog on 27 May 2010

Challenge 19 – An Explanation of a Query

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

0 comments, 1,693 reads

Posted in Dave Ballantynes blog on 27 May 2010

Older posts