Over the last week I have pitched 8 presentations for SQL Connections in Vegas at the end of October 2012. Hoping that 3 of my presentations get accepted. Here is the list so far. Using the New Analytic Functions in SQL Server 2012 Exploring the TSQL Enhancements in SQL Server 2012 Unleashing Common Table Expressions in SQL Server Using SSRS …
Working on my Presentations for SQL Connections Fall 2012 Read more »
A couple years ago in my Incident Safety Officer class with the fire department we studied risk assessment for any incident that the fire department may respond to. Since that time I have used a similar risk assessment matrix for SQL Server upgrades, and other big SQL Server maintenance tasks. The risk assessment matrix as it is used by the …
Part of SQL Server running queries is that once a query is analyzed, parsed and compiled, that compiled plan is kept in memory so that it can be quickly re-used in the future. If you are using proper parameterized queries, most of your queries will get kept around and re-used saving lots of CPU and memory on SQL Server. If …
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 …
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 / …
If you are using Windows 7, give this a try. When you have multiple windows all visible on your desktop, just click on the title bar of one of the windows. While holding your mouse button down “Shake” that window my moving your mouse back and forth quickly. All other windows on the desktop will be minimized, leaving the window …
This week I have been at the SQL Connections conference in Las Vegas. With 7 to 9 hours of classes and presentations every day, all on Microsoft SQL Server. The classes included the Next Generation of SQL Server, Distributed Applications with Service Broker, Building High Availability Using Microsoft SQL Server 2008, Virtualization, Installation and Migration Strategies, Logging and Recovery, Minimally …
Home after a week at SQL DevConnections 2009 in Las Vegas Read more »
First off if you are not familiar with ISO files, an ISO file is a file that is a disk image of a a CD disk or DVD disk. It is like a copy of the entire CD or DVD into a ISO image on your hard drive. These were typically used for copying or distributing a disk contents over …