Daily Coping 25 May 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-05-25
22 reads
Blog Posts
Data is not immutable
Information — in the form of data — usually stored as binary 1s and 0s in an electronic data store, is not immutable. Even the hardiest data storage designed...
2022-05-25
45 reads
Logic Apps and Source Control (with PowerShell)
At a data warehouse project I’m using a couple of Logic Apps to do some lightweight data movements. For example: reading a SharePoint list and dumping the contents into...
2022-05-25 (first published: 2022-04-20)
332 reads
Reblog from Brent Ozar: Designing a Data Model for Gender and Sexuality (Oh And Also, I’m Pansexual)
This is a repost of a blog by Brent Ozar. I seriously doubt anyone reading this post hasn’t seen Brent’s ... Continue reading
2022-05-25
38 reads
Reblog from Brent Ozar: Designing a Data Model for Gender and Sexuality (Oh And Also, I’m Pansexual)
This is a repost of a blog by Brent Ozar. I seriously doubt anyone reading this post hasn’t seen Brent’s ... Continue reading
2022-05-25
32 reads
Techorama 2022 – Session Materials
You can find my slidedeck for the session “Introduction to Azure Data Factory” on Github:https://github.com/KoenVerbeeck/SessionMaterials All demos given in the session are explained in the ADF tutorial at MSSQLTips.com.
The...
2022-05-25
23 reads
Visualizing SQL
While I think SQL is interesting, I know some people struggle with the way the language work. Someone at work posted a link to this site: https://animatesql.com/ I think...
2022-05-25 (first published: 2022-04-18)
1,589 reads
Daily Coping 24 May 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-05-24
23 reads
New Extended Events in SQL Server 2022
SQL Server 2022 CTP is here
It has been announced today (2022-05-24) during the MS Build event. The blog post includes a download link. Unfortunately, the Docker container is...
2022-05-24
26 reads
Notes on SQLSaturday Jacksonville 2022
I drove up to Jacksonville Friday afternoon to allow for bad traffic and immediately hit bad traffic, all four lanes of I-4 blocked that resulted in a 30 minute...
2022-05-24
69 reads
Blogs
Don’t Miss Out – SQL Server 2025 Unleashed Training Starts Next Monday!
Next Monday, Marchg 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
What is ALM in Fabric?
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
The Most Successful Startups in 2025 — And What They Have in Common
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
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