Extended Events – Event Anatomy
So far in these brief discussions about Extended Events, I have covered several core concepts including a basic introduction into...
2015-09-11
617 reads
Blog Posts
Hekaton Part 6:- Hash Indexes - Intro
With SQL Server 2014, new type of Index called the hash index was introduced. Little introduction to hash function would...
2015-09-11 (first published: 2015-09-08)
2,605 reads
Where you should start when managing an enterprise
This T-SQL Tuesday we are hosted by one of the DBA’s of the night: Jen McCown (b/t). She want’s us...
2015-09-11 (first published: 2015-09-08)
1,864 reads
A look on the CXPACKET wait type
I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database...
2015-09-10
369 reads
A look on the CXPACKET wait type
I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database was open for analysis. I caught the queries from...
2015-09-10
38 reads
A look on the CXPACKET wait type
I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database...
2015-09-10
697 reads
A look on the CXPACKET wait type
I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database was open for analysis. I caught the queries from...
2015-09-10
7 reads
BI on SQL Azure - Yes you can
Just 4 years before, it was not possible to have end to end Business Intelligence (BI) solution on SQL Azure. Please read my blog here which was actually written...
2015-09-10
21 reads
BI on SQL Azure - Yes you can
Just 4 years before, it was not possible to have end to end Business Intelligence (BI) solution on SQL Azure....
2015-09-10
474 reads
Buffer Pool Extension in SQL Server 2014 part 4: benchmark testing for update operations
One of my previous articles was devoted to carrying out a range of tests to compare speed of data read...
2015-09-10 (first published: 2015-09-04)
1,843 reads
Blogs
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...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
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