Upcoming SQL Developer Training Course in Ft. Worth
If you are in the Dallas/Ft. Worth area and are interested in SQL Server developer training, there is an opportunity...
2009-10-02
639 reads
Tim Mitchell
Eliminating Empty Output Files in SSIS
So you’ve got some packages that regularly extract data to one or more text files, but you know that from...
2009-09-30
13,943 reads
Space Sensitivity in SSIS Lookups
It's been well-documented through myriad blogs and forum posts about the case sensitivity of the comparisons in the SSIS lookup...
2009-09-29
2,736 reads
[Off Topic] Workstation Upgrade
It had been about 5 years since I’d bought a new desktop machine for my home, and with my oldest...
2009-09-26
547 reads
More Free Training Resources
A recent blog by Jack Corbett (No Training Budget Still No Excuse, followed up by SSC’s Steve Jones here) hit...
2009-09-21
1,245 reads
The Netbook: Upgrade to Windows 7
I’m more than 2 months into the netbook experience, and I’m happy to report that it’s still a good investment. ...
2009-09-19
597 reads
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
825 reads
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,762 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
752 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,356 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Two foreign keys to the same table. Can't cascade deletes.
Not sure if this is really a relational theory question but it seems about...
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers