2015-01-23
370 reads
Editorial
Getting IT Out of the Data Center
Technology shouldn't just be a cost sink in an organization, at least that's what Steve Jones thinks.
2015-01-22
114 reads
R-E-S-P-E-C-T
There's one word that can make a difference in how much you like your job. Steve Jones has a few thoughts today.
2015-01-21
221 reads
The Cost of Switching
With so many companies looking at other platforms, when should an organization consider changing their database? Steve Jones has a few thoughts.
2018-11-08 (first published: 2015-01-20)
251 reads
Where Microsoft went wrong with SQL CLR
We database developers would, of course, like easy access to all the .NET delights, such as the excellent Regex library, but we don't want a Do-It-Yourself kit to achieve this. So argues Phil Factor.
2018-12-12 (first published: 2015-01-19)
457 reads
Taking Care of Things Today
Steve Jones talks about procrastination today and how you might not want to do that with your SQL Servers.
2015-01-19
110 reads
Debugging SQL Server
This week we have a more technical poll as Steve Jones wonders how you best debug your T-SQL code.
2019-05-27 (first published: 2015-01-16)
463 reads
A Little Empathy
Perspective makes a big difference and Steve Jones looks at how you might change the way you think about clients, customers, and the work you do.
2015-01-15
140 reads
Hadoop and SQL Server
Hadoop is a technology that's getting quite a bit of attention in the last few years, including integration with SQL Server. Steve Jones talks about the technology and how it might fit in your career.
2015-01-14
676 reads
Testing
We know that software testing is important, but we often don't do a great job of executing. Steve Jones talk database testing today.
2015-01-13
219 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