Latest community news



Share:

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

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

15.11.2017

SQL Server Blog : SQL Server 2017 Features Bring ‘Choice’ to Developers

Data is everywhere today: in the cloud, on premises, and everywhere in between, tied up in systems o...
 

15.11.2017

Brent Ozar Unlimited : We’re Coming to London! Announcing Our SQL Bits Pre-Con.

Going to SQL Bits in London this year? Join me & Erik Darling on Wednesday at our all-day pre-co...
 

15.11.2017

Brent Ozar Unlimited : First Responder Kit Release: The Ides Of November

This is a cleanup release to get some of the pull requests in that didn’t make it in before th...
 

14.11.2017

Kevin Kline : SQL Server on Linux – It’s No Joke

SQL SERVER ON LINUX – IT’S NO JOKE Many thought it was an early April Fool’s Day prank, but it...
 

14.11.2017

Paul S. Randal : TSQL Tuesday #96: Folks Who Have Made a Difference

It’s been almost three years since I wrote a T-SQL Tuesday post (shame on me!), but this is on...
 

14.11.2017

Adam Machanic : New Post: The Career Influence of Usenet Strangers (T-SQL Tuesday #096)

Check out my new post on some of the people who helped shaped my career: The Career Influence of Use...
 

14.11.2017

Brent Ozar Unlimited : #TSQL2sday: Brad McGehee Made a Difference in My Career.

For this month’s T-SQL Tuesday, Ewald asked who’s made a difference in our careers. When...
 

13.11.2017

Marco Russo : DAX Best Practices

As with any other language, you can write good DAX but you can also write bad DAX. Good DAX works fi...
 

13.11.2017

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

This week, Richie and Tara discuss Richie’s current projects, Availability Groups, offloading ...
 

13.11.2017

Marco Russo : Strange behavior of HASONEVALUE and SELECTEDVALUE

I recently stumbled across a strange behavior of HASONEVALUE, which also impacts the SELECTEDVALUE f...
 

13.11.2017

Marco Russo : Querying raw data to Tabular

This article describes how to extract raw data stored in the Tabular engine, used by Analysis Servic...
 

10.11.2017

Brent Ozar Unlimited : How to Test Your Corruption Alerts

You’ve been such a good database administrator. You followed the setup checklist in our First ...
 

09.11.2017

Kevin Kline : Announcing SQL Server 2017 Release Candidate

ANNOUNCING SQL SERVER 2017 RELEASE CANDIDATE 1 Microsoft announced the first release candidate (a.k....
 

09.11.2017

Brent Ozar Unlimited : Implied Predicate and Partition Elimination

>implying Way back when, I posted about turning the Votes table in the Stack Overflow database i...
 

08.11.2017

Glenn Berry : Initial CrystalDiskMark Results for Intel Optane 900p

I have been building a new desktop workstation based on an AMD Ryzen Threadripper 1950X processor (w...
 

08.11.2017

Brent Ozar Unlimited : Coming in SQL Server vNext: Approximate_Count_Distinct

Last week at the PASS Summit in Seattle, Kevin Farlee & Joe Sack ran a vNext demo in the Microso...
 

08.11.2017

Paul S. Randal : New Pluralsight course: Understanding and Performing Backups

My latest Pluralsight course has been published – SQL Server: Understanding and Performing Backups. ...
 

07.11.2017

Kevin Kline : Microsoft on the Ascent on Business Intelligence and Data Science

MICROSOFT ON THE ASCENT IN BUSINESS INTELLIGENCE AND DATA SCIENCE Microsoft has been on a tear for t...
 

07.11.2017

Kalen Delaney : Webinar 2.3: Large Datatype Storage

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

07.11.2017

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

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

07.11.2017

Erin Stellato : Query Store and Availability Groups

Last week at the PASS Summit I presented a pre-con and general session on Query Store. I had several...
 

07.11.2017

Brent Ozar Unlimited : Partitioned Views, Aggregates, and Cool Query Plans

The Max for the Minimum Paul White (obviously of course as always) has a Great Post, Brent® about Ag...
 

06.11.2017

Paul S. Randal : New Pluralsight course: Understanding, Configuring, and Troubleshooting Log Shipping

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

06.11.2017

Brent Ozar Unlimited : It’s the last week to save $2,997.50 on my Live Class Season Pass.

We launched our new class lineup last week, and response has been fantastic. Turns out you really li...
 

03.11.2017

SQL Server Blog : Three years in a row – Microsoft is a leader in the ODBMS Magic Quadrant

We’re happy to report that Gartner has positioned Microsoft in the Leaders Quadrant in the 2017 Magi...
 

03.11.2017

Brent Ozar Unlimited : Microsoft’s Query Tuning Announcements from #PASSsummit

Microsoft’s Joe Sack & Pedro Lopes held a forward-looking session for performance tuners a...
 

02.11.2017

Kevin Kline : Adaptive Query Processing in SQL Server 2017

ADAPTIVE QUERY PROCESSING IN SQL SERVER 2017 The next release of Microsoft SQL Server, announced as ...
 

02.11.2017

Erin Stellato : PASS Summit 2017: Day 2

Day 2 is starting here at PASS Summit in Seattle – watch this space for updates the next hour ...
 

02.11.2017

Brent Ozar Unlimited : #PASSsummit Day 2 Keynote: Dr. Rimma Nehme on Azure Cosmos DB

Summit day 2 keynotes have become special. Over the last few years, Microsoft has dedicated the day ...
 

01.11.2017

Marco Russo : Latest news from PASS Summit 2017

PASS Summit is the largest conference about the Microsoft Data Platform technology. Started as a Pro...
 

01.11.2017

SQL Server Blog : SQL Server 2017 and Azure Data Services – The ultimate hybrid data platform

This post was authored by Rohan Kumar, General Manager Database Systems Engineering. Today at PASS S...
 

01.11.2017

Brent Ozar Unlimited : #PASSsummit Day 1 Keynote Live Blog

Good morning, folks, and welcome to our annual live blog of the PASS Summit Day 1 keynote. Open the ...
 

01.11.2017

Erin Stellato : PASS Summit 2017: Day 1

Hey friends!  After a one-year hiatus I am BACK at the PASS Summit and ready to blog the day 1 keyno...
 

01.11.2017

Brent Ozar Unlimited : Registration is Open Now – at Black Friday Prices.

Good news, everyone! Registration is open now, and a limited number of seats are available at half o...
 

31.10.2017

Brent Ozar Unlimited : How to Get Live Query Plans with sp_BlitzWho

sp_BlitzWho is our open source replacement for sp_who and sp_who2. It has all kinds of really neat-o...
 

31.10.2017

Kevin Kline : Powerful ETL Technologies in the Microsoft Data Platform

POWERFUL ETL TECHNOLOGIES IN THE MICROSOFT DATA PLATFORM Microsoft first truly disrupted the ETL mar...
 

31.10.2017

Brent Ozar Unlimited : What Is Estimated Subtree Cost? Query Bucks. No, Really.

When you look at a query plan, SQL Server shows a tooltip with an Estimated Subtree Cost: A long tim...
 

31.10.2017

SQL Server Customer Advisory Team : Recent Updates to setting up SQL Server Availability Groups in Azure VM with AAD Domain Services

Reviewed by: Dimitri Furman, Kun Cheng This blog is an extension to the one that was published in Fe...
 

30.10.2017

SQL Server Blog : Top five reasons to join us for the PASS Summit 2017 Day 1 Keynote

PASS Summit 2017 takes place from November 1 to November 3, in Seattle, Washington at the Washington...
 

30.10.2017

SQL Server Blog : Modernize your applications across on-premise and cloud with the Microsoft Data Accelerator Program

Your customers are demanding the latest innovations in every solution you deliver. How do you make s...
 

30.10.2017

Kalen Delaney : Why Learn About SQL Server Internals?

It's not just about performance tuning! https://www.dbbest.com/blog/learn-sql-server-internals/ Plea...
 

30.10.2017

Marco Russo : Controlling drillthrough using Detail Rows Expressions in DAX

The Detail Rows Expression in a Tabular model provides the user with control over the drillthrough r...
 

30.10.2017

Glenn Berry : SQL Server Diagnostic Information Queries for November 2017

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

30.10.2017

SQL Server Customer Advisory Team : SQLCAT @PASS Summit 2017

Are you coming to the PASS Summit 2017 in Seattle? SQLCAT will be in full force at the PASS Summit 2...
 

Interested?

Receive our monthly newsletter



;