Sept 15th, 2012 at the CAIT Campus of Washington University in St.Louis - 5 Jackson Avenue, Clayton, MO 63105
SQL Saturday #154 is the very first SQL Saturday event in the St.Louis area. It is a free one day event for SQL Server professionals and those wanting to learn about SQL Server. We are planning on a 4 track event with 200 attendees. We currently have several sessions aligned towards Database Administration, Application Development, Business Intelligence and professional Development Tracks. We also have several sessions focused on SQL Server 2012! Please visit our event website for more details and free registration. More »

Although, generally speaking, source control is the truth, a database doesn't quite conform to the ideal because the target schema can, for valid reasons, contain other conflicting truths that can't easily be captured in source control. Dave Ballantyne explains the problems and suggests a solution. More »

Editorial - Labor Day 2012

This weekend is Labor Day in the US. It's a holiday set aside to recognize the workers and their contributions to the economy. It's a holiday here that marks the end of summer and the beginning or school for many people. Hopefully it's a relaxing and enjoyable day for you.

It's a day off for me from work but probably one where I'm laboring. With a fence to build and a horse shelter, I'm going to be busy for the next few weeks. I've included a blooper reel for you to enjoy. Whether you're working or relaxing, hopefully you enjoy it.

Microsoft SQL Server 2012 will have major changes throughout the SQL Server and will impact how DBAs administer the database. With this book, a team of well-known SQL Server experts introduces the many new features of the most recent version of SQL Server and deciphers how these changes will affect the methods that administrators have been using for years. Loaded with unique tips, tricks, and workarounds for handling the most difficult SQL Server admin issues, this how-to guide deciphers topics such as performance tuning, backup and recovery, scaling and replication, clustering, and security.

SQL Server 2012 T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2012. It provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on. Get your copy from Amazon today.

ORDER BY PROBLEM
- Hi,
I have column in a table which needs to be ordered in an ascending order.
[code="sql"]DECLARE @NumberTable TABLE( ItemNumber VARCHAR(50))
INSERT @NumberTable
SELECT 'ABC-1702-XYZ' ItemNumber...

Date Query Format Problem
- Hi all, my database has a column called StartDate_Time and the format in this column is like so
Wed Sep...

This newsletter was sent to you because you signed up at SQLServerCentral.com. Feel free to forward this to any colleagues that you think might be interested. If you have received this email from a colleague, you can register to receive it here.