Category: SQL Server

Today I presented at Discovery Day New England, a SQL Server 2016 event (sponsored in part by SQL Sentry) held at the Microsoft office in Cambridge, MA. Attached are demos and slide decks.
Lori Edwards gives us a quick introduction to a new SQL Server 2016 feature, Temporal Tables, as a part of this month's T-SQL Tuesday.
Aaron Bertrand enters June's T-SQL Tuesday, talking about a feature long missing from SQL Server: The ability for Developer Edition to act like Standard.
We've separated out the now-static info about pre-release SQL Server 2016 builds into its own post, primarily to make maintenance easier and...
Aaron Bertrand explains some of the more common acronyms you might see flung around in blog posts, Connect items, and Knowledge Base articles.
Glenn Berry provides the SQL Server DBA some insight into the ever-changing world of hardware and infrastructure.
Aaron Bertrand cautions about using DROP COLUMN without immediately rebuilding the table. Wasted space is a concern; data loss is worse.
April 25, 2016 | Aaron Bertrand | SQL Server 19
David Benoit walks through the process of configuring a scale-out PolyBase cluster with SQL Server 2016 and Azure Blob Storage.
Aaron Bertrand talks about some of the upcoming changes to telemetry and other privacy settings in SQL Server 2016.
John Martin starts his security nuggets series, explaining why you should use encrypted connections for SQL Server if you take system security seriously.
March 16, 2016 | John Martin | Security, SQL Server 1
Think of this series as a brain dump for all of the career advice we'd give to an aspiring DBA. Register now!
March 14, 2016 | Kevin Kline | Best Practices, SQL Server, Career 0
Melissa Connors guides you through creating advanced SQL Sentry Custom Conditions with multi-step condition checks for intelligent alerting.
Microsoft first truly disrupted the ETL marketplace with the introduction of SQL Server Integration Services (SSIS) back with the release of SQL Server 2005.
Aaron Bertrand continues his Back to Basics series, this time discussing SQL Server's synonym and how it can be used.
March 2, 2016 | Aaron Bertrand | #BackToBasics, T-SQL, SQL Server 10

Top Categories

See all

Get the best SQL query analysis and optimization tool – free!

  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More