T-SQL DATEPART Explained
Here is a quick rundown on the T-SQL DATEPART function for SQL Server. DATEPART is used to pull a single part of a date/time element… Read More »T-SQL DATEPART Explained
SteveStedman
Installing Sample Databases for SQL Server 2008R2
As I work on testing the Database Health Reports project, I have configured several test servers running as virtual machines using Hyper-V. Part of setting… Read More »Installing Sample Databases for SQL Server 2008R2
Database Health Reports Beta 5 is Going Strong
The Database Health Reports project is going strong. Database Health Reports is a free application for monitoring the key metrics on your SQL Server. Created by… Read More »Database Health Reports Beta 5 is Going Strong
Common Table Expression accepted for SQL Saturday 212 in Redmond WA
My Common Table Expression presentation was accepted for SQL Saturday 212 in Redmond WA. This is the session that I am the most familiar with,… Read More »Common Table Expression accepted for SQL Saturday 212 in Redmond WA
DATEFROMPARTS function in TSQL
SQL Server 2012 adds a new function called DateFromParts. This new function simplifies the creating of a DATE type in TSQL over the older ways of… Read More »DATEFROMPARTS function in TSQL
Rows and Range, Preceding and Following
SQL Server 2012 adds many new features to Transact SQL (T-SQL). One of my favorites is the Rows and Range enhancements to the over clause.… Read More »Rows and Range, Preceding and Following
Select Favorite SQL Server 2012 Articles
The following articles are a collection of my favorite SQL Server related posts over the last 6 months. 3 Steps to Work More Efficiently in… Read More »Select Favorite SQL Server 2012 Articles
T-SQL 2012 Procedure sp_describe_first_result_set
SQL Server 2012 adds a new stored procedure called sp_describe_first_result_set. This new procedure returns metadata for the result set returned from a query. The metadata is… Read More »T-SQL 2012 Procedure sp_describe_first_result_set
What twitter hash tags do you follow for SQL Server?
# The key to twitter is to follow the right hash tags. What hash tags do you follow related to Microsoft SQL Server? Here are… Read More »What twitter hash tags do you follow for SQL Server?
Happy Birthday SQL Server 2012
It has been a year since SQL Server 2012 released. There were some fun posts on Twitter about the SQL Server 2012 birthday or anniversary.… Read More »Happy Birthday SQL Server 2012