SentryOne Team Blog (blogs.sentryone.com)

Category: SQL Server

T-SQL Tuesday #86 : Sorting a Stacked Chart

T-SQL Tuesday #86 : Sorting a Stacked Chart

Melissa Connors (@MelikaNoKaOi) wonders why she can't sort items in a Power BI Stacked Chart in a post for this month's T-SQL Tuesday about Connect items.

T-SQL Tuesday #86 : My Favorite Connect Items

T-SQL Tuesday #86 : My Favorite Connect Items

For T-SQL Tuesday #86, Aaron Bertrand (@AaronBertrand) highlights a few of his favorite bugs and feature requests on Microsoft's improvement site, Connect.

January Webinars Focus on Azure and Containers

January Webinars Focus on Azure and Containers

Kevin Kline (@kekline) invites you to three webinars coming up in January: A two-part series on the Azure platform, with Gavin Payne; and a session from Paul Stanton on running SQL Server inside Docker containers.

Major Feature Reconfiguration For SQL Server 2016 Service Pack 1

One of the long-standing differentiators between SQL Server's Enterprise Edition (EE) and Standard Edition (SE), besides price, were the large number of features available only in EE. This is also true for other lower editions of SQL Server such as Web Edition and Express Edition. But there's big news in the air! READ MORE… Originally

Glenn Berry : SQL Server 2016 Enterprise Edition Performance Advantages

Glenn Berry : SQL Server 2016 Enterprise Edition Performance Advantages

Glenn Berry uses a few specific examples to demonstrate the performance benefits you can get from SQL Server 2016 SP1 Enterprise Edition.

#BackToBasics : A Challenge for 2016

#BackToBasics : A Challenge for 2016

In every month of 2016, Aaron Bertrand (@AaronBertrand) will attempt to publish an introductory blog post about SQL Server.

Memory Limits in SQL Server 2016 SP1

Memory Limits in SQL Server 2016 SP1

Aaron Bertrand (@AaronBertrand) explains a few details about the memory limits in SQL Server 2016 Service Pack 1 that make this upgrade even more compelling.

Join Us at 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 October in Seattle. I've got two regular sessions, one technical and one profession, as well as two community sessions. I hope you can join me. In case you don't know, the PASS Summit connects you with industry experts and THOUSANDS

Proof of Concepts: Making Hard Things Easy with Azure

Back when I managed my employer's enterprise architecture, prior to the days of virtualization and cloud computing, one of my most difficult projects was to build out a sandbox environment for a major proof of concept (POC). Locally hosted servers and all of the required licenses were expensive and scarce. If you're still struggling with

VS Code on Mac meets SQL Server on Linux (in Docker)

VS Code on Mac meets SQL Server on Linux (in Docker)

Aaron Bertrand describes his steps for setting up a development stack, with VS Code on Mac, managing SQL Server on Ubuntu, inside a Docker container.

A Big Deal : SQL Server 2016 Service Pack 1

A Big Deal : SQL Server 2016 Service Pack 1

Microsoft has made a bold change to SQL Server 2016 in Service Pack 1 : Many Enterprise features are now available in lower editions. Read on for details.

Erin Stellato : Expanding DBCC CLONEDATABASE

Erin Stellato (@erinstellato) goes into detail about some practical use cases for a new DBCC command in SQL Server 2014 SP2 and 2016 : DBCC CLONEDATABASE.

#EntryLevel : Compression & Data Types

Melissa Connors (@MelikaNoKaOi) walks through the basics of when SQL Server data will benefit from compression and illustrates cases when it will not.

SQL Server 2016 is Simply Faster… A Lot Faster

I had the pleasure to spend some time with my old friend Mark Souza, a general manager in the Data Platform team at Microsoft, while speaking at the SQL Saturday event in Dublin, Ireland last summer. Now keep in mind that Mark and I have known each other since the 1990s when SQL Server was

Minimizing impact of widening an IDENTITY column – part 4

Aaron Bertrand (@AaronBertrand) continues his series on widening an IDENTITY column, showing how he would attack the problem directly.