".. There are pros and cons for all of them, but to me, the Google option is interesting. It gives you an instance (with SSIS/SSRS) and a proxy, but it...

Glue work makes you more visible to people outside your team, it also makes you more of a lynchpin (useful when an organization starts downsizing), and makes your resume look...

Maybe employers should require IT hires and executives to sign NDAs specific to protected data. There may be other remedies already in place, but a NDA would help establish boundaries...

For data intensive applications, simply moving the database or file storage to the cloud while keeping your applications running on-prem will probably not save you any money. In addition to...

So on a whim (because health insurance is going to make me take a paycut next year even if I get a raise), I started checking out salary info...

Thanks to DevOps tools like DbUp and Octopus, less of my day is spent running "DBA, can you please deploy ..." type scripts.

Also, scripts for doing things like checking disk...

When I think of a data-warehouse, I'm thinking OLAP, meaning data is updated on a schedule, contains versioned history of changes, and probably summarized as well for fast reporting and...

".. For very large deletions, consider disabling indexes and constraints before deleting, then rebuilding them after: .."

Dropping non-clustered indexes and constraints can improve performance of bulk deletes - but you...

For years, I've been getting that same error every time I submit, but it still creates the post.

Because it wasn't being...

...

The last one is VB6. Microsoft came up with Visual Basic to help those developers who had a hard time grokking C++ for Windows development. I don't know what...

If you are designing a new object with DML triggers, especially nested or recursive enabled triggers, then you should take a step back and consider if there is a better...

Yeah, automatic touchless transactions can make your life easy - until you have to deal with fraud. It could spoil someone's vacation or holiday.

Perhaps we could design tap cards in...

Historians in the future, who look at archival copies of today's "news" websites, will laugh at all the stupid memes and click bait ads appearing in the margins. Also, what's...

The fact that most input parameters are defined as NVARCHAR (4000) is evidence that the original code was generated by an ORM.

My guess is that the developers were instructed to...

We have about 900 Point Of Sale locations across the US running SQL Server Express on workstations and SSD drives. So, the disks are not invisible. If the event of...