--SQL User Group





Upcoming Events

25.01.2018

Data Warehouse Automation with metadata driven development

Working on your 20th staging package? Do you need to import 30 different flat files? Don't have the time to create all those packages?

With Biml - Business Intelligence Markup Language - you can cut back on development time by

  • generating your SSIS packages and database object using metadata.
  • turning tedious, repetitive work into reusable scripts.
  • automating general ETL patterns.

In this session, we will go over the basics of Biml and BimlScript and learn how we can use metadata to create a framework for automating your data integration tasks.

After this session, you can start with the automation of your SSIS packages.

A working knowledge of Integration Services package development is necessary for this session.

 

07.02.2018

SQL Operations Studio and Docker

Let’s have some fun with SQL operations Studio, containers and a possibly bit of Linux J

A lot of interesting stuff is happening lately. We got a brand new open source tool for connecting to our beloved SQL Server from any platform we want: Linux, Mac, Windows, … This tool is the SQL Operations Studio.

Frederik Bogaerts and Randi Vertongen will give you an introduction to the tool and show you its full potential! And yes they promise to make a connection from a Linux OS… What did you expect!

As a little extra they will also show you the MSSQL-CLI, a command line tool in public preview for querying SQL Server.

The session will be lightweight and easy going, a good way to relax after a hard day of SQL server work!

 

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

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

 

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

 

22.12.2017

Brent Ozar Unlimited : Sizing A New Server? Start With Maintenance.

Clientele Most of out customers are on slightly (ahem) older (AHEM) hardware, and they have big ques...

 

21.12.2017

Glenn Berry : SQL Server 2014 SP2 CU9

On December 18, 2017, Microsoft released SQL Server 2014 SP2 CU9, which is Build 12.05563.0. By my c...

 

21.12.2017

Brent Ozar Unlimited : Do Disabled Indexes Affect Missing Index Recommendations?

I’m so glad you asked! Let’s take a look. Open up the Stack Overflow database, turn on a...

 

20.12.2017

Paul S. Randal : Live online training from Kimberly in early January!

We’ve been considering doing some live, online training classes for a while now, and with the ...

 

20.12.2017

Brent Ozar Unlimited : Maintenance Plans Enable Your Disabled Indexes

One of Brent’s students in the Performance Tuning class, Jason M., told Brent that maintenance...

 

19.12.2017

SQL Server Blog : The December 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 Decemb...

 

19.12.2017

Brent Ozar Unlimited : Introducing sp_BlitzLock: For Troubleshooting SQL Server Deadlocks

Deadlocks are hard Especially when there are a lot of them. When there are dozens or more, looking a...

 

18.12.2017

Brent Ozar Unlimited : Rebuilding Indexes Can Slow Queries Down

Today, Jonathan Kehayias wrote about how fragmentation impacts execution plans. I’m really int...

 

18.12.2017

Brent Ozar Unlimited : GDPR: Why We Stopped Selling Stuff to Europe

The EU’s new General Data Protection Regulation (GDPR) is a set of rules that give consumers r...

 

16.12.2017

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

This week Tara, Erik, and Richie discuss virtualization, replication & mirroring, switching SQL ...

 

15.12.2017

Brent Ozar Unlimited : Database History: The Inventor of the Data Page

Do you ever wonder about the history of the systems you rely on every day? They didn’t teach u...

 

15.12.2017

Paul S. Randal : New class: Practical Machine Learning

We’ve added a third brand-new class to our Spring line-up in Chicago: Immersion Event on Practical M...

 

14.12.2017

Brent Ozar Unlimited : Can you prevent deletes and inserts without a WHERE clause from running?

File this under bad idea thong In the tradition of Klaus Aschenbrenner wanting to prevent people fro...

 

13.12.2017

SQL Server Blog : Bring clarity to complex data with graph databases on SQL Server 2017

SQL Server 2017, in addition to processing relational data, now fully integrates with graph database...

 

13.12.2017

Brent Ozar Unlimited : Query Plan Oddities: Two Identical Missing Indexes

As I’ve been building labs for my Mastering Query Tuning class, I’ve been spelunking thr...

 

12.12.2017

Brent Ozar Unlimited : What Your SQL Server Is Really Waiting On: YOU

Land of Confusion Most SQL Servers out there have never had anyone do a thorough, targeted assessmen...

 

12.12.2017

Paul S. Randal : New Pluralsight course: Implementing a Hybrid Cloud Solution in Azure

Tim’s latest Pluralsight course has been published – SQL Server: Implementing a Hybrid C...

 

12.12.2017

SQL Server Blog : Try mssql-cli, a new interactive command line tool for SQL Server

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

 

11.12.2017

Marco Russo : Computing same product sales in DAX

