My name is James Anderson and I am a SQL Server production DBA in the south of the UK. I have been working with databases since 2008. The first RDBMS I worked on was Paradox and I never want to see it again. I quickly moved to using T-SQL in SQL Server 2005. I have worked on every version of the product since. I enjoy query tuning and server optimisation. I detest transactional replication.

All authors

All authors

Blogs

Advice I Like: Failure

By

If it fails where you thought it would fail that is not a failure....

Logged in as a member of an Azure AD Group Error while Deploying DACPAC

By

Quite a long title for a short blog post ??While deploying a DACPAC (from...

Data Conferences – Worth Every Dollar

By

Some of the best career enhancers you can buy.   Why I Go to...

Read the latest Blogs

Forums

A Place where AI Technology Shines

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Place where AI Technology...

Alternate for xp_delete_file

By PJ_SQL

alternate for xp_delete_file

Select @ for different fields

By bswhipp

I have a need where I need to pass a field name to a...

Visit the forum

Question of the Day

Getting the Object Code

What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database? 

SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; 
GO

See possible answers