“Could you help me, we deleted the database’s transaction log file and now that database is stuck in ‘Recovery Pending’?” This was a panicked call that I received a...
2024-10-14 (first published: 2024-09-26)
471 reads
I’m hosting a webinar tomorrow with Rie Merritt from Microsoft. We’ll be talking about some of the sessions that Microsoft has planned for the PASS Data Community Summit as...
2024-10-14
5 reads
All Spark Connect Posts
I recently published the latest version of the Spark Connect Dotnet library which includes support for the new Variant data type in Apache Spark 4.0 here....
2024-10-12
9 reads
opia – n. the ambiguous intensity of eye contact The entry for this says “so much can be said in a glance, “ which I think is very true....
2024-10-11
68 reads
Recently, on a post celebrating a female professional earning a significant achievement within the cybersecurity field, another individual (male) commented wondering if this was due to DEI. The one...
2024-10-11 (first published: 2024-09-24)
248 reads
Recently I was trying to use a connection string to connect in SSMS. There are some tools that have a connection string available as an output, including some Redgate...
2024-10-11 (first published: 2024-09-25)
535 reads
This was actually a cool tip I saw internally from one of the product managers, when trying to find specific text in a migration. I’ve been working with Flyway...
2024-10-11
16 reads
The slides and scripts for my session “Tackling the Gaps & Islands Problem with T-SQL Window Functions” at dataMinds Connect 2024 can be downloaded from GitHub. If you want...
2024-10-10
19 reads
Look, we all know data is king these days. But having mountains of data and actually using it to make your business better are two different things. That's where...
2024-10-10
13 reads
I realized that I hadn’t done much blogging on Window functions in T-SQL, and I’ve done a few presentations, so I decided to round out my blog a bit....
2024-10-09
151 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I am getting the below error when I execute a SQL command in SQL...
I am getting the below error when I execute a SQL command in SQL...
Hi everyone. I have this table and this information. (left side of the image)...