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

When will we look back at this?

It’s amazing how software has advanced. I look at the software I use, and I’m amazed. I still remember texting...

Connecting Windows Server 2003 VM To External Network In Hyper-V

The Windows 8 and Windows Server 2012 SP1 Virtual Machines on my laptop are connecting just fine to my physical...

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

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