--SQL User Group





Upcoming Events





Latest community news

15.11.2018

Brent Ozar Unlimited : Adventures In Foreign Keys 4: How Should I Index These Things?

This week, we’re all about foreign keys. So far, we set up the Stack Overflow database to get ...

 

15.11.2018

Glenn Berry : AMD EPYC 7371 Processor in Q1 2019

At the Supercomputing 2018 Conference, AMD announced a special high-frequency SKU in their first-gen...

 

14.11.2018

Glenn Berry : IEPUM2017: Immersion Event on Planning and Implementing an Upgrade/Migration to SQL Server 2017

We’ve just announced the next round on live, online training classes for the first quarter of 2019. ...

 

14.11.2018

Paul S. Randal : Six new 2019 Q1 live online classes open for registration!

Due to the popularity of our live, online classes this year, we’re presenting six more in the ...

 

14.11.2018

Paul S. Randal : New live online training class in March: Columnstore Indexes

Continuing our series of live, online classes, Jonathan will be delivering his new IECS: Immersion E...

 

14.11.2018

Brent Ozar Unlimited : Adventures In Foreign Keys 3: A Cascade Of Badness

Legendreary In the last post, I looked at some issues with implementing foreign keys with cascading ...

 

13.11.2018

Brent Ozar Unlimited : Adventures In Foreign Keys 2: Difficulties, Difficulties, Difficulties

This week, we’re all about foreign keys. Yesterday’s post covered scripts to set up the ...

 

12.11.2018

Glenn Berry : Building a Modern AMD Desktop Development Workstation

Over the past 12-18 months, it has become relatively easy to build an extremely powerful AMD desktop...

 

12.11.2018

Brent Ozar Unlimited : Adventures In Foreign Keys 1: Eligibility Is Everything

In A Foreign Key, In A Foreign Table Much of what people want from foreign keys, like referential in...

 

11.11.2018

Brent Ozar Unlimited : [Video] Office Hours 2018/11/7 (With Transcriptions)

This week, Tara and Richie discuss offline file database and log backup solutions, VSS database back...

 

08.11.2018

Brent Ozar Unlimited : PASS Summit 2018 Keynote Day 2: Live Blog

Today is the second day of the 2018 PASS Summit, the largest annual gathering of Microsoft data prof...

 

07.11.2018

Brent Ozar Unlimited : PASS Summit 2018 Keynote Day 1: Live Blog

Today is the opening day of the 2018 PASS Summit, the largest annual gathering of Microsoft data pro...

 

07.11.2018

Brent Ozar Unlimited : What’s New in SQL Server 2019 CTP 2.1: Faster Functions

A while back, we talked you through a public whitepaper about how Microsoft was working on making us...

 

06.11.2018

Erin Stellato : Query Store Performance Overhead: What you need to know

“What is the performance overhead of enabling Query Store?” I get asked this question almost every t...

 

06.11.2018

SQL Server Customer Advisory Team : SQLCAT at PASS Summit 2018

This week in Seattle, PASS Summit 2018 will be happening for the twentieth time. As for many years b...

 

05.11.2018

Marco Russo : Showing actuals and forecasts in the same chart with Power BI

In budgeting reports, a common requirement is to show future sales forecast and actual sales volume ...

 

05.11.2018

Brent Ozar Unlimited : Picking #PASSsummit Sessions to Attend

So you’re going to the PASS Summit in Seattle this week, and you’re overwhelmed with the...

 

03.11.2018

Glenn Berry : SQL Server Diagnostic Information Queries for November 2018

This month, I have just made some more minor improvements to most of the query sets. I have a T-SQL ...

 

03.11.2018

Brent Ozar Unlimited : [Video] Office Hours 2018/10/31 (With Transcriptions)

This week, Brent, Tara, Erik, and Richie discuss load balancing, preventing auto-updates, compatibil...

 

02.11.2018

Brent Ozar Unlimited : The Curse of Cursor Options

Red Skies At Night I know it’s hard to believe, but I still see a lot of people using cursors ...

 

01.11.2018

Brent Ozar Unlimited : Save 50-75% Now: The 2018 Black Friday Sale is On!

Five years ago, I had a crazy thought. I liked bargain shopping during Black Friday sales, picking o...

 

31.10.2018

Brent Ozar Unlimited : How Check Constraints MIGHT Improve Your Queries and Missing Index Requests

The more SQL Server knows about your data, the better your query plans can get. Say you’ve got...

 

30.10.2018

Brent Ozar Unlimited : SUM, AVG, and arithmetic overflow

You Shoulda Brought A Bigger Int Sometimes you run a query, and everything goes fine. For a while. F...

 

29.10.2018

Glenn Berry : Automatic Plan Correction is Enterprise Edition Only Feature in SQL Server 2017

One interesting and useful new feature in SQL Server 2017 is Automatic plan correction. This feature...

 

29.10.2018

Brent Ozar Unlimited : You read reviews before you buy training, right?

Confession time: I love buying stuff. It’s not so much the buying as it is the comparing. I go...

 

28.10.2018

Brent Ozar Unlimited : [Video] Office Hours 2018/10/24 (With Transcriptions)

This week, Brent, Tara, and Richie discuss increasing a table’s varchar field from 1 to 2, pre...

 

26.10.2018

Brent Ozar Unlimited : Filtered Indexes vs Parameterization (Again)

At First I Was Like… This won’t work at all, because parameters are a known enemy of fil...

 

25.10.2018

Glenn Berry : New Intel Desktop Processor Families

Intel formally announced its 9th generation Core mainstream desktop processors on October 8, 2018 at...

 

25.10.2018

Brent Ozar Unlimited : Batch Mode For Row Store: Does It Fix Parameter Sniffing?

Snorting The Future SQL Server 2019 introduced batch mode over row store, which allows for batch mod...

 

24.10.2018

Glenn Berry : SQL Server Diagnostic Information Queries for October 2018

This month, I have just made some minor improvements to most of the query sets. I have a T-SQL scrip...

 

24.10.2018

Brent Ozar Unlimited : Batch Mode For Row Store: What Does It Help With?

SQL Server 2019 Introduces something pretty cool: the ability for row store indexes to be processed ...

 

23.10.2018

Brent Ozar Unlimited : How to See Execution Plans in Azure Data Studio

Azure Data Studio is Microsoft’s cross-platform tool for T-SQL developers. It’s still re...

 

23.10.2018

Brent Ozar Unlimited : You probably didn’t go to a training class this year. Again.

The year is drawing to a close, and you didn’t go to a training class. Again. Your skills aren...

 

22.10.2018

Paul S. Randal : New class: Immersion Event on Azure SQL Database, Azure VMs, and Azure Managed Instance

Tim’s been working closely with the development team on Azure Managed Instance, presented with...

 

22.10.2018

Marco Russo : Optimizing IF and SWITCH expressions using variables

This article describes how variables should be used in DAX expressions involving IF and SWITCH state...

 

22.10.2018

Brent Ozar Unlimited : Announcing The Team Membership

You have a team of database developers and DBAs – SQL Server professionals who want dedicated ...

 

22.10.2018

Brent Ozar Unlimited : Thank you, #sqlfamily, for donating to The Trevor Project.

A couple of weeks ago, we told you about how Andy Mallon’s LGBTQ Meetup was raising money for ...

 

22.10.2018

Paul S. Randal : Calling all user group leaders! We want to present for you in 2019!

By the end of December, we at SQLskills will have presented remotely (and a few in-person) to more t...

 

21.10.2018

Brent Ozar Unlimited : [Video] Office Hours 2018/10/17 (With Transcriptions)

This week, Brent, Erik, and Richie discuss small vendor apps, “Slow in the Application, Fast i...

 

19.10.2018

Erin Stellato : Baselines for SQL Server and Azure SQL Database

Last week I got an email from a community member who had read this older article of mine on baselini...

 

19.10.2018

Brent Ozar Unlimited : Is Cost Threshold for Parallelism Measured in Seconds?

SQL Server automatically chooses when to divide your query’s work across multiple CPU cores. I...

 

18.10.2018

Brent Ozar Unlimited : What Should We Change About the Data Professional Salary Survey for 2019?

Every year, we publish an open Data Professional Salary Survey. Last year, 3,113 folks from 73 count...

 

17.10.2018

Brent Ozar Unlimited : Skewing Parallelism For Fun And Profit

What Is Skewed Parallelism? When queries go parallel, some assumptions get made: There’s enoug...

 

17.10.2018

Paul S. Randal : Lazy log truncation or why VLFs might stay at status 2 after log clearing

Earlier this year I was sent an interesting question about why the person was seeing lots of VLFs in...

 

16.10.2018

Erin Stellato : Removing a database from a replica in an Availability Group

I recently had a scenario in a two-node Availability Group where multiple large-batch modification q...

 

16.10.2018

Brent Ozar Unlimited : Using NOLOCK? Here’s How You’ll Get the Wrong Query Results.

Slapping WITH (NOLOCK) on your query seems to make it go faster – but what’s the drawbac...

 

15.10.2018

Brent Ozar Unlimited : Building SQL ConstantCare®: Separating Out the Videos

When we started offering SQL ConstantCare®, our mentoring service, I wanted to make our web site as ...

 

13.10.2018

Brent Ozar Unlimited : [Video] Office Hours 2018/10/10 (With Transcriptions)

This week, Brent, Tara, and Richie discuss splitting large database files across multiple files, sec...

 

12.10.2018

Brent Ozar Unlimited : Index Tuning Week: Missed Missing Index Opportunities

A Reminder With a new baby in the house, I often find myself comparing her to various things. Barnac...

 

11.10.2018

Brent Ozar Unlimited : Index Tuning Week: Getting Blocking? Play “Hot or Not.”

This week, we’re all about tuning indexes. So far, we’ve covered Brent’s 5 and 5 R...

 

10.10.2018

Brent Ozar Unlimited : Index Tuning Week: Fixing Nonaligned Indexes On Partitioned Tables

Unquam Oblite This post will not change your life, but it will help me remember something. When you ...

 

09.10.2018

Glenn Berry : PASS Summit 2018

I will be presenting Migrating to SQL Server 2017 at the PASS Summit 2018 in Seattle, WA. I’m actual...

 

09.10.2018

Glenn Berry : SQLSaturday Oregon

I will be delivering a full day pre-con session called Migrating to SQL Server 2017 on November 2, 2...

 

09.10.2018

Brent Ozar Unlimited : Index Tuning Week: My D.E.A.T.H. Method for Tuning Indexes

This week I’m running a series of posts introducing the fundamentals of index tuning. Yesterda...

 

09.10.2018

Paul S. Randal : Spring 2019 classes in Chicago open for registration

I’ve just released our first set of 2019 classes for registration! We’ll be adding new classes...

 

08.10.2018

Marco Russo : Displaying Nth Element in DAX

This article describes how to create a measure displaying the name or value of an element that has a...

 

08.10.2018

Brent Ozar Unlimited : LGBTQ Meetup at the PASS Summit

The SQL Server community is known for its welcoming acceptance of everyone, regardless of their expe...

 

08.10.2018

Brent Ozar Unlimited : Index Tuning Week: How Many Indexes Are Too Many?

This week I’m running a series of posts introducing the fundamentals of index tuning. First up...

 

07.10.2018

Brent Ozar Unlimited : Pour One Out for Database Diagrams, and Good Riddance

On the left hand side, you see SQL Server Management Studio 17.9. On the right side, 18.0. Something...

 

06.10.2018

Brent Ozar Unlimited : [Video] Office Hours 2018/10/3 (With Transcriptions)

This week, Tara and Richie discuss database corruption, CLR, DBCC issues, adding identity columns to...

 

05.10.2018

Glenn Berry : Autogrow All Files Feature in SSMS 18.0 Preview 4

