Category: SQL Server

Kevin Kline (@kekline) tells us about why SQL Server defaults become so muddled and about a mysterious "Smoking Man" behind the scenes pulling strings.
Lori Edwards (@loriedwards) enters this month's T-SQL Tuesday, hosted by Andy Yun, to warn us about some important SQL Server default settings.
Kevin Kline shows you where to get the new preview apps for Power BI on Android and Windows, as well as a variety of community resources for Power BI.
Melissa Connors continues her compression series, looking at disk I/O, memory usage, and decision-making tables for selecting compression.
Melissa Connors continues her series on data compression, focusing on costs of implementation, index maintenance, and running SQL Sentry.
Kevin Kline (@KEKline) gives a recap of the #SQLVacation and points to all of his slide decks and SQL scripts.
Melissa Connors investigates the approach, costs, and space/performance benefits of applying data compression to the SQL Sentry database.
Kevin Kline (@kekline) wraps up the #SQLVacation speaking tour with a final stop in his hometown, Nashville TN.
Aaron Bertrand shows the ins and outs of a new function that a...
Aaron Bertrand talks about the recent release of SQL Server 2016 CTP 2.1 and what changes you should expect.
Kevin Kline (@kekline) continues the SQLVacation summer speaking tour by delivering four sessions on data management topics in St. Louis.
Kevin Kline (@kekline) teaches SQL Server performance at the first stop of the #SQLVacation speaking tour in Louisville, Kentucky.
Aaron Bertrand lists out the changes to In-Memory OLTP Enhancements...
Aaron Bertrand shows a workaround for an obscure error you might receive while patching SQL Server: "No room is available to display rows."
With detailed information and his uncanny knack for explaining technical concepts very well, Paul White concludes his series on ACID...

Top Categories

See all

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

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