Phil Factor

Updating Aging Databases

Somehow, one is expected to be pleased that SQL Server 2005 is going to have another Service Pack. Why? For many DBAs, SQL Server 2005 is still a dangerous and radical upgrade. Phil Factor considers Microsoft's responsibilities...

2008-10-28

182 reads

Every DBA's nightmare

When a copy of all 25 million of the UK’s child benefit records, including bank details, went missing in the post, whilst being sent to the NAO (National Audit Office) on 18th October, the UK government must have known that a cover-up was impossible. This sort of incident is every DBA’s nightmare.

5 (1)

2007-11-26

148 reads

Blogs

Fixing the PoSh Hotkey in ADS

By

I installed the PowerShell (PoSh) extension in ADS recently. This is available in the...

Capture Execution Plans Only For Long Running Queries

By

I love questions. Most of all, I love questions I can answer. I spotted...

Daily Coping 28 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

API Newbee

By thedeadzeds

Hi Guys, I'm completely new to API's and i was wondering if there is...

Simple Python question...

By pietlinden

I have a table in SQL Server like this: CREATE TABLE #SymptomData (  ...

Regular expressions in script component

By sqlfriend

In one of our SSIS package we have a script component that validate a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers