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
DBTA: Getting Up to Speed on the SQL Server Social Media Scene
If you haven't paid attention to the new social media, you're doing yourself a disservice. Just as email was a game-changer in the 1980s and the internet revolutionized society in the 1990s, social media is making a huge impact on the way people work and interact today. Personally, I was skeptical about social networking until some good friends persuaded me to give it a trial run. It seemed like a great way to dither away some valuable time, but I didn't see the business value in the whole proposition until I tried it. [READ MORE] … [Read more...]
Filed Under: Cloud, DBTA, On-Line Resources, Opinion, PASS, Professional Development, SQL Server, SQLServerPedia Syndication, Tips & Tricks, Trends Tagged With: Career, DBA, Professional Development, SQLPASS, SQLSaturday, Tools, Writing
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
DBTA: The Ebb and Flow of SQL Server Instrumentation
Microsoft SQL Server's relational engine has offered new instrumentation that improves by light years with each new release. The introduction of Dynamic Management Views (DMVs) in SQL Server 2005 provided a much-needed equivalent to Oracle's long-standing and capable V$ and X$ system views. SQL Server 2008 has provided another dramatic improvement to its instrumentation with Extended Events (also known as XEvents) that promises to offer even greater opportunities to tune, trace and troubleshoot the inner workings of a SQL Server application. All of this stands in stark contrast with the … [Read more...]
Filed Under: Administration, DBTA, Opinion, SQL Server, SQLServerPedia Syndication, Trends Tagged With: DBA, DBTA, Developer, DMV, SQL Server 2008 R2
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
DBTA:A Look at Upcoming Enhancements in SQL Server 2008 R2
At a rather muted Microsoft TechEd in Los Angeles in May, the crowds were diminished and the educational content was slimmed down. In the past, SQL Server sessions were so abundant that you'd have trouble choosing which of several you might want to attend. This year, the state of the economy was reflected in many ways, including the one, or, in just a few cases, two sessions per time slot allotted SQL Server professionals. Despite the low ebb, the Microsoft SQL Server team made an exciting announcement about the upcoming availability of the SQL Server 2008 R2 CTP (Community Technology … [Read more...]
Filed Under: Administration, Databases, DBTA, Opinion, SQL Server, SQLServerPedia Syndication Tagged With: DBA, DBTA, Developer, news analysis, SQL Server 2008 R2
Video: The Growing SQL Server World- Surviving the Data Avalanche
An expert roundtable discussion hosted by SQL Server Expert Kevin Kline and featuring speakers from Microsoft, EMC, Avanade, HP and Quest Software. With the release of SQL Server 2005 and its focus on Business Intelligence, SQL Server professionals are faced with unprecedented amounts of data to manage. How are you dealing with the flood of data? At the PASS Community Summit 2006, experts from Quest Software joined forces with a variety of other SQL Server industry experts for a panel discussion around the implications of managing large volumes of business critical data on SQL Server and … [Read more...]
Filed Under: Administration, BigData, Challenges, Conferences, Databases, Performance, Professional Development, SQLServerPedia Syndication, Strategies, Video Tagged With: DBA, SQL Server 2005, SQLPASS
DBTA: The Trouble with Third-Party Applications
Third-party applications are a very important part of the IT landscape. Many of us have faced the common dilemma of trying to decide whether to build or buy that next important application our organizations need. (By the way, I'm talking about smaller, specialized applications like an inventory management system for the company warehouse, or a practice management system for a doctor's office. I'm not talking about the huge and incredibly sophisticated ERP systems like SAP and Oracle Financials.) [READ MORE] … [Read more...]
Filed Under: Administration, Challenges, DBTA, Opinion, Trends Tagged With: DBA, DBTA
Video: MVPs talk about SQL Server 2008
Video chat with Brent Ozar and SQL Server MVPs Kevin Kline, Hilary Cotter and Geoff Hiten to talk about how SQL Server 2008 addresses DBA challenges and pain points. In this webcast, we cover features like Transparent Data Encryption, spatial data, and other new things that really differentiate SQL Server 2008 from 2005. Posted December 24, 2008. … [Read more...]
Filed Under: Challenges, Conferences, Cool Technologies, Opinion, SQLServerPedia Syndication, Tips & Tricks, Video Tagged With: DBA, Developer, MVP, SQL Server 2005, SQL Server 2008 R2, Video
