Viewing 15 posts - 1 through 15 (of 191 total)
Based on your conclusions about unit testing I'll ask if you've worked with tSQLt as a formal test framework? Without getting into the details of your UDF or stored procedure...
November 1, 2019 at 11:15 am
Granted, restoring a backup to a live database after a deploy with issues is risky at best and virtually impossible in most cases. Typically we just move forward...
October 30, 2019 at 3:18 pm
Same here. Our developers have a template script to use as a starting point so some of the details are provided for them. We also have a scratch database on...
October 30, 2019 at 2:21 pm
The ability for developers to delete data simply is a feature is mismanaged security. It has nothing to do with Dev-Ops.
To @jeff Moden's point, there are absolutely times...
October 30, 2019 at 11:56 am
I guess I've yet to encounter a tuning problem that required NOLOCK to handle.
October 28, 2019 at 6:20 pm
Agreed. That is also why having some demonstration of the potential consequences is so valuable. For some applications it is less risky.
The biggest problem is having it peppered throughout a...
October 28, 2019 at 4:08 pm
I've worked with SQL Server since v4.2.1. I have never put any code containing NOLOCK in production. At my present employer we actively remove WITH (NOLOCK) from code as it...
October 28, 2019 at 3:49 pm
I am always surprised that the default isolation level for SSIS package objects is Serializable. Granted, it could be useful or even necessary in some cases. Isolation Level settings other...
October 28, 2019 at 11:45 am
Whether you intended to or not you again illustrated the fallacy in "...and the execution plan showed all index seeks and no scans...". Seek good/scan bad is not a valid...
October 10, 2019 at 12:37 pm
Thanks for the straight-forward example, Steve. Things like this show that tSQLt testing isn't difficult and helps you avoid deploying bugs in the first place.
We adopted tSQLt for database unit...
September 24, 2019 at 12:02 pm
Where I work the dashboards and performance metrics for production applications and infrastructure is available to all in all environments. Being told something is one thing. Being shown is...
June 19, 2019 at 11:02 am
In a previous life we were developing a software layer to report across all of our hardware implementations. Each division ran on a different platform and reporting on a customer's...
June 18, 2019 at 1:46 pm
Perhaps for the same reason jackrabbits run in front of cars?
June 17, 2019 at 12:16 pm
Source control projects, such as SSDT, help you find and correct these issues before deploy.
June 17, 2019 at 11:50 am
Sorry, you can't have any of our Scrum Masters or POs. We have spent too much to properly train them. 😉
Speaking of which, do your SMs and POs have formal...
June 12, 2019 at 12:53 pm