SQL Saturday 467 – Precon – Query processing and internals
Im not doing a tremendous amount of public speaking this year and concentrating on more professional matters, however im pleased...
2015-10-04
306 reads
Dave Ballantyne
Getting out of the ground with TSQL Smells.
At SQLBits I had a number of conversations with a number of people over TSQL Smells, my open source project...
2015-03-23
697 reads
Increasing ColumnStore compression ratio for archival and “Cold storage”
At my present client, part of the task I have to under take is to re-engineer the “Cold Storage”. This...
2015-03-17
361 reads
SQLBits, Incremental Statistics and Demo Fail
So another great SQLBits is done and dusted, many thanks to the team, helpers and sponsors for putting on such...
2015-03-08
489 reads
Non use of persisted data – Part Three
A long time ago I looked at some reasons as to why persisted computed columns ( and therefore indexes on those...
2014-11-02
370 reads
Please please tell me now…
.. Is there something I should know, sang Duran Duran many moons ago when I was young and before I knew...
2014-08-15
406 reads
Reasons why your plans suck : No 56,536
I have been working with SQL server for more years than I really care to mention and like to think...
2014-04-12
394 reads
T4 Support in SSDT
Sometimes a piece of technology passes you by completely, T4 templating happens to have done that for me. On tuesday night,...
2014-03-29
1,154 reads
Whats This Command Bar ?
One of the challenges I faced while creating my TSQL Smells visual studio (SSDT) add in, was trying to find out...
2014-03-13
322 reads
On the move
Its been a fair few years since I started blogging on SQLBlogCasts and the time has now come to find...
2013-04-14
623 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