100th blog post

Unless you’ve entered “100th blog post” into your favourite search engine and clicked on pot luck (or whatever it is)...

Reblog: February 22 to February 28

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer...

SQL Server Events in the UK – March 2013

Welcome to the first of what I plan to be a regular recurring theme. Right here I will list out...

Windows 8 – First Impressions on a Desktop

I bought a new (to me) desktop recently to replace my aging hardware. I’ve had a quad core machine, but...

Something for the Weekend – SQL Server Links 01/03/13

It’s SFTW Time, I hope you’ve had a great week!
Make sure you don’t miss this weekly round-up of SQL Server...

SQL BLOG: First Occurrence Of Character In a String

Scenario:
 We need to find the first occurrence of character ie non numeric data in the string without using the built...

YYYYMM Math

I had a project recently where I had to do math on a number that represented a date, YYYYMM.

For example,...

Presentation Materials “A Function is a Function”

Here are the presentation materials for today’s Pragmatic Works Training on the T’s session A Functions Is A Function – Comparison of...

Insert multiple values sets into a table in one command

The INSERT command has two distinct ways to load data into a table.
INSERT INTO Table (field1, field2) VALUES ('string1','string2')And
INSERT INTO...

A Month of PowerShell – Day 28 (Using Windows PowerShell Remoting)

Welcome to Day 28 of my “A Month of PowerShell” series – the last day. This series will use the series...