SQLAgentman
Technically Speaking with Tim Ford
RSS
  • Home
  • About
  • SQL
    • #SQLHacker
    • Dynamic Management Objects
      • Periodic Table of Dynamic Management Objects
      • DMV Research Papers
    • Best Practices
    • Reporting Services
    • Templates
    • Tips and Tricks
    • Friends of SQLAgentman
      • Red Gate
        • Friends of Red Gate
      • Quest Software
  • SQL Cruise
    • What Gets Measured Gets Done
  • Interests
    • Cooking
    • Exercise
    • Family and Friends
    • Literature
    • Media and Culture
    • Music
    • Photography
    • Reviews
    • Tech
    • Travel
      • Seattle
  • Publications
    • MSSQLTips.com Articles
    • Red Gate Simple-Talk Articles
    • SQL Server Central Articles
    • SQLServerPedia
  • Series
    • 12 Days of Christmas 2011
    • 13 Mistakes and Missteps
    • Fun Time
      • Fun Fridays
      • Bacon Bits and Bytes
    • Meme Monday
    • SQL N00B Crew
    • T-SQL Tuesday
    • Top 10 Things Learned
    • What Gets Measured Gets Done
  • Training
    • SQL Cruise
    • PASS
      • PASS Summit
    • SQL Saturday
    • PresentationFiles
  • SHAREables
    • Weekly SHAREable Posts
  • Copyright

DMVs

Jun 20 2011

SELECT Sessions FROM PASS_Summit_2011

For the first time in the 10 years I’ve been associated with The Professional Association for SQL Server (PASS) I’ll be presenting a regular session at the annual Summit.  Sure, in the past I’ve presented on a panel discussion for Quest Software and make a fool out of myself for the sake of fun and games [...]

By Tim Ford • PASS Summit • 1 • Tags: DMVs, SQL PASS

Jan 11 2011

One Of These Things Is Not Like The Others

While examining things you can do with the sys.dm_os_info Dynamic Management View I ran across an interesting outcome concerning SQL Server start time. Theorhetically, you can determine the last start time for your SQL Server services via any of the three methods: Create Date of tempdb (because tempdb is recreated each time the SQL services [...]

By Tim Ford • Dynamic Management Objects, Syndicated • 2 • Tags: DMVs, sevice start time, SQL Server

Dec 21 2010

Collect and Store Historical Performance Counter Data Using DMVs

In my preparations for all my presentations for 2011 regarding Dynamic Management Views and Functions as well as my consolidation efforts of instances at work, I found myself mulling over the easiest way to capture some of the metrics I would be using for determining current load on my SQL Server instances and capacity planning [...]

By Tim • Dynamic Management Objects, MSSQLTips, Syndicated • 2 • Tags: DMVs, sys.dm_os_performance_counters

Apr 26 2009

My Top 5 SQL Server Indexing Best Practices

What are the top 5 indexing best practices? That’s pretty subjective, but here you go. I’m sure the list would be different tomorrow or even five minutes from now.

By Timothy • Dynamic Management Objects, Rants, Syndicated, Tech • 6 • Tags: Book, DMVs, Indexes, Most Experts Suck, Non-Clustered Afterbirth

Learn. Network. Relax. Grow.   Just add water.
 
 
Click logo to learn more about SQL Cruise  

Want the Latest News? Subscribe:

Subscribe by Email

Subscribe via RSS

   
 

 
 

Tags

#12DaysofSQLChristmas #sqlhacker #sqltrevor #telecommuting 24 Hours of SQL Server Bacon Best Practices Boring things that won't get you dates but may gain you geek cred. Buck Woody Challenge Contests DMV DMV Book DMVs Dynamic Management Objects Fun Friday Inactive August MSSQLTips PASS Photography Presentations Professional Association for SQL Server Professional Development Red Gate Security SQL sqlagentman SQL Cruise SQLCruise SQL Cruise Alaska 2011 SQL N00B Crew SQLPASS SQL Saturday SQL Server Summit 2009 Syndicated Tech TechEd2010 Things Learned Tim Ford Tips and Tricks Top 13 Mistakes Twitter Vendors What Gets Measured

Tim’s Tweets

Twitter Logo
Refresh
Follow Tim »
© SQLAgentman 2013
Powered by WordPress • Themify WordPress Themes