Upgrade and Refresh, or Not?
Today we have a guest editorial from Andy Warren that looks at the upgrade cycle and how that affects our jobs.
2015-03-06
132 reads
Editorial
2015-03-04
565 reads
Holidays as Benefits
When you take a job, do you ask about holidays? Do you consider them a benefit? Andy Warren asks what those holidays might mean to you.
2018-10-25 (first published: 2015-03-03)
217 reads
Pier to Pier Replication on Frozen Lake Erie
In a guest post, Rodney Landrum ponders the gaps in his DBA experience at the edge of Lake Erie.
2015-03-02
118 reads
No State Based Deployments
Today Steve Jones talks about deploying your database changes, and how you can't ever really depend on a state based approach.
2019-05-21 (first published: 2015-03-02)
297 reads
The Express Choice
This week Steve Jones wonders if you'd be willing to use Express edition in production situations.
2015-02-27
133 reads
Building Small Habits
Today Steve Jones talks about development, and finding ways to make small changes that improve your code.
2015-02-26
204 reads
Small Leadership
Today Steve Jones talks leadership, and the value it can bring to your team if you display just a little of it.
2015-02-25
139 reads
Making Plans
PASS President Tom Larock doesn't make long term plans. Steve Jones doesn't make long term plans. Do you?
2015-02-24
123 reads
Microsoft and Minecraft and Training Kids
Today we have a guest editorial from Andy Warren, looking at learning.
2019-05-15 (first published: 2015-02-23)
495 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