Moving Blog…

Due to a few different reasons, I’ll be moving my blog from here at MSDN to the following location. Please update your rollers and links, I’m hoping to see everyone at the new locations below! http://www.mssqltips.com/author.asp?authorid=2 I’ve moved most of my posts from here to these locations, and will be building on some of the…

1

Non-technical – big news for Chad, he’s getting married

So, I think most of my close friends have heard by now, but if you are a friend, and you haven’t heard, and this is how you’re hearing about it, sorry about that – give me a call and I’ll make it up to you over dinner and drinks or something :-). I’m getting married…

2

sp_who for Sql 2005 (sp_who2k5)

I get many requests from customers for something like sp_who/sp_who2 for Sql 2005 with new columns/features/etc. specific to Sql 2005 (sp_who/sp_who2 are both included in Sql 2005, but they return exactly the same information as they did in Sql 2000). Well, here’s one version of it – I’ve included the code below. You’ll find a…

2

Katmai (Sql 2008) – Group By Sets

With Sql 2008 (in the current CTP you have in your hand), thanks to a new extension to the group by clause referred to as ‘grouping sets’, you now have the ability to use sets of grouping columns in your group by clauses, allowing you to define basically multiple groupings in the same single query…

1

Katmai (Sql 2008) – Data Compression (including Backup Compression)

This post will cover an initial overview of the data compression feature that will be included in Sql Server 2008, and I’ll also cover briefly some information on the Backup Compression feature as well (note that these are 2 totally separate and distinct features, since they are very different, as you’ll hopefully see by the…

5

Katmai (Sql 2008) – The List of New Features

So, I’ve been getting quite a few pings about providing a list of new features to look for in Katmai (Sql 2008) and/or those that I’ll be either blogging about and/or presenting on at the DC area groups I mentioned here: http://blogs.msdn.com/chadboyd/archive/2007/07/18/katmai-sql-server-2008-presentations-in-the-dc-area-novasql-caparea-net-cmap.aspx Well, I put together a list below, and this isn’t even everything (though…

13

Katmai – Did you know? Inline variable initialization and Compound assignment

In Sql 2008 (Katmai), a couple of the ‘smaller’ features that are currently in the latest CTP include inline variable initialization and compound assignment (something you App Dev folks have had for years). So, the following types of code now work in Sql 2008:   declare @d datetime = getdate(),    @i int = 1,    @s…

2

Katmai / Sql Server 2008 Presentations in the DC area (novaSql, caparea.net, CMAP)

In August, September, and October I’ll be presenting on Sql Server 2008 (Katmai) at a variety of groups in the DC/Baltimore area. We’ll be demoing lots of the new functionality with Sql 2008, including but not limited to Change Data Capture, MERGE, Table Valued Parameters, Declarative Management Framework, FILESTREAM, enhancements to Mirroring and Service Broker,…

4

So you think you know SQL…Administration Part I

So you think you know SQL…Administration Part I The 2nd in the series…this one revolves around Administration and Internals of Sql Server, and is the 1st of 2-4 groups of questions in just Administration and Internals…again, these are seperated into easy, moderate, and difficult groups. As always, if there are any questions/comments/etc., post a comment…

1

So you think you know SQL…Concurrency and Locking

The first in hopefully a fairly long series of posts on interview type questions/scenarios/etc., this one will cover Concurrency and Locking related Q/A (simple Q/A only at this point).  The questions are separated into easy, moderate, and difficult groups.  If you have any comments, by all means please post and lets discuss! Typically, answers and…

0