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...]
Videos: Strategies for Addressing Common SQL Server Challenges
Filed Under: Administration, Challenges, Databases, Performance, Presentations, SQL Server, SQLServerPedia Syndication, Strategies, Tips & Tricks, Video Tagged With: Best Practices, DBA, Developer, DMV, Internals, Monitoring, Performance, Quest Software, SQL Server 2005, Tools, Tools & Scripts, Video
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...]
Filed Under: Cloud, Cool Technologies, Databases, NoSQL, SQL Server, SQLServerPedia Syndication, TCD blog post, Tips & Tricks, Tool Time Tagged With: cloud computing, DBA, Monitoring, Quest Software, Toad, Tools, Tools & Scripts
Video: SQL Server Disk Optimization
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 … [Read more...]
Filed Under: Administration, Challenges, Hardware, IO, Opinion, Performance, Presentations, SQL Server, SQLServerPedia Syndication, Tool Time, Video Tagged With: Best Practices, DBA, Developer, DMV, Internals, Monitoring, Performance, SQL Server 2005, Tools & Scripts, Video
Free Poster – SQL Server Dynamic Management Views
I enjoy working at Quest Software partly because we do a lot to give back to the community. Here's one example, a free poster describing all of the SQL Server 2005 and 2008 dynamic management views. Get it here. It's the perfect compliment to the free system map poster available from Microsoft here. … [Read more...]
Filed Under: Administration, On-Line Resources, SQL Server, Transact-SQL Programming Tagged With: Monitoring, Performance, SQL Server 2005, SQL Server 2008 R2, SQLMag, Transact-SQL Programming
New Interview and SQLMag ToolTime Blog Article on “SQLClue”
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. 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 … [Read more...]
Filed Under: Administration, On-Line Resources, Opinion, SQLServerPedia Syndication, Tool Time Tagged With: DBA, Monitoring, MVP, SQLMag, Tools & Scripts
SQL Server 5-Minute Health Check
Quest Software Pain of the Week Webcast: The 5-Minute SQL Server Healthcheck Join me and Christian Bolton, UK SQL Server MVP and blogger,as we discuss how to quickly evaluate the basic health of your SQL Server environment. You’ll learn about several quick checks you can perform in minutes to determine if critical thresholds are being met—and where you need to resolve issues. Date: Thursday, November 12, 2009 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 Presenters: Christian Bolton, SQL Server … [Read more...]
Filed Under: Presentations, SQLServerPedia Syndication Tagged With: DBA, Monitoring, MVP, Performance
New Post on my SQLMag Blog – Free DMV Monitoring Tools
I've posted a new entry on my SQL Server Magazine blog about two free DMV monitoring tools available on CodePlex. Read the article here: http://www.sqlmag.com/Articles/ArticleID/102837/102837.html?Ad=1 Take a look at the two tools and let me know which you like better and why. Inquiring minds want to know! Cheers, -Kev … [Read more...]
Filed Under: SQLServerPedia Syndication, Tool Time Tagged With: CodePlex, DBA, DMV, Monitoring, Performance, SQLCAT, SQLMag
