[Off Topic] The Big Apple
I got my first opportunity to visit New York City last week. I was actually sitting in on a training...
2008-08-20
1,551 reads
Tim Mitchell
Delayed gratification
Call me odd, but I enjoy taking certification tests. It may be that I've always tested well, or perhaps it's...
2008-07-20
666 reads
Slacking and data quality (in that order)
Well, I almost missed blogging for the entire month of June. I'm sure that this fact didn't go unnoticed by...
2008-06-30
1,393 reads
Using IN with possible NULL values
There is a little quirk with NULLs when using the NOT IN qualifier. I use the term "quirk" loosely here...
2008-05-29
1,587 reads
A little fun with SSIS Expression Language
The SSIS expression language is a powerful yet enigmatic entity. Once you get used to its syntax - which is part...
2008-05-08
4,872 reads
SQL Backup 5 (Red Gate)
So after many months of trudging through native SQL Server backups for new mission-critical application I'm deploying, I have decided...
2008-05-06
677 reads
Photos from SQL Saturday
Check out the photos from SQL Saturday 3 - Jacksonville:
http://tim-mitchell.spaces.live.com/
2008-05-06
888 reads
SQL Saturday Jacksonville
I just wrapped up a high-octane day of SQL Server community education at SQL Saturday in Jacksonville, Florida. This event,...
2008-05-04
867 reads
Gotta love the Information Age
First it was CNN 24x7. Next the Internet brought us live information from around the globe.
Now this... real-time pizza tracking...
2008-04-27
1,437 reads
Free SQL Server 2008 online courseware from Microsoft
Just received word that Microsoft has posted 3 new courseware titles under the "What's New in SQL Server 2008" umbrella. ...
2008-04-14
1,403 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