Getting value out of data quickly
There are times when you need to create a “quick and dirty” solution to build a report. This blog will...
2018-05-30
801 reads
Dates and Times in SQL Server: the problem with DATETIME
Recently I wrote a post about date and time functions you should never use, which contained an opinion I’ve expressed...
2018-05-30
454 reads
Importance of Statistics
Following up on my last post about the Cardinality Estimator let’s talk about column statistics and how they work and...
2018-05-30
597 reads
An interview with Brent Ozar
I was talking about interviews (although not the job kind) with a friend and it reminded me of the time...
2018-06-15 (first published: 2018-05-30)
2,928 reads
Azure SQL Database – The Default Isolation Is?
So what is the default isolation level for Azure SQL Database? I ran the following code to check it out....
2018-05-30
422 reads
SQL Server Minimally Logged Inserts (Assume Nothing!)
Side note :
I originally started this post to show with examples all the scenarios where you can get minimal logging...
2018-05-29
168 reads
SQL Server Minimally Logged Inserts (Assume Nothing!)
Side note : I originally started this post to show with examples all the scenarios where you can get minimal logging...
2018-05-29
145 reads
SQL Server: Backup and Restore operations using Cloud
This article discusses the concept of SQL Server backup and the various components required to use the Microsoft Azure Blob...
2018-05-29
397 reads
Spreading Job Run Times Out on an MSX/TSX Scheduled Job
Problem My company heavily uses MSX/TSX jobs for everything. But our SAN doesn’t necessarily like if we run all our index maintenance, backups, and integrity checks at the same...
2018-05-29
5 reads
Spreading Job Run Times Out on an MSX/TSX Scheduled Job
Problem My company heavily uses MSX/TSX jobs for everything. But our SAN doesn’t necessarily like if we run all our index maintenance, backups, and integrity checks at the same...
2018-05-29
7 reads
Blogs
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...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
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