--SQL User Group





Upcoming Events

06.03.2018

Crazy Data Science

Data is the most valuable asset to any company right now and you can gain a corporate advantage through the insights your data can provide. However, implementing Advanced Analytics can also lead to very... interesting... results.

Remember that algorithm that named paint colors? That's nothing compared to what you are going to witness in this session. From analyzing demonic possession based on selfies to analyzing how "metal" a song is.

In this session presented by mad data scientists Tomaž Kaštrun and Enrico van de Laar we will explore all the crazy things that are possible with data science.  And who knows?  You might even learn a thing or two!

 

12.04.2018

Datawarehouse Lightning Performance with Columnstore!

During this session we will be talking about Columnstore Indexes and how to use them. We will be showing you tips & tricks on how to get the performance you want out of Columnstore.

We will show you the concepts on how to efficiently load data to your Columnstore tables, how to get your Columnstore properly created and some dangers with performance you might face when working with Columnstore Indexes as seen in the field!

After this session things like segment elimination, auto adjust buffer size, Delta Store, ... will no longer be a mysterious concept for you and you will be ready to start implementing the different flavors of Columnstore Indexes in your environment.

 




Latest community news

23.02.2018

Paul S. Randal : New Pluralsight course: Building Multi-instance Asynchronous Applications

Jonathan’s latest Pluralsight course has been published – SQL Server: Building Multi-instance ...

 

23.02.2018

Paul S. Randal : New Pluralsight course: Understanding, Configuring, and Troubleshooting Database Mirroring

Glenn’s latest Pluralsight course has been published – SQL Server: Understanding, Configuring and Tr...

 

23.02.2018

Glenn Berry : SQL Server 2017 Cumulative Update 4

On February 20, 2018, Microsoft released SQL Server 2017 Cumulative Update 4, which is Build 14.0.30...

 

23.02.2018

Brent Ozar Unlimited : Computed Columns and Cardinality Estimates

:thinking_face: When most people think about computed columns, they don’t think about cardinal...

 

22.02.2018

Brent Ozar Unlimited : Using WITH (NOEXPAND) to Get Parallelism with Scalar UDFs in Indexed Views

Scalar functions are the butt of everybody’s jokes: their costs are wrong, their STATS IO resu...

 

21.02.2018

Glenn Berry : SQL Server Diagnostic Information Queries for February 2018

This month, there are more minor updates to the all of the versions of the queries, primarily in the...

 

21.02.2018

SQL Server Blog : Announcing a new update for mssql-cli: Special Commands

This post is authored by Alan Yu, Program Manager, SQL Server. We have released our first major upda...

 

21.02.2018

Brent Ozar Unlimited : Let’s Give The Optimizer A Name

Clunky As my favorite monkey likes to say, the hardest things do with computers are: 1. Naming thing...

 

20.02.2018

SQL Server Blog : What’s new in SSMS 17.5: Data Discovery and Classification

This post is authored by Alan Yu, Program Manager, SQL Server. We are excited to announce the releas...

 

20.02.2018

Brent Ozar Unlimited : How to Throttle Logins to SQL Server

So, uh, you can use WAITFOR in a logon trigger: [crayon-5a8c5782e0328301119748/] You probably don...

 

19.02.2018

Marco Russo : Reference Date Table in DAX and Power BI

This article describes a reference Date table in DAX using a Power BI template. The same technique c...

 

19.02.2018

Marco Russo : DAX Date Template

DAX Date Template is a Power BI template file containing a fully-featured Date table. This template ...

 

19.02.2018

Brent Ozar Unlimited : The Many Levels Of Concurrency

“Concurrency is hard” When designing for high concurrency, most people look to the hardw...

 

17.02.2018

Stacia Misner : Dynamic Web.Contents() and Power BI Refresh Errors

Recently, one of my clients was working with a new data source in Power BI that required multiple ca...

 

17.02.2018

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

This week, Brent, Tara, and Richie discuss the lack of backward compatibility for SQL Server backups...

 

