“Use descriptive object names.” – Read on to discover how ignoring this best practice can cause plan cache bloat and in turn performance issues.
T-SQL Tuesday is a monthly blog party. This month is the 70th episode and the topic is: “SQL Server Audit”. Read on to discover what #tsql2sday is all about and what you have to do to participate in this exciting blog-party.
Sometimes we need to update data in one table based on the contents of one or more other tables. Discover how the UPDATE from SELECT variation of SQL Server’s UPDATE statement provides an easy way to achieve this.
Abstract So, you got told you need to encrypt “the database”. Now what? There are many reasons to encrypt your database. You might have to comply with HIPAA or PCI DSS, or you might just have generally sensitive data. Correctly [more…]
If you have a small or medium sized business, you might be wondering of your business needs to be PCI DSS compliant. Read on to find out now.
One Billion – The number of accounts affected by security breaches during the last ten years. Is the data of your customers safe with you?
Continuous Integration (CI), while it comes with a high startup cost, provides several benefits that lead to a better product in the long term. Read on to discover six of the strongest reasons to us CI in your project.
Continuous Integration (CI) is an automated process that complements your unit testing efforts. Discover how CI can create deployable software packages while giving feedback about the health of the project.
Shared test data can lead to a particularly nasty form of fragile test. Discover why shared test data is bad and how to avoid using it in your unit tests.
Testing functionality dependent on the current time or date commonly leads to fragile tests. Discover three proven test patterns to avoid that trap.