2019-07-12 (first published: 2015-04-28)
377 reads
Editorial
Email In The Bathroom: Not A Universal Good
Here are some fine, affordable products to completely destroy your work-life balance.
2015-04-27
162 reads
Microsoft Exercise
We have got a deal for you, Microsoft is concerned about the health of your company and is doing something about it.
2019-06-07 (first published: 2015-04-27)
1,103 reads
Code Reviews
This week Steve Jones asks about a concept that he used early in his career: code reviews. It's a good practice, but it seems as though it's fallen out of favor with many developers.
2018-12-14 (first published: 2015-04-24)
234 reads
Your Role Is Changing
The DBA role is changing with the growth of DevOps as a way to better build software in an organization.
2015-04-23
228 reads
Security Through Chaos
A company Steve Jones knows uses a diverse network infrastructure to help provide security.
2015-04-22
111 reads
Would a Duress Password be a Good Idea?
Today we have a guest editorial from Andy Warren. Should we adopt a duress password, just in case we find ourselves in a movie situation while at work?
2019-09-26 (first published: 2015-04-21)
491 reads
Sweeping out SQL Server 2005
Tony Davis on why the dusty corners of many organizations still hide numerous SQL 2005 instances.
2015-04-20
150 reads
Embrace Stored Procedures
Developers working with SQL Server should learn to embrace stored procedures. They really, really do work well.
2018-11-01 (first published: 2015-04-20)
563 reads
Monitoring After Deployment
This Friday's poll looks at the time after deployment. Can you tell if things were successful? Do you have a formal way to determine if the changes are causing issues?
2019-06-04 (first published: 2015-04-17)
369 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