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...]

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...]

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...]

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...]

Microsoft SQL Server High-Availability Videos and Q&A Log

You Want Videos? We Got Videos! I always enjoy getting the chance to catch up with author, consultant, and Microsoft Clustering MVP Allan Hirt.  Allan and I recently presented two sessions covering an overview of high availability in Microsoft SQL Server and, the following week, a demo of how to implement several different kinds of high availability techniques including database mirroring, transactional replication, and Windows clustering services. You can see videos of these presentations at the Quest Software Pain of the Week webcast site. Archives of other videos are here. We're … [Read more...]

And the Winners are…

The winners were named last week in our contest for bloggers on SQLServerPedia.  Lots of great bloggers and great articles for you to read. A complete list of the winners is here: Thanks to the thousands who participated! Follow me on Twitter! … [Read more...]

Video: SQL Performance Optimization

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 … [Read more...]

Plays Well With Others – Upsizing Your Skills With OCW

In our last installment , I describe the three essential skills I felt were hallmarks of the best and most successful directors that I’ve worked with.  Good directors, indeed good strategic leaders of all stripes, usually have at least one or more of these skills: strategic planning, visionary goals, and emotional intelligence. The good news about these skills, and lots of other skills that can advance your career, is that you can learn them.  Many people will spend a fortune on a classroom approach to learning these sorts of skills via an MBA.  If you’re a penny pincher, you can get a leg … [Read more...]

Videos: Strategies for Addressing Common SQL Server Challenges

As a busy SQL Server DBA you face an increasing number of daily challenges: Managing fast growing data volumes and database environments Diagnosing and resolving performance issues Effective backup and recovery Monitoring and tracking database changes Balancing current resources against future capacity needs Inefficiencies in any of these areas can lead to performance degradation, unauthorized database changes, and unplanned, extended downtime. Webcast originally presented by renowned SQL Server expert Kevin Kline and learn valuable strategies for addressing these challenges … [Read more...]

Quest Software announces Cassandra support in Toad for Cloud Databases and a partnership with Riptano.

My employer, Quest Software, Inc.  (QSFT 26.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. Read the entire article here. … [Read more...]