I started out the day with the keynote presentation with some great info on PASS and the PASS volunteers, followed by Microsoft presenting on in memory tables, and native compilation for stored procedures, described and demonstrated as “Wicked Fast”. Next I attended a fabulous presentation from Erin Stellato on Extended Events, an improved replacement for the SQL profiler. I learned …
At the end of my SQL Saturday presentation today on Advanced Common Table Expressions, which is about the 12th time I have presented on CTEs, I was asked a question that I have been asked many times after I present. I am blogging about this because I have been asked about it so many times. This one one of those …
I will be speaking at SQL Saturday Denver, presenting on Advanced Common Table Expressions. This presentation should be a lot of fun. I will be covering all the advanced and fun CTE features that I haven’t had time to fit into my introduction to CTE session in the past. Here is the outline of the session: 1.Recursive CTEs. 2.Hierarchical CTEs. …
I have been working on Beta 7 over the last 3 months, and it is finally ready. Beta 7 has been released today featuring the addition of the SQL Technical Debt reporting. Besides the SQL Technical debt reporting, the other area of major improvement was the overall performance of the application. There are many areas that previously were slow or difficult …
Database Health Beta 7 Released – Featuring SQL Technical Debt Analysis Read more »
One of my sessions was accepted for SQL Saturday #190 in Denver this year. Please come see my CTE presentation. Common Table Expressions – Introduction Have you ever wanted to create a recursive query, but didn’t see how to do it. With the Common Table Expressions session you will learn everything needed to start using CTE’s for recursive queries, …
Related Common Table Expression Links Sample Database for Common Table Expressions Writing Your First Common Table Expression with SQL Server Video: Writing Your First CTE with SQL Server Common Table Expressions – Terminating the Previous Statement CTE Scope Introduction to Recursive CTEs Recursive CTE for Dates In A Year Expanding on Recursive Dates CTE Multiple CTEs in a Query …
Across 2. Management Studio 5. The database that is used as a template when creating a new database 6. Using a backup 7. Reporting Services 9. An index that rearranges the structure of a table 12. The underlying structure of an index 13. Common Table Expression 20. Making queries run faster 21. An index that doesn’t change the structure of …
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 »
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 …
It has been a busy week at SteveStedman.com. Here is a quick summary of this weeks postings: June 14th – CTE Data Paging June 13th – Query To Simulate CPU Load June 12th – Nested CTE’s Gone Wild – The Video June 11th – Nested CTEs June 10th – Database Health Reports – Seven Hundred Downloads So Far June 10th – Multiple CTEs in a …