Join database expert Kevin Kline in two new webcasts for SQL Server users: Storage IO Best Practices and Query Tuning Best Practices.
Learn More About SQL Server IO and Query Tuning in These Webcasts
Filed Under: Administration, Databases, IO, Performance, Presentations, SQL Server, SQLMag, SQLServerPedia Syndication, Transact-SQL Programming, Video Tagged With: Best Practices, DBA, Developer, Internals, IO, SAN, SQL Server 2012, SSD, Storage, Training, Transact-SQL Programming, Video
Flexibility When Waiting on Locks
An attendee at a recent performance tuning session wanted ideas to more flexibly react to locks on blocks than using the WITH (NOLOCK) hint.
Filed Under: Coding, Databases, Performance, SQL Server, SQLMag, SQLServerPedia Syndication, Transact-SQL Programming Tagged With: Developer, SQL Server 2012, Transact-SQL Programming
Dev Advice: Make a Tiny Dev Database Act Like a HUGE Prod Database
If you’re struggling with doing development on a big SQL Server database, learn the ropes on cloned databases asap!
Filed Under: Challenges, Cool Technologies, Databases, On-Line Resources, Performance, SQL Server, SQLMag, SQLServerPedia Syndication, Tips & Tricks, Tool Time, Transact-SQL Programming Tagged With: Best Practices, DBA, Developer, Performance, Transact-SQL Programming
SQL Server Migration Roll-Up
Here are a hand full of cool database migration tools and white papers worth mentioning for SQL Server, Oracle, MySQL, and Sybase.
Filed Under: Administration, Challenges, Databases, On-Line Resources, Performance, SQL Server, SQLMag, SQLServerPedia Syndication, Tips & Tricks, Tool Time, Transact-SQL Programming, Virtualization Tagged With: cloud computing, DBA, Developer, MS-Access, MySQL, Oracle, PHP, SQL Azure, SQL Server 2008 R2, Sybase, Tools, Tools & Scripts, Transact-SQL Programming
Wednesday Quest: Exciting New Community for Users of Toad for SQL Server
Filed Under: Cool Technologies, Databases, On-Line Resources, SQL Server, Tool Time Tagged With: DBA, Developer, Quest Software, Toad, Training, Transact-SQL Programming
Back in Atlanta! Wed, Feb 9 2011
Filed Under: PASS, Presentations, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: DBA, Developer, Internals, Performance, Query Tuning, Transact-SQL Programming
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.
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: The Future of Coding for SQL Server, Part 2
In my last column (published in the February e-edition and the March print edition of DBTA), I reviewed the overall coding landscape for SQL Server with special focus on LINQ to SQL, a new technology introduced by Microsoft in late 2008. LINQ to SQL promised to make developers’ lives much easier by allowing them to focus [...]
Filed Under: DBTA, Opinion, SQL Server, SQLServerPedia Syndication, Transact-SQL Programming, Trends Tagged With: DBTA, Developer, Transact-SQL Programming
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.
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
