SQL Saturday #371 - Tampa, FL
SQL Saturdau is coming to Tampa on February 28, 2015. This is a free training event for those wanting to learn about SQL Server. Register while space is available.
How to use the IsNothing Inspection Function in SSRS
SSRS includes multiple functions that can be used in within an expression. This article hopes to just show an example of how to use the IsNothing function in an SSRS report.
SQL Bits XIV, London, March 4 – 7, 2015
SQL Bits is Europe's largest SQL Server conference. They have experts teaching beginners, and beginners questioning experts, providing feedback and improving the event every year. Register with the code SSC-HERO to get a 15% discount on the ticket price!
Starting a New Job
Steve Jones talks about starting a new job and the need to get up to speed quickly, perhaps by being prepared on day 1.
Bowled Over by SQL Window Functions
What better way to learn how to construct complex CHECK CONSTRAINTs, use the SQL 2012 window frame capability of the OVER clause and LEAD analytic function, as well as how to pivot rows into columns using a crosstab query? Create the SQL code to score Ten-pin Bowling, of course. Dwain Camps explains the how, what and why.
Ship Safe...Ship Often
How can we ship safe, and ship often? Steve Jones has a few comments on the need for better engineering.
Using SQL Server's GROUP BY clause to Summarize your Data
SQL Server’s GROUP BY clause provides you a way to aggregate your SQL Server data and to group data on a single column, multiple columns, or even expressions. Greg Larsen discusses how to use the GROUP by clause to summarize your data.
SQL Bits and Community Superheroes
Chris Testa-O'Neil on the origins of SQL Bits and the joys of community events.
The Quickest Guide to Getting Started with PowerPivot
If you are still on the edge about PowerPivot and have not given it a shot, this article will get you started with ample of screen shots and a step-by-step guide.
Questions About T-SQL Control-of-Flow Language You Were Too Shy to Ask
Surely, we all know how T-SQL Control-of-flow language works? In fact it is surprisingly easy to get caught out. What, for example, do the BREAK, RETURN and CONTINUE keywords do in their various contexts? Robert Sheldon has the answers to this and other questions.
Blogs
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
Forums
Backup Availability Group
Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022...
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers