Master Data Services 2014: Creating nightly load processes

 
Introduction
A few days ago, I ran into an interesting issue when creating a stored procedure to load new data into...

SQL Server 2014: Master Data Services Backing up your data models.. A necessary evil !!

 
Introduction
A few days back, in my article entitled ‘Master Data Services 2014: Creating nightly load processes’, I discussed the setting...

Gotcha!!! Trying to install SQL Server 2012 on Windows 8.1 Professional

OK, after several tranquillizers and much grey hair, I found out why SQL Server 2012 will NOT install on Windows...

Setting your predicate arguments at run time Part: 2 MultiSelect

 
Introduction
A few days ago, I did a presentation for a Virtual Chapter meeting where I discussed SQL Server Data Access...

Setting your predicate arguments at run time

 
Introduction
A few days ago, I did a presentation for a Virtual Chapter meeting where I discussed SQL Server Data Access...

Monthly profit percentage techniques

Introduction
A few days ago, a friend of mine approached me with an interesting challenge. What he was trying to achieve...

Flexible Fiscal Data Sort

Flexible Fiscal Data Sorting
A few months ago, I faced the challenge of extracting data via SQL Queries (for our enterprise),...

Dynamic calculations of running totals

 Dynamic calculations of running totals
A few weeks back, a friend from South Africa wrote to
me asking if I knew of a...

Monitoring SQL Server Agent job run times

Introduction

A few months back, I was asked how long a particular nightly process took to run. It was a super...

Resolving data redundancy up front

 
Introduction
As all of us do when confronted with a problem, the resource of choice is to ‘Google it’.
This is where...