Matt

Matt Bowler is a DBA at Trade Me, and teaches database design and administration courses at the local institute of technology. A recent but avid discoverer of SQL Server, Matt is a regular contributor to forums at MSDN, Experts Exchange and SSC and he blogs at mattsql.wordpress.com.

Blog Post

Conditional Aggregates

The Problem: A legacy table contains amounts and a char column indicating whether the amount is a credit or a...

2014-02-11 (first published: )

3,058 reads

Blog Post

Duplicate Statistics

The Setup:
Standard best practise is to have auto create and auto update statistics set for SQL Server databases. But there...

2013-09-03 (first published: )

3,402 reads

Blogs

Daily Coping 21 Jan 2021

By

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

Using dbachecks for CIS Security Checks

By

Well back at the end of 2019 I finished writing most of the checks...

How to tell if Change Data Capture (CDC) is working as expected

By

I’m not sure how many of you use Change Data Capture (CDC) on your...

Read the latest Blogs

Forums

Creating AG group on FCI

By inHouseDBA

Hello, Can someone shed some lights on adding Availability Group with few databases to...

Any cloud interns out there??

By ashrimega

Hi everyone! I was hoping to get some insight into exactly what a cloud...

How to slit value from one row to multiple rows

By phambao

Hi all, I would like to know how I can slit value from one...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers