Articles

Test-Driven Development (TDD) involves the repetition of a very short development cycle that begins with an initially-failing test that defines the required functionality, and ends with producing the minimum amount of code to pass that test, and finally refactoring the new code. Michael Sorens continues his introduction to TDD by implementing the first tests and introducing the topics of Test doubles; Test Runners, Constraints and Assertions.

2014-09-19

7,785 reads

Azure Virtual Machines Part 0: A VM Primer

by Additional Articles

Just Azure

Azure

Mike Martin kicks off his series on Azure Virtual Machines with a primer, full of background and terms. To fully understand the Azure Virtual Machines offering, Mike explains how everything is connected and co-existing.

2014-09-18

8,859 reads

The Mindset of the Enterprise DBA: Harnessing the Power of Automation

by Additional Articles

SimpleTalk

dba skills

After you have done the necessary groundwork of standardising and centralising your database adminstration processes, you are now in a position to implement some effective automation of some of these processes. Which ones do you choose, and how do you set about automating these tasks?

2014-09-17

11,329 reads

The Ins and outs of In-Memory OLTP

by Roy Ernest

SQLServerCentral.com

Microsoft SQL Server

As you may know, SQL Server is a very robust database, but SQL server has its performance bottlenecks. With the introduction of In-Line memory OLTP, there is a chance to get rid of the performance bottlenecks

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(22)

You rated this post out of 5. Change rating

2014-09-16

6,750 reads

Discuss

Comparing SQL Server Datatypes, Size and Performance for Storing Numbers

by Additional Articles

MSSQLTips.com

DataTypes

When more than one numeric SQL Server data type may be suitable for a field in a project, which data type should you choose and what are the implications for SQL Server performance?

2014-09-16

9,167 reads

Another Way to Look at Trees

by Larry Schmidt

SQLServerCentral.com

SQL Server

An alternative to tree traversal, and ultimately more efficient way to look at organizational structures is presented.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(16)

You rated this post out of 5. Change rating

2014-09-15

7,592 reads

Discuss

Survey: Using Online Accounts

by Additional Articles

Redgate

survey

Using online accounts for license management has some advantages, Red Gate is researching how to implement this for our tools in a way that improves the experience for all involved. To say thank you for your participation, there's a chance to win a $25 Amazon certificate.

2014-09-15

7,444 reads

Who Broke the Build?

by Additional Articles

SimpleTalk

Continuous Integration (CI)

Continuous Integration and automatic builds are fantastic tools for software teams, but only if developers take responsibility for their code. Karsten Kempe explains how to use Team Foundation Server to drive better continuous integration, and walks through a simple open-source tool he built to make nightly builds more transparent, and more valuable.

2014-09-15

7,853 reads

Splitting Strings Based on Patterns

by Dwain Camps

SQLServerCentral.com

String Manipulation

Splitting strings based on patterns supported by LIKE and PATINDEX can be an interesting way to address a wide variety of problems.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(54)

You rated this post out of 5. Change rating

2014-09-12 (first published: 2012-11-29)

33,521 reads

Discuss

DBAs vs Developers: A Sad Tale of Unnecessary Conflict

by Additional Articles

SimpleTalk

dba skills

For many developers, does DBA really stand for Don't Bother Asking? David Poole thinks it is time to end the unnecessary conflict between developer and DBA, and explains how to deal professionally with the inevitable friction between development and operation activities in IT.

2014-09-12

12,291 reads

Articles

A TDD Journey: 3- Mocks vs. Stubs; Test Frameworks; Assertions; ReSharper Accelerators

Azure Virtual Machines Part 0: A VM Primer

The Mindset of the Enterprise DBA: Harnessing the Power of Automation

The Ins and outs of In-Memory OLTP

Comparing SQL Server Datatypes, Size and Performance for Storing Numbers

Another Way to Look at Trees

Survey: Using Online Accounts

Who Broke the Build?

Splitting Strings Based on Patterns

DBAs vs Developers: A Sad Tale of Unnecessary Conflict

Blogs

Upgrading SQL Server Containers on the Laptop

How to Find Expensive Queries in Amazon Redshift

The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech

Forums

SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade

How Long is a Long I/O?

T-SQL Trigonometric Functions in SQL Server

Question of the Day

How Long is a Long I/O?