Creating a Scripts Folder in SQL Compare
While I was at a conference recently, someone asked me about the Scripts Folder feature in SQL Compare and how to set that up. This post just looks at...
2024-01-05 (first published: 2023-12-20)
531 reads
Blog Posts
SELECT FORMAT(COUNT(1),’N’) FROM TableName WITH (NOLOCK);
Alternate title: How do I tell how far I am on that command? This little command (frequently with a WHERE ... Continue reading
2024-01-05 (first published: 2023-12-26)
1,063 reads
Skipping SQL Bits 2024
SQL Bits has been my favorite data platform event for years. Both it and the PASS Data Community Summit hold special places in my heard and I enjoy going,...
2024-01-04
25 reads
Create failed for Availability Group
Ever since the release of Always On Availability Group (AG or HADR) in SQL Server 2012 the adoption ratio is increasing. A lots of my clients too are adopting...
2024-01-03 (first published: 2023-12-25)
3,760 reads
Kusto (KQL) for Azure SQL Audit
According to Rod Trent, Kusto is named after Jacques Cousteau. He says, “We are exploring the depths of our data” by searching and querying our Azure log data. His...
2024-01-03 (first published: 2023-12-26)
315 reads
Career Plan for 2024
It’s a holiday today, but I’m dropping this as I spent last week working on it. I wrote about having a career plan on Friday, with a few notes...
2024-01-01
37 reads
Clearing Intellisense in SQL Prompt
I got this question from an account rep: if a customer is using SQL Prompt and a snippet, for example AT, that was also used as an alias, is...
2024-01-01 (first published: 2023-12-13)
271 reads
Spark Connect
Spark Connect References https://spark.apache.org/docs/latest/spark-connect-overview.html
https://www.databricks.com/blog/2022/07/07/introducing-spark-connect-the-power-of-apache-spark-everywhere.html
Reference Implementations Rust
GOLang
Source gRPC proto files https://github.com/apache/spark/tree/master/connector/connect/common/src/main/protobuf/spark/connect
Useful Videos If this doesn’t get you excited then nothing will it is, of course, suitable for work, it is...
2024-01-01
18 reads
A New Word: Koiniphobia
koinophobia – n. the fear that you’ve lived an ordinary life. The last one of the year. I’ve enjoyed reading through this dictionary, learning new (made up) words, and...
2023-12-29
205 reads
Can you take a differential backup of master?
In one of the sessions I attended during the Pass Data Community Summit the speaker asked “If master is in ... Continue reading
2023-12-29 (first published: 2023-12-19)
275 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