In this second delve into data cleanliness (read the first, How clean is your data?, here), we’ll test-drive the data profiling tool provided with Microsoft SQL Server. Other profiling tools have ...

In an earlier blog I talked about the difference in mentality between the typical developer and the typical DBA. One of the characteristics of the DBA is the distrust of the Microsoft Wizards. “Give ...

SQL Injection is a fairly new method of hacking your database. Learn how it’s done—and how to protect yourself. MOST NETWORK ADMINISTRATORS charged with keeping the network infrastructure secure tend ...

Value stream management involves people in the organization to examine workflows and other processes to ensure they are deriving the maximum value from their efforts while eliminating waste — of ...