A Short Hiatus - WaterOx Consulting
Reading Time: 1 minutesGoing to get Digby access to a little more water to rest...
The post A Short Hiatus appeared...
2015-06-10
367 reads
Chris
006 – Personal Trainer - WaterOx Consulting
Reading Time: 5 minutesDo You Have a Personal Trainer? In WOxPod!, episode # 006 –...
The post 006 – Personal Trainer appeared first...
2015-06-05
498 reads
Blacklist a Set of IPs - WaterOx Consulting
Reading Time: 3 minutesWe talked about whitelisting IPs before, but what about the opposite, blacklisting...
The post Blacklist a Set of...
2015-06-03
439 reads
005 – Antiques Roadshow - WaterOx Consulting
Reading Time: 4 minutesAre You Running An Antiques Roadshow? In WOxPod!, episode # 005 –...
The post 005 – Antiques Roadshow appeared first...
2015-05-29
1,099 reads
SQL F.A.D. – CSV List of Columns - WaterOx Consulting
Reading Time: 2 minutesI had a project once that was using change data capture (CDC)...
The post SQL F.A.D. – CSV List...
2015-05-27
473 reads
SQL F.A.D. – Average Transactions Per Day - WaterOx Consulting
Reading Time: 2 minutesSometimes Fast & Dirty is OK. Other times, not so much. Sometimes...
The post SQL F.A.D. – Average Transactions Per...
2015-05-25 (first published: 2015-05-13)
5,797 reads
004 – Cracked Foundation - WaterOx Consulting
Reading Time: 4 minutesDo You Have a Cracked Foundation? in WOxPod!, episode # 004 –...
The post 004 – Cracked Foundation appeared first...
2015-05-22
348 reads
SQL F.A.D. – Daily Identity Reset - WaterOx Consulting
Reading Time: 3 minutesSometimes you have to do some things considered pretty strange in your...
The post SQL F.A.D. – Daily Identity...
2015-05-20
371 reads
Identity Removal - WaterOx Consulting
Reading Time: 2 minutesMen In Black are not the only ones that can remove an...
The post Identity Removal appeared first...
2015-05-19 (first published: 2015-05-06)
6,420 reads
003 – The Data Guild - WaterOx Consulting
Reading Time: 5 minutesAre you an Apprentice DBA? in WOxPod!, episode # 003 – The...
The post 003 – The Data Guild appeared first...
2015-05-15
504 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