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...

Dust Off That Resume

Since I started regularly attending SQL Saturday events some five years ago, I’ve sat in on a number of professional...

SQL BLOG: Using Triggers for creating history tables in SQL Server

Case Study:1)       We  need to track the employee table in terms of new records inserted along with the datetime stamp
2)     ...

"An item with the same key has already been added."

In SQL Server Reporting Services, when adding a new dataset to a report, you may see an error that looks...

Check out IT Central Station

If you get some time, head on out to IT Central Station.com. You can provide some valuable feedback on the...

Data Warehouse Architecture Presentation Slides

Thanks to everyone who attended my session “Data Warehouse Architecture” to the PASS DBA virtual chapter.  There were over 200 attendees!  The recording of...