Category : SQL Server - SentryOne Team Blog

Category: SQL Server

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.

#BackToBasics : Great Debates : Unicode

In his 8th #EntryLevel post, Aaron Bertrand (@AaronBertrand) takes a look at one of the classic debates in SQL Server : whether to support Unicode.

Trust Issues Hurting Database Performance?

Melissa Connors (@MelikaNoKaOi) discusses locating & resolving SQL Server database trust issues (check constraints & foreign keys).

Where do I get SQL Server 2016 Developer Edition?

Aaron Bertrand (@AaronBertrand) shows a few different ways to download SQL Server 2016 Developer Edition, which is a bit harder to obtain than it should be.

T-SQL Tuesday #080 : DBCC CLONEDATABASE

Melissa Connors (@MelikaNoKaOi) takes a look at the new DBCC CLONEDATABASE command in SQL Server 2014 SP2 in this T-SQL Tuesday post.