Grant Fritchey

Tools for Cloud Construction

I’ve been reviewing the tools coming from Microsoft that help you deploy and manage your SQL Azure database over on...

20 May 2011 1 min read

Wesley David

Be the Puppet Master! Control Multiple PCs with one Keyboard and Mouse

In the average IT department, geek-credibility is bound up with the number of monitors you are simultaneously using. What about...

20 May 2011 10 min read

Simon Cooper

Visual Studio vNext

At TechEd this year, there’s only a few sessions and expo booths aimed squarely at devs rather than sysadmins and...

19 May 2011 3 min read

Grant Fritchey

Brush Your Teeth and Clean Your Room

Hello, Grant Fritchey here, one of these Scary DBAs. Tony isn’t around at the moment so I stopped by to...

12 May 2011 3 min read

Joe Celko

TIME Gentlemen please! The SQL Server temporal datatypes

If you are still using the old Sybase DateTime datatype, it is a good idea to move your code to...

12 May 2011 12 min read

Phil Factor

PATINDEX Workbench

The PATINDEX function of SQL Server packs powerful magic, but it is easy to get it wrong. Phil Factor returns...

12 May 2011 14 min read

Simon Cooper

I’ll be at TechEd Atlanta 2011

Just a brief note here – I’ll be going to TechEd Atlanta next week as part of a huge Red...

10 May 2011 1 min read

Andrew Clarke

Cloud Cuckoo Land

Does it strike you odd that, despite the outage of Amazon Elastic Compute Cloud (EC2) and Elastic Block Storage on...

10 May 2011 3 min read

Bert Jan van der Steeg

Database Management for SharePoint 2010

With each revision, SharePoint becomes more a SQL Server Database application, with everything that implies for planning and deployment. There...

10 May 2011 13 min read

Jaap Wesselius

Office365 and Lync Online

Having gotten us up and running with the basics of Office365, Jaap Wesselius now dives deeper, walking us through the...

10 May 2011 11 min read

Louis Davidson

What Counts For A DBA: Curiosity

It is a well-known saying that “curiosity killed the cat,” but is this really not as true as it might...

06 May 2011 5 min read

Louis Davidson

SQLPASS Submissions

So I am a bit hesitant to post this because the past few times I have posted about something I...

06 May 2011 4 min read

Richard Morris

Benjamin Pollack: Geek of the Week

Benjamin Pollack is well known for his work on Fog Creek Copilot, and Kiln. He is famous amongst young geeks...

06 May 2011 22 min read

Clive Tong

Remote Debugging in Visual Studio: Squashing Bugs in their Native Environment

There are already third-party applications that help you to debug .NET applications remotely, or at least get enough information to...

05 May 2011 7 min read

Grant Fritchey

Emergency Database Restores

I was reading a good article by Brent Ozar (blog|twitter) on a DBA Nightmare where I came across this section:...

04 May 2011 3 min read

Grant Fritchey

SQL Azure Differential Deployments

If you read my other blog, Scary DBA, you may be aware that I’ve been doing a series of experiments...

02 May 2011 3 min read

David Berry

Performance Implications of Parameterized Queries

Why don't we emphasize the huge advantages of parameterized queries over ad-hoc queries in SQL Server? There is a severe...

28 April 2011 19 min read

Grant Fritchey

It’s 3AM and I’m on call

If you are part of a team that is required to ensure that an application stays running at all hours,...

27 April 2011 11 min read

Robert Sheldon

SSIS Event Handlers Basics

SSIS event handlers are the simplest means of turning an SSIS script into a reliable system that is auditable, reacts...

26 April 2011 11 min read

Grant Fritchey

SQL Azure Deployments

Over on ScaryDBA.com I posted about the new Data-Tier Application (DAC) and DAC packages (DAC pac) this morning. You might...

25 April 2011 3 min read

Register for Simple Talk

Articles

Tools for Cloud Construction

Be the Puppet Master! Control Multiple PCs with one Keyboard and Mouse

Visual Studio vNext

Brush Your Teeth and Clean Your Room

TIME Gentlemen please! The SQL Server temporal datatypes

PATINDEX Workbench

I’ll be at TechEd Atlanta 2011

Cloud Cuckoo Land

Database Management for SharePoint 2010

Office365 and Lync Online

What Counts For A DBA: Curiosity

SQLPASS Submissions

Benjamin Pollack: Geek of the Week

Remote Debugging in Visual Studio: Squashing Bugs in their Native Environment

Emergency Database Restores

SQL Azure Differential Deployments

Performance Implications of Parameterized Queries

It’s 3AM and I’m on call

SSIS Event Handlers Basics

SQL Azure Deployments