MSSQL Tips Newsletter headline "Properly Secure SQL Server."

Well, duh. You don't need an article for that. Just revoke all access.

ALL access.

Problem solved. Server secure....

So under the context of my current project, my boss asked me to put in some technical debt. Basic code clean up and performance enhancement of code I wrote back...

<Headdesk>

You know that moment when, after 5-6 hours of unit testing (sometimes the entire previous day) and trying to find out why all your records disappeared, you realize that the...

My suggestion is to force the NULLs. And since you're accepting parameters, might I also suggest adding a bit of code to help you get around SQL Injection issues? You'll...

I'm beginning to think he's got the edition information mixed up with a corporate policy. IE, "you aren't allowed to install this on a server" vs "this isn't the version...

It is possible that the client machine is being updated. Our workplace does that. In fact, corporate IT forcibly reboots EVERYONE's PCs on a nightly basis (or they did for...