The Demo Setup–Attaching Databases with Powershell

I found another use for Powershell, one actually suggested by someone else: attaching specific SQL Server databases.
TL;DR I have a...

There are #temp tables and then there are ##temp tables.

Temporary tables are a common enough thing in T-SQL that most of us have probably used them on a fairly...

Date Range Challenge in sql

Hi Folks,

When you work in a offshore - onsite setup in IT industry and if you are fortunate 🙂 to be a...

Data Size – LEN() vs DATALENGTH() - WaterOx Consulting

Reading Time: 3 minutes  No. It isn’t just the way you use your data that...
The post Data Size – LEN() vs...

Friend of Redgate 2015

Today I am excited to announce that I have been accepted into the Friends of Redgate program for 2015. The...

Friend of Redgate 2015

Today I am excited to announce that I have been accepted into the Friends of Redgate program for 2015. The program targets influential people in their respective technical communities...

How to Replace Multiple Strings in a File using PowerShell

Replace the Data Source and Initial Catalog values of WebConfig.XML
Content of XML file
<Configuration ConfiguredType=”Property” Path=”\Package.Connections[ConnStaging].Properties[ConnectionString]” ValueType=”String”>

<ConfiguredValue>Data Source=localhost;Initial Catalog=Stage;Integrated Security=SSPI; Connection Timeout = 10</ConfiguredValue>

</Configuration>

PARAM(
[String]$DatabaseName='DCTarget',
[String]$XML='c:\webconfig.XML',
[String]$DatabaseServer='DataCenterDB01')[string]$db...

My First Ever SQL Saturday Pre-Con

Like most people I have a bucket list of things to do before I depart for other things. However I...

Speaker of the Month: February & March 2015

It’s not a question of scheduling. I just haven’t been to lots of community events in the last several months...

SQL Saturday #408 Houston – June 13th 2015

Call for speakers is now open for SQL Saturday #408 in Houston, TX.  If you are interested in presenting please...