Need to troubleshoot SQL Server 2005 memory settings? Not sure where to look to measure SQL 2000 memory pressure? Kevin lays out your options in today's podcast. You can view this video in higher quality or your favorite portable formats at: http://sqlserverpedia.com/blog/sql-se... Video published December 24, 2008. … [Read more...]
Video: SQL Server Memory Troubleshooting
Filed Under: Challenges, Opinion, Performance, Professional Development, SQLServerPedia Syndication, Strategies, Video Tagged With: DBA, DMV, Internals, Performance, SQL Server 2000, SQL Server 2005, Video
DBTA: What’s the Fuss about Data Deduplication?
Listen to a group of database professionals talk for awhile and someone will eventually bring up the topic of data deduplication. Data deduplication is a means to eliminate redundant data, either through hardware or software technologies. To illustrate, imagine you've drafted a new project plan and sent it to five teammates asking for input. That single file has now been reproduced, in identical bits and bytes, on a total of six computers. If everyone's email inbox is backed up every night, that's another six copies backed up on the email backup server. Through data deduplication … [Read more...]
Filed Under: Administration, BigData, Challenges, DBTA, Hardware, IO, Opinion, SQLServerPedia Syndication, Trends Tagged With: DBA, DBTA, High Availability, Internals, Performance, SQL Server 2008 R2
TN Summit 2010 – Surviving the Data Avalanche
Here's the link to my revamped presentation on Surviving the Data Avalanche The Abstract for this presentation is here. The slides for this presentation are here. … [Read more...]
Filed Under: BigData, Challenges, Databases, IO, Performance, Presentations, SQL Server, SQLServerPedia Syndication, Strategies, Trends, Video Tagged With: Best Practices, DBA, Internals, Performance, SQL Server 2008 R2, 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
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
In-Memory Databases (IMDBs)
Moore's Law tells us that CPU's get a LOT faster over time. Unfortunately for the database professional, all of the secondary elements of our databases DO NOT get a lot faster over time. Overall, the main methods of storing data since the 1960's, magnetic tape and hard disks, have improved only in the single percentiles year over year. Even those of us who were never good at math can tell that the CPU is outpacing the other system components. Two recent developments are helping to change that equation. First, solid state drives (SSDs) are having a dramatic impact many IT scenarios. … [Read more...]
Filed Under: Administration, Cool Technologies, SQLServerPedia Syndication, Trends Tagged With: DBA, FutureWatch, IMDB, Performance
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
Join Me May 19th for 24 Hours of PASS
Join Us for 24 Hours of SQL Server Training (with a special focus on SQL Server 2008 R2) Did I mention that your Cohorts in Crime (that be me and Brent Ozar) are presenting?!? The FREE 24 Hours of PASS event is bringing an exceptional lineup of SQL Server and BI experts to your computer starting at 12:00 GMT (UTC) on May 19. Get an in-depth look at the hottest SQL Server and BI topics, including (but not limited to!) - the new SQL Server 2008 R2, with its business intelligence and data management innovations, and much more. When does it start? 12:00 GMT … [Read more...]
April Omnibus
I freely admit it - I'm a sluggard. I should be blogging a couple times per week and tweeting in between. But, for some unknown reason, April has been a tough month to get this in gear. Hence, I'm putting out an omnibus post to cover all of the stuff I've been up to, instead of the one-off's I usually post when I've got something new to mention. Isn't it funny how life gets in the way of the stuff we want and intend to do? As they say - "The road to hell is paved with good intentions", or was that Detroit? But I digress. A New Translation! I don't like to toot my own horn. [sarcasm … [Read more...]
Filed Under: Conferences, PASS, Presentations, SQLServerPedia Syndication Tagged With: DBA, Performance, SQL Saturday, SQLPASS
