Fortunately for the DBA, because SQL is a high level declarative language, releasing modifications to a stored procedure (so long as it  also doesn't involve changes to shared objects like...

It would be nice to have the humble PRINT statement support %s and %i arguments similar to RAISERROR and also support the NOWAIT and LOG options.

Also, it would be nice...

If I'm on an airplane or Zenning out in the middle of nature without internet connectivity, then it's either a weekend or I'm on PTO, in which case I'm not...

If you're asking me, it's just Visio.

Keeping corporate data on your laptop or phone is an accident waiting to happen. Aside from the creeps who lurk around food courts waiting for you to refill your drink,...

Here is my first draft.

I call it the UEvent (Universal Event) data model, because it is abstract enough to accommodate anything from IT conferences,  university classes, webinars, book club meetups...

Redgate SQL Prompt has several features that are useful for code reviews, automated static code analysis, and refactoring.

First, there is the 'Code Analysis' feature.

https://documentation.red-gate.com/codeanalysis/code-analysis-for-sql-server

Then there is the feature to...

For those Azure customers with zone-redundancy enabled, it would be interesting to know how much loss of availability they experienced. Theoretically, it should be been a couple minutes at most...

You know, there are a lot of conversations about how AI will replace jobs. Particular industries like manufactoring, marketing, customer service, and IT be disrupted more than others. But I...

I've always thought that Microsoft's investment in Linux had more to do with the technicals of making SQL Server run more efficiently on Docker containers and expanding it's footprint into...

Maybe the most efficient way to mockup 100 million rows of randomized test data would be to leverage PowerShell or Python to create text files and then BCP them into...

First, I'll turn on the radio to NPR news (I hate political\entertainment talk radio and morning rock DJs shows). If there isn't a good feature on, then I'll...

In addition to having a "bug-out bag" ready to go in case of an emergency, it's also important to plan an intended destination given various scenarios. Simply tossing supplies into...

6 Jobs AI will never do

1. CEO
2. CFO
3. CTO
4. CIO
5. Senator
6. Public Representative

Those who make decisions about the implementation of AI don't have to worry about losing their jobs...

Similar to the history of how organizations have leveraged offshore IT talent, I'm sure that the pendulum will swing back and forth over time when it comes to leveraging AI...