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

Book Review – Windows PowerShell 3.0 Step by Step” by Ed Wilson;O’Reilly Media, Inc.

Today I will talk about a book  titled  ” Windows PowerShell 3.0 Step by Step” by Ed Wilson;O’Reilly Media, Inc.

When I...

A Rickety Stairway to SQL Server Data Mining, Part 13: Using CLR with Analysis Services

by Steve Bolton
               I was drawn into the realm of SQL Server in a roundabout manner thanks to Visual Basic. Around...

Security Questions: Differences between “Grant” and “With Grant?”

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

I’m presenting at the PASS Summit!

I am fortunate enough to have been selected to give a presentation at the PASS Summit 2013 in Charlotte, NC on October...

Exploring Excel 2013 for BI Tip #7: Retaining Pivot Table Size After Data Refreshes

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...

Business Objects on Linux and SQL Server

This is just a quick post to share a lesson learned while I was on an engagement where the client’s...

Dedicated Administrator Connection (DAC)

We all dread the scenario whereby SQL Server is under so much load and has a complete lack of resources...

Starting with Azure

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

SQL Server – Get the Default Data File and Log File Location using T-SQL Query

In SQL Serve 2012, we can get the default data file and log file locations using a simple T-SQL query...