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 …
In preparation for SQL Saturday 114 in Vancouver on March 17th, I have been updating and finalizing the SQL Server Health Reports. The upload today contains the largest number of changes since I created the SQL Server Health Reports. Before this update, the SQL Server Health Reports was just a bunch of reports for reporting on your database. One big change is the …
Top IO Report
This is very useful if you are creating many reports based on a single template. To start with when you use the “Add new Item” functionality into a report project, this is all you get. Report Wizard, Report, and Data Source. Then searching Online Templates is not very useful. So how do I add my own SSRS rdl templates. …
After my CTE presentation at SQL Saturday 108 in Redmond, I was asked many questions, and received several great suggestions from people. Based on that feedback, I am updating my presentation for SQL Saturday 114 in Vancouver to include some additional content. One question was how does the performance compare between a recursive CTE to generate a hierarchical tree path …
WOW, what a great day at SQL Saturday 108 in Redmond. I started out with a keynote presentation from Buck Woody. Then I delivered my presentation on Common Table Expressions. Which I think went well. There were some great questions and I look forward to refining my presentation to include some of the questions that I was asked at the …
After a recent tour at a couple companies who are using the LEAN process, I have decided to take on LEAN in my everyday work. This is the first in what I think will be many videos on the Lean Office topic. Click the link below to watch the video. Lean2SecondKeePass [FMP width=”640″ height=”360″]http://stevestedman.com/wp-content/uploads/2012/02/Lean2SecondKeePass.mp4[/FMP] For more info on KeePass …
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 / …
What is a Factorial: The product of an integer and all the integers below it; e.g., factorial four (4!) is equal to 24. The factorial of a positive integer n, written n!, is the product of all the positive integers from 1 up to and including n Example: 1! = 1 2! = 1 * 2 = 2 3! = 1 * …
Queries with Common table expressions (CTE) are made up of two parts, the CTE part, and the SQL that references the CTE. In preparation for SQL Saturday, the question came up of can you use an INSERT or UPDATE statement with a CTE. Referring to the documentation I confirmed that using an insert or update inside of the CTE is …