Microsoft Windows Platforms Blog Watch

July 20, 2011 by Leave a Comment

Remote Desktop Services Component Architecture Poster Grab your own poster! A visual guide to key Remote Desktop Services technologies in Windows Server 2008R2   Virtually Free Get the latest update rollup package for the Hyper-V role in Windows Server 2008 R2 and be sure to bookmark the Windows Virtualization Team Blog.  Be sure to check out blog World Simplified is a Virtual World. And doncha evah neglect application virtualization, such as the goodness at the App-V Product Team Blog.   Let's Optimize Some Desktops (Assuming You Have Gone Full Cloud … [Read more...]

Filed Under: Administration, Cloud, Cool Technologies, Databases, On-Line Resources, Performance, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post, Tips & Tricks, Tool Time Tagged With: , , , , , , , , , ,

Pain of the Week/Expert’s Perspective: Performance Tuning for Backups and Restores

June 27, 2011 by Leave a Comment

First off - the Pain of the Week webcast series has been renamed.  It's now known as The Expert's Perspective.  Please join us for future webcasts and, if you're interested in speaking, drop me a note to see if we can get you on the roster! The bigger your databases get, the longer backups take. That doesn't really seem like a huge problem — until disaster strikes and you need to restore your databases as fast as possible. Join my buddy Brent Ozar (blog | twitter), a Microsoft Certified Master of SQL Server and good friend, as he reveals ways to make these critically important … [Read more...]

Filed Under: Administration, Databases, Performance, SQL Server, SQLServerPedia Syndication, Tips & Tricks Tagged With: , , , ,

Available Online – SQL Server Training Videos

May 31, 2011 by Leave a Comment

Interested in my various performance tuning and troubleshooting videos about SQL Server?  These videos feature my good buddies (and uber-SQL Server experts) Brent Ozar (blog | twitter) and Buck Woody (blog | twitter).  View these insight-packed training videos from our SQL Server training events originally presented on March 3 and July 21 of 2010:HERE. You can watch the videos now at the URL above or order a DVD, shipped free of charge in the USA and Canada, HERE. Enjoy! -Kev ~~~ Twitter at kekline More content on my Blog … [Read more...]

Filed Under: Administration, Challenges, Databases, IO, On-Line Resources, Performance, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: , , , , , , , ,

Free Webcast Series: Patterns and Practices in Database Administration

April 27, 2011 by Leave a Comment

SSWUG.ORG’s virtual webcasts will prepare the “Accidental DBA” for patterns and practices they will experience in their role as a database administrator. I will provide easy-to-understand insights and realistic examples for professionals who have not had any formal DBA training. By the end of our four-part series, you should have the information needed to get up to speed on database planning, administration and performance tuning basics. Session Descriptions In the first session, you will see what is needed to fulfill the role of a (Database Administrator) DBA by learning more about what … [Read more...]

Filed Under: Administration, Challenges, Databases, Presentations, Professional Development, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: , , , , , ,

Integrating Workload Replays into Database Change Management

March 1, 2011 by Leave a Comment

I would like to make you aware of a recently written paper by Bert Scalzo.  The paper focuses on how DBAs can rely on the Toad and Benchmark Factory to perform database workload replays, ensuring that changes to the databases do not degrade the user experience. White Paper: Integrating Workload Replays into Database Change Management I encourage you to read the paper and make workload replay a part of your database change management practices.  As I’ve been saying for years, if you don’t have quantitative evidence of what normal is for your database, how can you know what is … [Read more...]

Filed Under: Challenges, Cool Technologies, Databases, Opinion Tagged With: , , , , , ,

Database Maintenance Scripting Done Right

February 18, 2011 by Leave a Comment

I first wrote about useful database maintenance scripts on my SQLBlog account way back in 2008.  Hmmm - now that I think about it, I first wrote about my own useful database maintenance scripts in a journal called SQL Server Professional back in the mid-1990's on SQL Server v6.5 or some such.  But I digress... Anyway, I pointed out a couple useful sites where you could get some good scripts that would take care of preventative maintenance on your SQL Server, such as index defragmentation, updating statistics, and so forth.  One of the script kits came directly from Microsoft's internal … [Read more...]

Filed Under: Administration, Challenges, Databases, On-Line Resources, Performance, SQL Server, SQLMag, SQLServerPedia Syndication, Tool Time Tagged With: , , , ,

Have You Heard About Project Lucy?

February 16, 2011 by 1 Comment

Quest Software's latest community initiative, Windows Azure-based Project Lucy, has debuted! Project Lucy is part infrastructure analytics, part social media experiment, and part performance data warehouse. The best things about Project Lucy include: It’s Free - just like our SQLServerPedia website, Project Lucy is free to anyone who wants to upload a trace file It’s 1oo% web-based - you don’t have to download or maintain anything and updates roll out seamlessly, all the time It really helps - just generate a SQL Trace on a SQL Server 2000, 2005 or 2008 instance, upload it on … [Read more...]

Filed Under: Cloud, Cool Technologies, Databases, On-Line Resources, Performance, SQL Server, Tips & Tricks, Tool Time Tagged With: , , , , , ,

Back in Atlanta! Wed, Feb 9 2011

February 7, 2011 by Leave a Comment

I always enjoy spending time with my friends from Atlanta, as well as meeting folks and making new friends. If you live in the Atlanta area, I hope you'll join me on the evening of Wednesday, February 9th, 2011.  Details are at the Atlanta SQL Server user group website. It's common knowledge that I have a terrible memory for many things.  However, one of the few things that my memory is usually really good at is remember names & faces (and remembering stories, but that is another story as well). It's only in the last couple years that I've gotten to know Atlanta-area folks like Aaron … [Read more...]

Filed Under: PASS, Presentations, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: , , , , ,

Video: Magic Formula for SQL Query Tuning

January 20, 2011 by Leave a Comment

Featuring Kevin Kline this video focuses on accelerated Disk Optimization and improved productivity with SQL Query Tuning. Posted December 18, 2006. … [Read more...]

Filed Under: IO, Performance, Presentations, SQL Server, SQLServerPedia Syndication, Tips & Tricks, Video Tagged With: , , , , , ,

Video: Ensure Optimal Performance When Deploying SQL Server 2005

December 16, 2010 by Leave a Comment

Kevin Kline will offer insight into best practices for SQL Server 2005 set up, configuration and queries. He will also discuss tuning for both the server and hardware to help an application perform better after it is deployed. This presentation will offer a better understanding of several SQL Server performance related areas including: * Hardware design * SQL Server configuration settings * Database configuration settings * Application design * SQL Tuning Posted December 20, 2006. … [Read more...]

Filed Under: Databases, IO, On-Line Resources, Performance, Presentations, SQL Server, SQLServerPedia Syndication, Video Tagged With: , , , , , , , ,
« Previous Page
Next Page »