One of the things that I enjoy about working for Quest Software is that we give back copiously to the community. From activities and offerings like SQLServerPedia, to our free posters mailed anywhere in North America (and don't forget the free hi-res PDFs for the rest of the world), Don't forget that free DVDs of our virtual conferences featuring me, along with Buck Woody (blog | twitter) and Brent Ozar (blog | twitter) will be mailed anywhere in North America free of charge, now available at this link. Enjoy! -Kevin Twitter at kekline More content at http://KevinEKline.com … [Read more...]
Totally Awesome and Totally Free Training SQL Server Training
Filed Under: Administration, Challenges, On-Line Resources, Presentations, Professional Development, Tips & Tricks, Video Tagged With: Best Practices, DBA, Developer, Professional Development, Training
Database Maintenance Scripting Done Right
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: Best Practices, DBA, Performance, SQL Server 2008 R2, Tools & Scripts
What’s Up With Discovery Wizard for SQL Server?
First, the Good News I really like the free SQL Server utility from Quest Software, nicknamed "Disco", that enables you to discover and inventory all versions and editions of Microsoft SQL Server from the mid-1990's onward. You can see what it does at http://questkb.com/category/sqlserver/discovery-wizard/. I've had a lot of customers who have faced the challenge of bringing an unwieldy and chaotically growing SQL Server infrastructure to heel. It can be really daunting in a big enterprise trying to find all of the SQL Servers tucked behind third-party applications, Microsoft … [Read more...]
Filed Under: Challenges, SQL Server, Tips & Tricks, Tool Time Tagged With: DBA, Quest Software, Tools, Tools & Scripts
Back in Atlanta! Wed, Feb 9 2011
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: DBA, Developer, Internals, Performance, Query Tuning, Transact-SQL Programming
Cloud Evolving, SQL Server Responding
Brent Ozar (blog | twitter) and I did an interview with TechTarget’s Brendan Cournoyer at last summer's Tech-Ed, which as turned into a podcast titled “Cloud efforts advance, SQL Server evolves.” The podcast covers all the major trends at the conference (like BI), virtualization features in Quest’s products (like Spotlight), Brent’s new book and MCM certification, and more. Here’s a link to hear it, appearing on 6/11/10: http://searchsqlserver.techtarget.com/podcast/Cloud-efforts-advance-SQL-Server-evolves … [Read more...]
Filed Under: Cloud, Databases, Interviews, Professional Development, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: Azure, Career, cloud computing, DBA, Professional Development, SQL Server 2008 R2, Writing
Education and Career Resources from Microsoft and the Community
Sometimes I'm timely in getting the news out on useful resources. And, other times, I'm a bit slower on the draw. As I told friends back at New Year's Day, "As an official member of the Procrastinators Club, welcome to 2008!" On the other hand, it's always good to remind folks of great resources that are still available and on the shelf. Why? Well, the Internet hits us with such a deluge of constantly new material, that we often forget about the old(ish) stuff that's still really useful. Quest vConference for SQL Server One of the most popular teaching sessions I ever engaged … [Read more...]
Filed Under: Administration, Databases, On-Line Resources, PASS, Presentations, Professional Development, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post, Tips & Tricks, Video Tagged With: Career, DBA, Developer, Professional Development, Quest Software, Training, Women in Technology
Azure, a Beautiful Color, and So Much More…
Windows and SQL Azure Resources Cloud computing is more than just the latest buzz word in the IT trade papers. It is a remarkable paradigm shift with as much potential to "turn over the apple cart" of IT computing as client-server had for the world of mainframe and minicomputers. If you're not spending time to learn about cloud computing, in general, and SQL Azure, in particular, then you're missing the boat in a big way. (Ha! Two big metaphors in one afternoon. My high-school English teacher would be proud.) There are mountains, literally MOUNTAINS, of free and high-quality content … [Read more...]
Filed Under: Cloud, Cool Technologies, Databases, On-Line Resources, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post, Tool Time, Video Tagged With: Azure, cloud computing, DBA, Developer, Training, Web Development
Video: Where are good SQL Server resources?
Kevin discusses resources online that he uses and considers to be excellent destinations for SQL Server professionals. Kevin will discuss each site he uses in detail - check it out! Posted August 15, 2008. … [Read more...]
Filed Under: Databases, On-Line Resources, Presentations, SQLServerPedia Syndication, Tips & Tricks, Video Tagged With: DBA, Developer, Internals, Monitoring, SQL Server 2005, Tools, Video
Video: Magic Formula for SQL Query Tuning
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: DBA, Performance, Query Tuning, SQL Server 2005, Troubleshooting, Video, Web Development
Video: Interview – Part 3 Cross-Platform Issues
Heather Eichman interviews Kevin Kline, the former President of PASS and systems specialist for the SQL Server Business Unit at Quest Software. Posted January 31, 2008. … [Read more...]
Filed Under: Challenges, Cool Technologies, Databases, Interviews, Opinion, SQL Server, SQLServerPedia Syndication, Strategies, Video Tagged With: DBA, Oracle, SQL Server 2005, Video
