Script to Populate Date Dimension, without Using a Cursor
Most of the scripts I've used to populate date dimension uses a cursor. Since data is loaded only once to...
2013-01-22
2,481 reads
Samuel Vanga
Script to Populate Date Dimension, without Using a Cursor
Most of the scripts I’ve used to populate date dimension uses a cursor. Since data is loaded only once to...
2013-01-22
786 reads
SQL Server Views
This post is first of yet to come long series on basic concepts of SQL Server. I’ll begin with basic...
2013-01-22
766 reads
Scripts to Detect Data Warehouse Issues
Standards and best practices are like flu shots you take before you're infected; Database best practices protect your databases from...
2013-01-15
557 reads
Scripts to Detect Data Warehouse Issues
Standards and best practices are like flu shots you take before you’re infected; Database best practices protect your databases from...
2013-01-15
489 reads
Every ebook from Apress for $15
Query Performance Tuning. Grant Fritchey. $15. If this doesn’t excite you, nothing will. Apress is offering every e-book for just $15...
2012-11-26
975 reads
PASS SQL Saturday World Map
I had the pleasure of helping Karla Landrum (@Karlakay22) for the PASS Summit 2012 by creating two dashboards: SQL Saturday...
2012-11-20
995 reads
PASS Summit 2012 Twitter Dashboard
As a business intelligence developer, my skills include taking the raw data, shaking it to remove all the junk, and...
2012-11-12
1,528 reads
Create Several Shell SSIS Packages In Minutes Using BIML
What do i mean by shell packages? You’re spot on – that’s an excellent question to begin with. For the purpose...
2012-10-22 (first published: 2012-10-16)
4,655 reads
Generate Uniqueidentifier with SSIS
If you are trying to generate Uniqueidentifier/Newid() in SSIS data flow, you will soon realize that there is no out-of-the-box...
2012-10-16 (first published: 2012-10-10)
11,063 reads
Blogs
A New Word: Mottleheaded
By Steve Jones
mottleheaded – adj. feeling uneasy when socializing with odd combinations of friend and family,...
Microsoft Purview GA menu’s
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
Connect to Power BI as a Guest User in another Tenant
Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
I have never seen an insert statement with -= tablename in place of values
We have a third part software and looking at some of their SQL we...
Question of the Day
Disable All the Indexes
How do I disable all the indexes on the dbo.Logger table?
See possible answers