Using Extended Events in Azure
Over the past 6 months I have been trying to push myself to use extended events (XEvents) over SQL trace,...
2017-02-10 (first published: 2017-02-06)
1,307 reads
Arun Sirpal
SQL Server vNext
I have been pretty busy recently working with Joe Sack from Microsoft and getting my hands dirty with SQL Server...
2017-02-03
730 reads
Compare Execution Plans
Have you ever wanted to compare execution plans from SQL Server Management Studio? Well with the newer version of the...
2017-02-02
441 reads
SQL Server Performance Dashboard Reports
Setting up SQL Server Management Studio (SSMS) based performance dashboard driven off servers that are registered through a Central Management Server (CMS).
2017-02-02 (first published: 2015-08-20)
15,995 reads
My backup and SLEEP_BPOOL_FLUSH
I noticed that my backup was taking longer than usual. I went to Perfmon to look at some counters, more...
2017-02-01
822 reads
Interactive query experience for SQL databases
This is a new feature where you can issue TSQL commands via a TSQL editor straight from the Azure portal,...
2017-01-25
611 reads
Using Extended Events Telemetry Session
You are probably wondering what this is, quite honestly I was wondering too. Well it is an extended events session...
2017-01-23
1,913 reads
MVPs
I was having a conversation with Oracle professionals the other day and they started to discuss the Oracle ACE program...
2017-01-20
661 reads
SQL database built-in intelligence
I sometimes forget that Microsoft watches out for us by proactively looking at the behaviour of our SQL databases in...
2017-01-18
503 reads
Looking at wait stats differently with SQL 2016
Wait statistics is a great place to start looking into performance issues. Normally people would issue commands/queries based on sys.dm_os_wait_stats...
2017-01-16
628 reads
Blogs
PostgreSQL: Diagnosing and Fixing a Sequential Scan with No Filter Predicate
A sequential scan is not always a problem — PostgreSQL's planner often chooses one...
Giving AI Agents Visibility Into SQL Server with MCP
I’ve been thinking a lot lately about what it actually takes to make an...
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Forums
Stop Prompting Your AI Agent. Give It a Playbook.
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Finish the quote
Comments posted to this topic are about the item Finish the quote
Everything I Needed to Know Used to be Found in One Book
Comments posted to this topic are about the item Everything I Needed to Know...
Question of the Day
Finish the quote
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers