--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

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...

 

15.05.2018

Brent Ozar Unlimited : How to Screw Up Your Database Updates in 3 Simple Steps

Hi. I’m not Brent. My name’s Alex, and I care about databases, DevOps and data protectio...

 

15.05.2018

Glenn Berry : SQLskills SQL101: The Importance of Maintaining SQL Server

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

 

14.05.2018

SQL Server Blog : A new update for mssql-cli, an interactive CLI, is now available

We have released our second major update for mssql-cli since our public preview announcement in Dece...

 

14.05.2018

SQL Server Blog : Visualize geographic spatial data from SQL Server directly in Tableau 2018.1

This is a partner post authored with the Tableau team As part of Microsofts open and flexible platfo...

 

14.05.2018

Brent Ozar Unlimited : Building SQL ConstantCare®: I Love Unit Tests

You know what my biggest regret is about sp_Blitz? No unit tests. Seriously. Back then, I wrote a bu...

 

14.05.2018

Brent Ozar Unlimited : Today’s Press Conference Transcript: I’m Running for Database Administrator General

Thanks for joining me today – I know you reporters are all really busy, and I appreciate you t...

 

12.05.2018

Stacia Misner : Revisiting Dynamic Web.Contents()

Thus far in my series of posts using hockey data to explore the subject of data analytics in Power B...

 

12.05.2018

SQL Server Customer Advisory Team : Turbo boost data loads from Spark using SQL Spark connector

Reviewed by: Dimitri Furman, Xiaochen Wu Apache Spark is a distributed processing framework commonly...

 

11.05.2018

Brent Ozar Unlimited : Informal Poll: What Are Your Favorite Error Log Messages?

I Know You Have Yours I have mine. When I go looking at a server for the first time, I wanna know ab...

 

11.05.2018

Erin Stellato : Do you need to update statistics after an upgrade?

There are a variety of methods we use for helping customers upgrade to a new SQL Server version, and...

 

11.05.2018

Brent Ozar Unlimited : Where Clustered Index Keys Dare

Colonel Clustered We’ve blogged a couple times about how clustered index key columns get store...

 

10.05.2018

Erin Stellato : Query Store Examples: Stories from customers

In the past week I’ve used Query Store to troubleshoot performance issues for two different cu...

 

10.05.2018

Brent Ozar Unlimited : Book Review: Microsoft SQL Server Training, Volume 1

Last week, I shared a few pictures out of Ron Soukup’s Inside SQL Server 6.5 book. You had a b...

 

09.05.2018

SQL Server Blog : SSMS 17.7 is now available

This post is co-authored bySandy Winarko, Principal PM, SQL Server. We are excited to announce the r...

 

09.05.2018

Brent Ozar Unlimited : When Query Plans Lie Part 2

Getting Weirder In Part 1, we looked at how query plans can tell us little lies. Now we’re goi...

 

08.05.2018

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

This post is co-authored by Karl Burtram, Senior Software Engineer, SQL Server. We are excited to an...

 

08.05.2018

SQL Server Blog : Database scoped default online options is in preview for Azure SQL DB

This post is authored byJosh Gnanayutham, Program Manager, Azure SQL Database. We are happy to annou...

 

08.05.2018

Brent Ozar Unlimited : The DeWitt Clause: Why You Rarely See Database Benchmarks

Back in the early 1980s, Dr. David DeWitt – who you might know from past PASS Summit keynotes,...

 

07.05.2018

Marco Russo : Using COMBINEVALUES to optimize DirectQuery performance

This article describes the behavior of the COMBINEVALUES function in DAX, and how it can optimize th...

 

07.05.2018

Brent Ozar Unlimited : When Query Plans Lie Part 1

Freaking Out Brent Is a full time job. Some days I can get him to hit the desk drawer tequila, and o...

 

07.05.2018

Brent Ozar Unlimited : Availability Groups Bug with Indexed Views

The short story: if you drop an index on an indexed view, queries on the Always On Availability Grou...

 

06.05.2018

Marco Russo : DAX Formatter now uses a different color for variables names

In the latest weeks I received several requests to support a different color for variable names in D...

 

06.05.2018

Stacia Misner : Numerical Variable Relationships

In the previous post in this series (which began all the way back in February 2018 with Getting Star...

 

05.05.2018

SQL Server Customer Advisory Team : CPU and Memory Allocation on Azure SQL Database Managed Instance

Reviewed By: Ajay Kalhan, Borko Novakovic, Drazen Sumic, Branislav Uzelac In the current Azure SQL D...

 

05.05.2018

SQL Server Customer Advisory Team : Azure SQL DB Managed Instance – sp_readmierrorlog

Reviewed by: Kun Cheng, Borko Novakovic, Arvind Shyamsundar, Mike Weiner Azure SQL Database Managed ...

 

04.05.2018

Marco Russo : Removing column filter in Power BI when Sort by Column is active

A recurring issue for Power BI users writing DAX code is that column filter removal might have an un...

 

04.05.2018

Brent Ozar Unlimited : Parameter Fluid Optimization

Optimizer Studies I don’t have a real job, which means that if something strikes my fancy, lik...

 

04.05.2018

Glenn Berry : Windows Disk Cleanup

One very useful tool for freeing up disk space is the built-in Disk Cleanup application in Windows. ...

 

03.05.2018

Brent Ozar Unlimited : Hey, That’s Not My Sort!

Understand Your Plan When reading query plans, you may sometimes see a sort when you didn’t ex...

 

02.05.2018

Glenn Berry : SQL Server Diagnostic Information Queries for May 2018

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

 

02.05.2018

Brent Ozar Unlimited : Book Review: Inside SQL Server 6.5

30 years ago, back in 1988, Microsoft, Ashton-Tate, and Sybase got together to start building SQL Se...

 

01.05.2018

Brent Ozar Unlimited : I’m speaking at SQL Saturday NYC

No, Not Brent Just me. And a few dozen other people, on May 19 (2018). I have sessions on the query ...

 

01.05.2018

Brent Ozar Unlimited : First Responder Kit Release: Darn May Showers

There’s usually something that I think is funny in this space. Instead, I’m going to ext...

 

30.04.2018

Brent Ozar Unlimited : Building SQL ConstantCare®: Refining Our Recommendations

One of the fun things about building SQL ConstantCare® as a cloud-based service is that we can itera...

 

29.04.2018

Stacia Misner : Categorical Variable Relationships

I knew I had a lot to say in this series…and we’re still at the tip of this iceberg with...

 

29.04.2018

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

This week, Brent, Erik, Tara, and Richie to discuss cloud server disaster recovery, Availability Gro...

 




Interested?

Receive our monthly newsletter