One of the small improvements in SSMS 18.0 Preview 4 is the addition of an “Autogrow All Files” chec...

 

05.10.2018

Brent Ozar Unlimited : Making The Query Plan Profile Hint More Useful

Way Back When I blogged about the new USE HINT that logs query plans that use it to a new XE session...

 

04.10.2018

Brent Ozar Unlimited : SQL Server Management Studio 18’s Execution Plans Will Change The Way You Look At Plan Tuning

The preview of the next version of SQL Server Management Studio is out, and it has a radical improve...

 

03.10.2018

Erin Stellato : Plan Forcing in SQL Server

Last month I was in Portugal for their SQLSaturday event, and I spent a lot of time talking about Pl...

 

03.10.2018

Brent Ozar Unlimited : We Need to Talk About the Warnings In Your Query Plans.

SQL Server, thanks for coming today. Have a seat. Yes, this might seem odd – there are a lot o...

 

02.10.2018

Brent Ozar Unlimited : First Responder Kit Release: Fingers Crossed!

This is a small release just to make sure you don’t forget about us. We know you’re busy...

 

02.10.2018

Brent Ozar Unlimited : Unused Indexes – Are they really unused or have they just not been used YET?

During our Critical Care® sessions with clients, we often see unused indexes (reads=0) with high wri...

 

01.10.2018

Brent Ozar Unlimited : The New Lightweight Query Plan Profile Hint

Recent Updates To SQL Server 2016 and 2017 introduced a new USE HINT that lets you direct an actual ...

 

28.09.2018

Brent Ozar Unlimited : When You Need to Tune A View, Don’t Just Get Its Plan

Say your database has a view, and everybody’s queries use it. Let’s take the Stack Overf...

 

27.09.2018

Brent Ozar Unlimited : New Class Week: Developer’s Guide to SQL Server Performance Tuning

You’re stuck with a database server that’s not going fast enough. You have a hunch that ...

 

27.09.2018

SQL Server Customer Advisory Team : Real-time performance monitoring for Azure SQL Database Managed Instance

This article was co-authored by Dimitri Furman and Denzil Ribeiro Reviewed by: Danimir Ljepava, Bork...

 

26.09.2018

Brent Ozar Unlimited : New Class Week: Fundamentals of Azure Data Factory

Azure Data Factory, or ADF, is an Azure PaaS (Platform-as-a-Service) that provides hybrid data integ...

 

26.09.2018

Paul S. Randal : PFS corruption after upgrading from SQL Server 2014

I’m seeing reports from a few people of DBCC CHECKDB reporting PFS corruption after an upgrade...

 

25.09.2018

Glenn Berry : Backup Checksum Feature in SSMS 18.0 Preview 4

I was pleasantly surprised to see a new “Backup checksum” checkbox in the Server Properties, Databas...

 

25.09.2018

Glenn Berry : SQL Server Diagnostic Information Queries for September 2018

This month, I have added a separate set of queries for SQL Server 2019. I have also added two new qu...

 

25.09.2018

Brent Ozar Unlimited : New Class Week: Performance Tuning in 21 Demos

We first unveiled this class for the PASS Summit, but due to high demand, we’re doing an onlin...

 

24.09.2018

Marco Russo : Understanding DAX Auto-Exist

This article describes the behavior of auto-exist in DAX, explaining the side effects of combining s...

 

24.09.2018

Brent Ozar Unlimited : What’s New in SQL Server 2019 System Tables

The free SQL Server 2019 preview download is out, and here are quite a few things to check out that ...

 

24.09.2018

Brent Ozar Unlimited : What’s New in SQL Server 2019’s sys.messages: More Unannounced Features

The system table sys.messages holds error messages that SQL Server needs to return to end users. Whe...

 

24.09.2018

Brent Ozar Unlimited : What’s New in SQL Server 2019: Faster Table Variables (And New Parameter Sniffing Issues)

For over a decade, SQL Server’s handling of table variables has been legendarily bad. I’...

 

24.09.2018

