The Post Pandemic Office Experience
I traveled to Pasadena, CA this week to work with a few other Redgaters in an office. There was a get together planned this week for the entire staff,...
2021-07-26
17 reads
Blog Posts
The Second Annual, Official WordPress.com Growth Summit is Coming and You Won’t Want to Miss It
Join us online August 17 (Americas) or August 18 (Asia-Pacific). Register today!
2021-07-26
23 reads
Container Limits and SQL Server
Limits in Containers Docker gives you the ability to control a container’s access to CPU, Memory, and network and disk IO using resource constraints, sometimes called Limits. You define...
2021-07-25
20 reads
Crocs and Naps….
I was planning a blog post for a TSQL2sday..instead would up writing an obituary blog post for a dear friend who passed on yesterday. Brian Moran was among the...
2021-07-23 (first published: 2021-07-10)
353 reads
Daily Coping 23 Jul 2021
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...
2021-07-23
11 reads
Data Mesh: Centralized ownership vs decentralized ownership
I have done a ton of research lately on Data Mesh (see the excellent Building a successful Data Mesh – More than just a technology initiative for more details),...
2021-07-23
22 reads
Inspector V2.6 now available
As always the code can be found here in our github repoWe updated our sample report here We forgot to mention V2.5! We added the ability to add Thresholds...
2021-07-23
112 reads
Interview with the Amazing Kellyn Pot’Vin-Gorman
Thanks for agreeing to do this Kellyn. I’ve always found you to be one of the more interesting personalities in ... Continue reading
2021-07-23 (first published: 2021-07-08)
247 reads
Daily Coping 22 Jul 2021
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...
2021-07-22
15 reads
Make Your Best Photos Shine
Photos on your website can be a representation of who you are, what you do, or what you love. We want your photos to show to your visitors as...
2021-07-22
24 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
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