Last Weeks Top “Reading” Links #34

For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...

The 2013 SQL in the City Tour

Once again, Red Gate is planning on a tour of the US for the SQL in the City events. Last...

Bulk Insert Task SSIS – Path Specified Cannot be Found or File Does Not Exist

When using the Bulk insert task in SSIS, you might encounter an error stating that The File Does Not Exist...

Use Lookups the right Way

SSIS Lookup tasks are all too easy to abuse as they are easy to setup and not really think about...

Temporary Post Used For Theme Detection (6a375569-f9c1-4835-a7fb-fa1ba0b240e4 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

This is a temporary post that was not deleted. Please delete this manually. (e621c360-788f-48aa-bd56-670930569ab5 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

Have you configured Database Mail to utilize multiple SMTP Accounts ?

Lets start discussing about this subject by closely looking at the term Redundancy.  What is redundancy all about ?
Wikipedia defines redundancy as “In engineering, redundancy is the...

MSBI (SSAS, SSRS and SSIS) Training

Hi Guys,

Anyone interested in online training for MSBI (SSAS, SSRS and SSIS), please contact @ er.lokeshsharma08@gmail.com.

Features - Best material (practical and theoretical) for becoming familiar with...

SQL – SQL Server Script to Iterate and Pull Data from All SQL Instances – Database Backup

This Post is a continuation of my previous post. Many times, there is a difficulty in pulling the data to...

Reblog: May 17 to May 23

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

A Little Azure Fun on Friday

You know how we’ve always heard that sp_msforeachtable and other similar undocumented functions may not be supported in future versions...