Last Week Reading (2019-01-20)
Hello folks! Good morning on Monday morning and let’s go through some interesting news from the #data world. Press Using...
2019-01-20
157 reads
Blog Posts
Containerization
Docker has containers to work on processes or application. now docker containers has some limitations as it uses resources from...
2019-01-19
122 reads
Error – Hung Docker
Sometime when you not actively working on Docker and on you are not actively working on the system. it could...
2019-01-19
212 reads
New page on this blog: Contact Me
This is not a technical post! Just wanted to say that I set up a public email address for this...
2019-01-19
132 reads
DBA Jobs: Threats and Opportunities (Dear SQL DBA Episode 66)
Jobs change over time, and database administrator jobs are no different. In this 35 minute recorded Twitch livestream (my first ever!) I talk about threats to DBA jobs and...
2019-01-18
7 reads
Error : DBCC could not obtain a lock on this object because the lock request timeout period was exceeded
DBCC CheckDB failed with error “DBCC could not obtain a lock on this object because the lock request timeout period...
2019-01-18
1,336 reads
Pro SQL Server on Linux–Getting Started
As part of my learning goals for 2018, I wanted to work through various books. This is part of my...
2019-01-18 (first published: 2019-01-04)
1,915 reads
Supercharge Your SQL Server Scalar Functions By Switching To Table Value Functions
User defined functions in SQL server can cause all kinds of performance problems, there are however some tricks that are...
2019-01-18
286 reads
The Necessary Extras That Aren’t Shown in Your Azure BI Architecture Diagram
When we talk about Azure architectures for data warehousing or analytics, we usually show a diagram that looks like the...
2019-01-18 (first published: 2019-01-11)
2,374 reads
3 Key Points from My Upcoming Talk, “DevOps: What, Who, Why, and How?”
Next week, I’m giving a free webcast for Redgate on DevOps fundamentals. DevOps is something I am a big proponent of for database administrators, developers, and company leaders. The...
2019-01-17
3 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
SQL Server 2019 - Agent job PowerShell step issue
I have a couple of SQL Agent job steps which run PowerShell commands of...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers