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
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
The Zombie PerfMon Counter That Never Dies! Quick Tip
Learn the Performance Monitor counters to avoid and those to exploit for the latest versions of Microsoft SQL Server from database expert Kevin E. Kline.
Filed Under: Challenges, Databases, IO, Performance, SQL Server, SQLMag, SQLServerPedia Syndication, Tips & Tricks Tagged With: Best Practices, DBA, Developer, DMV, Monitoring, Troubleshooting
Two New Slide Decks. Plus, the Week in Colorado.
Kevin provides two new session slide decks and tells about his week presenting sessions in Colorado from August 14-17, 2012.
Filed Under: Administration, Challenges, Cool Technologies, Databases, IO, On-Line Resources, PASS, Presentations, Professional Development, SQL Server, SQLMag, SQLServerPedia Syndication, Tips & Tricks, Video Tagged With: Best Practices, CodePlex, DBA, Developer, Leadership, Performance, SQL Server 2012, SQLSaturday, Tools & Scripts, Troubleshooting, Video
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
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
New on SQLMag Tool Time Blog – Update to FineBuild
Read about the latest update to FineBuild for SQL Server, a tool with speeds installation and configuration of SQL Server and associated utilities and programs.
Filed Under: Administration, SQL Server, SQLMag, SQLServerPedia Syndication, Tips & Tricks, Tool Time Tagged With: CodePlex, DBA, SQLMag, Tools, Tools & Scripts
Must-Have Resources – SQL Server Backup & Recovery
The industry’s best resources for maximizing Microsoft SQL Server backup and recovery. Don’t get burned!
Filed Under: Administration, Challenges, Databases, On-Line Resources, Presentations, SQL Server, SQLMag, SQLServerPedia Syndication, Tips & Tricks, Video Tagged With: Backup & Recovery, DBA, Quest Software, SQL Server 2008 R2, Video
Information Hoarder No More!
Kevin tells you how he is now keeping up with the thousands of blog posts, newsreader feeds, e-newsletters, and social media entries in his information hoard.
Filed Under: Challenges, Opinion, Professional Development, SQLMag, SQLServerPedia Syndication, Tips & Tricks Tagged With: Career, Plays Well With Others, Productivity
