Aug 17 2010
Today marks the start of my second week on the job with a new company in almost 11 years. I severely underestimated what that means: new connection methods, new software, new communication tools, new naming conventions, processes, and workplace methodologies. Heck, I have yet to even get exposed to new personnel/HR policies – I was [...]
Jul 12 2010
The service accounts for SQL Server have undergone expansion in the past few releases of Microsoft SQL Server. Back in the days of SQL Server 2000 and earlier you only had to deal with configuring a service account for the SQL and the SQL Agent services. Now you have to contend with those in addition [...]
Jun 20 2010
OK, Hive Mind I have an assignment for you. As I plod through the edit phase of my Performance Tuning with SQL Server DMVs book I’ve been asked by my Overlord PITA Task Master Editor to explain what I mean by Transaction when used in discussing the sys.dm_tran_ … Dynamic Management Objects. Of course we’ve [...]
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 [...]
May 25 2010
Thank you Portland, Oregon and all those associated with puting together and participating in SQL Saturday #27 on 5/22/2010. I would personally like to thank the anonymous, but freakishly tall gentleman who attended my last session of the day and was somehow able to reach the projector on the ceiling in order to restart it after [...]
May 20 2010
I will be presenting on two topics at SQL Saturday #27 in Portland, OR this weekend: Backup and Disaster Recovery for N00Bs and Indexing Dynamic Management Views. It’s going to be exhausting, but fun: out of Detroit at 8pm EDT – Into Portland around 11pm PDT (that’s 2 AM “real” time folks if you don’t [...]
May 14 2010
Paul Randal recently streaked through the the family picnic and tossed-down a hornet’s nest on the dessert table by starting a meme on which five things Microsoft should drop from their SQL Server product. I came to this party late – and uninvited – but I’m going to go ahead and drop my junk in [...]
May 10 2010
#11 – Memory Settings Unless you have been working with SQL Server for a while, you may not go into the Server Properties or Facets and tweak much of anything after a successfull install. After all, there are a great deal of things out there and it can be really confusing. Let’s keep it really [...]
