The Slack Integration
Slack has become a popular phenomenon in the technical world, especially for software developers. Should we join in?
Disabling SQL Server Optimizer Rules with QUERYRULEOFF
Daniel Farina shows how to disable the optimizer rules by using QUERYRULEOFF, an undocumented hint.
The Data Driven Event
In a couple of days, Microsoft is holding Data Driven, an event that will highlight SQL Server 2016.
SQL GROUP BY Basics
It sometimes pays to go back and look at what you think you already know about SQL. Joe Celko gives a quick revision of the GROUP BY and HAVING clauses in SQL that are the bedrock of any sort of analysis of data, and comes up with some nuggets that may not be entirely obvious.
Deep Dive into Changing Database Collation
Changing Database Collation Through Primary keys, Foreign Keys, Default and Check Constraints and more.
Testing times with SMO
SMO gives every appearance of being a great example of over-reliance on automated testing at the expense of manual exploratory testing.
Microsoft Data Driven SQL Server Event - Watch Live
Hear from Microsoft engineering experts on the latest features in SQL Server 2016 before the live event. Learn about new business intelligence capabilities like built-in mobile BI, fully integrated advanced analytics, security innovations, mission critical in-memory performance and new hybrid cloud solutions.
Performance Surprises and Assumptions : SET NOCOUNT ON
Aaron Bertrand (@AaronBertrand) revisits the impact that eliminating DONE_IN_PROC messages using SET NOCOUNT ON may or may not have on query performance
Data Science for SQL Folks: Leveraging SQL and R
Learn about how to build value driven analytics with SQL Server and R.
Blogs
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers