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
Help Me Update the History of SQL Server
Find out the early history and evolution of Microsoft SQL Server in this engaging article from database expert Kevin Kline.
Filed Under: Cool Technologies, Databases, Opinion, SQL Server, SQLMag, SQLServerPedia Syndication, Transact-SQL Programming Tagged With: Career, DBA, Developer
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
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
DBTA: The Future of Coding for SQL Server
I’m going to address an important issue for the SQL Server community: the future direction of coding for SQL Server
Filed Under: DBTA, Opinion, SQLServerPedia Syndication, TCD blog post, Transact-SQL Programming, Trends Tagged With: DBTA, Developer, FutureWatch, SQL Server 2008 R2
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
