Were I not a DBA, I'd be hustling to become a DBA.

I'm not understanding the use of views for this. There is also no need to add logins for each individual user account, just add login and user access for the AD...

Or simply create a linked server.

It's a common misconception that usage of linked servers create performance issues. Actually, no. A linked server is nothing more than a...

Think about it for a moment. From what I've seen, the root of most massive high profile data breaches are not the result of result of cracked or weak passwords,...

The Data Modeling Scorecard website looks interesting. I don't know how I missed hearing about this guy Steve Hoberman.

I think there is room for at least a couple of AI or ML literate people in any large IT organization, but let's not get carried away with the idea....

To make this more transparent, I encrypt using session level symmetric keys and wrap a view around each table to provide the decrypted computed columns.

We use a product called SecretServer to manage our service account passwords, certificates, etc. across the enterprise. It also has a web service based API for integration with PowerShell scripts...

Yes, altering column definition from INT to BIGINT is a change of size operation, meaning that every page in the table and every page in every index (clustered and non-clustered)...

Just wait until government regulators start issuing automobile recalls based on IoT equipment failure or security issues. Some may see it as an unprofitable risk. Shareholders and the corporate board...

I totally get the potential value of IoT enabled assembly plants, commercial transport vehicles, or shipping containers. But when it comes to embedding IoT in consumer facing products (like automobiles...

Tell us when the "slowness" occurs and what is it relative to. For example, have you recently migrated this instance to Hyper-V and then the problem occurred, or has it...