Data Warehousing Tip: Surrogate Key Generation

If IDENTITY insert is disabled or simply not available in a particular database or a database architecture, you’ll want to do a table based surrogate key assignment or use...

Data Warehousing Tip: Surrogate Key Generation

If IDENTITY insert is disabled or simply not available in a particular database or a database architecture, you’ll want to...

Reblog: April 5 to April 11

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer...

SQL Saturday#197–Omaha Recap

This was the second SQL Saturday hosted in Omaha.  I loved to see how the event grew from the first...

DBA Question of The Day: What is SAVE TRANSACTION?

 Hello Dear Reader!  I was teaching a class in Chicago last week and I got a lot of really great...

SQL Server – Add Date/Time to output file of BCP / SQLCMD (2)

Last time I posted about How you can add date/time to output file name, in which I used xp_cmdshell to...

PASS Business Analytics Conference Live Blog

Apologies if you went to my site this morning to see my blog from the bloggers table at PASS Business Analytics...

PowerShell and SQL – Easy and Different Ways to Find Number of Rows of all Tables in a database

SQL Example:
DECLARE @TableRowsCount table

(

Tablename varchar(50),

cnt int)
insert into @TableRowsCount

EXEC sp_MSforeachtable @command1=” select ‘?’,count(*) from ?”
select * from @TableRowsCount
PowerShell Example:
Load SQL PowerShell by...

I See BI People

A tweet from Ted Krueger (Blog | @Onpnt) this morning…
I’m surrounded by BI people!!!!#passbac
— Ted Krueger (@onpnt) April 11, 2013

inspired a little creativity…

 
You...

Entertainment for the Traveling Consultant (UltraViolet Review)

Like many of us, I have a collection of favorite movies. These include Ghostbusters, Stripes, Serenity, and dozens more. I...