--SQL User Group





Upcoming Events

24.04.2019

Azure SQL Database Improvements

When Microsoft Azure SQL Database was introduced, it had only a small subset of the features available in the SQL Server database engine. With the introduction of version V12 a few years ago, Azure SQL Database is now an enterprise-class platform-as-a-service (PaaS) offering. Of course, Microsoft continued to add new features and functionalities into Azure SQL Database. Join this dataMinds evening session to learn more about some cool new features that are available now in Azure SQL Database, like

  • Hyperscale
  • vCore Model
  • Elastic Database Jobs
  • Backup Retention Periods
  • Geo-replication & Failover Groups
  • Virtual Network service endpoints
  • TDE with Bring Your Own Key
  • Data Discovery and Classification
  • SQL Vulnerability Assessment
  • Automatic Tuning
  • Intelligent Insights
  • Managed Instance
  • Data Migration Service

 

Oh man… as you can see, a lot of topics to explain in 2 hours ?? but we can discuss which topics you would like to hear more in detail. And no worries, we provide food & drinks!

Important:  Prior knowledge on Azure SQL Database is required.

 




Latest community news

15.01.2019

Marco Russo : Naming variables in DAX

The current version of DAX has a limitation for names you can provide to variables in a DAX expressi...

 

14.01.2019

Glenn Berry : The Importance of Database Compatibility Level in SQL Server

Prior to SQL Server 2014, the database compatibility level of your user databases was not typically ...

 

12.01.2019

Glenn Berry : More CPU Competition Coming for Intel

On January 9, 2019, AMD CEO and President Dr. Lisa Su presented a CES 2019 Keynote where she demonst...

 

11.01.2019

Glenn Berry : SQL Server Diagnostic Information Queries for January 2019

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

 

11.01.2019

Erin Stellato : Workload Tuning Training

I recently booked my flight to the U.K. for SQLBits, and I realized I probably should write a post a...

 

10.01.2019

Jonathan Kehayias : Availability Group Readable Secondaries – Just Say No

Considering an Availability Group readable secondary setup for SQL Server? Learn why an Availability...

 

10.01.2019

Brent Ozar Unlimited : How Should We Show Statistics Histograms in sp_BlitzIndex?

If you’re a graduate of my free How to Think Like the SQL Server Engine course – and you...

 

09.01.2019

Erin Stellato : Different Query Store Settings for a Database in an Availability Group

Last week there was a question on #sqlhelp on Twitter about the status of Query Store for a database...

 

08.01.2019

Brent Ozar Unlimited : Consultants: want a utility to gather SQL Server data?

When you’re a consultant, you need to get diagnostic data from your clients. When you’re...

 

07.01.2019

Marco Russo : Understanding the data lineage in DAX

Data lineage is a DAX feature so well-implemented that most developers use it without knowing about ...

 

06.01.2019

Brent Ozar Unlimited : The 2019 Data Professional Salary Survey Results

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

 

05.01.2019

Brent Ozar Unlimited : [Video] Office Hours 2019/1/2 (With Transcriptions)

This week, Brent, Erik, Tara, and Richie discuss whether you need to premake a destination database ...

 

04.01.2019

Jonathan Kehayias : CPU Ready Impact on SOS_SCHEDULER_YIELD

At the end of May 2017, Paul and I had a discussion about SOS_SCHEDULER_YIELD waits and whether or n...

 

04.01.2019

Erin Stellato : Handling Dates in Query Store

Query Store retains query performance data at the plan level.  This data is then broken out into int...

 

03.01.2019

Brent Ozar Unlimited : From The Server To The SAN

Enter SANdman When people buy SANs, it’s often quite a large investment. Whether it’s al...

 

03.01.2019

Brent Ozar Unlimited : The Pleasure Of Presenting With Joe Obbish

Grouple On At the December 2018 GroupBy I had the honor of co-presenting with one of the smartest gu...

 

03.01.2019

Brent Ozar Unlimited : Database Design Choices To Consider When You’re Worried About Scale

Tipping the Kilter I’m intentionally avoiding physical/hardware choices in this post, like how...

 

03.01.2019

Brent Ozar Unlimited : Why Do Some Indexes Create Faster Than Others?

To warn you ahead of time, this post is an exploration without an answer (yet). There’s some i...

 

03.01.2019

Brent Ozar Unlimited : An Idea For Improving DBCC CHECKDB

Hard Enough At this point, we’ve all probably got a database that’s a terabyte or more i...

 

03.01.2019

Brent Ozar Unlimited : Fast Food Code

Cheap and Easy We’ve all done it. We all know what and where it is, because we’ve probab...

 

03.01.2019

Brent Ozar Unlimited : Erik and Tara Are Heading Out

About two years ago, I realized I didn’t have the skills to grow the consulting part of the company ...

 

02.01.2019

Brent Ozar Unlimited : How Azure SQL DB Hyperscale Works

Microsoft is starting to talk about the internals for Azure SQL DB Hyperscale, their competitor to A...

 

01.01.2019

Glenn Berry : New Year Technology Maintenance

With the start of a new year, and with many people having some time off work, this seems like a good...

 

31.12.2018

Paul S. Randal : 2018 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...

 

31.12.2018

Paul S. Randal : 2018: the year in books – a new record!

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

 

31.12.2018

Brent Ozar Unlimited : 38 Blog Posts We Couldn’t Write in 2018

Behind the scenes here at Brent Ozar Unlimited, we’ve got a place where we jot down blog post ...

 

30.12.2018

Brent Ozar Unlimited : Thoughts About the 2019 Salary Survey’s New Questions

Our annual Data Professional Salary Survey is open now and closes this Sunday. We’re asking a ...

 

28.12.2018

Glenn Berry : How to Check if Your Processor Supports Second Level Address Translation (SLAT)

If you want to run Docker for Windows, you will need to be running Windows 10 Professional, Windows ...

 

28.12.2018

Brent Ozar Unlimited : 20 Questions to Ask About Your Availability Group Design

Questions about the overall project: What are your RPO and RTO goals? Are there financial penalties ...

 

28.12.2018

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

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

 

27.12.2018

Brent Ozar Unlimited : When Does SARGability Matter Most?

!erehT iH I know what you’re thinking. Another post about how you should just never do this on...

 

26.12.2018

Brent Ozar Unlimited : Updated First Responder Kit for January 2019: Extraneous Syllables

Does anyone know what the date really is? I usually don’t, and I often consider how doomed hum...

 

26.12.2018

Brent Ozar Unlimited : The 2018 Blog Posts You Commented On the Most

Of the blog posts we published in 2018, here are the ones that got you talking the most. These comme...

 

24.12.2018

Brent Ozar Unlimited : The 2018 Blog Posts You Read the Most

Here are the 2018 blog posts you visited the most: 10. What’s New in SQL Server 2019 CTP 2.1: ...

 

23.12.2018

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

This week, Erik, Tara, and Richie discuss disaster recovery, Python vs C# for SQL Server, whether yo...

 

21.12.2018

Brent Ozar Unlimited : 5 Ways to Change Execution Plans Without Tuning

A couple years back, I realized there were at least Ten Ways to Set MAXDOP. These days, as I write a...

 

20.12.2018

Brent Ozar Unlimited : Do Functions Stop You From Using Indexes?

Say I’ve got a function in my WHERE clause: [crayon-5c1bcec1313f9955282302/] If I have an inde...

 

20.12.2018

Marco Russo : Displaying a list of selected months

Today I woke up with an interesting question, about how to show a selection of months in a nice way,...

 

19.12.2018

Glenn Berry : Performance and Stability Related Fixes in Post-SQL Server 2014 SP3 Builds

As of December 12, 2018, there has been one Cumulative Update (CU) for the Service Pack 3 branch of ...

 

19.12.2018

Glenn Berry : SQL Server 2014 Service Pack 3 CU1 Released

On December 12, 2018, Microsoft released SQL Server 2014 Service Pack 3 CU1, which is Build 12.0.620...

 

19.12.2018

Brent Ozar Unlimited : Query Store And Cruel Defaults

Gosh Darn Now, look, it’s no secret that I think Query Store is cool. Heck, I went and wrote s...

 

18.12.2018

Brent Ozar Unlimited : Sniffed Nulls and Magic Numbers

I Sniff Your Milkshake Building off of A Simple Stored Procedure Pattern To Avoid, I wanted to talk ...

 

17.12.2018

Marco Russo : Bidirectional relationships and ambiguity in DAX

Activating bidirectional cross-filter in a Tabular data model might create ambiguous paths in the ch...

 

17.12.2018

Paul S. Randal : New class: Immersion Event on Power BI, Power BI Report Server, and SSRS

No only has Tim been working heavily with Azure in 2018, he’s also been diving into the variou...

 

17.12.2018

Brent Ozar Unlimited : Comparison Review: Microsoft SSDT vs Redgate SQL Source Control

Hi. I’m still not Brent. My name’s Alex, and I care about databases, DevOps and data protection. Las...

 

17.12.2018

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

This week, Erik and Richie discuss TSQL classes, scalar functions, index reorganize vs rebuild, dail...

 

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

 




Interested?

Receive our monthly newsletter