As I have been working on my SQL Server Health Reports for my presentation at SQL Saturday 114 in Vancouver on March 17th, I have changed the way that I do things several times. After attending a SSRS class “SSRS Beyond the Basics ” at SQL Saturday 108 in Redmond presented by @sqlbelle I learned a few tricks to help make this happen. …
I learned this from one of my co-workers. A quick tip for formatting SSRS reports. When you are in the SSRS report editor, and you want to move the currently selected object (or objects), you can move them with the arrow keys. Most people who have used SSRS know that one, but did you know that if you use the …
Other SQL Server CTE Material, Posts, and Samples On This Site CTE Hierarchy compared to the alternative Recursive CTE’s Calculating Factorials with a Recursive CTE Fibonacci Sequence CTE – With An Insert Statement Generating a Tree Path with a CTE CTE Query Performance Multiple CTE’s in a single Query Recursive CTE’s CTE Category on this site CTE Tag on this …
Before proceeding with the article, please take this quick password safety test. Password Safety Test – Score one point for every YES answer.: Do you write your passwords down? ( YES / NO ) Do you ever re-use a password on multiple systems or websites? ( YES / NO ) Are your passwords shorter than 8 characters? ( YES / …
As part of my CTE research for my SQL Saturday presentation in Redmond in 2 weeks I decided to take on some classic computer science algorithms with CTE’s. Here is what I cam up with. Any math geek can tell you what the Fibonacci Sequence is, but do you know how to calculate it with a query? First, what is …
I had a great time presenting at SQL Saturday 108 in Redmond. Below is the presentation and sample code from the presentation. CTE_Redmond.zip The thing that I love about a presentation like this is the people who ask questions at the end of the presentation. I learned a few things that I plan to add into the presentation for Vancouver …
After being approved as a speaker at SQL Saturday 114 – Vancouver BC, and SQL Saturday 108 – Redmond WA, I have decided to give it another shot at SQL Saturday 120 in Orange County California. I have submitted 2 abstracts for sessions: The first one is titled Unleashing Common Table Expressions in SQL Server, and if accepted this will be …
Sessions Submitted for SQL Saturday #120 Orange County CA Read more »
I just checked the schedule and one of the sessions that I submitted for SQL Saturday 108 in Redmond WA on February 25th has been accepted. I will be presenting Unleashing Common Table Expressions in SQL Server. If you are going to be there, drop me an email and let me know. This should be fun!
Notes from my presentation at SQL Saturday 114 in Vancouver BC on March 17, 2012. Unleashing Common Table Expressions in SQL Server Have you ever wanted to create a recursive query, but didn’t see how to do it. With the Common Table Expressions class you will learn everything needed to start using CTE‘s for recursive queries, as a temporary views, …
I am available to speak at your event and bring extensive SQL Server expertise to your audience, with content that spans the breadth of SQL Server functionality and performance. My presentations are tailored to meet the needs of your attendees, whether they are beginners, advanced users, or somewhere in between. In addition to popular SQL Server topics like SSRS, performance …