Flyway Desktop PoC–Adding a Shadow and Baseline Script
In the last post, I created a baseline marker for Flyway in each database. This set the version in the dev and QA databases to v1. However, I also...
2023-04-12
30 reads
Blog Posts
How to Change the Browser Used by SSMS for AAD Auth
Did you know that you can change the browser used by SQL Server Management Studio to authenticate using Azure Active Directory to a SQL database in Azure? I had...
2023-04-12 (first published: 2023-03-28)
592 reads
Using SQL Alerts to Spot Suspicious Activity in SQL
SQL doesn’t really give us too many tools out of the box to allow us to spot when someone may be up to no good. We can look at...
2023-04-12 (first published: 2023-03-29)
546 reads
Reasons Why SQL Servers Don’t Get Configured to Industry Best Practices
Throughout my career, I’ve worked on a LOT of different SQL Servers. Many that were installed and configured by application administrators, developers, vendors, and data professionals. I’ve seen servers...
2023-04-11
7 reads
Creating a Simple Graph in RedisGraph
I delivered a session on graph databases, and in it I used RedisGraph to show how you can work with graph data on that platform. This blog shows a...
2023-04-10
64 reads
New Job -> Week 2 -> Creating a Checklist
This is part of a series of new job blog posts. You can find them all here. Last week was the first week of the rest of my life....
2023-04-10 (first published: 2023-03-24)
547 reads
Tales From The Field Weekly Wrap Up for the Week of 04-03-2023 & Easter
Hello Dear Reader! Hopefully you had a great weekend. This weekend was filled with gatherings. On Saturday we gathered with friends and had a really nice Game Night.... where...
2023-04-10
11 reads
Why i use a smaller docker image part I
What is Docker? Docker is a famous platform for building, shipping, and running container applications. What are containers? Containers are a way to package software in a portable and...
2023-04-10 (first published: 2023-03-27)
242 reads
Converting Types in C#
I am not a great software developer. I’m OK, and I do know how to use Google and Stack Overflow well. Maybe my best skill is wording searches well?...
2023-04-07 (first published: 2023-03-22)
265 reads
Dropping Career Goals for Q2
I set goals at the beginning of 2023 for Q1. I didn’t do well, as my evaluation earlier this week has a D for my efforts. I’m re-evaluating things,...
2023-04-07
13 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