--SQL User Group





Upcoming Events

13.09.2018

Building & deploying custom ML models with Azure ML

Azure offers a wide range of services that make it easier than ever to bring intelligence to your business and to create and deploy your own custom machine learning models.

This session will explore the Azure machine learning CLI as an effective tool to train your own models in a streamlined way. We will create our own face recognition model in TensorFlow, evaluate its accuracy and deploy the model both to the cloud and the edge using the CLI.

Additionally, we will shortly explore alternative tools for AI and machine learning in Azure, so that we can pick the best fitting solution for every use case.

 

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

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

 

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

 

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

 




Interested?

Receive our monthly newsletter