[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
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Setting PK Names in Redgate Data Modeler
By Steve Jones
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
Forums
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...
Semantic Search in SQL Server 2025
Comments posted to this topic are about the item Semantic Search in SQL Server...
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