Thursday Webinar Postponed due to Hurricane Florence
Hello! The webinar I was going to give this coming Thursday with MSSQLTips.com has been postponed. When we have a...
2018-09-11
230 reads
Reduce your Azure Development Subscription Cost
Azure VMs
Usually you should convey to developers and testers to shut down the VMs manually when they are not using non production virtual machines. Also there some ways to...
2018-09-11
24 reads
Do You Need a Relational Data Warehouse?
Are you looking to do a major update to your data warehouse or looking to modernize? Many technologies have come...
2018-09-27 (first published: 2018-09-11)
3,071 reads
CCI – How to load data for better Columnstore Segment Elimination
Introduction
In this blog post, I would like to explain what a columnstore segment elimination is and how to load data...
2018-09-11
189 reads
Pride and Prejudice... and Triggers
This post is part of #tsql2sday event :)I know, in the world of the database administrators and developers, the triggers...
2018-09-11
549 reads
SQL in the City Summits–Coming to New York, London, and Chicago
I love New York. Every time I get to travel to the city, I get excited and look forward to...
2018-09-11
317 reads
What happens in a trigger stays in the transaction: T-SQL Tuesday #106
Anything that happens in a trigger happens within the same transaction of the command that called it.
Part of me feels...
2018-09-11
213 reads
Triggers: The hidden logic that will strike back – TSQL Tuesday #106
This month’s T-SQL Tuesday is brought by Steve Jones (b | t) and he wants to know if triggers causes headaches...
2018-09-11
254 reads
TSQL Tuesday #106: Triggers and the Spiral To Oblivion
It’s the second Tuesday of the month which must mean only one thing…
We’re all skint and payday feels like a...
2018-09-11
282 reads
Steps to Restore Database from Backup File in SQL Server
Overview
In most of the cases, users create a backup file of their database on their machine. This help the users to perform recovery at the time of any disaster,...
2018-09-11
20 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