Foreign Keys in SQL Data Generator
A customer recently asked about using FKs in SQL Data Generator, and I decided to write a short post showing how these work. The Scenario I’ve got a copy...
2024-03-06 (first published: 2024-02-26)
312 reads
Blog Posts
How Redgate’s Test Data Manager Can Enhance Automated Testing
A brief overview of the benefits and challenges of automated testing and how Redgate’s Test Data Manager can help. Automated testing uses software tools to execute predefined tests on...
2024-03-06 (first published: 2024-02-26)
154 reads
Adding Git LFS Support – #SQLNewBlogger
I got this message recently while committing some changes: This post shows my work in adding Git LFS support to GitHub. Another post for me that is simple and...
2024-03-04 (first published: 2024-02-21)
171 reads
Know Thy Platform
IT and data professionals, I implore you – know thy platform. All of it. Not just the layer your job is tasked with. Modern public cloud (or any infrastructure...
2024-03-04 (first published: 2024-02-22)
210 reads
The Redgate Summit in Atlanta
Navigating the Database Landscape is the headline of our Redgate Summit in Atlanta on Mar 13. I’m doing the Keynote with Grant Fritchey and Kathi Kellenberger with this title,...
2024-03-04
70 reads
A New Word: Aesthosis
aesthosis– n. the state of feeling trapped inside your own subjective tastes – not knowing why you find certain things beautiful or ugly, only that you do – wishing...
2024-03-01
75 reads
EightKB 2024
EightKB is back! The biggest online SQL Server internals conference is back in 2024…it’s all happening on August the 8th! We’ve open our call for speakers, you can submit...
2024-03-01 (first published: 2024-02-21)
250 reads
Friday Flyway Tips–Capture the Filegroup for Tables
A customer asked recently why Flyway doesn’t detect the filegroup for some changes. I showed them it does and decided to write a post on this. I’ve been working...
2024-03-01 (first published: 2024-02-16)
159 reads
Friday Flyway Tips–Quick Command Line Access
One of the things I had to do recently in a demo was access the Git command line. The way I did it impressed a customer, so I put...
2024-03-01
45 reads
Elevate Your Data Leadership: A Unique Intensive Learning Experience
I’ve collaborated with two industry experts to design a transformative course for data leaders: “The Technical and Strategic Data Leader.” This six-week intensive learning journey is crafted to elevate...
2024-02-28 (first published: 2024-02-16)
327 reads
Blogs
Data Viz in Fabric Notebooks
Lots of people have created Power BI reports, using interactive data visualizations to explore...
App-Consistent MongoDB Snapshots Across Multiple Pure Storage FlashArrays
Introduction When you’re running MongoDB at scale with data distributed across multiple Pure Storage...
PASS: Quantum Computing Slides
By Brian Kelley
If you're an attendee at the PASS Data Community Summit this year, there are...
Forums
Filtered Indexes: The Developer’s Secret Weapon in SQL Server
Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...
Is Data Modeling Common?
Comments posted to this topic are about the item Is Data Modeling Common?
Getting The Database Name
Comments posted to this topic are about the item Getting The Database Name
Question of the Day
Getting The Database Name
I run this code to connect to SQL Server 2022 from the command line.
sqlcmd -S localhost -EAt the command line, I run these two commands:
SELECT ORIGINAL_DB_NAME() GOWhat is returned? See possible answers