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,928 reads
All About SQL
MVPs
I was having a conversation with Oracle professionals the other day and they started to discuss the Oracle ACE program...
2017-01-20
663 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
507 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
632 reads
Checking Time Zones in SQL Server
I was building some basic queries around time zone manipulation and I am happy to say that I enjoyed myself...
2017-01-13
1,330 reads
I used to shrink my databases!
This is an entry level post and a response to SQLEspresso’s blog challenge(http://sqlespresso.com/2017/01/10/ooops-was-that-was-me-blog-challenge) where we share mistakes from our “younger”...
2017-01-11
822 reads
SQL Server Bugs & Enhancement Requests
T-SQL Tuesday #86: SQL Server Bugs & Enhancement Requests hosted by Brent Ozar. https://www.brentozar.com/archive/2017/01/announcing-t-sql-tuesday-87-sql-server-bugs-enhancement-requests/ I did not want to miss out...
2017-01-10
636 reads
Clearing Plan Cache in SQL Database (Azure)
Sometimes when in a testing mode I do like to clear cache within my SQL database (Azure). Nowadays a lot...
2017-01-05
702 reads
Checking DBCC CHECKDB
I hope you run consistency checks on your databases, if you are not currently doing this you probably will want to....
2017-01-03
582 reads
Why I am called BlobEater
It’s coming towards the holiday season for me and I thought that I would wind-down a little with a non-technical...
2016-12-17
529 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers