Do you use Express Edition? Then you might not know that the published memory limits are not set in stone.
Squishy Limits in SQL Server Express Edition
Filed Under: Administration, Databases, Performance, SQL Server, SQLMag, SQLServerPedia Syndication, Tips & Tricks Tagged With: DBA, Developer, Express Edition, Internals, Memory, SQL Server 2012
Learn More About SQL Server IO and Query Tuning in These Webcasts
Join database expert Kevin Kline in two new webcasts for SQL Server users: Storage IO Best Practices and Query Tuning Best Practices.
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
Let’s Talk Licensing and Virtualization for SQL Server
Filed Under: Administration, Architecture, Cool Technologies, Databases, DBTA, On-Line Resources, Performance, SQL Server, SQLMag, SQLServerPedia Syndication, Trends, Virtualization Tagged With: Best Practices, DBA, DBTA, Developer, Internals, Licensing, Monitoring, SQL Server 2012, SQLMag, SQLPASS, Virtualization, VMware
Quick Tip – Speed a Slow Restore from the Transaction Log
Filed Under: Databases, IO, Performance, SQLMag, SQLServerPedia Syndication, Tips & Tricks Tagged With: Backup & Recovery, DBA, Internals, SQL Server 2012
New White Paper: SQL Server Extended Events and Notifications
Download the new, free white paper from Microsoft MVP Jason Strate detailing SQL Server Extended Events and Event Notifications (registration required).
Filed Under: Administration, Challenges, Cool Technologies, Databases, On-Line Resources, Performance, SQL Server, SQLMag, Tips & Tricks Tagged With: Best Practices, DBA, Internals, Monitoring, SQL Server 2008 R2
SQL Server Performance Tuning and Optimization in Jacksonville, FL on April 27th
Learn more about troubleshooting and optimizing SQL Server performance in this full-day seminar on Friday,, April 27 2012.
Filed Under: Databases, Performance, Presentations, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: Career, Internals, SQLPASS, SQLSaturday, Training
Microsoft SQL Server Internals & Architecture Matter!
It’s not everyday that a dry topic like the internals and architecture of Microsoft SQL Server is presented in a fun and easy to understand format, so get in while the gettin’ is good.
Filed Under: Administration, Databases, Presentations, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: Best Practices, DBA, Developer, Internals, Monitoring, Performance, SQL Server 2008 R2
Available Online – SQL Server Training Videos
Interested in my various performance tuning and troubleshooting videos about SQL Server? These videos feature my good buddies (and uber-SQL Server experts) Brent Ozar (blog | twitter) and Buck Woody (blog | twitter). View these insight-packed training videos from our SQL Server training events originally presented on March 3 and July 21 of 2010:HERE. You can watch [...]
Filed Under: Administration, Challenges, Databases, IO, On-Line Resources, Performance, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: Best Practices, DBA, DMV, Internals, Monitoring, Performance, Quest Software, SQL Server 2008 R2, Video
New on SQLMag.Com: Update to SP_WHOISACTIVE
I profiled Adam Machanic’s excellent stored procedure, SP_WHOISACTIVE, back in August of 2010
Filed Under: SQL Server, SQLServerPedia Syndication, Tool Time Tagged With: DBA, Internals, Monitoring, SQL Server 2008 R2, SQLMag, Tools, Tools & Scripts
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
