--SQL User Group





Upcoming Events

15.10.2018

dataMinds Connect 2018

dataMinds Connect will take place on Monday 15th and Tuesday 16th October, at the Ghelamco Arena in Ghent.

 




Latest community news

17.07.2018

SQL Server Customer Advisory Team : DataCAT team at Data Platform Summit 2018

Team members from Microsoft AzureCAT (a.k.a. DataCAT / SQLCAT) will be presenting a full-day pre-con...

 

16.07.2018

Marco Russo : Power BI is a model-based tool

This article describes the differences between report-based tools and model-based tools. Because Pow...

 

16.07.2018

Brent Ozar Unlimited : Building SQL ConstantCare®: What Cloud Hosting Costs

In our behind-the-scenes posts about building SQL ConstantCare®, I’ve written about how we pic...

 

16.07.2018

Brent Ozar Unlimited : What Do You Want to Learn This Fall?

We’re designing a new round of courses for the fall. Let us know what you want to learn in thi...

 

15.07.2018

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

This week, Brent, Richie, and Erik discuss best account practices for SQL Server, change tracking, d...

 

14.07.2018

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

This week, Brent, Erik, Tara, and Richie discuss using SQL Server 2016 vs 2017 for production enviro...

 

13.07.2018

Brent Ozar Unlimited : [Video] SSIS Design Patterns: Extract, Load, and Transform – and Save 50% on Training

This week, we’re sharing Instant Replay videos from our training classes. Last but not least t...

 

12.07.2018

Brent Ozar Unlimited : [Video] Installing SQL Server Updates in an Availability Group, and Save 50% on Training

This week, we’re sharing Instant Replay videos from our training classes. Today’s Instan...

 

11.07.2018

Brent Ozar Unlimited : [Video] Interpreting Missing Index Recommendations

This week, we’re sharing Instant Replay videos from our training classes. Next up is Pinal Dav...

 

11.07.2018

Glenn Berry : T-SQL Tuesday #104: Code I Have Written That I Would Hate to Live Without

Bert Wagner (b/t) is hosting T-SQL Tuesday #104. The invitation is to write about code you’ve writte...

 

10.07.2018

Brent Ozar Unlimited : [Video] PowerShell Functions and Parameters, and 50% Off Training Classes

This week, we’re sharing some of the Instant Replay videos from our training classes. First up...

 

10.07.2018

Brent Ozar Unlimited : #TSQL2sday: +

For this month’s T-SQL Tuesday, He of Perfect Hair, Bert Wagner asked, “What code have y...

 

10.07.2018

Brent Ozar Unlimited : #TSQL2sday: How Much Plan Cache History Do You Have?

For this month’s T-SQL Tuesday, Bert Wagner asked, “What code have you written that you ...

 

09.07.2018

Brent Ozar Unlimited : Building SQL ConstantCare®: Analyzing Query Plans

XML Delenda Est Last week, I talked about how we’re going to be collecting query plans from us...

 

06.07.2018

Brent Ozar Unlimited : Why SQL Developers Keep Making The Same Mistakes

Dead Horses I read a lot of SQL blogs, both new and old. What’s striking is how many blogs see...

 

06.07.2018

Glenn Berry : SQL Server Diagnostic Information Queries for July 2018

This month, there are improvements to seven of the the SQL Server 2012 and newer versions of the que...

 

05.07.2018

Brent Ozar Unlimited : Ola Hallengren’s Scripts Keep Getting Better

You Know Him, You Love Him You trust your database backups and integrity checks to him, and he has b...

 

04.07.2018

Brent Ozar Unlimited : 10 SQL Server Feature Requests I’ve Upvoted Recently

In no particular order: Database Level Option for Storing Wait Stats – just like we can store ...

 

03.07.2018

Brent Ozar Unlimited : Management Studio Hides Missing Indexes From You.

