Gain insight into best practices for SQL Server optimization and ways to alleviate many root causes that can impact performance of your SQL Server database. Kevin also will discuss how to manage for planned and unplanned changes, speed time to implementation of your applications and ensure that your databases are running as they should.
You will learn how to:
* Identify the root cause of bottlenecks that hinder performance of your SQL Server environment
* Diagnose and fix T-SQL errors in development before code goes into production
* Learn new best practices for project planning and formatting your code
* Ensure that your code is scalable, optimized and validated
* Resolve 60-80% of the performance bottlenecks attributed to poorly written SQL
My employer, Quest Software, Inc. (QSFT26.15, +0.68, +2.65%) today added Apache Cassandra, an open-source NoSQL database, to its list of supported NoSQL platforms with the second beta release of Toad(R) for Cloud Databases. Toad now supports data access and management for Apache Cassandra, Amazon SimpleDB, Microsoft Azure Table Services, Apache HBase, and any Open Database Connectivity-enabled relational database.
Since the release of SQL Server 2005, companies have been investing heavily in SQL Server for their business-critical applications. DBAs are now challenged with supporting ever-growing datasets and making efficient use of allocated disk space in both production and enterprise storage environments. Yet DBAs seldom have a clear picture of their data storage and therefore cannot determine whether they are getting a worthwhile return on their storage investment or if an out-of-disk situation is looming.
In this presentation, Kevin will address these challenges and explore methodologies to help you efficiently use allocated disk space for enterprise storage and production environments.
This presentation is a bit old, but largely still applicable. It will help you understand Microsoft tuning techniques. It will teach tips and tricks for making queries perform better, and how to use tools to tune SQL.
We’ve got two sessions that you (the “we” meaning the fine folks at Quest Software) need to sign up for right away. The upcoming webcast for Oracle-oriented folks has huge registration numbers. And I’m sure you’ll learn more than you expected thanks to my fine co-presenters. Get in while you still can before we hit the limit of what LiveMeeting can handle!
Webcast:SQL Server for the Oracle DBA Date:Thursday, May 27, 2010(Just a couple days hence!) Time: 8 a.m. Pacific / 11 a.m. Eastern / 4 p.m. United Kingdom / 5 p.m. Central Europe Duration: 45-60 minutes Cost:FREE
In enterprise IT, database professionals face a mixed-bag of platforms within their environments — and the overlapping duties that go along with them. Whether you like it or not, you get asked to support Microsoft SQL Server operations even though you’re an Oracle DBA.
In this instructive webcast, experts from Microsoft and Quest with years of experience in both platforms will discuss the biggest issues and areas of interest for Oracle DBAs who need to work on Microsoft SQL Server. You’ll learn their tips and tricks for efficiency and gain a deeper understanding of SQL Server to help you add more value than ever to your organization.
Presenters: Kevin Kline, SQL Server MVP, Quest Software Buck Woody, Senior Technology Specialist, SQL Server, Microsoft
Webcast:Easy Ways to Fix Hard SQL Server Problems – Without a Guru Date: Thursday, June 17, 2010 Time: 8 a.m. Pacific / 11 a.m. Eastern / 4 p.m. United Kingdom / 5 p.m. Central Europe Duration: 45-60 minutes Cost:FREE
In this instructive webcast, you’ll learn straightforward methods for troubleshooting and resolving common poorly performing stored procedures and queries in SQL Server 2008. The presenters will show you how to easily:
Read query execution plans and identify bottlenecks in performance
Record system performance metrics for trend analysis
Design databases and write Transact–SQL code to avoid common problems
Understand what an index is, what it does, and how to build one
Use industry-accepted best practices and develop your own to arrive at optimal database performance
Don’t miss this chance to get practical advice from working experts instead of just theories from academics! Presenters: Kevin Kline, SQL Server MVP, Quest Software Grant Fritchey, “Scary” DBA from FM Global
I just posted a new blog entry on how I automate the shutdown and startup of Windows services.
Check it out at http://www.sqlmag.com/blogs/tool-time.aspx. Be sure to let me know what you think and if you have your own unique methods for automating the control of Windows services!
A neat new administration and configuration management tool for the SQL Server set. I especially like the Run Book features, because Run Books are the way us “oldtimers” like to run our IT infrastructure. My pal, Buck Woody, also likes Run Books (and really big explosions by the guys on MythBusters, but that’s another discussion). Find all the details about the new tool, created by Bill Wunder, here.
"Richard, wasn't that an awesome interview?!?" "Carl, I could've danced, er, talked all night!"
In addition, I’m honored and amazed that the team at RunAsRadio invited me to participate in interview #143. These are the same guys who also put together one of the best and longest running IT podcasting shows – .NETRocks. Unlike a lot of interviews, it seems like we had too little time to cover all the topics. I’d love to hear your feedback!
If you’re like me, you’ve used Ctrl+C/Ctrl+V more than a time or two, but you’ve always felt a little dirty afterwards. Yeah, you can use the command-line COPY or XCOPY utilities. But they’re decidedly 20th Century, much like some of the laundry still loitering under my office couch.
So I spent a little time over the holidays cleaning up my file system by scripting a backup routine using the very cool and very free ROBOCOPY utility. Now, I’ve got a regularly scheduled job that, after the first run which captured all my files, only backs up new or changed files (and directories) while keeping all of their NTFS attributes. Boo-Yah!
Read all about it on my Tool Time Blog at SQLMag. I’ll also show you how to use some other free and powerful alternatives in future entries.