16.02.2018

Brent Ozar Unlimited : Then Why Doesn’t SQL Always Seek?

Scan The Man There seems to be a perpetual battle waged against the Index Scan. At some point it was...

 

16.02.2018

Brent Ozar Unlimited : New SQL Server Management Studio 17.5: It’s Classified

SQL Server Management Studio 17.5 is out, and new in this release is a SQL Data Discovery & Clas...

 

15.02.2018

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

This post is authored by Alan Yu, Program Manager, SQL Server. We are excited to announce the Februa...

 

15.02.2018

SQL Server Blog : Sync SQL data in large scale using Azure SQL Data Sync

This post is authored by Xiaochen Wu, Program Manager, SQL Server.   Azure SQL Data Sync allows user...

 

15.02.2018

Brent Ozar Unlimited : Memory Grants: SQL Server’s Other Public Toilet

Sharing Is Caring When everything is going well, and queries are behaving responsibly, one need hard...

 

14.02.2018

Brent Ozar Unlimited : How to Suck at Database Admininstration

This isn’t about having a sucky job, this is about you sucking at your job. There’s a bi...

 

14.02.2018

Erin Stellato : T-SQL Tuesday #99: Life Outside SQL Server

I am late to the party (I am often late to the party, just ask Aaron Bertrand, this month’s ho...

 

13.02.2018

Glenn Berry : T-SQL Tuesday #99: Home Brewing

It is T-SQL Tuesday time for February 2018, which is being hosted by Aaron Bertrand. One of the choi...

 

13.02.2018

Brent Ozar Unlimited : #TSQL2sday: What I’m Passionate About – Sas Christian’s Art

For this month’s T-SQLTuesday, Aaron Bertrand asked what we’re passionate about – ...

 

12.02.2018

Brent Ozar Unlimited : Attending our SQLBits Pre-Con? Prepare Your Laptop Now.

If you’re joining Erik & me at our SQLBits precon, Expert Performance Tuning for SQL Serve...

 

09.02.2018

Stacia Misner : Using Parameters in an R Script for a Power BI Query

In my last post, I described a problem I had working with an R script in Power BI for which the caus...

 

09.02.2018

Brent Ozar Unlimited : The Annals of Hilariously Bad Code, Part 2

You’re Crazy In Part 1, I showed you code that I think has some anti-patterns in it. In case y...

 

08.02.2018

Brent Ozar Unlimited : Creating Insert Triggers to Silently Ignore Data You Don’t Want

Say you’ve got an application that insists on inserting data into the database, and…you ...

 

07.02.2018

Brent Ozar Unlimited : Using LIKE on Integers Gets You Implicit Conversion

Using the Stack Overflow public export, take these two queries looking for a particular user by Id (...

 

07.02.2018

Marco Russo : The new Data Modeling for Power BI course

If you import more than one table into Power BI or Power Pivot, you have a data model. When you have...

 

06.02.2018

Paul S. Randal : Setting mentoring ground rules

One of the things I always recommend in the first newsletter of each year is to try to get a mentor....

 

06.02.2018

Brent Ozar Unlimited : The Annals of Hilariously Bad Code, Part 1: Critique the Code

Hey Beavis That’s the first time I’ve used “annals” correctly. I will be 40 ...

 

06.02.2018

Glenn Berry : SQLskills SQL101: How You Can Make Your Database Backups More Reliable

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

 

05.02.2018

Marco Russo : DAX optimization examples

How do you optimize a DAX expression? In this session we analyze some DAX expressions and Tabular mo...

 

05.02.2018

Brent Ozar Unlimited : Things I Have Not Heard Recently

“No, don’t bother the DBA. It’s probably not a database problem.” “Sol...

 

05.02.2018

Marco Russo : The definitive guide to ALLSELECTED

ALLSELECTED is a powerful function that can hide several traps. This article is an in-depth analysis...

 

04.02.2018

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

This week, Tara, Erik, and Richie discuss 3rd-party tools for object-level restore, patching, string...

 

04.02.2018

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

This week, Brent, Tara, and Richie discuss a simple way to fill tempdb, tools for retrieving data fr...

 

02.02.2018

Stacia Misner : Power BI: R Home Directory vs Library Trees

Although I’ve been writing the last few weeks about Power BI, the rest of my time during the last mo...

 

02.02.2018

Brent Ozar Unlimited : A Gentle Introduction To the Stack Overflow Schema

Stack: Dumped Wanna learn the schema of the free Stack Overflow public database? If you want the Ful...

 

01.02.2018

Marco Russo : Power Pivot Utilities 1.09

Bertrand d’Arbonneau added a new feature in the last version (v 1.09) of Power Pivot Utilities...

 

01.02.2018

Brent Ozar Unlimited : Functions and “the use of indexes”

Wordy Bird This sentence gets repeated a lot. You know the one. “Functions prevent the use of ...

 

01.02.2018

Erin Stellato : Query Store and “in memory”

If you’ve ever been to one of my sessions you know that I really like demos.  I find they can illust...

 

31.01.2018

Brent Ozar Unlimited : Scripting Tip: Start With Crediting Your Source

In the course of your career, you’re going to accumulate a folder of scripts to do various tas...

 

30.01.2018

Brent Ozar Unlimited : Tom Roush, the SQL Server community’s best storyteller.

You, dear reader, know a lot of SQL Server community names from their blogs, webcasts, podcasts, pre...

 

30.01.2018

Brent Ozar Unlimited : Other People’s GitHubs: Fork, Clone, and Pull

Let’s say you found an interesting repository (code project) on Github, and you wanted to make...

 

29.01.2018

Paul S. Randal : More live online training from Kimberly in March!

Due to the popularity of Kimberly’s delivery of her new IEVLT: Immersion Event on Very Large T...

 

29.01.2018

Brent Ozar Unlimited : Froid: How SQL Server vNext Might Fix the Scalar Functions Problem

Scalar functions and multi-statement table-valued functions are notorious performance killers. They ...

 

28.01.2018

Brent Ozar Unlimited : First Responder Kit Release: Sunday, Boring Sunday

This is a modified limited release. After a few new feature releases, we’re achieving stasis. ...

 

26.01.2018

Marco Russo : Why I attend conferences and why I speak at conferences

I’ve recently been asked to talk about my experience as a speaker at technical conferences. I wasn’t...

 

26.01.2018

Brent Ozar Unlimited : New Speed Controls for Training Videos

All of our training classes include Instant Replay, the ability to watch a recorded version of your ...

 

25.01.2018

Stacia Misner : Crushing Your Goals with Power BI: Visualizing Progress

Now that I have data both for my goals and for my subsequent goal-related activity as described in m...

 

25.01.2018

Brent Ozar Unlimited : Two Code Patterns That Don’t Virtualize Well

Virtualization used to be a really Big Deal™ for database admins: we had to do a lot of careful plan...

 

24.01.2018

Paul S. Randal : SQLskills SQL101: Why does my heap have a bunch of empty pages?

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

 

24.01.2018

Brent Ozar Unlimited : Computed Columns: Reversing Data For Easier Searching

During Training We were talking about computed columns, and one of our students mentioned that he us...

 

23.01.2018

Brent Ozar Unlimited : What Students Said About My New Hands-On Mastering SQL Server Classes

In my new 3-day Mastering Index Tuning, Mastering Query Tuning, and Mastering Server Tuning, you get...

 

22.01.2018

SQL Server Customer Advisory Team : SQL Server VLDB in Azure: DBA Tasks Made Simple

Reviewed by: Rajesh Setlem, Mike Weiner, Xiaochen Wu With thanks to Joey D’Antoni (blog) for asking ...

 

22.01.2018

Marco Russo : Optimizing duplicated DAX expressions using variables

This article describes how to use variables to optimize the performance of DAX expressions containin...

 

22.01.2018

SQL Server Blog : SQL Server 2017 on Linux webcast series

The world’s leading database is now available on Linux by bringing Microsoft SQL Server to Linux, Mi...

 

22.01.2018

Brent Ozar Unlimited : Updated (and Smaller!) Stack Overflow Demo Databases

The nice folks over at StackOverflow.com (shout out, @onlybluefeet) updated their public data dump l...

 

19.01.2018

Brent Ozar Unlimited : How Much Can One Row Change A Plan, Part 4

Monte Carlo Or Bust In Part 3, I showed you how two queries with TOP clauses can produce wildly diff...

 

18.01.2018

Glenn Berry : Checking Your SQL Server Instance for Spectre/Meltdown Patches

If you are running SQL Server 2008 through SQL Server 2017, you should be thinking about what you sh...

 

18.01.2018

SQL Server Blog : Webinar: Modernize your applications with cloud and on-premises data solutions from Microsoft

Customers today demand the latest innovations in every solution you deliver. How can you make sure y...

 

18.01.2018

Brent Ozar Unlimited : How Much Can One Row Change A Plan, Part 3

All The Rage We’ve asked how much one column and even one row can change a plan before. The do...

 

17.01.2018

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

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

 

17.01.2018

Brent Ozar Unlimited : [Video] The Junior DBA Workout Plan

Squat, deadlift, overhead press, and bench press. In the gym, it’s easy to figure out what you...

 

16.01.2018

Brent Ozar Unlimited : When Does Index Size Change Index Choice?

Size Matters? One thing I hear a lot is that the optimizer will take the size of an index into accou...

 

15.01.2018

Stacia Misner : Crushing Your Goals with Power BI: Measuring Progress

In my previous post in this series, I explained how to capture and load goals data into Power BI and...

 

14.01.2018

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

This week Brent, and Richie discuss validating backups using the backup set table, how to figure out...

 

12.01.2018

Brent Ozar Unlimited : SQL Server 2017 CU3 adds optimizer row goal information in query plans

Row Whats? Like it or not, the optimizer has row goals. We’re not going to go terribly in-dept...

 

11.01.2018

Glenn Berry : Checking Your Intel Processor Features Regarding the Meltdown Exploit

By now, you have probably heard plenty about the Spectre and Meltdown exploits that affect many mode...

 

11.01.2018

Brent Ozar Unlimited : SQL Server 2017 CU3 adds tempdb spill diagnostics in DMVs and Extended Events

Where have you been all my life? Whenever I’m teaching people about query tuning, two things c...

 

10.01.2018

Paul S. Randal : SQLintersection Spring 2018

As we head towards our 11th SQLintersection in March, I’m excited to say that it’s once ...

 

10.01.2018

Glenn Berry : SQL Server Diagnostic Information Queries for January 2018

This month, there are more minor updates to the all of the versions of the queries, primarily in the...

 

10.01.2018

Paul S. Randal : New Pluralsight course: Automatic Tuning in SQL Server 2017 and Azure SQL Database

Erin’s latest Pluralsight course has been published – SQL Server: Automatic Tuning in SQL Server 201...

 

10.01.2018

Brent Ozar Unlimited : SQL Server 2017 CU3 adds CXCONSUMER waits, doesn’t mention it

The revolution will not be documented At the PASS 2017, Pedro Lopes (don’t call him low-pez) f...

 

09.01.2018

Brent Ozar Unlimited : First Responder Kit Release: It’s Too Cold Not To Do A Release

You look just like a snake when you crawl like a worm. You can download the updated FirstResponderKi...

 

09.01.2018

Glenn Berry : Performance Effects of Meltdown and Partial Spectre Fixes on Intel Core i7-7500U Laptop

I have a fairly recent vintage HP Spectre x360-13w023dx laptop (slightly over a year old) that has a...

 

09.01.2018

Glenn Berry : SQL Server 2017 CU3 Released on January 4, 2018

On January 4, 2018, Microsoft released SQL Server 2017 CU3, which is Build 14.0.3015.40. By my count...

 

09.01.2018

Brent Ozar Unlimited : SQL Server 2017 CU3 adds execution statistics for scalar-valued, user-defined functions

Estimated Plans Need Not Apply This is, of course, only available in actual plans. All together now:...

 

08.01.2018

Marco Russo : Context Transition and Filters in CALCULATE

This article explains how the context transition interacts with the filter arguments of a CALCULATE ...

 

08.01.2018

Stacia Misner : Crushing Your Goals with Power BI: Getting Started

It’s that time of year when (almost) everyone around you is talking about New Year’s Resolutio...

 

08.01.2018

Glenn Berry : Checking Your Meltdown and Spectre Mitigation Status in Windows

As I have previously discussed, there has been an explosion of information and speculation about the...

 

08.01.2018

Brent Ozar Unlimited : The 2018 Data Professionals Salary Survey Results

How much do database administrators, analysts, architects, developers, and data scientists make? We ...

 

06.01.2018

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

This week Brent and Richie discuss the latest big Intel CPU security flaw, distributed transactions,...

 

05.01.2018

Brent Ozar Unlimited : Automating Complacency

There’s no Latin word for Robot I’m all for automation, especially when it comes to the ...

 

04.01.2018

Glenn Berry : Microsoft SQL Server Updates for Meltdown and Spectre Exploits

Over the last couple of days, you have probably heard quite a bit of chatter and speculation about s...

 

04.01.2018

Brent Ozar Unlimited : The Perils Of VSS Snaps

So much, so often Ah, backups. Why are they so tough to get right? You start taking them, you find o...

 

04.01.2018

Brent Ozar Unlimited : SQL Server Patches for Meltdown and Spectre Attacks

The Meltdown and Spectre attacks are newly announced ways of hacking CPUs. They affect both Windows ...

 

03.01.2018

Brent Ozar Unlimited : Network Issue or THREADPOOL waits?

I’ve had a handful of clients that were experiencing significant THREADPOOL waits. This isn...

 

02.01.2018

Brent Ozar Unlimited : Heaps, Deletes, and Optimistic Isolation Levels

The Humble Heap If you don’t know this by now, I’m going to shovel it at you: If you hav...

 

29.12.2017

Brent Ozar Unlimited : What’s So Bad About Shrinking Databases with DBCC SHRINKDATABASE?

You read a lot of advice that says you shouldn’t shrink databases, but…why? To demonstra...

 

28.12.2017

Paul S. Randal : 2017 review: the year by the numbers

The last post of the year! It’s been a really excellent year all round and time for my traditional p...

 

28.12.2017

Glenn Berry : SQL101: Avoiding Mistakes on a Production Database Server

As Kimberly blogged about earlier this year, SQLskills has an ongoing initiative to blog about basic...

 

28.12.2017

Brent Ozar Unlimited : How Personally Identifiable Information Gets Around

Let’s say someone – not you, dear reader, because you would surely never be this sloppy ...

 

28.12.2017

Paul S. Randal : 2017: the year in books

Back in 2009 I started posting a summary at the end of the year of what I read during the year (see ...

 

27.12.2017

Brent Ozar Unlimited : Our 25 Most-Read and Most-Commented Blog Posts of 2017

We published a whopping 312 blog posts in 2017! Looking back, wow, there was a lot of fun stuff in h...

 

27.12.2017

Marco Russo : What has happened in the DAX world in 2017

We are approaching the end of 2017, so it is a good time to review what happened in the DAX world th...

 

26.12.2017

Brent Ozar Unlimited : Female DBAs Make Less Money. Why?

The 2018 Data Professional Salary Survey is open now, and you can look at the live responses as they...

 

23.12.2017

Brent Ozar Unlimited : [Video] Office Hours 2017/12/20 (With Transcriptions)

This week Brent, Erik, and Richie discuss truncating & repopulating, failed logins, their choice...

 

Interested?

Receive our monthly newsletter



;