This article shows a technique in DAX to compute the sales volume of products that were available ri...

 

11.12.2017

SQL Server Blog : What’s new in SSMS 17.4: SQL Vulnerability Assessment

This post is authored by Ronit Reger, Senior Program Manager, SQL Data Security and Alan Yu, Program...

 

11.12.2017

Brent Ozar Unlimited : Tell Us What You Make: The 2018 Data Professional Salary Survey

Not what you’re worth, dear reader: we know your worth cannot possibly be calculated in base-1...

 

10.12.2017

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

This week Brent, Erik, and Richie discuss filestream waits, what to use instead of filestream, Avail...

 

09.12.2017

Brent Ozar Unlimited : [Video] Office Hours 2017/11/29 (With Transcriptions)

This week Brent, Erik, and Richie discuss whether you need to know T-SQL to be a Senior DBA, if you ...

 

08.12.2017

Brent Ozar Unlimited : Running SQL Server in the Cloud: 2017 Edition

You have two basic options: Infrastructure as a Service (IaaS) is just VMs running in someone else&#...

 

07.12.2017

Brent Ozar Unlimited : sp_BlitzQueryStore: A Gentle Introduction

Odds and ends During the precon, we asked how many people were on 2016, how many people were aware o...

 

07.12.2017

Brent Ozar Unlimited : SQL Bits: We’re Teaching Another Pre-Con!

Our Wednesday pre-con, Expert Performance Tuning for SQL Server 2016 & 2017, sold out pretty qui...

 

06.12.2017

Brent Ozar Unlimited : What Should We Change About the Data Professional Salary Survey?

Last year, 2,899 of you filled out the 2017 Data Professional Salary Survey (results), so I figure w...

 

05.12.2017

Kevin Kline : How Can I Become a Microsoft MVP?

For those IT professionals who have heard of the Microsoft MVP accolade, they know that it carries a...

 

05.12.2017

Paul S. Randal : 2012/2014 bug that can cause database or server to go offline

Over the years I’ve discussed log space reservation, which is when SQL Server automatically re...

 

05.12.2017

Brent Ozar Unlimited : Index Maintenance Madness

When we look at a new server, we check out their database maintenance jobs, making sure their server...

 

05.12.2017

Kevin Kline : Proof of Concepts: Making Hard Things Easy with Azure

PROOF OF CONCEPTS: MAKING HARD THINGS EASY WITH AZURE Back when I managed my employer’s enterp...

 

05.12.2017

Brent Ozar Unlimited : First Responder Kit Release: Treating Object References Like Object Instances, Man

Object reference not set to an instance of an object. You can download the updated FirstResponderKit...

 

04.12.2017

Glenn Berry : SQL Server Missing Indexes Feature and Trace Flag 2392

Background Since the SQL Server 2005 release, SQL Server has had the default ability to collect metr...

 

01.12.2017

Glenn Berry : SQL Server Diagnostic Information Queries for December 2017

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

 

01.12.2017

Paul S. Randal : Disaster recovery 101: Object ID 0, index ID -1, partition ID 0

Quite often I see questions about DBCC CHECKDB error messages along the lines of: Specifically, the ...

 

01.12.2017

Brent Ozar Unlimited : Contest: Guess the SQL Server 2018 Release Date

When will Microsoft officially release SQL Server 2018 for download? The dust is just barely startin...

 

30.11.2017

SQL Server Blog : Azure Database Migration Service Preview brings the “lift and shift”

It’s time to get excited—the Azure Database Migration Service Public Preview is here to help y...

 

30.11.2017

Kevin Kline : SQL Server Adds Even More New Features in Data Science

SQL SERVER ADDS EVEN MORE NEW FEATURES IN DATA SCIENCE One of the great promises of AI is contextual...

 

30.11.2017

Brent Ozar Unlimited : Partition Level Locking: Explanations From Outer Space

It’s not that I don’t like partitioning It’s just that most of my time talking abo...

 

29.11.2017

Glenn Berry : Performance and Stability Fixes in SQL Server 2017 CU Builds

As of November 28, 2017, there have been two Cumulative Updates (CU) for SQL Server 2017. There have...

 

29.11.2017

Glenn Berry : SQL Server 2017 CU2 Is Available

On November 28, 2017, Microsoft released SQL Server 2017 CU2, which is build 14.0.3008.27.  I c...

 

29.11.2017

SQL Server Blog : SQL Server 2017: The world’s first enterprise-class diskless database

This post is authored by Bob Ward, Principal Architect, and Jamie Reding, Senior Program Manager and...

 

29.11.2017

Brent Ozar Unlimited : So You Want a Cheap Disaster Plan

