Upcoming Speaking Engagements for Q4
In the next few months, I’ll be giving a couple of talks on SQL Server business intelligence. For October, I...
2009-09-18
835 reads
Tim Mitchell
- Interests: SQL Server, Data Warehousing, ETL, Data Architecture, Python, Dbt
- Website: https://www.TimMitchell.net
- Bluesky: tmitch.net
Skipping Items in a Foreach Loop
Recently, my friend Jack Corbett asked a question on Twitter:
In a nutshell, the SSIS foreach loop will enumerate a given...
2009-09-16
5,777 reads
Getting Into the Biz, Part 3
In a couple of previous posts (Part One and Part Two), I shared some thoughts about starting a career path...
2009-09-14
1,369 reads
North Texas SQL Server User Group Meeting on Thursday
The monthly North Texas SQL Server User Group (NTSSUG) meeting will be held this Thursday, September 17, at 7:00pm at...
2009-09-14
762 reads
SQL Saturday Dallas Update
Just a quick update on the SQL Saturday event we are planning for the Dallas area next year. Late last...
2009-09-13
670 reads
Updating Existing Data with SSIS
I see a lot of questions on the forums about updating existing data in SSIS. When the update is dynamic...
2009-09-10
22,364 reads
SpeakerRate – Need Your Feedback
Everybody loves a compliment. Not everyone enjoys criticism, even if it’s constructive and politely delivered, but the fact is that...
2009-09-08
771 reads
24 Hours of PASS - Recap
At times it felt like a party, it had enough content to be a mini-conference, and we learned that some...
2009-09-03
878 reads
Keeping a Low Profile
I’ve been mostly offline for the last ten days or so, cutting back on blogging and forum participation and mostly...
2009-09-01
566 reads
Pass Board of Directors
As you’ve no doubt heard or read, the call for nominations for the PASS Board of Directors is open until...
2009-08-27
594 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers