--SQL User Group





Upcoming Events

15.01.2019

Azure Data Factory & Azure Search

Azure Data Factory
Learn more about Azure Data Factory, the easiest cloud-based data integration service at scale.
In this session, you’ll learn the basics of Azure Data Factory. Tom Kerkhove will show you how you can take the data you have stored in your on-premise and cloud-based systems and create, manage and operate your own data pipelines. This session will be demo-based.

Azure Search
In this session, Sammy Deprez will tell us more about his first experiences with Azure Search, based on an ongoing project at a large customer in the public sector.

 

23.01.2019

Power BI - All Over The Place

This is not going to be an evening where we will talk about one single topic. This is going to be an evening where we will be talking about several topics. The only thing linking the different topics is Power BI. There will be two important topics that deserve more time than the others:

  • Power BI Context(s): this is easy to define, but sometimes hard to understand. What can you expect: definitions, context switching and examples
  • Aggregations in Power BI (Preview): for me one of the best improvements when you need an enterprise solution; so expect some explanation, some examples and some warnings

The rest of the time I will be showing cool things you can use to bring your Power BI reports to the next level. This is the part where I show things smarter people than me have figured out: this can some crazy script or a link to a website where you can find great stuff. It will go all over the place.

 

21.02.2019

Event-driven ETL

So you've been doing your datawarehousing in its traditional sense. You have your ETL set up to start after business hours, load all the new and updated data to have your datawarehouse ready and up-to-date for your business users when they start work the next day.

Now, you're asked to take things to the next level, they want to track data changes when they occur during the day so the DWH is always reporting on the latest data. Event-driven ETL to the rescue, as any type of event in the source system will need to trigger only that specific subsection of your ETL so it doesn't try to load your entire DWH every time one source changes.

 

In this session we'll explore the possibilities to set up a metadata-based solution to start specific subsegments of your ETL for any source system event and guide you through how a possible framework would be set up to facilitate this.

 




Latest community news

14.12.2018

Glenn Berry : SQL Server Diagnostic Information Queries for December 2018

This month, I have just made some more minor improvements to most of the query sets, mainly in the c...

 

14.12.2018

Brent Ozar Unlimited : What Azure SQL DB Managed Instances Don’t Support (Yet)

Whenever a new product or feature comes out, I like keeping an eye on its support forums to understa...

 

13.12.2018

Erin Stellato : Finding the Slowest Query in a Stored Procedure

This post, Finding the Slowest Query in a Stored Procedure, originally appeared on the PASS website....

 

13.12.2018

Brent Ozar Unlimited : Never Judge A Query By Its Cost

Signs and Numbers When tuning queries, or even finding queries to tune, there’s a rather misgu...

 

12.12.2018

Brent Ozar Unlimited : Does low fill factor affect SELECT performance?

Sometimes good intentions lead to big problems. Imagine a system where page splits were thought to b...

 

11.12.2018

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

It’s time for our annual salary survey to find out what data professionals make. You fill out ...

 

10.12.2018

Brent Ozar Unlimited : Have Availability Groups Gotten Easier Lately?

Easy Lover I don’t blog a lot about AGs. If we’re being honest (and I do try to be hones...

 

08.12.2018

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

This week, Tara and Richie discuss deletes on heaps, Docker, using containers in production environm...

 

07.12.2018

Brent Ozar Unlimited : “Surely this one will get a clustered index scan.”

I love building demos for our training classes because I’m constantly in a battle of the minds...

 

06.12.2018

Brent Ozar Unlimited : Azure SQL DB is Slow: Do I Need to Buy More DTUs?

You’ve got an Azure SQL DB, and your queries are going slow. You’re wondering, “Am...

 

05.12.2018

Brent Ozar Unlimited : Indexed View Matching With GROUP BY And DISTINCT

Bit Of A Kick I’ve been playing with indexed views a little bit lately for some demos in my Bi...

 

04.12.2018

Brent Ozar Unlimited : Indexed View Creation And Underlying Indexes

Accidental Haha While working on some demos, I came across sort of funny behavior during indexed vie...

 

03.12.2018

Marco Russo : Understanding numeric data type conversions in DAX

This article describes how DAX automatically converts data types in arithmetic operations. These sma...

 

03.12.2018

Brent Ozar Unlimited : How to Log Active Queries with sp_BlitzWho

Queries are running when you’re not around. They’re wreaking havoc – maybe they...

 

02.12.2018

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

This week, Brent, Tara, and Richie discuss storing phone numbers in a database, forced parameterizat...

 

01.12.2018

Brent Ozar Unlimited : What Is SQL Injection?

Say we have a stored procedure that queries the Stack Overflow database. We have two separate parame...

 

30.11.2018

Brent Ozar Unlimited : Updated First Responder Kit for November 2018: Get Into Sports Dummy

I dunno, I just like this picture. You can download the updated FirstResponderKit.zip here. sp_Blitz...

 

29.11.2018

Brent Ozar Unlimited : Tales From Overindexing: Too Many One Column Indexes

Master Plan Sometimes you see a query, and it’s hitting one table, and then the query plan loo...

 

28.11.2018

Brent Ozar Unlimited : How to Troubleshoot Blocking and Deadlocking with Scripts and Tools

When you need to find which queries are blocking other queries, your decision comes down to when the...

 

27.11.2018

Brent Ozar Unlimited : Getting Sneaky With Forced Parameterization

Silly Rules I’ve blogged about some of the silly rules about where Forced Parameterization doe...

 

27.11.2018

Paul S. Randal : Cyber Monday special on 2019 live, online classes 6-pack – save $199 per class!

It’s Cyber Monday today, and now that you’ve finished picking up great deals for your pe...

 

26.11.2018

Brent Ozar Unlimited : Not So Forced Parameterization

Asking The Wrong Question Sometimes, when you wanna turn on a feature, you spend so much time wonder...

 

25.11.2018

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

This week, Brent, Tara, and Erik discuss update statistics, how soon it is safe to use a new version...

 

22.11.2018

Brent Ozar Unlimited : Congratulations to the Scholarship Class of 2019.

To celebrate the holiday season each year, we give back to those who spend the entire year giving ba...

 

21.11.2018

Brent Ozar Unlimited : A Lot of Your SQL Servers Are Unsupported.

I’m almost afraid to look into the SQL ConstantCare® client base to see the answer to this, bu...

 

20.11.2018

Brent Ozar Unlimited : Going to SQLBits in 2019? Come to my pre-con!

My Favorite Conference I love SQLBits, and not just because it gets me out of the country for a week...

 

19.11.2018

Marco Russo : Improving temporal line charts in Power BI with DAX

This article shows how to improve line charts with a date-based axis in Power BI using DAX and makin...

 

19.11.2018

Brent Ozar Unlimited : Psst – it’s holiday card time. Update your address.

We’re getting ready to send out our annual holiday cards to folks who shopped with us this yea...

 

19.11.2018

Brent Ozar Unlimited : How Much Memory is “Normal” for SQL Servers?

When I look at a SQL Server, one of the first things I check is, “How much memory does this th...

 

18.11.2018

Glenn Berry : CPU Upgrade to AMD Ryzen Threadripper 2950X

About a year ago, I built a high-end desktop (HEDT) workstation based on the then, top-of-the-line 1...

 

17.11.2018

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

This week, Tara, Erik, and Richie discuss using Docker in dev environment, in-place upgrades, disast...

 

16.11.2018

Brent Ozar Unlimited : Adventures In Foreign Keys 5: The Limits Of Elimination

FINALLY… This is the last post I’ll write about foreign keys for a while. Maybe ever. Le...

 

15.11.2018

Brent Ozar Unlimited : Adventures In Foreign Keys 4: How Should I Index These Things?

This week, we’re all about foreign keys. So far, we set up the Stack Overflow database to get ...

 

15.11.2018

Glenn Berry : AMD EPYC 7371 Processor in Q1 2019

At the Supercomputing 2018 Conference, AMD announced a special high-frequency SKU in their first-gen...

 

14.11.2018

Glenn Berry : IEPUM2017: Immersion Event on Planning and Implementing an Upgrade/Migration to SQL Server 2017

We’ve just announced the next round on live, online training classes for the first quarter of 2019. ...

 

14.11.2018

Paul S. Randal : Six new 2019 Q1 live online classes open for registration!

Due to the popularity of our live, online classes this year, we’re presenting six more in the ...

 

14.11.2018

Paul S. Randal : New live online training class in March: Columnstore Indexes

Continuing our series of live, online classes, Jonathan will be delivering his new IECS: Immersion E...

 

14.11.2018

Brent Ozar Unlimited : Adventures In Foreign Keys 3: A Cascade Of Badness

Legendreary In the last post, I looked at some issues with implementing foreign keys with cascading ...

 

13.11.2018

Brent Ozar Unlimited : Adventures In Foreign Keys 2: Difficulties, Difficulties, Difficulties

This week, we’re all about foreign keys. Yesterday’s post covered scripts to set up the ...

 

12.11.2018

Glenn Berry : Building a Modern AMD Desktop Development Workstation

Over the past 12-18 months, it has become relatively easy to build an extremely powerful AMD desktop...

 

12.11.2018

Brent Ozar Unlimited : Adventures In Foreign Keys 1: Eligibility Is Everything

In A Foreign Key, In A Foreign Table Much of what people want from foreign keys, like referential in...

 

11.11.2018

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

This week, Tara and Richie discuss offline file database and log backup solutions, VSS database back...

 

08.11.2018

Brent Ozar Unlimited : PASS Summit 2018 Keynote Day 2: Live Blog

Today is the second day of the 2018 PASS Summit, the largest annual gathering of Microsoft data prof...

 

07.11.2018

Brent Ozar Unlimited : PASS Summit 2018 Keynote Day 1: Live Blog

Today is the opening day of the 2018 PASS Summit, the largest annual gathering of Microsoft data pro...

 

07.11.2018

Brent Ozar Unlimited : What’s New in SQL Server 2019 CTP 2.1: Faster Functions

A while back, we talked you through a public whitepaper about how Microsoft was working on making us...

 

06.11.2018

Erin Stellato : Query Store Performance Overhead: What you need to know

“What is the performance overhead of enabling Query Store?” I get asked this question almost every t...

 

06.11.2018

SQL Server Customer Advisory Team : SQLCAT at PASS Summit 2018

This week in Seattle, PASS Summit 2018 will be happening for the twentieth time. As for many years b...

 

05.11.2018

Marco Russo : Showing actuals and forecasts in the same chart with Power BI

In budgeting reports, a common requirement is to show future sales forecast and actual sales volume ...

 

05.11.2018

Brent Ozar Unlimited : Picking #PASSsummit Sessions to Attend

So you’re going to the PASS Summit in Seattle this week, and you’re overwhelmed with the...

 

03.11.2018

Glenn Berry : SQL Server Diagnostic Information Queries for November 2018

This month, I have just made some more minor improvements to most of the query sets. I have a T-SQL ...

 

03.11.2018

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

This week, Brent, Tara, Erik, and Richie discuss load balancing, preventing auto-updates, compatibil...

 

02.11.2018

Brent Ozar Unlimited : The Curse of Cursor Options

Red Skies At Night I know it’s hard to believe, but I still see a lot of people using cursors ...

 

01.11.2018

Brent Ozar Unlimited : Save 50-75% Now: The 2018 Black Friday Sale is On!

Five years ago, I had a crazy thought. I liked bargain shopping during Black Friday sales, picking o...

 

31.10.2018

Brent Ozar Unlimited : How Check Constraints MIGHT Improve Your Queries and Missing Index Requests

The more SQL Server knows about your data, the better your query plans can get. Say you’ve got...

 

30.10.2018

Brent Ozar Unlimited : SUM, AVG, and arithmetic overflow

You Shoulda Brought A Bigger Int Sometimes you run a query, and everything goes fine. For a while. F...

 

29.10.2018

Glenn Berry : Automatic Plan Correction is Enterprise Edition Only Feature in SQL Server 2017

One interesting and useful new feature in SQL Server 2017 is Automatic plan correction. This feature...

 

29.10.2018

Brent Ozar Unlimited : You read reviews before you buy training, right?

Confession time: I love buying stuff. It’s not so much the buying as it is the comparing. I go...

 

28.10.2018

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

This week, Brent, Tara, and Richie discuss increasing a table’s varchar field from 1 to 2, pre...

 

26.10.2018

Brent Ozar Unlimited : Filtered Indexes vs Parameterization (Again)

At First I Was Like… This won’t work at all, because parameters are a known enemy of fil...

 

25.10.2018

Glenn Berry : New Intel Desktop Processor Families

Intel formally announced its 9th generation Core mainstream desktop processors on October 8, 2018 at...

 

25.10.2018

Brent Ozar Unlimited : Batch Mode For Row Store: Does It Fix Parameter Sniffing?

Snorting The Future SQL Server 2019 introduced batch mode over row store, which allows for batch mod...

 

24.10.2018

Glenn Berry : SQL Server Diagnostic Information Queries for October 2018

This month, I have just made some minor improvements to most of the query sets. I have a T-SQL scrip...

 

24.10.2018

Brent Ozar Unlimited : Batch Mode For Row Store: What Does It Help With?

SQL Server 2019 Introduces something pretty cool: the ability for row store indexes to be processed ...

 

23.10.2018

Brent Ozar Unlimited : How to See Execution Plans in Azure Data Studio

Azure Data Studio is Microsoft’s cross-platform tool for T-SQL developers. It’s still re...

 

23.10.2018

Brent Ozar Unlimited : You probably didn’t go to a training class this year. Again.

The year is drawing to a close, and you didn’t go to a training class. Again. Your skills aren...

 

22.10.2018

Paul S. Randal : New class: Immersion Event on Azure SQL Database, Azure VMs, and Azure Managed Instance

Tim’s been working closely with the development team on Azure Managed Instance, presented with...

 

22.10.2018

Marco Russo : Optimizing IF and SWITCH expressions using variables

This article describes how variables should be used in DAX expressions involving IF and SWITCH state...

 

22.10.2018

Brent Ozar Unlimited : Announcing The Team Membership

You have a team of database developers and DBAs – SQL Server professionals who want dedicated ...

 

22.10.2018

Brent Ozar Unlimited : Thank you, #sqlfamily, for donating to The Trevor Project.

A couple of weeks ago, we told you about how Andy Mallon’s LGBTQ Meetup was raising money for ...

 

22.10.2018

Paul S. Randal : Calling all user group leaders! We want to present for you in 2019!

By the end of December, we at SQLskills will have presented remotely (and a few in-person) to more t...

 

21.10.2018

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

This week, Brent, Erik, and Richie discuss small vendor apps, “Slow in the Application, Fast i...

 

19.10.2018

Erin Stellato : Baselines for SQL Server and Azure SQL Database

Last week I got an email from a community member who had read this older article of mine on baselini...

 

19.10.2018

Brent Ozar Unlimited : Is Cost Threshold for Parallelism Measured in Seconds?

SQL Server automatically chooses when to divide your query’s work across multiple CPU cores. I...

 

18.10.2018

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

Every year, we publish an open Data Professional Salary Survey. Last year, 3,113 folks from 73 count...

 

17.10.2018

Brent Ozar Unlimited : Skewing Parallelism For Fun And Profit

What Is Skewed Parallelism? When queries go parallel, some assumptions get made: There’s enoug...

 

17.10.2018

Paul S. Randal : Lazy log truncation or why VLFs might stay at status 2 after log clearing

Earlier this year I was sent an interesting question about why the person was seeing lots of VLFs in...

 

16.10.2018

Erin Stellato : Removing a database from a replica in an Availability Group

I recently had a scenario in a two-node Availability Group where multiple large-batch modification q...

 

16.10.2018

Brent Ozar Unlimited : Using NOLOCK? Here’s How You’ll Get the Wrong Query Results.

Slapping WITH (NOLOCK) on your query seems to make it go faster – but what’s the drawbac...

 

15.10.2018

Brent Ozar Unlimited : Building SQL ConstantCare®: Separating Out the Videos

When we started offering SQL ConstantCare®, our mentoring service, I wanted to make our web site as ...

 

13.10.2018

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

This week, Brent, Tara, and Richie discuss splitting large database files across multiple files, sec...

 

12.10.2018

Brent Ozar Unlimited : Index Tuning Week: Missed Missing Index Opportunities

A Reminder With a new baby in the house, I often find myself comparing her to various things. Barnac...

 

11.10.2018

Brent Ozar Unlimited : Index Tuning Week: Getting Blocking? Play “Hot or Not.”

This week, we’re all about tuning indexes. So far, we’ve covered Brent’s 5 and 5 R...

 

10.10.2018

Brent Ozar Unlimited : Index Tuning Week: Fixing Nonaligned Indexes On Partitioned Tables

Unquam Oblite This post will not change your life, but it will help me remember something. When you ...

 

09.10.2018

Glenn Berry : PASS Summit 2018

I will be presenting Migrating to SQL Server 2017 at the PASS Summit 2018 in Seattle, WA. I’m actual...

 

09.10.2018

Glenn Berry : SQLSaturday Oregon

I will be delivering a full day pre-con session called Migrating to SQL Server 2017 on November 2, 2...

 

09.10.2018

Brent Ozar Unlimited : Index Tuning Week: My D.E.A.T.H. Method for Tuning Indexes

This week I’m running a series of posts introducing the fundamentals of index tuning. Yesterda...

 

09.10.2018

Paul S. Randal : Spring 2019 classes in Chicago open for registration

I’ve just released our first set of 2019 classes for registration! We’ll be adding new classes...

 

08.10.2018

Marco Russo : Displaying Nth Element in DAX

This article describes how to create a measure displaying the name or value of an element that has a...

 

08.10.2018

Brent Ozar Unlimited : LGBTQ Meetup at the PASS Summit

The SQL Server community is known for its welcoming acceptance of everyone, regardless of their expe...

 

08.10.2018

Brent Ozar Unlimited : Index Tuning Week: How Many Indexes Are Too Many?

This week I’m running a series of posts introducing the fundamentals of index tuning. First up...

 

07.10.2018

Brent Ozar Unlimited : Pour One Out for Database Diagrams, and Good Riddance

On the left hand side, you see SQL Server Management Studio 17.9. On the right side, 18.0. Something...

 

06.10.2018

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

This week, Tara and Richie discuss database corruption, CLR, DBCC issues, adding identity columns to...

 

05.10.2018

Glenn Berry : Autogrow All Files Feature in SSMS 18.0 Preview 4

One of the small improvements in SSMS 18.0 Preview 4 is the addition of an “Autogrow All Files” chec...

 

05.10.2018

Brent Ozar Unlimited : Making The Query Plan Profile Hint More Useful

Way Back When I blogged about the new USE HINT that logs query plans that use it to a new XE session...

 

04.10.2018

Brent Ozar Unlimited : SQL Server Management Studio 18’s Execution Plans Will Change The Way You Look At Plan Tuning

The preview of the next version of SQL Server Management Studio is out, and it has a radical improve...

 

03.10.2018

Erin Stellato : Plan Forcing in SQL Server

Last month I was in Portugal for their SQLSaturday event, and I spent a lot of time talking about Pl...

 

03.10.2018

Brent Ozar Unlimited : We Need to Talk About the Warnings In Your Query Plans.

SQL Server, thanks for coming today. Have a seat. Yes, this might seem odd – there are a lot o...

 

02.10.2018

Brent Ozar Unlimited : First Responder Kit Release: Fingers Crossed!

This is a small release just to make sure you don’t forget about us. We know you’re busy...

 

02.10.2018

Brent Ozar Unlimited : Unused Indexes – Are they really unused or have they just not been used YET?

During our Critical Care® sessions with clients, we often see unused indexes (reads=0) with high wri...

 

01.10.2018

Brent Ozar Unlimited : The New Lightweight Query Plan Profile Hint

Recent Updates To SQL Server 2016 and 2017 introduced a new USE HINT that lets you direct an actual ...

 




Interested?

Receive our monthly newsletter