In this article we learn migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool. In...
2018-11-25
365 reads
Since SQL Server 2014 SP1 we’ve had DMV’s that can support Live Query Statistics (Basically a query plan that gives...
2018-12-06 (first published: 2018-11-24)
3,469 reads
Since SQL Server 2014 SP1 we’ve had DMV’s that can support Live Query Statistics (Basically a query plan that gives...
2018-11-24
244 reads
Recently I was asked my opinion, via Twitter, on where to store the index DDL for a single database that had multiple clients with varied usage patterns. You can...
2018-11-23
10 reads
Recently I was asked my opinion, via Twitter, on where to store the index DDL for a single database that...
2018-11-23
222 reads
Introduction Chris Webb is independent consultant specialising in Analysis Services, MDX, Power Pivot, DAX, Power Query and Power BI in...
2018-11-23
233 reads
I have been a regular attendee at PASS Summit for 15 years now. This year (2018) marked my 15th year...
2018-11-22
201 reads
This is my first blog for PBI – DAX. I lately started working on DAX and trying to understand it in depth. While looking for a DBA hat, getting...
2018-11-22
26 reads
This is my first blog for PBI – DAX. I lately started working on DAX and trying to understand it in...
2018-11-22
5,645 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-11-22
222 reads
If you spend your days tuning queries, managing pipelines, or keeping a production database...
By SQLPals
SQL Server gMSA: Why DBAs Still Aren't Using It in 2026 ...
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
We have performed a side-by-side upgrade, from SQL Server 2016 to 2022 Developer Edition,...
Comments posted to this topic are about the item Automating OSM Data Refresh in...
Comments posted to this topic are about the item 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