Backing up the Teslamate Database
I was worried about some of my data, so I wanted to be sure I had a backup of my Teslamate system. This post covers the config I’d added...
2024-01-08
99 reads
Blog Posts
Careful When Changing SQL Server Database File Extensions
I recently had a friend reach out to me about database performance dropping drastically. I asked if anything had changed recently on the server, and they told me that all...
2024-01-08
19 reads
SQL Server Blog quarterly review
This SQL Server blog roll talks about the few blog articles I have published in last couple of months. I am certain you would like reading
The post SQL...
2024-01-08 (first published: 2024-01-01)
227 reads
2023 in Review – Steve’s Perspective
2023 was another transition year as I continue to navigate my ALS with work. It has become harder to write or at least more work is required. I use...
2024-01-05
39 reads
A New Word: agnosthesia
agnosthesia – n. the state of now knowing how you really feel about something, which forces you to sift through clues hidden in your own behavior, as if you...
2024-01-05
60 reads
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)
536 reads
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,071 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
30 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)
4,075 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)
321 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
How to change the FDLaunch Error log file location
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers