Latest community news



Share:

19.10.2017

SQL Server Customer Advisory Team : Using SQL Service Broker for asynchronous external script (R / Python) execution in OLTP systems

Authored by Arvind Shyamsundar (Microsoft) Credits: Prasad Wagle, Srinivasa Babu Valluri, Arun Jayap...
 

19.10.2017

Brent Ozar Unlimited : SQL Server Workarounds

360 Questions We’ve been asking you folks a lot about what you’d add to SQL Server, and ...
 

18.10.2017

Glenn Berry : Windows Server Servicing Model Changes

Microsoft has announced some changes to the release schedule and servicing model for Windows Server....
 

18.10.2017

Brent Ozar Unlimited : Paste The Plan…Now With Comments

You didn’t ask but we listened: we have added comments to Paste The Plan. We’re always l...
 

17.10.2017

Paul S. Randal : SQLskills SQL101: How can corruptions disappear?

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

17.10.2017

Kevin Kline : Dynamic Data Masking and Row-Level Security Features on the Way in SQL Server 2016

DYNAMIC DATA MASKING AND ROW-LEVEL SECURITY FEATURES ON THE WAY IN SQL SERVER 2016 In addition to St...
 

17.10.2017

Brent Ozar Unlimited : Do Variables Exist?

I know, I know I swore I’d never talk about variables again. Then I ran into some funny busine...
 

16.10.2017

Marco Russo : Filtering and comparing different time periods with Power BI

This article introduces a technique to filter and productively compare two time periods with Power B...
 

16.10.2017

SQL Server Customer Advisory Team : Performance implications of using multi-Statement TVFs with optional parameters

Authored by Arvind Shyamsundar (Microsoft) Credits: Prasad Wagle, Srinivasa Babu Valluri, Arun Jayap...
 

16.10.2017

Brent Ozar Unlimited : Applications are Open for our 2018 Scholarship Program

At this time of year, with the PASS Summit and SQL Intersections and Black Friday rapidly approachin...
 

16.10.2017

Marco Russo : DirectQuery in Analysis Services: Best practices, performance, use cases

DirectQuery is a feature of Analysis Services that transforms a Tabular model in a semantic layer on...
 

15.10.2017

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

This week, Brent, Erik, and Richie discuss the new Extended Events Profiler, using SQL audit vs a tr...
 

13.10.2017

Kevin Kline : SQL Server Named DBMS of the Year

SQL SERVER NAMED 2017 DBMS OF THE YEAR Way back in the summer of 2014, I told you about how I used D...
 

13.10.2017

Brent Ozar Unlimited : How to Log Wait Stats to Table with sp_BlitzFirst

When you’re analyzing SQL Server performance, one of the best places to start is wait stats. W...
 

12.10.2017

Brent Ozar Unlimited : How to Do a SQL Server Architecture Review

We’ve talked about how to do a free SQL Server health check, and then how to drill deeper with...
 

12.10.2017

Greg Low : Time for a new blog–but so many thanks to Adam and Peter

For many years now, I’ve been hosting my blog at sqlblog.com. I can’t thank my old friends Adam Mach...
 

11.10.2017

Kevin Kline : Tomorrow: Learn about SQL Server on Vmware

SQL Server Running on Vmware. A Common Scenario. I have the honor of presenting a webinar, tomorrow,...
 

11.10.2017

Brent Ozar Unlimited : How to Do a Free SQL Server Performance Check

Your client or boss just said, “Find out why this SQL Server is slow.” You’ve alre...
 

10.10.2017

Kevin Kline : Revisiting PASS Summit 2015

PASS SUMMIT 2015: THE AGE OF THE DATA PROFESSIONAL IS NOW The PASS Summit 2015, the largest conferen...
 

10.10.2017

SQL Server Blog : What’s new in SQL Server Management Studio 17.3

This post was authored by Alan Yu, Program Manager, Microsoft SQL Server We are excited to announce ...
 

10.10.2017

SQL Server Blog : Webinar: Get enterprise-grade features at open-source prices with SQL Server 2017 on Linux

IT pros now have the flexibility of running workloads across Windows, Linux, or a combination of bot...
 

10.10.2017

Paul S. Randal : SQLskills SQL101: Should you kill that long-running transaction?

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

10.10.2017

Marco Russo : Offline model editor experience for Power BI

Professional BI developers using Analysis Services and advanced users working with Power BI share a ...
 

10.10.2017

Brent Ozar Unlimited : How to Do a Free SQL Server Health Check

Your boss or client came to you and said, “Give me a quick health check on this SQL Server....
 

09.10.2017

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

This week, Brent, Tara, and Richie discuss what they think about having no more service packs for SQ...
 

08.10.2017

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

Note: this is coming to you from the past due to technical difficulties. This week, Brent and Erik d...
 

07.10.2017

Paul S. Randal : Spring 2018 classes in Chicago and Bellevue open for registration

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

07.10.2017

SQL Server Customer Advisory Team : Secure your on-premises network outbound connection to Azure SQL Database by locking down target IP addresses

Reviewed by: Dimitri Furman, John Hoang, Mike Weiner, Rajesh Setlem Most people familiar with Azure ...
 

06.10.2017

Kevin Kline : Introducing the SQL Server Database Experimentation Assistant

INTRODUCING THE SQL SERVER DATABASE EXPERIMENTATION ASSISTANT There’s a very handy new tool fr...
 

06.10.2017

Brent Ozar Unlimited : Getting Help with a Slow Server

StackExchange users often ask, “Why is my server slow?” Here’s a few tips to get b...
 

06.10.2017

SQL Server Blog : SQL Server 2012 Service Pack 4 is now available

The SQL Server team is excited to bring you the final service pack release for SQL Server 2012. The ...
 

05.10.2017

Glenn Berry : SQL Server Diagnostic Information Queries for October 2017

This month, I have added a set of diagnostic queries for Azure SQL Database. These are very much a w...
 

05.10.2017

Brent Ozar Unlimited : PasteThePlan October 2017 Update

We’re back at it again. We took a bit of time out of our busy schedule to put in a few enhance...
 

04.10.2017

SQL Server Blog : Taking your data to the cloud is easier than you thought

Data management is shifting away from on-premises towards the many benefits of the cloud. Data is th...
 

04.10.2017

Brent Ozar Unlimited : Bad Idea Jeans: Finding Undocumented Trace Flags

I need to start this blog post with a disclaimer: you should not be doing this. Hell, *I* should not...
 

04.10.2017

Paul S. Randal : New Pluralsight course: Analyzing Query Performance for Developers

Erin’s latest Pluralsight course has been published – SQL Server: Analyzing Query Performance ...
 

03.10.2017

SQL Server Customer Advisory Team : Unattended install and configuration for SQL Server 2017 on Linux

SQL 2017 bits are generally available to customers today. One of the most notable milestones in the ...
 

03.10.2017

Kevin Kline : Stronger Security Via Always Encrypted in SQL Server 2016

STRONGER SECURITY VIA ALWAYS ENCRYPTED IN SQL SERVER 2016 Prior to SQL Server 2016, currently in CTP...
 

03.10.2017

Paul S. Randal : SQLskills SQL101: Running out of ints and bigints

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

03.10.2017

Brent Ozar Unlimited : No More SQL Server Service Packs: Is CU12 the New SP1?

Starting with yesterday’s release of SQL Server 2017, Microsoft has a new servicing model: the...
 

02.10.2017

Brent Ozar Unlimited : New System Stored Procedures in SQL Server 2017

Got a few new stored procs for columnstore indexes: sp_add_columnstore_column_dictionary – inp...
 

02.10.2017

Brent Ozar Unlimited : New sys.messages Entries in SQL Server 2017

I’m only showing the English (1033) ones here, message ID and then text. Some of the new messa...
 

02.10.2017

SQL Server Blog : Analysis Services Innovations in SQL Server 2017

This post was authored by Christian Wade, Senior Program Manager, Microsoft Microsoft SQL Server Ana...
 

02.10.2017

Marco Russo : Avoiding circular dependency errors in DAX

This article explains how DAX handles dependencies between tables, columns and relationships, to hel...
 

02.10.2017

SQL Server Blog : SQL Server 2017 on Windows Linux and Docker is now generally available

This post was authored by Travis Wright, Principal Program Manager, SQL Server Engineering Today, Oc...
 

02.10.2017

Brent Ozar Unlimited : New Wait Stats and DMV columns in SQL Server 2017

SQL Server 2017 is officially out, and here’s what I’ve found so far. New Wait Stats in ...
 

02.10.2017

Brent Ozar Unlimited : SQL Server 2017 Installation Screenshot Tour (Windows)

It’s like an unboxing, but with setup.exe. For the vast majority of setup, it’s the same...
 

02.10.2017

Kalen Delaney : Thank you, SQLSaturday Holland!

The first event on my Fall tour is behind me now. I had a wonderful time at SQL Saturday Holland. A ...
 

02.10.2017

Marco Russo : DAX Studio 2.7 – Improved Debug Experience

DAX Studio 2.7 largely improved the debug experience by adding several feature described in this vid...
 

01.10.2017

Brent Ozar Unlimited : [Video] Office Hours 2017/09/27 (With Transcriptions)

This week, Richie and Erik discuss altering database columns, separating log files, encryption, NOLO...
 

01.10.2017

Kimberly L. Tripp : SQLintersection Fall 2017 – 4 weeks to go!

As we head towards our 10th SQLintersection in four weeks, we’re excited to say that it’...
 

30.09.2017

Marco Russo : Why data modeling is important in #powerbi

I have a long experience in working on reporting systems based on semantic models. Now we call them ...
 

29.09.2017

Brent Ozar Unlimited : First Responder Kit Release: Still Totally Lacking A Servicing Model

A lot of people would think we’re crazy for releasing a FRK update a few days before a new ver...
 

29.09.2017

SQL Server Blog : View on-demand: Microsoft Data Platform – SQL Server 2017 and Azure Data Services

Did we miss you at Microsoft Ignite in Orlando this year? That’s OK! You can still stream the Data G...
 

29.09.2017

Brent Ozar Unlimited : Adaptive Blog Posts

It turns out I can be dumb In a previous blog post about Adaptive Joins, I thought that EXISTS wasn&...
 

28.09.2017

Brent Ozar Unlimited : SQL Server 2017 Showplan Schema Is Available

File this under… Things probably only I care about. But the Showplan Schema for SQL Server 201...
 

28.09.2017

Kevin Kline : Major Feature Reconfiguration For SQL Server 2016 Service Pack 1

MAJOR FEATURE RECONFIGURATION FOR SQL SERVER 2016 SERVICE PACK 1 One of the long-standing differenti...
 

28.09.2017

SQL Server Blog : Enhancing query performance with Adaptive Query Processing in SQL Server 2017

This post was authored by Joe Sack, Principal Program Manager, Data Systems Group, Microsoft SQL Ser...
 

28.09.2017

Glenn Berry : Modern SQL Server Servicing Model

Microsoft has announced a pretty big change for how they are going to service SQL Server, starting w...
 

28.09.2017

Brent Ozar Unlimited : How to Hire a Junior DBA

When you’re hiring a Junior DBA, ask yourself a few questions: “What job did they have b...
 

28.09.2017

Erin Stellato : Query Store Pre-Con at PASS Summit: More Details

In the time since my last post about my Query Store pre-con at the PASS Summit (it’s just about a mo...
 

28.09.2017

Kalen Delaney : I'm Leaving on a Jet Plane

I'm taking off tomorrow for Holland, UK, Denmark, Germany and Israel: https://www.dbbest.com/blog/im...
 

27.09.2017

SQL Server Blog : SQL Server 2017: Fast, faster, and the fastest database everywhere you need it

This post was authored by Bob Ward, Principal Architect, Database Systems Group “I feel the need, th...
 

27.09.2017

Brent Ozar Unlimited : Which sp_configure Options Clear the Plan Cache?

When you change MAXDOP and run RECONFIGURE, SQL Server clears the plan cache. (It’s documented...
 

26.09.2017

SQL Server Blog : In-database Machine Learning in SQL Server 2017

This post is authored by Sumit Kumar, Senior Program Manager, Microsoft and Nellie Gustafsson, Progr...
 

26.09.2017

Brent Ozar Unlimited : Live Query Plans and Blocking

You’d think this would be cool After all, you’ve got a query plan being executed LIVE ON...
 

25.09.2017

Erin Stellato : Changes to query text and the effects in Query Store

In this week’s Insider newsletter, Paul talked about an interesting customer issue I ran into ...
 

25.09.2017

Brent Ozar Unlimited : #PASSSummit Expert Performance Tuning Pre-Con: Stretch Goals

Eric and I are doing a PASS Summit pre-con class called Expert Performance Tuning for SQL Server 201...
 

25.09.2017

SQL Server Blog : New managed SQL server Integration Service hosting capability in Data Factory

This week at Ignite, we announced new capabilities in Azure Data Factory (ADF) service available in ...
 

25.09.2017

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

This week, Brent, Tara, Richie, and Erik discuss a most excepted solution for SA and securing an ins...
 

25.09.2017

Brent Ozar Unlimited : Announcing More Online SQL Server Classes

Our recent class lineup did pretty well, so now we’ve got a new round: Always On Availability ...
 

25.09.2017

SQL Server Blog : SQL Server 2017 and Red Hat Enterprise Linux offer

This post was authored by John ‘JG’ Chirapurath, General Manager, Data Platform Marketing. Microsoft...
 

25.09.2017

SQL Server Blog : Microsoft for the Modern Data Estate

This post was authored by Rohan Kumar, General Manager, Data Systems Group. Welcome to Microsoft Ign...
 

22.09.2017

Brent Ozar Unlimited : Key Lookups and ColumnStore Indexes

Beavis v. Butthead I was a bit surprised that this was a possibility with ColumnStore indexes, since...
 

21.09.2017

Kevin Kline : Don’t Miss the Biggest Annual SQL Server Conference, PASS Summit

I’m thrilled to be presenting once again at this year’s PASS Summit, coming up in Octobe...
 

21.09.2017

SQL Server Blog : SQL Server PolyBase supports Hadoop.rpc.protection

This post was authored by Casey Karst; Program Manager II; Data Systems. We are pleased to announce ...
 

21.09.2017

Brent Ozar Unlimited : Answering Questions For Fun And No Profit

I love answering questions about SQL My forum of choice is dba.stackexchange.com because I find the ...
 

21.09.2017

Brent Ozar Unlimited : Breaking News: Using TDE on 2016? Doing Backups? Time to Patch.

Normally, when you use Transparent Data Encryption (TDE) to secure your database at rest, you can...
 

20.09.2017

Kalen Delaney : Geek City: Changing How To Change Your Database Properties — ALTER DATABASE

(This article was originally published at https://www.dbbest.com/blog/ Long ago (in SQL Server years...
 

20.09.2017

Brent Ozar Unlimited : What Would You Put in SQL Server 2018?

If you were leading Microsoft’s development programs, what would you add or change in SQL Serv...
 

20.09.2017

SQL Server Customer Advisory Team : Enterprise Data Pipelines using Azure PaaS Services – An Introduction

Authors: Rangarajan Srirangam, Mandar Inamdar, John Hoang Reviewers: Murshed Zaman, Sanjay Mishra, D...
 

19.09.2017

Brent Ozar Unlimited : The Ghosts of Temp Tables Past

True story You may find it hard to believe, but I recently had to fix a small bug in sp_BlitzCache a...
 

19.09.2017

Marco Russo : Missing automatic update of Data Gateway for Power BI

Recently Microsoft unified the Data Gateway so that you have a single gateway for Power BI, Azure An...
 

18.09.2017

Kevin Kline : New Releases for the Microsoft Data Platform

NEW RELEASES FOR THE MICROSOFT DATA PLATFORM The Microsoft data platform team is on fire! It is deli...
 

18.09.2017

Paul S. Randal : New Pluralsight course: Indexing for Performance

It’s been a while coming but it’s worth the wait! Kimberly’s latest Pluralsight co...
 

18.09.2017

Marco Russo : Using KEEPFILTERS in DAX

This article explains how to use KEEPFILTERS to intersect instead of overriding an existing filter c...
 

18.09.2017

Brent Ozar Unlimited : Kickstarter-Style Ideas for our PASS Summit Pre-Con

Boy, have I got a weird challenge for you, dear reader. When Erik & I started building Expert Pe...
 

15.09.2017

Glenn Berry : SQLskills SQL101: Azure SQL Database Monitoring

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

15.09.2017

Brent Ozar Unlimited : How Much Can One Row Change A Query Plan? Part 2

Earlier this week, I showed you two nearly identical queries and their estimated plans: They look pr...
 

14.09.2017

Brent Ozar Unlimited : Optional Parameters and Missing Index Requests

That’s when it all gets blown away At one point or another in everyone’s SQL-querying ca...
 

13.09.2017

Brent Ozar Unlimited : Indexing for Windowing Functions: WHERE vs. OVER

Life Is Messy Demo queries have this nasty habit of being clean. Even using a pit of despair like Ad...
 

12.09.2017

Marco Russo : The easiest way to start using variables in #dax

A few months ago, I and Alberto realized that the reason why variables are not used in DAX as they s...
 

12.09.2017

Brent Ozar Unlimited : How Much Can One Row Change A Query Plan? Part 1

Last week, Erik showed two queries that were aaaaalmost identical, with only one extra column –...
 

12.09.2017

SQL Server Customer Advisory Team : Instant Log Initialization for SQL Server in Azure

Reviewed by: John Hoang, Denzil Ribeiro, Rajesh Setlem, Mike Weiner Introduction Instant File Initia...
 

11.09.2017

Erin Stellato : Query Store Pre-Con at the PASS Summit: Is it right for you?

I received an email over the weekend asking about my pre-con at the PASS Summit, my general session ...
 

08.09.2017

Brent Ozar Unlimited : How Much Can One Column Change A Query Plan? Part 2

What happened in Part 1? Join Elimination, naturally. Until the end. My copy of the Stack Overflow d...
 

07.09.2017

Brent Ozar Unlimited : Creating Basic Indexes on the Stack Overflow Public Database

My public SQL Server database copy of the Stack Overflow data dump only includes clustered indexes b...
 

06.09.2017

Brent Ozar Unlimited : SQL Server on Linux is the New SQL Server on Windows Core

When Windows Server 2012 came out with Core, I heard some rather suspicious things at conferences li...
 

06.09.2017

SQL Server Customer Advisory Team : Common ISV application patterns using Azure SQL Data Warehouse

Author: John Hoang Technical Reviewers: Dimitri Furman, Murshed Zaman, Sanjay Mishra Overview This a...
 

05.09.2017

Brent Ozar Unlimited : [Video] Office Hours 2017/08/30 (With Transcriptions)

This week, Brent, Erik, and Richie discuss Availability Groups, versions of sp_BlitzIndex™, SQL Serv...
 

Interested?

Receive our monthly newsletter