SQL Server Management Studio only shows you the first missing index recommendation in a plan. Not th...

 

03.07.2018

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

So far this year, we at SQLskills have presented remotely (and a few in-person) to 59 user groups an...

 

02.07.2018

Marco Russo : Creating table functions in DAX using DETAILROWS

This article describes how to use the detail rows expression of a measure to obtain the equivalent o...

 

02.07.2018

Marco Russo : Smart Filter Pro Preview

Today we start the preview of Smart Filter Pro. This is the first commercial custom visual produced ...

 

02.07.2018

Brent Ozar Unlimited : Building SQL ConstantCare®: Collecting Query Plans

Coming Soon In an upcoming release, we’ll start collecting query plans from your servers. Sinc...

 

29.06.2018

Brent Ozar Unlimited : [Video] What to Do When SQL Server is Slow

Someone comes running in and asks, “Are you doing something on the SQL Server right now? Can y...

 

29.06.2018

Brent Ozar Unlimited : [Video] SQL Query Optimization: Why Is It So Hard to Get Right?

The first paper on cost-based query optimization was published in 1979 by Patricia Selinger from IBM...

 

28.06.2018

Paul S. Randal : What is the FCB_REPLICA_SYNC spinlock?

A question came up on the Data Platform MVP email list last night asking what the FCB_REPLICA_SYNC s...

 

28.06.2018

Brent Ozar Unlimited : Does It Matter Which Field Goes First in an Index?

Let’s take the dbo.Users table from the Stack Overflow database, which holds exactly what you ...

 

27.06.2018

Brent Ozar Unlimited : First Responder Kit Release: Like pssdiag, if pssdiag had parents who cared

I went to the PFE and guess what he told me? Guess what he told me? He said girl you better try fix ...

 

27.06.2018

Brent Ozar Unlimited : How The Cloud Turns Performance Tuning Into Cost Savings

Barely Metal In Ye Olde Olden Dayyes, companies would outline hardware budgets and refresh cycles. E...

 

26.06.2018

Brent Ozar Unlimited : [Video] Why Performance Tuning Wisdom Needs Expiration Dates

Several months ago, Erik said something like, “We should do a performance art piece where one ...

 

25.06.2018

Brent Ozar Unlimited : Building SQL ConstantCare®: How We Use Feature Toggles

In SQL ConstantCare®, you send in your SQL Server’s diagnostic data, our systems analyze it, a...

 

25.06.2018

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

This week, Brent, Erik, and Richie discuss using foreign keys in a data warehouse, SQL Server virtua...

 

24.06.2018

Marco Russo : Correct calculate of age in DAX from birthday

By answering to a student question I realized we often used a wrong calculation of customers age in ...

 

22.06.2018

Erin Stellato : Updating Statistics with Ola Hallengren’s Script

I am a HUGE fan of updating statistics as part of regular maintenance.  In fact, if you don’t know i...

 

22.06.2018

Brent Ozar Unlimited : Announcing My @DevIntersection Pre-Con: Developer’s Guide to SQL Server Performance

You’ve built an application that uses SQL Server or Azure SQL DB as a back end, and it’s...

 

22.06.2018

Brent Ozar Unlimited : Job Duties for Database Developers, Development DBAs, and Production DBAs

At the start of my classes and calls, I ask folks to introduce themselves – not by what it say...

 

21.06.2018

Brent Ozar Unlimited : 300 Blogs And Running

Why Bother Blogging? I blog primarily because there’s a Certain Kind of Person that irks me to...

 

20.06.2018

Glenn Berry : AMD Ryzen Threadripper 2990X CPU-Z Leaks?

On June 5, 2018, during the Computex show in Taiwan, AMD revealed some details about its upcoming 12...

 

20.06.2018

SQL Server Blog : The June release of SQL Operations Studio is now available

We are excited to announce the June release of SQL Operations Studio is now available. Download SQL ...

 

20.06.2018