There’s a lot that goes into a Disaster Recovery plan. One of them is offsite backups. There a...

 

29.11.2017

Kalen Delaney : Webinar 2.6 - Fragmentation

Slides and scripts are now up from today's webinar. https://www.dbbest.com/blog/webinar-2-6-followup...

 

28.11.2017

Kevin Kline : SQL Server 2016 – The Cool is in the Tool (SSMS That is)

SQL SERVER 2016 – THE COOL IS IN THE TOOL (SSMS THAT IS) As a heavy user of other RDBMS data platfor...

 

28.11.2017

Erin Stellato : Query Store Settings

In SQL Server 2017 there are nine (9) settings related to Query Store.  While these are documented i...

 

28.11.2017

Brent Ozar Unlimited : Good Reasons to Rebuild or Reorganize Indexes

No, not that It’s not the F word. Not like this embarrassing page that was somehow updated in ...

 

27.11.2017

Glenn Berry : Recent TPC-E Results on SQL Server 2017

Lenovo has submitted the two most recent TPC-E OLTP benchmark results, both using SQL Server 2017 ru...

 

27.11.2017

Marco Russo : How to handle BLANK in DAX measures

This article describes a counterintuitive behavior of BLANK in DAX measures affecting Power BI, Anal...

 

27.11.2017

Brent Ozar Unlimited : Book Review: Database Reliability Engineering by Campbell & Majors

When you see the cover of Database Reliability Engineering, the first question you’re probably...

 

26.11.2017

Brent Ozar Unlimited : [Video] Office Hours 2017/11/22 (With Transcriptions)

This week, Brent and Richie discuss the new Power BI Dashboard for DBAs, designing a new backup stru...

 

25.11.2017

Marco Russo : Using TREATAS in place of IN in DAX

During a conversation at PASS Summit, one of the developers of Power BI shown me a way to use TREATA...

 

24.11.2017

Brent Ozar Unlimited : How to Move TempDB to Another Drive & Folder

Every time I have to do this, I Google for a script. I might as well write my own and put it here so...

 

22.11.2017

Kevin Kline : SQL Server 2016 is Simply Faster… A Lot Faster

SQL SERVER 2016 IS SIMPLY FASTER…A LOT FASTER I had the pleasure to spend some time with my old frie...

 

22.11.2017

Brent Ozar Unlimited : How to Track SQL Server Changes with sp_BlitzFirst

In the First Responder Kit’s Power BI Dashboard, there’s a Quick Diagnosis results area ...

 

22.11.2017

Paul S. Randal : Disaster recovery 101: fixing a broken system table page

This post is about a disaster-recovery scenario I described in our bi-weekly newsletter a couple of ...

 

21.11.2017

Kevin Kline : U-SQL and the Azure Data Lake

U-SQL AND THE AZURE DATA LAKE There’s a new buzzword on the loose, the data lake. At first gla...

 

21.11.2017

Brent Ozar Unlimited : Announcing the Free First Responder Kit Power BI Dashboard

What the heck is going on inside your SQL Server? Why’s it so slow? I wrote sp_BlitzFirst to a...

 

20.11.2017

Paul S. Randal : Summer 2018 classes in London open for registration

Due to popular demand, we’re coming back to London in 2018 and I’ve just released our cl...

 

20.11.2017

Brent Ozar Unlimited : [Video] Office Hours 2017/11/15 (With Transcriptions)

This week Brent, Erik, Richie, and Tara discuss Docker, writing to different servers in different lo...

 

20.11.2017

Brent Ozar Unlimited : Updated Stack Overflow Database Dump Importer v1.4

The nice folks at Stack Overflow publish their entire data set (data included) in XML format. ItR...

 

17.11.2017

Brent Ozar Unlimited : Free Upcoming Webcasts: Query Store, R, AGs, Encryption, Security, and More

Here’s the lineup for the next free GroupBy online conference: Friday, December 1: 8:00 AM Eas...

 

16.11.2017

Kevin Kline : Temporal Tables in SQL Server 2016

TEMPORAL TABLES IN SQL SERVER 2016 While temporal data support is something that has existed in the ...

 

16.11.2017

SQL Server Blog : SQL Server 2017: A proven leader in database performance

This post was authored by Bob Ward, Principal Architect, and Jamie Reding, Senior Program Manager an...

 

16.11.2017

Brent Ozar Unlimited : Announcing Our 2017 Black Friday Doorbusters

You’ve waited for it. You’ve emailed me about it. You’ve been warning your boss th...

 

15.11.2017

SQL Server Blog : Announcing SQL Operations Studio for preview

We are excited to announce that SQL Operations Studio is now available in preview. SQL Operations St...

 

Interested?

Receive our monthly newsletter



;