Art

SQL Database Administrator/Developer. Background in developing OLTP/document based databases, SQLXML and performance tuning with an unhealthy fascination for the SQL query optimiser!

Blog Post

Basic RegEx in SSMS

Have you ever had that moment where you have gone "Geez.. I wish I'd learnt this stuff ages ago" after...

2014-02-04 (first published: )

5,443 reads

Blog Post

And that is 2013

I’ve been blogging for a couple of years now and although I’ve never been a prolific blogger (and never will!),...

2013-12-23

567 reads

Blogs

The 5 Best SQL Course for Beginners – Reviews and Guide

By

In the technologically driven world of 2024, more individuals are finding themselves drawn towards the...

Speaking at SQL Saturday Boston 2023

By

I’m heading to Boston next week for SQL Saturday Boston 2023. I went to...

SQL Prompt Quick Access to Helper Code

By

We’ve been doing some events as part of the Redgate Roadshow, and at one...

Read the latest Blogs

Forums

checkdbcc date for all database

By lan2022nguyen

CREATE TABLE #tempdblogin ( lastcheck nvarchar(100) ) EXEC sp_MSforeachdb 'USE ? insert into #tempdblogin...

Azure Postgres reliability/management experiences

By CreateIndexNonclustered

I am considering implementing an Azure Postgres DB for use in a part of...

Unable to deploy DACPAC

By LearningDBA

Every time the dev team runs their dacpac, they encounter an issue. "This deployment...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers