Daily Coping 26 Dec 2022
Today’s coping tip is to see how many people you can smile at today. Easy one for me. I find this makes me happier and my day better when...
2022-12-26
13 reads
Blog Posts
My Stats from 2022
I wrote last week about my travel, 23 trips in 2022. However, I’ve been gathering some other stats about my life and what I do, so I wanted to...
2022-12-26
20 reads
Types of data consulting engagements and what you can expect from them
There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The type of engagement you choose affects the pace and deliverables of the project, and the...
2022-12-26 (first published: 2022-12-06)
219 reads
A Big Year for Travel
I do tend to travel a good amount as my kids have gotten older. The pandemic slowed things for a year, but only then. Someone remarked on this year...
2022-12-23
13 reads
Advent of Code 2022
Foreword
Advent of Code is an annual event in which participants solve a series of coding puzzles. It typically begins on December 1 and runs through the end of the...
2022-12-23 (first published: 2022-12-08)
160 reads
Daily Coping 23 Dec 2022
Today’s coping tip is to be generous. Feed someone with food, love, or kindness today It’s often a family day today, as work ends and we prepare for Christmas....
2022-12-23
10 reads
T-SQL Tuesday #157–The End of Year
It’s that time of the month, and I’m late. I’ve been on holiday for a week, so this is a quick post for T-SQL Tuesday. This month is hosted...
2022-12-23 (first published: 2022-12-13)
232 reads
Daily Coping 22 Dec 2022
Today’s coping tip is to buy an extra item and donate to a local food bank. The food banks in my area are only open limited days, especially post...
2022-12-22
15 reads
Daily Coping 21 Dec 2022
Today’s coping tip is to listen wholeheartedly to someone else, without judging them. I get the chance to talk with lots of people. I make it a point when...
2022-12-21
12 reads
Effectively Integrating FHIR Data from Azure Health Services
This blog is intended to be a follow up from the SQL Saturday 2022 in Oregon & SW Washington. In that session I presented an introduction to FHIR and...
2022-12-21 (first published: 2022-12-13)
277 reads
Blogs
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...
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
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