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

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

 

07.09.2018

Brent Ozar Unlimited : Forwarded Fetches and Bookmark Lookups

Base Table When you choose to forgo putting  a clustered index on your table, you may find your quer...

 

06.09.2018

Brent Ozar Unlimited : Going to Summit? Here’s a Calendar Invite for My Session.

At Summit, on Wednesday at 1:30PM in room 6C, I’m presenting “Getting Better Query Plans...

 

06.09.2018

Brent Ozar Unlimited : It’s Okay If You Don’t Create Statistics.

Along with the ability to create indexes (which you most definitely should be doing), SQL Server giv...

 

05.09.2018

Paul S. Randal : SQLskills is now a Microsoft Gold Data Platform Partner

We’ve been doing a huge amount of work this year with Microsoft field offices and customers on...

 

05.09.2018

Brent Ozar Unlimited : Locks Taken During Indexed View Modifications

Frankenblog This post has been nagging at me for a while, because I had seen it hinted about in seve...

 

04.09.2018

Brent Ozar Unlimited : Single-Column-Key Missing Index Recommendations are Usually Wrong.

When you’re looking at an index recommendation – whether it’s in an execution plan...

 

03.09.2018

Brent Ozar Unlimited : Building SQL ConstantCare®: You Should Probably Learn Power BI. I Did.

When I was prepping for the PASS Summit last year, I wanted to unveil something awesome and free tha...

 

02.09.2018

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

This week, Brent, Erik, and Richie discuss Microsoft cumulative updates, AlwaysOn Encrypted, query t...

 

31.08.2018

Brent Ozar Unlimited : First Responder Kit Release: What Does A Fish Know About Friday?

I know, it seems like just yesterday I was doing one of these releases. But no, it was three weeks a...

 

31.08.2018

Brent Ozar Unlimited : Free SQL Server Training Next Week at GroupBy

It’s time for another day of free training for the community, by the community. Here’s t...

 

30.08.2018

Erin Stellato : ALTER DATABASE SET QUERY_STORE command is blocked