Brent Ozar Unlimited : How to Fix sp_BlitzIndex Aggressive Indexes Warnings

sp_BlitzIndex gives your indexes a psychiatrist-style evaluation. It’s a lot like a real psych...

 

19.06.2018

Glenn Berry : Performance and Stability Related Fixes in Post-SQL Server 2016 SP2 Builds

As of May 30, 2018, there has been one Cumulative Update (CU) for the Service Pack 2 branch of SQL S...

 

19.06.2018

Brent Ozar Unlimited : A Surprising Simplification Limitation

When It Comes To Simplification Rob Farley has my favorite material on it. There’s an incredib...

 

18.06.2018

Marco Russo : Optimizing mutually exclusive calculations

This article describes how to optimize DAX expressions with mutually exclusive calculations that mig...

 

18.06.2018

Marco Russo : My Power BI report is slow: what should I do?

You have created a wonderful looking Power BI report, but when you open it you find it is not render...

 

18.06.2018

Brent Ozar Unlimited : Updating Paste The Plan to use the Serverless Framework

I just updated PasteThePlan, and the change you’ll notice first is that we’re using the ...

 

18.06.2018

Erin Stellato : Can you force a plan for a different query with Query Store?

This is question I’ve gotten a few times in class…Can you force a plan for a different query w...

 

17.06.2018

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

This week, Brent and Richie discuss using full-text index, Elasticsearch, server restart issues, sp_...

 

15.06.2018

Brent Ozar Unlimited : Can Non-SARGable Predicates Ever Seek?

Cheating At Candy Crush The short answer is that yes, they can. But only with a little extra prepara...

 

15.06.2018

Erin Stellato : Query Store and the Plan Cache Flushing

I’ve had two comments recently on my blog about Query Store causing the plan cache to be flushed. Th...

 

14.06.2018

Erin Stellato : Why aren’t you using Query Store?

Way back in 2016 I wrote a post trying to find out why people were not using Extended Events.  See, ...

 

14.06.2018

Brent Ozar Unlimited : Why You Should Stop Depending On SQL Server Versions In Code

It Used To Be That when you wrote scripts that had to work across different versions of SQL Server, ...

 

13.06.2018

Brent Ozar Unlimited : Nodes Offline: Why Your SQL Server VM Can’t Use All Its Virtual Hardware

When you install SQL Server Standard or Web Edition in a virtual machine with more than 4 cores, thi...

 

12.06.2018

Brent Ozar Unlimited : New Stack Overflow Public Database Available (2018-06)

@Taryn and the kind folks at Stack Overflow publish their data export periodically with your questio...

 

12.06.2018

Brent Ozar Unlimited : Indexing Strategies For Cross Apply

Slicked Brad The apply operator remains one of my favorite tools, but much like CTEs and windowing f...

 

11.06.2018

Paul S. Randal : New live online training class in October: Fixing Slow Queries, Inefficient Code, and Caching/Statistics Problems

Continuing our series of live, online classes, Erin, Jonathan, and Kimberly will be delivering their...

 

11.06.2018

Paul S. Randal : New live online training class in October: Transactions, Locking, Blocking, Isolation, and Versioning

Continuing our series of live, online classes, Kimberly will be delivering her new IETLB: Immersion ...

 

11.06.2018

Paul S. Randal : New live online training class in August: Planning and Implementing an Upgrade/Migration to SQL Server 2017

Continuing our series of live, online classes, Glenn will be delivering his new IEPUM2017: Immersion...

 

11.06.2018

SQL Server Blog : SQL Server Automatic Tuning around the world…

..and in the cloudsWhen I first saw early builds of SQL Server 2017, one of the features that caught...

 

11.06.2018

Brent Ozar Unlimited : Building SQL ConstantCare®: Why People Aren’t Using Query Store

When Microsoft first talked about Query Store, I was wildly excited. It’s basically a black bo...

 

10.06.2018

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

This week, Brent, Erik, Tara, and Richie discuss index maintenance, stats updates, the acquisition o...

 

09.06.2018

Stacia Misner : Using SSIS to Stage JSON in SQL Server Tables

Last month I started wrangling with JSON in SSIS and discussed how to download JSON files and store ...

 

08.06.2018

Brent Ozar Unlimited : Announcing a Very Special #SQLFamily Webcast with Dr. David DeWitt

On Thursday, June 28th, at noon Eastern (see in your local time zone), join us for a very special pr...

 

08.06.2018

Brent Ozar Unlimited : Demoing Latch Waits with Stupid Tricks

Say you’ve got PAGELATCH_UP or PAGELATCH_EX waits, and you’re wondering what might be ca...

 

07.06.2018

Brent Ozar Unlimited : How Table Variables Mess With Parallelism

This Is A Parallel Query This Is A Temp Table [crayon-5b1ab31ab8028447860303/] This Is A Parallel In...

 

06.06.2018

Glenn Berry : Speaking at PASS Summit 2018

I am honored to have been selected to present a half-day session at the PASS Summit 2018 in Seattle,...

 

06.06.2018

Brent Ozar Unlimited : Stupid T-SQL Tricks

Presented without comment: [crayon-5b180871ba4d6413244018/] Next up, can you break up a query with s...

 

05.06.2018

Glenn Berry : SQL Server Diagnostic Information Queries for June 2018

This month, there are more minor updates to the SQL Server 2012 and newer versions of the queries, p...

 

05.06.2018

Paul S. Randal : CXCONSUMER wait type – history and what you need to know

I’m a little bit overdue to blog about this new wait type, but I wanted to wait until SQL Serv...

 

05.06.2018

Brent Ozar Unlimited : Is Your Database Databasic?

Pumpkin Spice When I’m looking at someone’s server, it’s easy to tell the kind of ...

 

04.06.2018

Marco Russo : Optimizing IF conditions using variables

This article describes a very common optimization pattern using variables to optimize conditional ex...

 

04.06.2018

Brent Ozar Unlimited : First Responder Kit Release: Just When You Think There’s Nothing New Left To Do

T*m* f*r An*th*r F*rst R*spond*r K*t R*l**s*. All joking aside! A big thank you goes out to a few pe...

 

04.06.2018

SQL Server Blog : Microsoft releases the latest update of Analytics Platform System

Microsoft is pleased to announce that the Analytics Platform System (APS) appliance update 7 (AU7) i...

 

04.06.2018

Brent Ozar Unlimited : New Training Videos on Memory Grants, Paging, Reporting, Variables, and More

This week, Erik’s added several new videos to his T-SQL Level Up: Level 2 course: Memory Grant...

 

02.06.2018

Stacia Misner : T-SQL JSON Output to Flat File Destination in SSIS

In my last post, I was stymied by a problem in SSIS. My goal was to use a T-SQL statement to generat...

 

02.06.2018

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

This week, Brent, Erik, Tara and Richie discuss severity 16 error warning, best way to move database...

 

01.06.2018

Brent Ozar Unlimited : Mysterious Forwarded Records

Thinking Of You When people think about Heaps and the problems they can cause, they don’t ofte...

 

01.06.2018

Marco Russo : How to write DISTINCTCOUNTX in DAX

I received a question about how to implement the equivalent of a DISTINCTCOUNTX function in DAX. Wel...

 

31.05.2018

Brent Ozar Unlimited : Wanna Attend All My Classes for a Year?

When I introduced my Live Class Season Pass, buyers got access to my entire new Mastering series for...

 

30.05.2018

Brent Ozar Unlimited : How Many Kinds Of Joins Are There?

Quite So There are three in SQL Server, not counting the Adaptive Join which is just a placeholder f...

 

29.05.2018

SQL Server Blog : Cloud data and AI services training roundup May 2018

To help you stay up to date on online training opportunities, were releasing a monthly list of the l...

 

29.05.2018

SQL Server Blog : SQL Server at the Red Hat Summit 2018

This blog post is authored byBob Ward, Principal Architect, Microsoft; Travis Wright, Principal Prog...

 

29.05.2018

Brent Ozar Unlimited : Behind Every Trivial Plan Is A Good Demo

A While Back I started this Q&A on Stack Exchange about ISNULL. It’s one of the most commo...

 

28.05.2018

Brent Ozar Unlimited : How to Tell If Your SQL Server Has Too Much Memory

Sounds impossible, right? The saying goes that you can never be too rich or too thin or have too muc...

 

27.05.2018

Stacia Misner : Using SSIS to Retrieve JSON Files

As I mentioned in my previous post, I’ve been wrangling at lot of JSON lately. And, in my spar...

 

26.05.2018

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

This week, Brent, Tara, and Richie discuss relaying SQL Server performance updates to upper manageme...

 

26.05.2018

Marco Russo : Change culture/collation of an Analysis Services Tabular database

When you create a Tabular model for Analysis Services, the Culture and Collation properties are set ...

 

25.05.2018

Brent Ozar Unlimited : SQL Server Setup Feature List Changes 2008-2017

If you happen to install several SQL Servers in a row, you’ll notice differences from over the...

 

24.05.2018

Brent Ozar Unlimited : A Strange Place For A Memory Grant

If You Hang Around Fetish Bars Long Enough… You learn things about memory grants in execution ...

 

24.05.2018

Paul S. Randal : SQLskills SQL101: Why do some wait types need to be ignored?

SQLskills has an ongoing initiative to blog about basic topics, which we’re calling SQL101. We’re al...

 

23.05.2018

Brent Ozar Unlimited : How to Reduce the CPU Overhead of Dynamic SQL

Dynamic SQL is a good choice for catch-all type queries, but you have to be careful how you execute ...

 

23.05.2018

Marco Russo : Time intelligence issues in DAX for fiscal years starting in March

If you have a fiscal year starting in March, you can have a problem using the time intelligence func...

 

22.05.2018

Brent Ozar Unlimited : Trivial Plans, Simple Parameterization and Check Constraints

Trivial Plans Are Weird They’re the optimizer’s “Yes, Dear”.  The thing is, ...

 

21.05.2018

Brent Ozar Unlimited : Building SQL ConstantCare®: Adding Daily Emails and Recognizing Your Work

When we first launched SQL ConstantCare®, the workflow was: You sent in data about your SQL Servers ...

 

21.05.2018

Marco Russo : From SQL to DAX: Joining Tables

In SQL there are different types of JOIN, available for different purposes. This article shows the e...

 

20.05.2018

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

This week, Brent, Erik, Tara, and Richie are back in action again to and are discussing sys.dm_db us...

 

19.05.2018

Stacia Misner : Handling JSON in SSIS

I believe the first time I ever learned JSON was a thing in the data world was when I attended SQLSa...

 

18.05.2018

Brent Ozar Unlimited : Stuff People Tell Me Is The Default

Playing The Odds Assuming that life carries on as usual for a couple more weeks, I’ll have bee...

 

17.05.2018

Brent Ozar Unlimited : How to Create Deadlocks and Troubleshoot Them

Watch in awe and wonder as I create a deadlock, then use sp_BlitzLock after the fact to show you whi...

 

16.05.2018

Kevin Kline : Quick Tip – Speed a Slow Restore from the Transaction Log

Here’s a quick tip for you: During some restore operations on Microsoft SQL Server, the transa...

 

16.05.2018

Brent Ozar Unlimited : Quick Tips For Debugging Large Stored Procedures

Hell Here! Get Your Fresh Hell, Here! Let’s face it — as far as developer tools go, SSMS...

 




Interested?

Receive our monthly newsletter