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.

Quick tip: sp_configure and sys.configurations

by Matt

Ctrl-alt-geek

In order to query the configuration settings of a server you can run this sproc:
exec sp_configureOn a default install of...

2012-05-16

1,113 reads

Setting up transactional replication using T-SQL

by Matt

Ctrl-alt-geek

Replication is one of the more complex of the SQL native “HA/DR” technologies. There are a lot of moving parts....

2012-05-15

1,997 reads

Working with bitwise data in SQL Server

by Matt

Ctrl-alt-geek

I was working with a group of students on a design brief. The brief was to partially implement a database...

2012-05-10

1,030 reads

Locked out of SQL Server.

by Matt

Ctrl-alt-geek

This is a very cool and useful tip if you find yourself locked out of the sysadmin role in sql...

2012-04-30

2,631 reads

SQL Server 2005 backups in a hung state because of full text search process

by Matt

Ctrl-alt-geek

I came across an issue today where a backup process was in a blocked state with a wait type of...

2012-04-24

608 reads

Apply SP1 to SQL Server 2008R2 on active/active cluster.

by Matt

Ctrl-alt-geek

While researching the steps required to service pack SQL Server on an active active cluster I came across a lot...

2012-04-16

909 reads

Instant File Initialization Security Risk

by Matt

Ctrl-alt-geek

A while ago I blogged about instant file initialization. A colleague of mine pointed out that there is a small...

2012-04-16

945 reads

Comparing users and role memberships between two databases

by Matt

Ctrl-alt-geek

The other day I was asked to restore a production database into a development environment and then check the database...

2012-03-21

880 reads

Blogs

Flyway Tips: Automation Assistance in Flyway Desktop

I was chatting with the product managers at Flyway and one asked me whether...

The Benefits of Teaching

By Brian Kelley

Even preparing for a class or seminar with set materials takes a lot of...

Power BI, Excel, OneLake – Dreams Do Come True!

By DataOnWheels

I can’t believe it’s finally here! A way to have Excel live in OneDrive...

Read the latest Blogs

Forums

Help! MEMORY_ALLOCATION_EXT wait stalls

Hi I have an overnight process that moves allot of claims records Been working...

Unlocking Data Transformation: My journey with dbt (Data Build Tool) on SQL Server

By ashok.gadiparthi

Comments posted to this topic are about the item Unlocking Data Transformation: My journey...

Putting the Player with the Number

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Putting the Player with the...

Visit the forum

Question of the Day

Putting the Player with the Number

In SQL Server 2025, what does this return?

DECLARE @player varchar(20) = 'Bo Nix',
@num VARCHAR = '10'

SELECT @player || @num

See possible answers