Runtime Interaction with SSIS Packages - Confirming Actions
In developing my data warehouse ETL processes, there are some packages and SQL Agent jobs that are both necessary to the process of deploying a new version of the...
2011-05-10
17 reads
Blog Posts
T-SQL Tuesday #18 – CTEs
To CTE or not to CTE, that is the Question
So my post really has nothing to do with the title....
2011-05-10
693 reads
T-SQL Tuesday #18 – CTEs
To CTE or not to CTE, that is the Question So my post really has nothing to do with the title. This is not a post to help you...
2011-05-10
2 reads
T-SQL Tuesday #18 – My CTE
It’s time for T-SQL Tuesday again, and it’s number 18. Hard to believe it’s been a year and a half...
2011-05-10
949 reads
Use ACE Drivers and PowerShell to Talk to Text Files
As a follow up to my SQLRally 2011 Scripting Guy Guest Blog Post which dealt with Excel and Access files,...
2011-05-10
2,338 reads
A quicker way than using count(*)
A quick little tip I found a couple of years ago. Ever use the count(*) syntax and it takes forever...
2011-05-09
564 reads
Minnesota SQL Server Study Group
Study Time!
A few weeks back, I sent a message on the PASSMN LinkedIn group page about expanding the MCM study...
2011-05-09
685 reads
PASSMN May Meeting
If you are going to be visiting Minnesota on May 17th or are there on more permanent basis, you can...
2011-05-09
628 reads
Pragmatic Tools Week: BIxPress
Much like Tim “The Toolman” Taylor had his themed weeks, we’re going to do something similar. This week we salute:...
2011-05-09
652 reads
Speaking at Colorado Springs SQL Server User’s Group on June 15
I will be speaking at the Colorado Springs SQL Server User’s Group, live and in person, on Wednesday, June 15,...
2011-05-09
516 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
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