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...
2013-05-27
319 reads
Blog Posts
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)
2013-05-25
780 reads
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...
2013-05-24
727 reads
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...
2013-05-24
499 reads
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...
2013-05-24
436 reads
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...
2013-05-24 (first published: 2013-05-20)
4,145 reads
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...
2013-05-24
85,863 reads
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...
2013-05-24
491 reads
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...
2013-05-24
1,100 reads
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...
2013-05-23
1,246 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Managing Incidents and Fighting Fires
Comments posted to this topic are about the item Managing Incidents and Fighting Fires
Backing Up a DMK
Comments posted to this topic are about the item Backing Up a DMK
The Quiet Part
Comments posted to this topic are about the item The Quiet Part
Question of the Day
Backing Up a DMK
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers