Fun with Savepoints–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-11-30 (first published: 2018-11-15)
1,899 reads
Determine database version from a bak file
Have you ever imagine you can determine the version of SQL Server from a bak or a MDF file? I...
2018-11-26 (first published: 2018-11-15)
18,209 reads
Monitor Database Offline Events
Hopefully, a database being taken offline is a known event and not a surprise. Occasionally there are gremlins, in the form of users with too many permissions, that tend...
2018-11-15
133 reads
Monitor Database Offline Events
The other day, I shared an article showing how to audit database offline events via the default trace. Today, I...
2018-11-26 (first published: 2018-11-15)
1,928 reads
Parameterized dynamic SQL is parameterized.
Ok, that title sounds silly, but it’s actually a real point. The first parameterized refers to using parameters within dynamic...
2018-11-23 (first published: 2018-11-15)
2,534 reads
Microsoft Professional Program vs Microsoft Certification
When learning new technologies many people will go towards training courses (in person or online) but many also go for...
2018-11-15
264 reads
TSQL Tuesday #108 – Learning to Learn
G’day,
One attribute that I think is more relevant today than ever is to have a broad base of skills with...
2018-11-15
192 reads
Switching blog website
For quite some years now I have been active on my blog over at www.dotnine.net. While there was nothing wrong with...
2018-11-14
201 reads
Dates and Times in SQL Server: DATEADD()
We are now in the home stretch of the long-running series about dates and times in SQL Server and Azure...
2018-11-14
251 reads
Fix My Functions: Speeding Up Scalar and Table Valued UDFs (video)
Last week, I was lucky enough to present on the topic of TSQL User Defined Functions (UDFs) in SQL Server at the PASS Summit. My session was live-streamed, and...
2018-11-14
112 reads
Blogs
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
SQL Server gMSA: Why So Many DBAs Still Aren't Using It in 2026
By SQLPals
SQL Server gMSA: Why DBAs Still Aren't Using It in 2026 ...
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
Forums
Fulltext filter daemon host (FDHost) process has stopped abnormally
We have performed a side-by-side upgrade, from SQL Server 2016 to 2022 Developer Edition,...
Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer
Comments posted to this topic are about the item Automating OSM Data Refresh in...
Database Mail Configuration
Comments posted to this topic are about the item Database Mail Configuration
Question of the Day
Database Mail Configuration
If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?
See possible answers