Letter To My Father
We spread my Fathers ashes over the past weekend. It was one of the hardest things...
2019-09-06 (first published: 2019-08-22)
508 reads
Blog Posts
My Organizer's Notes and Goodbye after #SQLSatBR 2019
Some 2019 tips for other SQLSat organizers from my last year as lead organizer of SQLSatBR. I hope as a fellow organizer, you can pull some ideas and inspiration...
2019-09-06 (first published: 2019-08-21)
361 reads
Q&A: Dealing with Thousands of Databases (Part 3)
This is Part 3 in a three-part series. Please see Part 1 and Part 2 for more. There we go! Thank you Jon for sending in your questions. This...
2019-09-06
5 reads
Q&A: Dealing with Thousands of Databases (Part 3)
This is Part 3 in a three-part series. Please see Part 1 and Part 2 for more.
What does your average day look like?
I’m going to punt to my “A...
2019-09-06
6 reads
Q&A: Dealing with Thousands of Databases (Part 2)
This is Part 2 of a series. Please see Part 1 for the background and more. Stay tuned for the thrilling conclusion in Part 3, coming soon!
The post Q&A:...
2019-09-05
16 reads
Q&A: Dealing with Thousands of Databases (Part 2)
This is Part 2 of a series. Please see [Part 1]/2019/09/03/qa-dealing-with-thousands-of-databases/) for the background and more.
What is the most unexpected experience you’ve had in this position?
I have two answers...
2019-09-05
4 reads
SpeedPASS Printing
Based on the great post and script from Wayne Sheffield I decided to try again pre-printing the SpeedPASS for everyone this year. I dislike the line of shame and...
2019-09-05 (first published: 2019-08-21)
223 reads
SSIS Lookup Cache Modes
In SQL Server Integration Services, the lookup component is one of the most frequently used tools for data validation and completion. The lookup component is provided as a means...
2019-09-05
265 reads
VSCode Tips–Remove the Highlighted Line
VSCode was making me crazy as I was writing a script. I like a light theme, and every time I went to type, I saw this: The highlight was...
2019-09-05 (first published: 2019-08-23)
2,415 reads
Azure Storage Explorer
I only ever use the storage explorer when managing my blobs, files, queues within storage accounts. It is your single view access point for all your storage needs and...
2019-09-04
75 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