Database DevOps Metrics
DevOps includes the idea of measuring how code flows through your organization and looking for ways to improve your software development process. Steve has a few thoughts on the four main metrics many developments use.
Scales & Measurements
If you’re going to work with databases, you probably ought to know something about data. In particular, we don’t put data directly into a database; we have to encode it and represent it in a format which a machine can handle.
DeepSeek: What is new with this AI technology?
Learn how the DeepSeek GenAI LLM works and see how it produces SQL code.
Is GenAI Coming Faster Than You Think?
GenAI technologies have created a lot of concern among many tech workers. Steve has a few thoughts on how these technologies might impact data professionals.
Finding Out What Changed in a Cumulative Update
Over the last several years, Microsoft has been putting less and less effort into Cumulative Update documentation. We used to get full-blown knowledge base articles about fixes, but these days, we get a collection of footnotes with deceiving hyperlinks that look like they’re going to lead to more information – but they simply lead back to themselves.
Fantasy baseball and old habits
Old habits are hard to change sometimes. Time and again, regardless of what the task or query for information might be, my go-to source of information is Google. Whether on my phone or computer, my muscle memory instinctively opens a browser window or clicks into the search widget and starts typing. My “google foo” has […]
Implementing Fuzzy Search in SQL Server Using New Inbuilt Functions
Learn about the new string similarity functions in Azure SQL Database.
The Inefficiencies of Kubernetes
Kubernetes hasn't proved to be as useful to many companies as they expected.
Basic Regex Emulator for SQL Server
Regular expressions (REGEX) let you adaptively investigate, employ, and authenticate text data. This makes it easy to search for simple or complex string patters. There is no direct way to do this in SQL Server, but in this article we look at some SQL functions you can create to emulate regex like functionality.
The End of SQL Server 2019
Steve has a few thoughts after the end of mainstream support for SQL Server 2019.
Blogs
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers