To start with for Transparent Data Encyrption (TDE) we will need to be using Enterprise (or Developer) edition of SQL Server 2014. I am using SQL Server 2014 Enterprise Edition CTP1, which is the early release of SQL Server 2014. Next we need a database to work with. I will just use the Sample Database for Common Table Expressions, a simple …
Enabling Transparent Data Encryption on SQL Server 2014 Read more »
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 technology Hekaton is claimed to dramatically increase performance. Are you ready to increase the speed of your OLTP databases by 30x?
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 working on adding a new feature into the Database Health Reports to analyze T-SQL Technical Debt. If you are not familiar with technical debt, it applies to all aspects of programming or technology. This is going to …
Working on the T-SQL Technical Debt feature in the Database Health Reports Read more »
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 software is really good, I am using very regularly to audit and performance tune the SQL instances that I administer. Managed to knock a third of a large SSIS pipeline’s runtime just from using the …
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 also applies to database development. There are many tools available to report on technical debt for C#, PHP or other programming languages, but there isn’t much available to manage the SQL Server or T-SQL technical …
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 me feedback along the way. I am currently working on Beta 7, which should be out by the end of the summer. For now Beta 6 is the most stable and feature packed version of …
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 CTP1 of SQL Server 2014. After some additional research, and discovering that I didn’t miss something on the installation. There is no more Business Intelligence Development Studio (BIDS) in SQL Server 2014, instead it can be downloaded …
No more Business Intelligence Development Studio in SQL 2014 Read more »
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 CTE Month at SteveStedman.com to mark the release of my Common Table Expressions book. CTE Month Summary CTE Month postings started with the basics on June 1st, and grew throughout the month to include more …
I love this T-Shirt that I found at Amazon.com. Trust Me ! I’m A Database Administrator Mens T-shirt
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, cleaner code, or de-duplication of data. I am curious what you are using CTE’s for? Please post a reply with the top things you use CTE’s for. Thanks!!