TSQL Queries – Using NTILE
NTILE is a SQL Server function that can be called in a TSQL Query. This is part of the free sql query training to prepare… Read More »TSQL Queries – Using NTILE
SQL Server
SQL Query Training – Next Week – Set Operators, Derived Tables and CTEs
The SQL Training was a lot of fun this week we covered Top, Ranking, NTILE, and Analytic functions in preparation for the Microsoft 70-461 exam. Next… Read More »SQL Query Training – Next Week – Set Operators, Derived Tables and CTEs
TSQL Aggregation Crossword Puzzle
Based on this weeks Free SQL Server training on Aggregation, I have created a crossword puzzle with terms in the Aggregation session. Download the… Read More »TSQL Aggregation Crossword Puzzle
TSQL Aggregation Strategies and Aggregating Data
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… Read More »TSQL Aggregation Strategies and Aggregating Data
What are your favorite SQL Conferences / Trainings?
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… Read More »What are your favorite SQL Conferences / Trainings?
Does SQL Server work with PHP
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… Read More »Does SQL Server work with PHP
A great day at SQL In The City by Redgate
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.… Read More »A great day at SQL In The City by Redgate
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
What is SQL Server?
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… Read More »What is SQL Server?
- « Previous
- 1
- …
- 11
- 12
- 13