EightKB is back! The biggest online SQL Server internals conference is back in 2023…happening on May 24th. We’ve open our call for speakers, you can submit here: – https://sessionize.com/eightkb-may-2023/...
2023-01-30 (first published: 2023-01-23)
158 reads
I have a Logic App that reads out a SharePoint library and stores all the documents found into Azure Blob Storage (ADF only supports Lists). I was trying to...
2023-01-30 (first published: 2023-01-18)
68 reads
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to make sure we are prepared for the scenario where something goes wrong. For instance, if...
2023-01-30
18 reads
Over the last year, at work and after work, I’ve been teaching myself a lot of brand new technologies. As such, I’m reliant on others to have put together...
2023-01-30
8 reads
My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend and colleague Ben E. Weissman, is now available on Pluralsight here! If you want to...
2023-01-28
13 reads
Today’s coping tip is to try something new to get out of your comfort zone. I did two things here. First, I’ve been participating in a Jan American Cancer...
2023-01-27
11 reads
In a previous post, I got Flyway installed as a CLI utility (command line interface). This post will look at the first connection to a database. If you need...
2023-01-27 (first published: 2023-01-11)
392 reads
Problem Recently I had a situation where I was looking at a SQL Instance due to a contractor who controls the system wanting to drop
The post Impact of Eliminating...
2023-01-27 (first published: 2023-01-18)
273 reads
I am very excited and lucky to be speaking once again at SQLBits along with my DCAC colleagues. SQLBits, the largest Data Platform conference in Europe, held this year...
2023-01-27
58 reads
Monitoring for Problems The encryption of your existing data occurs as a background process referred to as the encryption scan, but it will consume resources while it runs, so...
2023-01-27
187 reads
Lots of people have created Power BI reports, using interactive data visualizations to explore...
Introduction When you’re running MongoDB at scale with data distributed across multiple Pure Storage...
By Brian Kelley
If you're an attendee at the PASS Data Community Summit this year, there are...
Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...
Comments posted to this topic are about the item Is Data Modeling Common?
Comments posted to this topic are about the item 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