The parts of an object’s name
Any object within a database in SQL Server has what is called a four part name. Which rather implies four...
2017-03-20
371 reads
Kenneth Fisher
Review of Azure Fundamentals class on Openedx
My company has recently adopted a Cloud first attitude. Now that’s different from Microsoft’s Cloud first. Microsoft is putting new...
2017-03-08
514 reads
Queries with optional parameters
These are those queries where you are pulling for, let’s say, a first name, a last name, a state, and/or...
2017-03-06 (first published: 2017-02-27)
3,538 reads
Using GROUP BY instead of DISTINCT
Recently, Aaron Bertrand (b/t) posted Performance Surprises and Assumptions : GROUP BY vs. DISTINCT. In it he says he prefers GROUP...
2017-03-06
2,441 reads
Event storming! It’s raining emails!
One of the most common ways to get an event notification is by email. So what happens when you get...
2017-03-01
386 reads
What’s in my backup file?
Restoring a backup file is pretty easy right?
RESTORE DATABASE [Test] FROM DISK = 'C:\backups\backup.bak';Ok, but what if more than one database...
2017-02-22
947 reads
Penny wise, pound stupid
Growing up my mother used this phrase quite a bit. Penny wise, pound stupid. (In case you didn’t know the...
2017-02-20
423 reads
Deadlock priority
Everyone deals with deadlocks from time to time. But sometimes we need to control who’s the deadlock victim and who...
2017-02-17 (first published: 2017-02-08)
2,913 reads
Deadlock on ALTER DATABASE
I had an interesting problem recently. A database was stuck in single user mode. How exactly was it stuck you...
2017-02-16
1,423 reads
Server level database permissions
Sometimes you have a requirement to grant permissions to every database on an instance. Historically this has required creating a...
2017-02-14
732 reads
Blogs
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...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
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