How Often Do You Patch?
Patching is a chore that any system administrator needs to deal with. As SQL Server 2016 moves out of mainstream support, Steve asks if you have a plan and how often you ensure systems are patched.
2021-07-23
270 reads
Editorials
The Danger of Management Access
First we had the Solarwinds hack, and now we have a Kaseya ransomware epidemic. It seems the criminals are moving up the stack. We used to see physical attacks on tapes and keyboards, then we saw OS level attacks. Now we seem to be getting to the management layer for software that is used to […]
2021-07-21
303 reads
Seriously Real Time Data Processing
Autonomous cars provide a great environment for large scale, real-time data processing.
2021-07-19
420 reads
Taking time off
Time is a precious commodity, and so much of our time is dedicated to working. IT professionals often have jobs with good benefits, including generous paid time off. It’s important to get away from work to relax and recharge, but, sometimes, it’s difficult to take those days that belong to us. Even when we do […]
2021-07-17
104 reads
Messy Job Descriptions
Job descriptions can be messy and intimidating, but Steve notes that they aren't ever going to be perfect. Work with that to find the job or candidate you need.
2021-07-16
269 reads
Improving DevOps Automation
Steve notes that his employer is re-evaluating their build and release process, in a true DevOps fashion to improve the way they build software.
2021-07-14
135 reads
Enterprise Software
Building software in an enterprise is hard, and often, large organizations don't quite know how to do it.
2021-07-12
477 reads
Do We Need to Learn Linux?
An announcement on Windows containers has Steve noting that Linux might be a more desired skill in the future for SQL Server professionals.
2021-07-10
204 reads
Fixing Report Visuals
Building reports and visualizations isn't as simple as we would like. Learning a bit about how to better design them is important.
2021-07-09
147 reads
How Do You Decide to Rollback?
One of the constant questions I get from Redgate customers is about rolling back database changes. We build software to help you deploy changes, but what about rollbacks? I think I've heard this in almost every conversation I've had on this topic in the last 5 years. It's one reason that Flyway has undo, though […]
2021-07-07
453 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers