There’s A New North Central Regional Mentor
What has two thumbs and just signed on to be a PASS Regional Mentor? This guy!
Over the past couple weeks,...
2011-03-17
690 reads
StrateSQL
Happy Pi Day
Here’s wishing you a Happy Pi Day…
Pi in Pie Pan
If my picture isn’t good enough, here’s a better representation of...
2011-03-14
499 reads
March PASSMN Meeting This Week
I mentioned the PASSMN meeting last week and thought a reminder might be worthwhile. Just in case you head has...
2011-03-13
581 reads
Aggregating With Correlated Sub-Queries #tsql2sday
It’s that time of the month again. Time for T-SQL Tuesday! This month’s event is being hosted by Jes Schultz...
2011-03-08
691 reads
SSWUG DBTechCon Coming Up
Over the last few years, I’ve blogged about and spoke at the SSWUG Virtual Conferences. It’s that time of the...
2011-03-07
471 reads
XQuery for the Non-Expert – Aggregates
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
In the...
2011-03-07
1,254 reads
March PASSMN Meeting Announced
Come one, come all to the March PASSMN meeting – that’s the Minnesota SQL Server User Group. This month we’re going...
2011-03-04
658 reads
TechFuse 2011 – This Month
If you’re looking for a day of training in the Twin Cities, then check out Benchmark Learning’s2011 TechFuse event. The...
2011-03-02
610 reads
FileSystemHelper Update and Release
About a year ago, I started playing around with CLR and my desire to disable xp_cmdshell for my clients. As...
2011-02-23
483 reads
Can You Dig It? – Plan Cache Series
She can dig it!
D Sharon PruittA few PASS Summit’s ago, I became interested in the information available in the...
2011-02-18
577 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