One of the most confusing data types in SQL Server is the datetime datatype.

Harmful, Pervasive SQL Server Performance Myths

by Additional Articles

SQLPerformance.com

Performance

Aaron Bertrand begins a new series around disproving prevalent myths regarding SQL Server performance.

The Value of Your Personal Data

by Steve Jones

SQLServerCentral.com

Editorial

Today Steve Jones discusses the idea of data value, and what it might mean to you, personally.

Using PerfMon and PAL to Diagnose SQL Issues

by Jim Youmans

SQLServerCentral.com

Free tools to help you find and diagnose SQL issues

Automating database deployments to and from source control using SQL Compare and PowerShell

by Additional Articles

Redgate

SQL Compare

Phil Factor shows how you can use the SQL Compare Pro command line with PowerShell to automate the task of getting a new database into version control, creating a new database build script, and creating a database migration script.

Dynamic SSRS report documentation via a ReportServer.dbo.Catalog query

by Stan Kulp

SQLServerCentral.com

Reporting Services (SSRS)

This article demonstrates a method of generating SSRS report documentation by using an SSRS report that queries the ReportServer.dbo.Catalog table.

Changing SQL Server Collation After Installation

by Additional Articles

MSSQLTips.com

Collation

In some scenarios we can find different SQL Server collations between the server instance and its databases. Douglas P. Castilho explains a simple way to correct the collations in a few steps.

By Design

by Rodney-Landrum

SQLServerCentral.com

Editorial

Just because something works, is it prudent to implement a solution knowing there is a chance this design flaw will be stricken from future revs of SQL Server? It depends.