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

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

Per Member Per Month Per 1000 Calculations in MDX

In a lot of industries there is a popular calculation called “Per Member Per Month Per 1000” calculation or the...

Performing an INSERT from a PowerShell script

This code demonstrates how to do an INSERT into SQL Server from a PowerShell script using an ADO.NET command object...

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

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

Ad-hoc Reporting with SharePoint Recording and Q&A

I hope you were able to attend my free webinar on Ad-hoc Reporting with SharePoint on May 21, 2013.  If...

Azure does Powershell too

Or, I guess it might be more appropriate to say that Powershell does Azure. Regardless, there are a set of...

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