T-SQL Tuesday #2 – Data Conversions

Adam Machanic started the idea of a blog party last month, getting people to write about date and time issues...

T-SQL Tuesday #2 – Data Conversions

Adam Machanic started the idea of a blog party last month, getting people to write about date and time issues...

Video Featured on SQLShare

I didn’t have a chance to blog this yesterday (January 11, 2010), but my most recent video, Dynamic SQL Using...

We Interrupt Your Regular SQL Blogging For This Announcement…

EXEC sys.sp_addextendedproperty 
   @name = N'IsWifePregnant', 
   @value = N'True',
   @level0type = N'USER',
   @level0name = N'Kendal.VanDyke' ;

EXEC sys.sp_addextendedproperty 
   @name = N'ExpectedDueDate',
   @value = N'August 2010',
   @level0type = N'USER',
   @level0name...

Webcast Tomorrow - Dynamic SSIS: Using Expressions and Configurations

Join me tomorrow at 1:00pm CST as I present "Dynamic SSIS: Using Expressions and Configurations" for the PASS DBA virtual...

Would Third-party Product Driven/Vendor Sessions Benefit User Groups and Community Events?

In the the couple of years I have been involved in the SQL Server community I have noticed that there...

A Time and a Place for the SQL Server Maintenance Plan Wizard

Reprinted from my editorial in Database Weekly.
In the course of my job, I get to give a lot of presentations,...

Horror… sort of

You must read this post from Tim Ford to understand why I might do this on my technical blog. But...

Kevin Cox from SQLCAT Presenting at the Denver SQL Server User’s Group On January 21, 2010

Kevin Cox, who is part of the SQLCAT Team at Microsoft, will be giving the presentation at this month’s Denver...

Lock configuration setting and preventing locking contention

The locks configuration option for SQL Server controls the number of locks available in SQL Server. You can view this...