Using the SSIS Merge Join
The Merge Join Transform in SSIS is a great way to load a Data warehouse quickly and an easy way...
2011-09-06
12,626 reads
Blog Posts
Database Cost Savings
I watched a video recently by Forester Research , discussing Database Cost Savings. The video was intended for IT decision makers,...
2011-09-05
887 reads
Managing AlwaysOn with Powershell
Although you can use SQL Server Management Studio or T-SQL to manage AlwaysOn, SQL Server Denali CTP 3 includes 25...
2011-09-05
19,079 reads
My Guide to Passing MCTS Exam 70-432
A reader wrote in to me last weekend regarding the MCTS Exam 70-432 (SQL Server 2008, Implementation and Maintenance).
Hi John,
I...
2011-09-05
2,389 reads
PASS 2011 Countdown – 5 Weeks To Go
We are now 5-weeks from this years PASS Summit. It’s time to start getting ready for the event. Hopefully, you...
2011-09-05
861 reads
SQL Education
They always used to tell us that education is important.
Education is (They said) key, in fact. We as a technical...
2011-09-05
469 reads
SQL Server 2011 “Denali”: Give feedback and win nice gifts
Microsoft SQL Server guys extended periods for Denali’s feedback on Microsoft Connect. And they motivates with really nice gifts for...
2011-09-05
642 reads
The Principle of Least Privilege – Skill #3
This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for...
2011-09-05
5,537 reads
When technology works.
Living in the South East has it perks with the abundant rivers, lakes, streams, mountains, and friendly people. It also...
2011-09-05
414 reads
Youngest MCM in the world?
As part of my MCM preparation (Have to study aggressively at least for next 2 years) , I have downloaded almost all readiness...
2011-09-05
1,492 reads
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers