SSIS packages are contained in .dtsx files and the underlying data format is XML. You should see things like referenced database objects and T-SQL commands in clear text. Other protected...

This script you've posted is missing a description and comments, but what it appears to be doing is a SELECT COUNT(*) across *every* table and column in the database, even...

Good point. If we use different passwords for each...

Bunting and stealing are highly effective, if the individual player is a string runner.. and especially if the other team doesn't see it coming (ie: they read the memo that...

ICANN can defend itself by explaining the contact information is essential to it's core business operations. In the age of GDPR, organizations will need to be more transparent about their...

Used plastic bottles are valuable to a recycling company, while for most people (and companies) it's just a byproduct of our daily lives. To have a dollar value there must...

OK, so recovering from a disaster is a good adrenaline rush (so long as it doesn't turn into a full blown crisis), and getting praise for a job well done...

Platforms like Azure have removed the barrier of entry for companies that want to perform analytics, but we still need to consider whether it makes sense for most organizations to...

The sysadmin charged with guarding the gate doesn't necessarily need the key to every door inside the castle. For databases containing sensitive data, there should be something like column level...

RDMS are typically SQL based, but a RDMS can also use some other query language besides SQL, and a non-RDMS (or NoSQL) database can also use SQL. It seems to...