Test-Driven Development (TDD) has a misleading name, because the objective is to design and specify that the system you are developing behaves in the ways that the customer expects, and to prove that it does so for the lifetime of the system. Michael Sorens starts an introduction to TDD that is more of a journey in six parts.
2014-07-31
9,842 reads
Set a security standard across environments that developers can see and run, but not change.
2014-07-30
3,868 reads
One option to get notified when TempDB grows is to create a SQL Alert to fire a SQL Agent Job that will automatically send an email alerting the DBA when the Tempdb reaches a specific file size. This tip explains how to set it up.
2014-07-30
10,602 reads
CONNECT ANY DATABASE is one of three new permissions in SQL Server 2014 that can be granted to server logins. What is this new permission good for and why would we ever want this?
2014-07-29
15,065 reads
Here are seven practical tips for any 'accidental DBA' or developer, faced with having to deploy an upgrade to a database live to production, in a development environment that is in the early stages of getting the database code “house in order".
2014-07-29
10,764 reads
This article describes an easy way to handle calculation based on fiscal year and quarter
2014-07-28
20,719 reads
There is little doubt that static code analysis can contribute to code quality and deliverability. As an aid to a developer, it seems increasingly essential, but can it ever deliver reliable metrics of code-quality? One shudders at the potential misuse of quality metrics in the wrong hands. My hope is that it remains just an aid to human judgement; and creativity.
2014-07-28
69 reads
In this article, we’ll be focusing on the different ways you can build with a Cloud Service, and what exactly happens in terms of virtual machines when you deploy your application.
2014-07-28
10,018 reads
Recursive CTEs can be confusing and scary, so examining some non-standard examples may cast light upon these shadowy demons.
2014-07-25 (first published: 2012-07-17)
27,399 reads
During a transaction, data is written to the log cache so that it’s ready to be written to the log file on commit, or can be rolled back if necessary. When the log cache is being flushed to disk, the SQL Server session will wait on the WriteLog wait type. If this happens all the time, it may suggest disk bottlenecks where the transaction log is stored.
2014-07-25
9,844 reads
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Comments posted to this topic are about the item The day-to-day pressures of a...
I recently used accounting assignment help, and it made a huge difference in my...
Comments posted to this topic are about the item This Week's AI Trust Problem...
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers