Burnout
Doing the same thing for too long, and not enjoying it, isn't good for anyone. You might be burned out, or as Steve Jones notes, you might need to change our perspective.
2018-10-29 (first published: 2015-02-09)
415 reads
Editorial
Programming Rules and 'Best Practices' Can't Replace Professional Judgement
In which Phil Factor casts doubts on 'programming policies'. For certain, any IT team development requires plenty of methods of working that maximise productivity, but coding standards and ‘best practices’ have to be treated with caution. Programming rules can’t replace professional judgement
2015-02-09
209 reads
Interrupt Me, I'm Stagnating
Today we have a guest editorial from Andy Warren with a few hints on how you can continue to be proactive as a DBA.
2015-02-05
197 reads
The Number that shouldn't be a number
Gail Shaw is often left bewildered by the weird and wonderful data types people choose for their tables, when storing something as simple as a telephone number or a date.
2024-07-12 (first published: 2015-02-02)
705 reads
2019-05-28 (first published: 2015-01-30)
411 reads
You Better Learn to Work at Scale
We are managing more and more systems and databases all the time. To Steve Jones, that means we must be able to work at scale.
2015-01-29
151 reads
Normal Data
More and more people are starting to perform data analysis, including DBAs, but they should be aware of what normal means for data.
2018-10-10 (first published: 2015-01-28)
201 reads
Time for Learning
How do you find time for learning? More importantly, Steve Jones asks if you find time for actual use of your knowledge.
2015-01-27
266 reads
Deploy the Database First
Steve Jones thinks it's important that we be able to deploy almost any changes to our databases without breaking applications.
2018-12-17 (first published: 2015-01-26)
184 reads
Which Problem Are You Solving?
This week Steve Jones talks a bit about problem solving and how you should approach the issue.
2015-01-26
106 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