MDX Functions: TopCount
The MultiDimensional eXpressions, or MDX, language is used to query the data in a multidimensional in an OLAP database. In the...
2012-03-12
2,262 reads
SQL Server Database Mirroring Tips and Tricks, Part 1
Even though SQL Server Database Mirroring is deprecated in SQL Server 2012, it is still a very useful HA/DR technique...
2012-03-16 (first published: 2012-03-12)
6,669 reads
Data Warehouse Architecture – Kimball and Inmon methodologies
What is the best methodology to use when creating a data warehouse? Well, first off, let’s discuss some of the reasons why...
2012-03-15 (first published: 2012-03-12)
9,525 reads
Done or Not Done
One of the things I hear a lot relating to work big and small is that it is “almost done”,...
2012-03-12
581 reads
SQL Server 2012 AlwaysOn & A Thorough Setup
It’s surprisingly easy to set up the new AlwaysOn features. I’ve done it on VMs running on my laptop, from...
2012-03-14 (first published: 2012-03-12)
3,140 reads
Double-Dash Comments, the Hidden Menace
While writing my last post on cleaning up old maintenance plans, I was reminded of something I heard in a...
2012-03-12
2,568 reads
Last Execution Date Time of a Stored Procedure
On many forums I have found a very basic yet important query - “How can I know when was my Stored...
2012-03-12
21,811 reads
Cleaning up Old Maintenance Plans
This is something I trip over every now and then on systems we inherit from our clients, and I thought...
2012-03-12
656 reads
SQL Server 2012 RTM–Are you waiting for SP1?
As you probably know by now SQL Server 2012 was launched last week, Microsoft had an online launch event that...
2012-03-12
3,490 reads
Synchronizing subscriptions in SQL Server Express
I was recently asked about synchronizing a Merge pull subscription in SQL Server Express using RMO, the lack of a...
2012-03-13 (first published: 2012-03-12)
4,305 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