Brent Ozar Unlimited : What’s New in SQL Server 2019: Adaptive Memory Grants

When you run a query, SQL Server guesses how much memory you’re going to need for things like ...

 

23.09.2018

Brent Ozar Unlimited : [Video] Office Hours 2018/9/19 (With Transcriptions)

This week, Brent, Tara, Erik, and Richie discuss moving views between databases, Cluster Quorum File...

 

22.09.2018

Brent Ozar Unlimited : Leaked: SQL Server 2019 Big Data Clusters Introduction Video

Psst – you’re probably not supposed to see this yet, but look what @WalkingCat found: SQ...

 

21.09.2018

Brent Ozar Unlimited : 6 DBA Lessons I Wish Someone Would Have Taught Me Earlier

I was talking to a DBA friend of mine, reminiscing about some of the hard lessons we learned early o...

 

20.09.2018

Brent Ozar Unlimited : Finding & Fixing Statistics Without Histograms

Men Without Hats – now those guys were cool: Statistics Without Histograms – not so much...

 

20.09.2018

Paul S. Randal : New VLF status value

At least since I started working on the SQL Server team (just after 7.0 shipped) and since then ther...

 

19.09.2018

Brent Ozar Unlimited : A Simple Stored Procedure Pattern To Avoid

Get Yourself Together This is one of the most common patterns that I see in stored procedures. IR...

 

19.09.2018

Marco Russo : DAX Guide – the reference I had been wanting

If you have read the book Alberto and I wrote, “The Definitive Guide to DAX” then by looking at the ...

 

18.09.2018

Brent Ozar Unlimited : One Hundred Percent CPU

Raise Your Hand If You’ve ever wanted to play a prank on your co-workers, but just didn’...

 

17.09.2018

Brent Ozar Unlimited : Free Training Classes for Those Who Give Back: Announcing our 2019 Scholarships

You work at a charity or non-profit, helping them make a difference with data. Maybe you write repor...

 

15.09.2018

Brent Ozar Unlimited : [Video] Office Hours 2019/09/12 (With Transcriptions)

This week, Brent, Erik, Tara, and Richie discuss syncing logins and database data via log shipping, ...

 

14.09.2018

Brent Ozar Unlimited : Should Index Changes Require Change Control?

We got a phenomenal series of questions from a client, and I wanted to encapsulate the answers into ...

 

13.09.2018

Brent Ozar Unlimited : Quirks When Working With Extended Events To Track Locks

Worse Than Mobile Browsing I have a love/hate relationship with Extended Events. Yes, they’re ...

 

12.09.2018

Brent Ozar Unlimited : Should You Use the New Compatibility Modes and Cardinality Estimator?

For years, when you right-clicked on a database and click Properties, the “Compatibility Level...

 

11.09.2018

Brent Ozar Unlimited : Can Forced Parameterization Go Wrong?

App Like That If you’ve got the kind of application that sends bare-assed strings to SQL Serve...

 

10.09.2018

Brent Ozar Unlimited : Thoughts On Microsoft’s Azure Outage Post-Mortem

Last week, Azure suffered a day-long outage. One of the services involved was Visual Studio Team Ser...

 

10.09.2018

Marco Russo : Optimizing DAX with cardinality estimation: computing working days

Estimating the cardinality of iterators is an important skill when optimizing DAX code. This article...

 

10.09.2018

Brent Ozar Unlimited : Your SQL Server is Bored: What Low Wait Times Mean

Let’s say you have an assistant. (I know, unlikely, but bear with me.) And say you give your a...

 

08.09.2018

Brent Ozar Unlimited : Announcing SQL Server 2019

TEASE Who Let The Docs Out? If you head over to Microsoft’s GitHub repo, you can peruse around...

 

08.09.2018

Brent Ozar Unlimited : [Video] Office Hours 2018/9/5 (With Transcriptions)

This week, Brent, Tara, Erik, and Richie discuss whether you should keep autoshrink on, AG multisite...

 




Interested?

Receive our monthly newsletter