Time Off, Recharge, Rethink
Some of you may have noticed that I haven’t posted for a while. The 12th May was the date of...
2010-05-25
624 reads
Gethyn Ellis
Are Transaction Rolled Back When CHECKDB Runs?
Ever come across a scary error in the SQL Server log when running CHECKDB against your databases. The error looks...
2010-05-12
513 reads
SQL Server Integrity Checks – DBCC CHECKDB
I like to run integrity checks against my databases very regularly, sometimes daily if I can get away with it....
2010-05-05
2,179 reads
SQL Server Replication - Replication Agents
My first post in my replication series gave a brief overview of replication, before I dive into setting up and...
2010-05-04
7,199 reads
When was SQL Server last restarted?
How do you tell when your SQL instance was lasted restarted?
I was reading a post by Joe Webb (Blog|Twitter) about...
2010-04-29
6,173 reads
SQL Server Connection Strings
The purpose of this short post is to demonstrate a simple method of generating an accurate SQL Server connection string...
2010-04-28
13,577 reads
SQL Server Replication Overview
For my next series of blog posts I intend to document and write about SQL Server replication. This is a...
2010-04-27
2,494 reads
Microsoft Teleconference – Ted Kummert (Senior VP) and Tom Casey (General Manager of BI)
Microsoft held a big teleconference today, which I unfortunately got called away from a minutes into it. The call was...
2010-04-21
593 reads
Virtualisation – An Introduction
For the last two years or so, in one capacity or another I have been running SQL Server in virtual...
2010-04-21
653 reads
SQL Server 2008 R2 – Release Date
This is a very short post
I’m probably very late to this party but…SQL Server 2008 R2 is scheduled for release...
2010-04-15
512 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