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...]
Video: Ensure Optimal Performance When Deploying SQL Server 2005
Filed Under: Databases, IO, On-Line Resources, Performance, Presentations, SQL Server, SQLServerPedia Syndication, Video Tagged With: Best Practices, DBA, Developer, DMV, Internals, Monitoring, Performance, SQL Server 2005, Tools & Scripts
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...]
Filed Under: Challenges, Databases, On-Line Resources, Performance, SQL Server, SQLServerPedia Syndication, Tips & Tricks, Video Tagged With: Best Practices, Database Mirroring, DBA, High Availability, SQL Server 2008 R2, Tools & Scripts, Video, Windows Clustering
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...]
Filed Under: On-Line Resources, Professional Development, SQL Server, SQLServerPedia Syndication, Tips & Tricks Tagged With: DBA, Developer, DMV, Internals, Professional Development, Quest Software, Tools & Scripts
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...]
Filed Under: Challenges, Databases, Performance, Presentations, SQL Server, SQLServerPedia Syndication, Tips & Tricks, Video Tagged With: Best Practices, DBA, Developer, DMV, Internals, Monitoring, Quest Software, Tools & Scripts, Video
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...]
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
Video: Maximize SQL Server Performance with SQL Tuning
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. Posted March 27, 2007. … [Read more...]
Filed Under: Challenges, Presentations, SQL Server, SQLServerPedia Syndication, Tips & Tricks, Tool Time, Transact-SQL Programming, Video Tagged With: Best Practices, DBA, Developer, SQL Server 2005, Tools & Scripts, Transact-SQL Programming, Video
Two Free Training Webcasts Open for Registration
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! Pain of the Week: SQL Server for the Oracle DBA 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 … [Read more...]
Filed Under: On-Line Resources, Presentations, SQLServerPedia Syndication Tagged With: DBA, Developer, DMV, Internals, Oracle, Performance, Tools & Scripts, Training
New on SQLMag – Automating the Startup and Shutdown of Windows Services
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! Many thanks, -Kevin -Twitter @kekline … [Read more...]
Filed Under: Administration, SQLServerPedia Syndication, Tool Time Tagged With: DBA, SQLMag, Tools & Scripts
