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

Archives: March 2010

Notes from the Orlando Code Camp March 2010

I arrived about 7:15 and already quite a few people on hand. Registration was moved to inside this time, just inside the cafeteria, and seemed like a much better traffic flow. Few things I noted on arrival:

  • Attendees didn’t receive name badges (this really helps speakers & networking)
  • Breakfast set…

Read more

1 comments, 923 reads

Posted in SQLAndy on 29 March 2010

Using Custom Connection Colors in SSMS

One of the new features that was added to SQL Server Management Studio (SSMS) in SQL Server 2008, which was continued in SQL Server 2008 R2, is the ability to set custom connection colors for individual instances of SQL Server. The color you set shows up in the bottom of… Read more

9 comments, 3,812 reads

Posted in Glenn Berry's SQL Server Performance on 29 March 2010

To Get Certified or Not Get Certified

I have noticed quite a bit of discussion recently about the merits of Microsoft certification. Some people (like me) think that getting a Microsoft certification is a good thing. It proves that you have at least a certain level of competence with the product, and it shows that you have… Read more

3 comments, 869 reads

Posted in Glenn Berry's SQL Server Performance on 29 March 2010

TempDB – Relocate the TempDB Database Files

I took control of a new server recently and noticed that Tempdb was not configured to best practice. It was not on its own drive and it consisted of one data file and one log file…The server had a couple of cores, I’m not sure how relevant this is anymore… Read more

4 comments, 1,233 reads

Posted in The SQL DBA in the UK on 28 March 2010

DBCC INPUTBUFFER vs fn_get_sql

Someone asked a question in the forums the other day and I realized it would make a pretty decent blog post to explain the differences in functionality between these two and provide some code for working with them.


  • fn_get_sql returns the last *statement* executed, where as DBCC INPUTBUFFER returns…

Read more

0 comments, 8,224 reads

Posted in Never Say Never on 28 March 2010

Making Sense of Replication Errors in Replication Monitor

Making Sense of Replication Errors in Replication Monitor
If you've ever had to deal with errors in Replication Monitor, your first experiences with it probably involved confusion. Sometimes the error messages are too generic and do not help you find a resolution.
Replication Monitor also tells you the…

Read more

Creative disruption 2010-2020: Contextual IT

The 12th Annual Emerging Technologies Update Day @ Wharton was very helpful on helping us not forget how IT is evolving longer term:

  • Microprocessor. Workloads that required 200 servers 5 years ago can now be executed with only on 13 servers. An increase of 15X computing power on the…

Read more

0 comments, 677 reads

Posted in The Future Computing Appliances and SQL Server on 27 March 2010

SQL Server Social Group a Fresh Perspective on User Group Meetings

The Cam river flows through Cambridge, England. At the center of the river you can see a punt (a type of boat) used to navigate the Cam.

I must have attended at least 25 different SQL Server and .NET user groups over the past couple of years, and most of… Read more

0 comments, 443 reads

Posted in SQL Aloha on 27 March 2010

So you want to write a blog?

First, figure out what you want to write about. It should be something you have passion for. And it should be something where you don't really care if people read it or not. At least that's my philosophy. I write because I love to write. Thankfully, some people see some… Read more

SQL Saturday #29 Presentations & Twittering

Tomorrow, I’m presenting a couple of sessions at SQLSaturday #29 in Birmingham, Alabama. Here are the presentation materials I’ll use.


Read more

0 comments, 536 reads

Posted in Joe Webb on 26 March 2010

Cross Apply Ambiguity

Cross apply (and outer apply)  are a very welcome addition to the TSQL language.  However, today after a few hours of head scratching, I have found an simple issue which could cause big big problems.

What would you expect from this statement ?

select * 
  from sys.objects b…

Read more

2 comments, 1,467 reads

Posted in Dave Ballantynes blog on 26 March 2010

SQL Saturday - Columbia

I've talked about trying to do a SQL Saturday event in Columbia, SC, for the last couple of years, ever since Andy Warren first asked me about it. I've never been able to put together a team to be able to tackle this, but it looks like we have a good… Read more

Learning About Microsoft Certified Master: SQL Server

Among the Microsoft certifications, the Microsoft Certified Master is the apex of all of them except maybe the Microsoft Certified Architect. But you can't run down to your local bookstore, grab a few books, and go take a test to earn it. It requires 3 weeks of study at… Read more

Book Review: Titan The Life of John D. Rockefeller, Sr.

I read Titan: The Life of John D. Rockefeller, Sr. ($13 @ Amazon) as one of the books recommended to me earlier in the year when I asked for suggestions. It was a long read, but filled in a lot of blanks about events around the turn of the century,… Read more

2 comments, 815 reads

Posted in SQLAndy on 26 March 2010


There seems to be quite a flurry of talk these days about certification. There is evidence of it in the forums and editorials at SSC, as well as in several personal blogs of various SQL Professionals throughout the community. I even see it happening with the quarterly goals at my… Read more

6 comments, 1,207 reads

Posted in SQL RNNR on 26 March 2010

Indexed Views

Views are used quite often within SQL Server for a number of reasons.  They can be used to restrict access to tables (restrict the columns viewable or the records returned) , combine multiple tables into a single 'virtual table', or apply specific sets of formulas(like avg cost or an item).… Read more

0 comments, 418 reads

Posted in SQLRunner on 26 March 2010

Simple Series : SSIS Conditional Split

Conditional Split is a very powerful component, enabling you to send records in different directions or exclude them from the downstream altogether.  I use this component quite often in my SSIS packages.  In the industry I work in, publishing, there are many times we'll get a file in from…

Read more

0 comments, 743 reads

Posted in SQLRunner on 26 March 2010

Powerscripting Podcast 2

I was interviewed by Jon (@JonWaltz) and Hal (@Halr9000) in episode 106 of the PowerScripting Podcast. This was my second time coming on the show and it was great to be back. In the interview we talked about the PowerShell changes in SQL Server 2008… Read more

0 comments, 1,862 reads

Posted in Chad Miller on 25 March 2010

Red Gate and Hyperbac

Imagine my surprise when I arrived at the Red Gate offices Monday morning to find Jeff Aven at the office. I had a double take since Jeff is one of the founders of Hyperbac, and since Red Gate has SQL Backup, I’m surprised that Jeff was even allowed in the… Read more

8 comments, 2,421 reads

Posted in The Voice of the DBA on 25 March 2010

Measuring Transactional Replication Latency Without Tracer Tokens

Measuring Transactional Replication Latency Without Tracer Tokens
SQL Server 2005 introduced Tracer Tokens (SQL 2005 | SQL 2008), a new methodology for programmatically measuring replication latency in transactional replication. To measure latency with a tracer token, you simply insert a tracer token at the publisher. The replication…

Read more

Newer posts

Older posts