The Ease of Containers
Containers have changed how to develop and deploy software. They haven't caught on with databases as much, but Steve thinks this will change.
2021-03-10
146 reads
Editorials
Distributed SQL Databases
There are new platforms out there that promise a distributed SQL relational database. Steve talks about a few today.
2021-03-09
426 reads
Disclosing the How
As we use more Artificial Intelligence and Machine Learning tools in our applications, we need to understand how they work.
2021-03-08
77 reads
Stories to Engage Us
I've always been fascinated by history. For a long time growing up, my plan was to become a history teacher. While that didn't work out, I've continued to read quite a lot of history, both popular and scholarly works. One of the things about it that I find most fascinating are the stories. History is […]
2021-03-06
47 reads
Making Guesses
When working on a new database, Steve Jones hesitates to make too many guesses, or at least, too many exact guesses.
2021-03-05 (first published: 2015-08-11)
214 reads
An Amazing Interview
There are many amazing candidates in IT, but how many can give an amazing interview. I feel I can't, can you?
2021-03-04
299 reads
You know what we really need? Better interpersonal communication
Today we have a guest editorial as Steve is traveling. Ben Kubicek notes that sometimes it is hard for technical people to communicate well.
2021-03-03 (first published: 2016-09-08)
204 reads
Using Dynamic SQL
Today Steve notes that Dynamic SQL can be helpful, but it's a technique you should understand well before you start using it.
2021-03-02
246 reads
Viva
Microsoft is working on the future of work, and adapting to remote work. Steve isn't sure this will work, but they have at least one interesting technology idea he likes.
2021-03-01
123 reads
Common Table Expression Misunderstandings
I frequently use Common Table Expressions (CTEs) when I demo windowing functions and get questions about them. Windowing functions are limited to the SELECT and ORDER BY clause which means that you can’t filter or group on them directly. Using a CTE is one way to separate the logic of the query into multiple steps […]
2021-02-27
4,683 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
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...
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