The SQL Server Instance That Will not Start

Everyone's SQL Server nightmare: The instance will not start. If such a problem strikes you, keep calm, follow Gail's advice,...

17 January 2013 29 min read

Chris Lambrou

SQL Monitor's data repository: Monitoring data – part 1

Okay, I had originally intended to blog about SQL Monitor on a fairly frequent basis. Unfortunately I got rather distracted...

16 January 2013 18 min read

Jonathan Lewis

Compression in Oracle – Part 1: Basic Table Compression

In this short series on compression in Oracle, we will be looking at the various types of compression used by...

15 January 2013 12 min read

Buck Woody

Data Science Laboratory System – Testing the Text Tools and Sample Data

Anyone who is frequently faced with preparing data for processing needs to be familiar with some industry-standard text-manipulation tools. Awk,...

15 January 2013 18 min read

Ambily Kavumkal Kamalasanan

Windows Store App Contracts

Windows Store Apps use contracts to declare the interactions that they support with other apps and with the 'Charm Bar'....

14 January 2013 15 min read

Warwick Rudd

Expanding AlwaysOn Availability Groups with Replication Publishers

SQL Server 2012 AlwaysOn Availability Groups provide a high-availability and disaster-recovery solution for you SQL Server 2012 environments. Replication has...

14 January 2013 9 min read

Dino Esposito

ASP.NET MVC 4: What else?

Even ASP.NET MVC can be improved. Dino explains the value of templates, and makes a case for the productivity gains...

11 January 2013 11 min read

Edward Charbeneau

Using Chrome and Visual Studio for Real Time CSS Development

Although CSS editing tools exist that give you a measure of WYSIWYG, it is often more convenient to make small...

10 January 2013 11 min read

Nirmal Sharma

Microsoft Hyper-V Networking and Configuration – Part 2

Hyper-V Networking can be configured to meet a wide range of requirements, but it isn't always obvious which choices are...

10 January 2013 16 min read

Joe Celko

UNIQUE Constraints in SQL

Here is an in-depth look at an underused constraint, UNIQUE, that can increase the performance of queries and protect data...

10 January 2013 22 min read

Patrick Barel

Custom Authentication in APEX

Trust is a great force multiplier. – Tom Ridge When you build a web application you have two choices for...

09 January 2013 6 min read

Feodor Georgiev

HDDs, SSDs and Database Considerations

In this article Feodor clears up a few myths about storage, explains the difference in how HDDs and SSDs work...

09 January 2013 11 min read

Grant Fritchey

Statistics in SQL Server

SQL Server's Query Optimiser relies on statistics for providing a decent query plan. If the statistics are wrong, outdated or...

08 January 2013 10 min read

Louis Davidson

What Counts For a DBA: Amnesia

As we rush headlong into 2013, many of us prepare the annual document of self-deception otherwise known as our “New...

07 January 2013 3 min read

Jonathan Allen

Keeping sysinternals up to date

Pretty much anyone in the IT business should know about sysinternals tools. They are a set of tools written by...

05 January 2013 2 min read

Rodney Landrum

2013 and the Impossible Challenge

I am consistently amazed when I read on twitter the exploits of DBAs who compete in marathons, endure triathlons, or...

03 January 2013 3 min read

Robert Sheldon

Handling Errors in SQL Server 2012

The error handling of SQL Server has always been somewhat mysterious. Now at last, the THROW statement has been included...

03 January 2013 10 min read

Damon Armstrong

Interactive Office 2010 Command Reference

I believe it was Office 2007 that did away with the old menu system and toolbars in favor the Ribbon,...

28 December 2012 1 min read

Simple Talk Editorial Team

Rudolph The Red-Nosed Tester and Other Festive Arrangements

I don’t know what it’s like in your offices right now, but at the Simple-talk HQ, it’s that time of...

21 December 2012 2 min read

Steve Harville

Automating and delegating datapump imports with PL/SQL

We recently bought another company and we are in the process of integrating our systems with theirs. One requirement was...

20 December 2012 2 min read

Register for Simple Talk

Articles