Slide background

Trust Issues Hurting Database Performance?

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

Erin Stellato : Trace Flag 2389 and the new Cardinality Estimator

Erin Stellato shows the combined effect of different versions of the cardinality estimator and trace flag 2389 on an ascending key model.

Singin' the #SQLVacation Blues in Memphis, TN

I'm sure not everyone agrees, but Memphis means blues, BBQ, Elvis and BB King. It's Tennessee's biggest city, at approximately 650k residents, only 8% more than Nashville. It's strategic location on the Mississippi River made it a key shipping and immigration hub and, as a consequence, the city houses some of the state's prettiest and

Latest Builds of SQL Server 2012

Updated July 19th, 2016 : SQL Server 2012 is now at Service Pack 3, but regardless of what build you're on now, read this post to see what you should know before deploying. Most recent update: New Cumulative Updates for SP2 & SP3.

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.

Latest Builds of Management Studio

July 14, 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.

Latest Builds of SQL Server 2016

July 14, 2016 : See updated downloads, release notes, and observed changes for builds of SQL Server 2016.

Have You Been Using Runtime Statistics?

Patrick Kelley marks his debut on the SQL Sentry team blog with a deep dive into an often-overlooked feature, Runtime Statistics.

Latest Builds of SQL Sentry Software

Updated July 13, 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.

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.

T-SQL Tuesday #080 – SQL Server R Services

For this month's T-SQL Tuesday, Lori Edwards (@loriedwards) explains why she wants to learn about R Services in SQL Server 2016.

T-SQL Tuesday #080 : CREATE OR REPLACE

Aaron Bertrand (@AaronBertrand) submits a wish list item for the 80th T-SQL Tuesday : CREATE OR REPLACE, a cleaner way to deploy objects without losing permissions.

Latest Builds of SQL Server 2014

Updated July 11, 2016 : SQL Server 2014 is now at Service Pack 2 (12.0.5000), with plenty of enhancements back-ported from the recent SQL Server 2016 release.

It's #SQLVacation Time in Baton Rouge

There are three more dates in my #SQLVacation this year after Baton Rouge. So, after a bit of vacation time in Gulf Shores, AL, were now at the half-way point for the excursion. While I knew that Baton Rouge was the state capital of Louisiana and a major petrochemical center, I had no idea it

10 Critical Signs You Need SQL Server Monitoring

Richard Douglas (@SQLRich) Shares 10 Critical Signs You Need SQL Server Monitoring. Read on to see if these resonate with you!