Kalen Delaney, Straight to Your Computer
Only about a day left to register!
This week’s virtual workshop is going to be very cool – Kalen Delaney will be teaching about Indexes – and it’s going to be amazing! Kalen is well known for her in-depth approach to teaching workshops, classes, pre-conference sessions and so much more. We’re really jazzed about bringing you more than *4 hours* of detailed information about things you need to know about Indexes and SQL Server. Learn about key aspects of indexes and, perhaps more importantly, how to apply that knowledge to get the best possible performance from your systems. Take a look here at the virtual workshop site – but don’t delay – the workshop is Friday, so be sure to register today. We’ll even be giving away a copy of her book to one lucky workshop attendee!
>> [Visit the workshop site]
>> [Register for the virtual workshop]
SelectViews Show – SQL Injection
SelectViews: SPECIAL — Kevin Kline – Sample virtual conference session – Avoiding SQL Injection. Watch this special edition selection from the virtual conference to see the types of sessions coming in April.
[Watch the Show Here]
Featured Article(s)
Undocumented SQL Server 2008 Security Stored Procedures
In this article, Alexander Chigrik looks at six undocumented security stored procedures that shipped with SQL Server 2008.
Webcast Today:
Optimizing Backup and Restore Performance
As databases continue to grow in size, the time it takes for backup and recovery grows in length of time. Attend this session and learn methods to minimize the time it takes for your backups to complete, as well as how to minimize the amount of time it takes to recover. Presented by: Thomas LaRock
> Register Now
> Live date: 2/10/2010 at 12:00 Pacific
Reporting and Performance Tip of the Day
You can have a huge impact on performance associated with reports and ad-hoc queries on your system by taking a bit of time to understand how people are using your systems.
Seems pretty obvious – but the key is how they *really* use your systems.
I don’t know of a single time where we’ve deployed an application that allowed at least SOME flexibility where the end-users used that application exactly as we expected, and only as we expected. They always find new ways to use the tools, new things to do with the software.
This leads to opportunity! No, really. It does! It’s an opportunity for you to go back in after the systems have been in use for a bit and really help out in the performance and usability area. How? If you go through and review how people use the system, what types of reports and queries are run, and then compare it to the current indexing and storage layout, you can make changes that can significantly impact the responsiveness of the system. It might be that you can remove indexes that aren’t used, add indexes that are needed or even create views (and indexed views) that let SQL Server do some of the work more efficiently.
The point of this suggestion is pretty simple. Take some time to go review how people are really using your systems. Use Profiler and/or the Database Engine Tuning Adviser tools to figure out the items that can help out. Review where your databases are stored, split apart things across spindles and such.
You won’t be sorry, and you’ll be a hero to your users.
What types of things have you done that have had a solid impact? Drop me an email – let me know – I’d love to hear about your experiences!