Mssql-cli Command-Line Query Tool
A recent announcement on the release of several SQL Server tools has raised expectations across various groups. Product requirements and business...
2018-05-11
900 reads
Blog Posts
SQL Server Database Snapshots
What Are They
Database snapshots are a readonly point in time version of a database. You can use them for things...
2018-05-11
2,260 reads
YouTube Channel Update: 11 May 2018
I’ve been busy getting the videos up on YouTube. If they’re helpful to you, please subscribe. Some point soon I’ll...
2018-05-11
231 reads
Creating SQL Server Containers for versions 2012-2017
I am working on my dbatools and dbachecks presentations for SQL Saturday Finland, SQLDays, SQL Saturday Cork and SQLGrillen I want...
2018-05-10
369 reads
Database testing and ETL processes
Unit testing using tSQLt is really great, you call FakeTable on any tables your code touches and then insert the...
2018-05-10 (first published: 2018-05-01)
3,014 reads
Day 10 Option file
So far we have discussed various mays to configure MySQL, Environmental Variables, Global Variable, Session Variables, Status Variable and Server...
2018-05-10
215 reads
DMV To List Foreign Keys With No Index
I was entrusted with a new database for a critical application that was having general performance issue and the CPU...
2018-05-10
1,568 reads
Each session should be able to have its own temp table, but there can be problems.
You should be able to create a #temp in every session. That’s the idea, right? It’s one of the things...
2018-05-10
989 reads
Finding Tabs in SSMS–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-05-10
472 reads
How To Audit Data Changes In SQL Server?
Scenario:
I was at a new client, with their previous and only DBA / DEVELOPER/ MASTER OF ALL of 8 years all...
2018-05-10
10,404 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