Always remain updated about current software development trends

Simple Talk

What Counts For a DBA: Imagination

By drsql

"Imagination\u2026One little spark, of inspiration\u2026 is at the heart, of all creation." \u2013 From the song "One Little...

The PoSh DBA: Grown-Up PowerShell Functions

By Laerte Junior

Laerte goes step-by-step through the process of tidying up and making more reusable an untidy collection of PowerShell routines, showing how pipelines and advanced functions can make PowerShell more effective in helping to automate many of the working DBA's...

SQL VIEW Basics

By Joe Celko

SQL Views are essential for the database developer. However, it is common to see them misued, or neglected. Joe Celko tackles an introduction to the subject, but there is something about the topic that makes it likely that even the experienced developer will...

Handling Deadlocks in SQL Server

By Jonathan Kehayias

In this excerpt from his book Troubleshooting SQL Server: A Guide for the Accidental DBA, Jonathan Kehayias provides a guide to identifying the causes, reacting to, and ultimately preventing the dreaded deadlock.

List of resources for database continuous integration

By David Atkinson

Because there is so little information on database continuous integration out in the wild, I've taken it upon myself...

SQL Scripts Manager and IronPython

By Timothy Wiseman

As well as running TSQL and PowerShell, the free SQL Scripts Manager tool can also run Python scripts. This allows even more sophisticated scripting possibilities for managing automated database tasks.

Metrics - A little knowledge can be a dangerous thing (or 'Why you're not clever enough to interpret metrics data')

By Jason Crease

At RedGate Software, I work on a .NET obfuscator\xa0 called SmartAssembly.\xa0 Various features of it use a database to...

.NET Memory Management and Finalization

By Jean-Philippe Gouigoux

In this excerpt from his new book, Practical Performance Profiling: Improving the Efficiency of .NET Code, Jean-Phillipe Gouigoux discusses the Dispose mechanism and the finalization process in the context of .NET Garbage Collection

Towards the Perfect Build

By Matt Wrock

An automated build and deployment system is no longer a dream. Now that PowerShell has matured as a product, and since the emergence of new tools such as Psake and Chocolatey, the ambition of the perfect build process has come nearer to reality.

IT Admin for Thrill Seekers

By Tony Davis

A developer suggested to me recently that the life of the DBA was, surely, a dull one. My first reaction was...