Assuming you're using a version control system, a visual difference comparison across commits helps tremendously. Also, it helps when each commit has a descriptive comment, because (at least in TFS...

I've dealt with BigInt identifiers a lot when I worked in the healthcare industry, and I've seen Entity-Attribute-Value modeled tables accumulate several billion rows within the first couple years of...

I may look back at this 10 years from now and laugh, but I can't imagine uniquely identifying 9,223,372,036,854,775,807 of anything, unless you're doing click stream analysis on every global user...

The short answer is: No, you can't assign execution priority to a SQL Server request the same way you can a Windows process. Also, the issue isn't just CPU and...

I still recall the day back in 1997 when I first saw that awesome new Sybase server with it's 500 (MB) of memory. It was such a leap forward from...

I work for a national retail chain, and we have 2000+ installations of SQL Server Express edition deployed at store locations, and just last year we finally got all the...

If you're not in charge of backups, security, and monitoring, then you're not a database administrator.
If you can't code T-SQL, then you're not a database programmer.
If you...

Yes, you don't need an "all hands" meeting every time a deployment fails or something goes bump in the night, especially when such things are a weekly or even daily...

As for certifications, yes it is helpful when it comes to landing a job. We may argue the merits of whether a certification makes a competent DBA / Developer even...

Topics like unit testing, DevOps, or ETL are broadly defined and subject to interpretation even today. It's very well possible that you have more actual experience than you think you...

The financial and healthcare industries are already regulated, because they involve money and privacy, but really unsecured data can cost individuals their money and privacy regardless of the line of business with...