Dec 24 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… [...]
Jun 18 2010
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 [...]
Jun 1 2010
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 [...]
Apr 23 2010
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 [...]
Dec 15 2009
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 [...]
Sep 8 2009
How do you steer those unfamiliar with SQL Server Reporting Services away from Microsoft Access before they hurt themselves or do harm to others?
