Slide background

#BackToBasics : Naming Stored Procedures

Naming conventions for stored procedures is the topic for Aaron Bertrand's 9th post for his #EntryLevel series.

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.

Dynamic Data Masking : My Thoughts

Recently I have been exploring Dynamic Data Masking, looking at ways that it can be used and I thought I would share my thoughts with you.

Latest Builds of SQL Server 2014

Updated August 26, 2016 : SQL Server 2014 is now at Service Pack 2, with plenty of enhancements back-ported from the recent SQL Server 2016 release.

SSMS is starting to look better…

Aaron Bertrand (@AaronBertrand) uses several examples to show the progress the SSMS team is making on enabling full support for HiDPI / 4K screens.

Deploying SQL Sentry Reports to SSRS

SQL Sentry has an array of built-in reports that provide insight on the performance of your environment. Here John looks at deploying these to SSRS server.

Latest Builds of SQL Sentry Software

Updated August 18th, 2016 : This post is intended to give you a single location to determine the latest general release version of our software components, as well as links to downloads, change lists, documentation, and product-related blog posts.

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

Latest Builds of Management Studio

August 15, 2016: Find information about the builds of SQL Server Management Studio and SSDT in their new release cycle approach, and locate the latest build of SSMS for previous versions.

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.

SQL Sentry Performance Advisor : Disk Activity tab

Lori Edwards (@loriedwards) provides a detailed overview of the patented Disk Activity tab in SQL Sentry Performance Advisor.

New Custom Conditions Pack (July 2016)

Melissa Connors (@MelikaNoKaOi) tells you what's new in the latest SQL Sentry Custom Conditions Pack for more intelligent SQL Server altering.

Rob Farley : AT TIME ZONE – a new favourite feature in SQL Server 2016

Rob Farley explains why AT TIME ZONE is his new favourite feature in SQL Server 2016, but also shows that it can make a mess of cardinality estimates.