When you configure SQL Server AlwaysOn Availability Group from management studio, it may fail with below error while joining secondary...
2018-07-31
15,796 reads
Recently someone mentioned the LOADHISTORY option of RESTORE. It’s not horribly hard to find in BOL but it wasn’t the...
2018-07-31 (first published: 2018-07-18)
3,021 reads
Watch this week's video on YouTube
One of the things that the SQL Server query optimizer does is determine how to retrieve the data requested by your query.
Usually it does...
2018-07-31
12 reads
Watch this week's video on YouTube
One of the things that the SQL Server query optimizer does is determine how to retrieve the data requested by your query.
Usually it does...
2018-07-31
11 reads
Last week I posted a quiz on SQL Operations Studio, a free, multi-platform tool from Microsoft. This tool is under active development and the features are improving by the day...
2018-07-31
29 reads
The truncate option is fast and efficient but did you know that it takes a certain lock where you could...
2018-07-31
573 reads
I have heard some people say if you have a data warehouse, there is no need for cubes (when I...
2018-07-31 (first published: 2018-07-20)
3,229 reads
I am not a morning person. I’ve really tried but there’s something in me that just stops me from getting...
2018-07-30
323 reads
Friends/My Readers,
Its been a long i have been away from my blogging.When i see back Its exactly 3 yrs Today(30/July/2015...
2018-07-30
323 reads
Very rarely there is a need to force an execution plan and even more rarely we should be doing it....
2018-07-30 (first published: 2018-07-20)
13,347 reads
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Comments posted to this topic are about the item Learn From History
Comments posted to this topic are about the item The SQL Server MCP Server
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers