What is Hekaton
Hekaton is also known as SQL Server In-Memory database, touted to accelerate transaction throughput up to 30x performance increases on existing hardware. With a new latch-free… Read More »What is Hekaton
Working on the T-SQL Technical Debt feature in the Database Health Reports
As part of my contribution back to the SQL Server community I am adding a new feature into the free Database Health Reports application. I am currently… Read More »Working on the T-SQL Technical Debt feature in the Database Health Reports
New Raving Fan for Database Health Reports
I received this rave today about the Database Health Reports. It has been posted on the Raving Fans page. 7/17/2013 – Beta 6 Rave The… Read More »New Raving Fan for Database Health Reports
T-SQL Technical Debt
Technical Debt is a programming concept that is also known as code debt. The concept of Technical Debt applies closely with Agile software development, but… Read More »T-SQL Technical Debt
Database Health Reports – 800th download
Today marks the 800th download of the Database Health Reports application. I would like to thank everyone who as used it and everyone who has provided… Read More »Database Health Reports – 800th download
No more Business Intelligence Development Studio in SQL 2014
When you look at the installed programs with SQL Server 2014 CTP1 you see the following: There is no BIDS or Visual Studio installed with… Read More »No more Business Intelligence Development Studio in SQL 2014
End of June Summary
June was an exciting month for me with Beta 6 of the Database Health Reports releasing at the beginning of the month, and this being… Read More »End of June Summary
Trust Me – I’m a Database Administrator
I love this T-Shirt that I found at Amazon.com. Trust Me ! I’m A Database Administrator Mens T-shirt
What Do You Use CTEs for?
There are many great reasons to use Common Expressions, from derived table query re-use, to doing recursive queries and creating hierarchies to doing data paging,… Read More »What Do You Use CTEs for?
CTE Data Paging in a Procedure
Day 15 of Common Table Expression Month (June) at SteveStedman.com, today we will be taking a look at data paging with CTE’s in a function. Yesterday… Read More »CTE Data Paging in a Procedure