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.
Data Mining Part 24: SQL Profiler and Data Mining
In this chapter we will detect the Data Mining activity using SQL Server Profiler.
Data Mining Part 24: SQL Profiler and Data Mining
In this chapter we will detect the Data Mining activity using SQL Server Profiler.
Programming Rules and 'Best Practices' Can't Replace Professional Judgement
In which Phil Factor casts doubts on 'programming policies'. For certain, any IT team development requires plenty of methods of working that maximise productivity, but coding standards and ‘best practices’ have to be treated with caution. Programming rules can’t replace professional judgement
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Limit the Blast Radius
Comments posted to this topic are about the item Limit the Blast Radius
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers