SQLAgentman
Technically Speaking with Tim Ford
RSS
  • Home
  • About
  • SQL
    • Best Practices
    • Dynamic Management Objects
      • DMV Research Papers
    • 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
    • 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
  • Copyright

Best Practices

On the Eleventh Day of Christmas…2011

Dec 24 2011

On the Eleventh Day of Christmas…2011

On the Eleventh day of Christmas I Give Some Tips to Thee…11 SQL Never Not Dos! Ten Quick Hit Thumbscripts A Nine Hour Work Day I FORGOT WHAT EIGHT WAS FOR… Seven Reports to Start My Day Six Gb of RAM Five Volumes Minimum… Four Words to Live By… Three Training Events… Two Twitter Handles… [...]

By Tim Ford • 12 Days of Christmas 2011, Best Practices, Syndicated • 1 • Tags: #12DaysofSQLChristmas, #BestPractices, SQL

Jun 18 2010

Making Sausage

Last week while I at TechEd I had a conversation with one of my Application Analysts back in the shop about a problem database from an ISV that we have been dealing with for over a month.  A patch had been put in place and I was reviewing the results of some queries against the sys.dm_os_wait_stats [...]

By sqlagentman • Best Practices, Syndicated • • Tags: SQL Server

Jun 1 2010

Top 13 SQL Server Mistakes and Missteps – #10 Default Database Autogrowth Settings

By default, new databases are created with the following basic file settings: Data File: 2 MB 1 MB unrestricted growth Log File 1Mb 10% unrestricted growth Just exactly why is this bad?  It will assuredly increase the frequency at which files will grow automatically…    A transaction log file, if configured for autogrowth, will expand when it [...]

By sqlagentman • Best Practices, SQL, Syndicated • • Tags: SQL, SQL N00B Crew, Top 13 Mistakes

Apr 23 2010

Bad Decisions: Not Just For The Young Hollywood Elite

I give you exhibit A: The Last Straw:                        Yes, Third Party Software vendors out there are still trying to ruffie our SQL Servers.  I encountered these instructions yesterday when reviewing a pending installation process.  What you don’t see here though are items 1-11 in their instructions (one being a requirement for [...]

By sqlagentman • Best Practices, Fun Time, Rants, Syndicated • • Tags: Best Practices, SA, SQL N00B Crew, SQL Server

Dec 15 2009

This Should Be Fun

Imagine an environment where you have a production SQL 2005 cluster (2 nodes, 2 instances) and what you think is an identical test/dev 2005 cluster (2 nodes, also 2 instances).  Now imagine you come to a conclusion 3 years after you’ve installed, configured, and utilized the four instances that one of the test/dev nodes is [...]

By sqlagentman • Best Practices, SQL, Syndicated •

Sep 8 2009

Functionality, Ramen Noodles, and MS Access

How do you steer those unfamiliar with SQL Server Reporting Services away from Microsoft Access before they hurt themselves or do harm to others?

By Timothy • Best Practices, Reporting Services, Syndicated • • Tags: MS Access, SQL Server Reporting Services

  Professional Association for SQL Server Summit     
 
  Professional Association for SQL Server Summit

Like My Stuff? Subscribe:

Subscribe by Email

Subscribe via RSS

SQLAgentMan Twitter Feed

  • @tjaybelt @way0utwest but not as silly running as Pierce Brosnan Silly Running.
  • @YanniRobel thanks! You like tho?
  • @YanniRobel Hey Yanni! How is the foot?
  • Full blog overhaul complete for http://t.co/60yM8xUh. Time for some celebratory ice cream! #heyIrodethebiketoday #bike1hr
  • @way0utwest We all went to see it yesterday. I was surprised at how great it was. You'll not be disappointed.
  • @SQLNewbie Hopefully the Emerald Aisle at National will have an AWD for me then just in case.
  • @buckwoody that is correct Sir! #SQLCruise
  • @buckwoody rule of 3s?
  • Challenging DML and DDL only game of WWF with @AaronBertrand. Much swapping involved. Whomever gets the Z is in trouble!
  • @buckwoody buck, I am free all day. DM me a time and I'll give you a call.
Follow me

Tags

#12DaysofSQLChristmas #sqltrevor 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 DMF DMV DMV Book DMVs Dynamic Management Objects Free Training Fun Time Inactive August Indexing MS Access MSSQLTips PASS Photography Presentations Professional Association for SQL Server Rants 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 Tips and Tricks Top 13 Mistakes Vendors What Gets Measured
© SQLAgentman 2012
Powered by WordPress • Themify WordPress Themes