Author: Bradley Schacht

2

SELECT COUNT(*) vs COUNT(1) vs COUNT(ColumnName)

What is the difference between COUNT(*), COUNT(1) and COUNT(ColumnName)? A mystery that will never be known… ok that was a lie, but the rest of this blog is not a lie, just to be clear.  🙂 COUNT(*) – Number of...

Reset Identity Column in SQL 0

Reset Identity Column in SQL

I’ll be honest, I am partially writing this because I always forget how to reset the identity column on a table and I want to be able to just pull up my blog and look it up.  Yet again today...

2

Excel Services in SharePoint 2010 Webinar

Tomorrow I will be presenting a webinar at 11 AM eastern time for the Pragmatic Works Training on the T’s.  This month each of the authors of the SharePoint 2010 Business Intelligence 24-Hour Trainer available from Wrox are presenting a...

0

SQL Saturday #79 South Florida

SQL Saturday in South Florida is quickly approaching in just 2 short weeks.  As usual, if you are in the area please come out and support the wonderful people who are giving of their time to help out in the...

0

SQL Saturday #85 Orlando

SQL Saturday #85 is quickly approaching. It will be held in sunny Orlando, FL so if you live in the area get ready for awesome because I am coming to town! Ok, that may have been a little over the...

Upcoming Content Preview 0

Upcoming Content Preview

It has been a few weeks since I last posted.  I know, I’m a slacker, thanks for pointing that out.  I have a little bit of a pipeline that I am working on getting populated and just wanted to toss...