Looking for Buried Treasure in the Transaction Log

Lately, I’ve been finding more and more reasons to look in the transaction log for investigative purposes. Questions come up...

Recap of our SQL Saturday #225 in Kosovo, Prishtina

SQL Saturday Kosovo #225, happened last week and I’m very happy that we did for the first time in Balkan...

Security Questions: Difference between sysadmin and CONTROL SERVER Permission

As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...

Starting with Azure

I’ve been meaning to do this, and I finally had the chance recently to start working with Azure. Red Gate...

Sum Result of SSRS LookupSet Function

SSRS provides several built-in Lookup functions:  Lookup, MultiLookup and LookupSet.  Lookup returns a single value while MultiLookup and LookupSet return...

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

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)

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

Effect of using operator '-' with dates in vb6

Recently I encountered a problem of handling dates while converting a vb6 code to .net code.

Problem - cant predict what the...