If you are trying to execute an ALTER DATABASE command to change a Query Store option (e.g. turn it ...

 

30.08.2018

Brent Ozar Unlimited : What Kind Of Statistics Updates Invalidate Plans?

Basics If you update statistics when the underlying objects haven’t been modified, plans won&#...

 

29.08.2018

Brent Ozar Unlimited : What’s Different About SQL Server in Cloud VMs?

When you start running SQL Server in cloud VMs – whether it’s Amazon EC2, Google Compute...

 

29.08.2018

Brent Ozar Unlimited : What Were Your Game-Changing Discoveries in SQL?

If you like learning random tips & tricks, there’s a great discussion going on in Reddit: ...

 

28.08.2018

Brent Ozar Unlimited : Do You Have Tables In Your Tables?

This Isn’t A Trick Question Hopefully it’ll get you thinking about your tables, and how ...

 

27.08.2018

Marco Russo : Optimizing nested iterators in DAX

This article describes how to consider possible optimization approaches to improve performance of ne...

 

27.08.2018

Brent Ozar Unlimited : Building SQL ConstantCare®: Updating ConstantCare.exe

When we started designing SQL ConstantCare® (back before we had a name for it), I listed out the mai...

 

26.08.2018

Paul S. Randal : SQLintersection Fall 2018 (no clash with PASS this year!)

As we head towards our 12th SQLintersection in December, I’m excited to say that it’s on...

 

24.08.2018

Brent Ozar Unlimited : DBAs Need a Jump Box or Jump Server.

Every now and then, you’re going to need to run a query that takes a long time. You’re g...

 

23.08.2018

Brent Ozar Unlimited : Tall Tales From Table Variables

Secret Squirrel When you modify a table with multiple indexes, SQL Server may choose either a narrow...

 

22.08.2018

Brent Ozar Unlimited : It’s Time to Improve DBCC CHECKDB.

Microsoft has been resting on Paul Randal’s laurels for far too long. From 1999 to 2007, Paul ...

 

21.08.2018

Brent Ozar Unlimited : Foundational Material: Microsoft SQL Server Book and Blogs From The Past

What Did Dinosaurs Watch On TV? These are some of my favorite books and blogs from Microsoft from th...

 

21.08.2018

Marco Russo : DAX Studio and Power BI diagnostic port

DAX Studio connects to a Power BI Desktop model using a technique that was not officially supported ...

 

20.08.2018

Brent Ozar Unlimited : Building SQL ConstantCare®: Now Free for Consulting Customers

We’re kinda like an emergency room for SQL Server: we specialize in a 3-day SQL Critical Care®...

 

19.08.2018

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

This week, Brent, Tara, Erik, and Richie discuss error log issues, issues with moving a 2-node AG to...

 

17.08.2018

Brent Ozar Unlimited : A Presenter’s Guide to the Stack Overflow Database

You present on SQL Server topics at user groups and conferences, and you’ve been wondering how...

 

17.08.2018

Marco Russo : Dates differences between Excel and DAX

DAX supports dates starting in 1900 and while teaching DAX I always explain that DAX manages dates l...

 

16.08.2018

Brent Ozar Unlimited : Wait Stats When VSS Snaps Are Slow

Deus Redux A while back I wrote about the Perils of VSS Snaps. After working with several more clien...

 

15.08.2018

Brent Ozar Unlimited : How Trace Flag 2335 Affects Memory Grants

This trace flag is documented in KB #2413549, which says, “Using large amounts of memory can r...

 

14.08.2018

Brent Ozar Unlimited : A Common Query Error

So Many Choices When you only need stuff from a table where there’s matching (or not!) data in...

 

13.08.2018

Marco Russo : Side effects of the Sort By Column setting in DAX

The Sort By Column feature in Power BI causes side effects that are important to know when writing a...

 

13.08.2018

Brent Ozar Unlimited : Setting Up SQL Server: People Still Need Help

I Like What’s Happening I wanna start off by saying that I like what Microsoft has been doing ...

 

12.08.2018

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

This week, Brent, Tara, Erik, and Richie discuss troubleshooting port blocking, page life expectancy...

 

10.08.2018

Brent Ozar Unlimited : First Responder Kit Release: A Year From Now These Will All Stop Working On 2008 And 2008R2

You think I’m kidding. Time bomb. Boom. Get your upgrade underwear on. You can download the up...

 

10.08.2018

Brent Ozar Unlimited : The First 3 Things I Look At on a SQL Server

1. Are backups and CHECKDB being done? Before I step out on the wire, I want to know if there’...

 

10.08.2018

Marco Russo : The hidden secrets of TOTALYTD

DAX has many time intelligence functions that are often redundant, offering different shorter syntax...

 

09.08.2018

Brent Ozar Unlimited : How to Check for Non-Existence of Rows

You’re writing a query, and you wanna check to see if rows exist in a table. I’m using t...

 

08.08.2018

Brent Ozar Unlimited : Why Does My Select Query Have An Assert?

You And Ert This is a quick post because it came up with a client. I like having stuff to point peop...

 

07.08.2018

Brent Ozar Unlimited : A Visual Guide to Choosing an Index Type

Warning: I’m about to overly simplify a whole lot of topics to make things easy. Armchair arch...

 

06.08.2018

Brent Ozar Unlimited : Two Important Differences Between SQL Server and PostgreSQL

SQL ConstantCare® uses PostgreSQL as a back end – specifically, AWS RDS Aurora – so I...

 

05.08.2018

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

This week, Erik and Richie discuss monitoring tools, finding all unused tables across databases, que...

 

03.08.2018

Brent Ozar Unlimited : How to Check Performance on a New SQL Server

So you just built a brand new SQL Server, and before you go live, you wanna check to see if it’...

 

02.08.2018

Glenn Berry : SQL Server Diagnostic Information Queries for August 2018

This month, I spent some time improving and reorganizing the Azure SQL Database queries. I also have...

 

02.08.2018

Brent Ozar Unlimited : Wait Stats Should Be Easy By Now

Why Is My Query… We’ve all started a question with a close approximation of those words....

 

01.08.2018

Brent Ozar Unlimited : How I Configure SQL Server Management Studio

Ever go into Tools-Options? SSMS has a stunning number of options these days. Here are some of my fa...

 

31.07.2018

Brent Ozar Unlimited : A Query That Should Be Contradicted

Innocent Enough I was writing another query, and became enamored with the fact that HAVING will acce...

 

30.07.2018

Marco Russo : Applying a measure filter in Power BI

This article describes how to use a measure to filter a Power BI visualization and what is the diffe...

 

30.07.2018

Brent Ozar Unlimited : New Classes: Dashboard in a Day, Database DevOps, tSQLt, SQL Server Internals, and Avoiding NOLOCK

We’ve got a few new goodies, and they’re 50% off for a limited time! Dashboard in a Day ...

 

30.07.2018

Brent Ozar Unlimited : Common Entity Framework Problems: N + 1

I wanna dance with common problems One of the most common issues that I’ve seen with Entity Fr...

 

28.07.2018

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

This week, Erik and Richie discuss whether it’s relevant to specify data in logs in SQL cloud ...

 

27.07.2018

Brent Ozar Unlimited : [Video] “Actual” Execution Plans Lie for Branching Queries

In which I show why you can’t trust “actual” execution plans for branching stored ...

 

26.07.2018

Brent Ozar Unlimited : Do I Have A Query Problem Or An Index Problem?

Party Up When someone says “this query is slow”, and you can rule out contextual stuff l...

 

25.07.2018

Brent Ozar Unlimited : Does your backup strategy achieve RPO and RTO goals of the business?

When deciding on a backup strategy for a database, there are various things we must consider: Does t...

 

24.07.2018

Brent Ozar Unlimited : CXCONSUMER Is Harmless? Not So Fast, Tiger.

In Theory Let’s say you’ve got a query, and the point of that query is to take your larg...

 

24.07.2018

Marco Russo : Power BI DAX optimization examples

How can you optimize your DAX expressions? In this session, we’ll analyze DAX expressions and ...

 

24.07.2018

Marco Russo : Time intelligence in Microsoft Power BI

Every Microsoft Power BI model has dates and the need for calculation over dates to aggregate and co...

 

23.07.2018

Brent Ozar Unlimited : Building SQL ConstantCare®: What Mentoring Is (and Isn’t)

When we built SQL ConstantCare® as a mentoring – not monitoring – product, I really mean...

 

22.07.2018

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

This week, Brent, Erik, and Tara discuss their SQL server specialization, CPU-ready time, making SSI...

 

20.07.2018

SQL Server Customer Advisory Team : Storage performance best practices and considerations for Azure SQL DB Managed Instance (General Purpose)

Reviewed by: Kun Cheng, Borko Novakovic, Jovan Popovic, Denzil Ribeiro, Rajesh Setlem, Arvind Shyams...

 

20.07.2018

Brent Ozar Unlimited : How to Test Disaster Recovery Before You Go Live

When I build a server, success means not touching the server again for 2-3 years. I already have eno...

 

20.07.2018

Brent Ozar Unlimited : Election Injection

Setting politics aside (Lord knows I’d like to), this ABC 7 Chicago news story covers how Russ...

 

20.07.2018

Paul S. Randal : New Pluralsight course: SQL Server 2017: Diagnosing Configuration Issues with DMVs

Glenn’s latest Pluralsight course has been published: SQL Server 2017: Diagnosing Configuration Issu...

 

19.07.2018

Brent Ozar Unlimited : Announcing “Great Post, Erik” – A Book of Erik’s Best Work

Erik Darling blogs a lot. Not lightweight stuff, either, but ambitious posts with a lot of demo scri...

 

19.07.2018

Erin Stellato : Query Store Training – Portugal

I am so excited to announce that I am presenting a full day of Query Store Training, in-person, this...

 

19.07.2018

Marco Russo : On comparing Power BI with other tools

In the last few years, the Business Intelligence (BI) world has been moving towards self-service BI....

 

18.07.2018

Glenn Berry : SQL Server 2016 SP2 CU2 Available

On July 16, 2018, Microsoft released SQL Server 2016 SP2 CU2, which is Build 13.0.5153.0. There are ...

 

18.07.2018

Brent Ozar Unlimited : A Quirk In Parallel Hash Join Plans

Bailing, Takes Me Away Both of these queries will return zero rows, in the 2010 version of the Stack...

 

17.07.2018

Brent Ozar Unlimited : A New tempdb Trace Flag Appears!

Coming Around Microsoft has been doing a good job of taking stuff that used to be Wizard Hat and mak...

 

17.07.2018

Erin Stellato : Monitoring Space Used by Query Store

Last week I presented a session on Query Store and when talking about the settings I mentioned that ...

 

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

 




Interested?

Receive our monthly newsletter