This weeks training as part of the Free SQL Training for the 70-461 certification course is now available on YouTube. This week we covered Aggregating Data and Aggregation strategies. For more information on sessions, take a look at the Free …
TSQL Aggregation Strategies and Aggregating Data Read more »
I am starting to fill out my schedule for SQL related conferences to attend this year, and I wanted to if anyone has any favorite conferences that I may be overlooking. PASS Summit 2015 is the big, must attend conference, …
What are your favorite SQL Conferences / Trainings? Read more »
Coming from a SQL Server, and PHP background, I often get asked, does SQL Server work with PHP? The answer is YES. I have been using SQL Server and PHP together in a high availability load balanced environment with multiple data …
Friday I had a great day at Redgate’s SQL In The City presentation by Steve Jones (@way0utwest). There were three sessions presented which are summarized below. Session 1 – Team-based Database Development with Version Control I thought that this session was …
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 doing it. The information here has been extracted from my SQL Saturday presentation on Whats New in …
Originated as Sybase SQL Server Acquired by Microsoft and named Microsoft SQL Server in 1989 Recent Versions (2005, 2008, and 2008 R2) But what is it? A system for managing large amounts of data Provides a language TransactSQL (T-SQL) to …