PostgreSQL and Azure Data Studio
As I’ve been working more with PostgreSQL, I’ve found that I’m basically pretty happy just issuing SQL commands to get work done. However, it’s handy to have an actual...
2022-06-06
5 reads
Blog Posts
Power BI Adding Dynamic Hierarchies – XMLA, TOM, C#
This post is a continuation of my adventure into the Tabular Object Model and how we can use it to make Power BI scalable and incorporate it into existing...
2022-06-06 (first published: 2022-05-12)
254 reads
T-SQL Tuesday 151 Invite: T-SQL Coding Standards
T-SQL Tuesday is the blog party started by Adam Machanic (b|t) over a decade ago and is now maintained by Steve Jones (b|t) on tsqltuesday.com. On the first Tuesday of...
2022-06-06
43 reads
My First Technical Job – T-SQL Tuesday #150
I’m late to the party on May’s T-SQL Tuesday, but thought it was an interesting enough topic to be worth a belated blog post. It’s about first technical jobs...
2022-06-05
38 reads
Daily Coping 3 Jun 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-06-03
37 reads
Goal Progress for May 2022
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022. A few days late, and I missed April, but I’m...
2022-06-03
37 reads
How can I use the identity column, without knowing identity column’s name.
One of the most fun parts of blogging is when you learn something completely unexpected while writing a blog. The ... Continue reading
2022-06-03 (first published: 2022-05-12)
408 reads
Speaking on Ethics in Modern Data at Improving Edge 2022
Christine and I are looking forward to speaking at the Improving Edge conference, co-presenting our session on Monday, June 6th. Our presentation on “Ethics in Modern Data” features topics relevant...
2022-06-03
41 reads
Two Percent, Five Percent, More?
I was reading Seth Godin today and he makes this claim: If 2% of a population takes coordinated action, it makes a difference. If 5% do, it can change...
2022-06-03 (first published: 2022-05-12)
299 reads
Branding Yourself for A Dream Job Slides
Slides from today’s talk at DataGrillen Branding Yourself for a Dream Job.
2022-06-02
41 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