Forum Replies Created

Viewing 15 posts - 1 through 15 (of 43 total)

  • Reply To: Bad Managers

    I consider myself very fortunate as I can count the number of bad managers I’ve had in my long career on one finger. This isn’t to say my other managers...

  • Reply To: Growing and Changing

    We are in a profession, not a trade, so (re)learning is essential. Practices that may have been best at one time may no longer apply. This reminded me of my

  • Reply To: The 2019 Home Lab

    I've had a home lab for decades and have found it invaluable for keeping up with the technologies I use and want to explore. This was quite expensive back when...

  • Reply To: What Keeps You Employed?

    I was asked "want do you do for a living" a few years ago during jury selection. After seeing eyes gloss over when I responded with my "Database Solution Architect"...

  • Reply To: Getting Close

    My guess for the SQL Server 2019 release date is August 31, 2019.

  • RE: Will Terminators Be Required?

    Although not using semi-colon statement terminators has been deprecated for a decade, using statement terminators is still...

  • RE: They Call Me Andy Null

    A true story I mention when teaching about proper NULL handling is the guy who received thousands of parking tickets because his personalized tag was "NO PLATE". This...

  • RE: Conflict in Functional Teams

    Absence of conflict is one of the key indicators of dysfunctional team, according to The Five Dysfunctions of a Team (https://en.wikipedia.org/wiki/The_Five_Dysfunctions_of_a_Team). In short, conflict is healthy when...

  • RE: Adjusting Model

    I always change the model recovery model to SIMPLE for development and QA instances since the recovery plan is to restore from the latest FULL and DIFFERENTIAL backup.

  • RE: How many environments?

    Below are the environments we use for the last 2 GA releases plus the version under development of our software product. The Test, Performance, and QA environments for the...

  • RE: Not a cloud to be seen

    It's amazing what one can do with SQL Server on bare-metal commodity hardware with a well architected system and attention to detail. I've been a staunch advocate of the...

  • RE: The Rename Game

    Install or upgrade? I assume both. Is this happening often?

    The QA databases as well as databases used for automated unit and performance testing are upgraded nightly with the latest check-in...

  • RE: The Rename Game

    Yes, I sometimes rename objects and columns. Our development process is Agile with Continuous Integration. Database changes checked into source control are deployed to QA every night. ...

  • RE: The Express Choice

    IMHO, Express Edition is fine for a production environment as long as meets performance and availability SLAs. 4 cores is more than enough for many workloads. The 10GB...

  • RE: Stairway to Server-side Tracing - Step 8: How to Automate SQL Traces using the Data Collector

    For starters, check the execution log in the MDW database for the problem collection set to see if any issues are logged:

    SELECT *

    FROM syscollector_execution_log

    WHERE collection_set_id = <specify-collection_set_id-here>

    ORDER BY finish_time;

    You...

Viewing 15 posts - 1 through 15 (of 43 total)