Latest community news



Share:

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

30.10.2017

Glenn Berry : Presenting Two Sessions at the PASS Summit 2017 in Seattle

I’ll be presenting two sessions at the PASS Summit 2017 in Seattle, WA. There will be a half-day ses...
 

30.10.2017

Brent Ozar Unlimited : Announcing my new Mastering class series – and registration opens Wednesday.

We’ve talked about why traditional training sucks, how our all-new series is different, and wh...
 

28.10.2017

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

This week, Brent, Erik, and Richie discuss database corruption, multi-instance clusters, career advi...
 

27.10.2017

Kevin Kline : They Did it Again – The Release of SQL Server 2017

THEY DID IT AGAIN – THE RELEASE OF SQL SERVER 2017 Not only has the Microsoft SQL Server engineering...
 

27.10.2017

Brent Ozar Unlimited : Here’s what our early-access students said about our new courses.

While developing my new SQL Server training experiment, I ran an early-access version, and here̵...
 

26.10.2017

Paul S. Randal : New class: IEBISec on Securing Your BI Platform

We’ve added a second brand-new class to our Spring line-up in Chicago: Immersion Event on Securing Y...
 

26.10.2017

Paul S. Randal : New class: IEBIStrat on Developing a BI and Analytics Strategy

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

26.10.2017

Brent Ozar Unlimited : Let’s mix things up with a new way to learn.

Because learning SQL Server is painful, we’ve been experimenting with new topics, new guest in...
 

25.10.2017

Glenn Berry : SQL Server 2017 CU1 is Available

On October 24, 2017, Microsoft released SQL Server 2017 Cumulative Update 1, which is Build 14.0.300...
 

24.10.2017

Brent Ozar Unlimited : First Responder Kit Release: Precon Precogs

This release comes to you from a hotel room in Chicago: The land of fiscal insolvency and one shooti...
 

24.10.2017

Kevin Kline : Machine Learning and the Microsoft Data Platform

MACHINE LEARNING AND THE MICROSOFT DATA PLATFORM If you’re into data and databases and you hav...
 

24.10.2017

Brent Ozar Unlimited : Learning SQL Server is painful.

Blogs are free, but they’re bite-sized. They’re great when you’ve only got a few m...
 

23.10.2017

Kalen Delaney : SQL Server 2016/2017 Internals and Tuning is Online!

I am presenting my entire SQL Server Internals training online, an hour at a time, though DB Best. C...
 

23.10.2017

SQL Server Customer Advisory Team : Top Questions from New Users of Azure SQL Database

Reviewed by: Kun Cheng, John Hoang, Denzil Ribeiro, Rajesh Setlem Over the years, we have been engag...
 

23.10.2017

SQL Server Blog : Ask the team that built SQL Server 2017 anything on October 25, 2017

Hi! We’re Travis Wright and Tobias Ternstrom from the Microsoft SQL Server engineering team and we a...
 

23.10.2017

Marco Russo : DAX Studio

DAX Studio is a tool to write, execute, and analyze DAX queries in Power BI Designer, Power Pivot fo...
 

20.10.2017

Kevin Kline : Surprising but True: the Basics are Still Difficult

SURPRISING BUT TRUE: THE BASICS ARE STILL DIFFICULT I always look forward to new research from Unisp...
 

20.10.2017

Brent Ozar Unlimited : French makes everything sound so sexy.

Even error messages: [crayon-59ea21cde3ea0700516613/] Produces: These sound better than anything I w...
 

20.10.2017

Marco Russo : VertiPaq Analyzer

VertiPaq Analyzer is useful to analyze VertiPaq storage structures for a data model in Analysis Serv...
 

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

17.10.2017

Marco Russo : Power Pivot Utilities

Power Pivot Utilities in an Excel add-in (based on a collection of VBA macros) that helps documentin...
 

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

14.10.2017

Marco Russo : DAX Editor

DAX Editor is an extension to SSDT that makes it easier to edit DAX measures in a Microsoft Analysis...
 

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

13.10.2017

Marco Russo : BISM Normalizer

ISM Normalizer is a free and open-source tool to manage Microsoft Analysis Services tabular models.
 

12.10.2017

Marco Russo : SSAS Tabular Translator

SSAS Tabular Translator is an editor for the JSON translation files exported and imported by SQL Ser...
 

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

Interested?

Receive our monthly newsletter



;