SQL Server 2014 Buffer Pool Extension part 3: system monitoring
In this article I’d like to tell about monitoring tools available in SQL Server 2014 to evaluate the performance of...
2015-09-03
1,294 reads
Blog Posts
SSIS – Unexpected Termination
I was toying around with the new SQL Server 2016 CTP release and I wanted to run a few SSIS packages...
2015-09-03
5,485 reads
Viewing Running XEvent Metadata
Running session metadata, while it can be still be viewed in the catalog views, is exposed via DMVs. Putting it a slightly different way, if I query DMVs that...
2015-09-03
11 reads
10 DAX Calculations for your Tabular or Power Pivot Model (Part 1)
If you’ve read my blog for a while you may have seen the following posts:
Ten MDX Calculations For Your Cube...
2015-09-02
1,087 reads
An Evening of Networking at the 2015 PASS Summit on October 26, 2015 (Monday)
Going to be in Seattle on Monday night (Oct 26th) and want to see old friends and make some new...
2015-09-02
607 reads
Checking for Excessive Permissions in SQL Server - Syndication – WaterOx Consulting
Who can do what? One of the key things that a DBA...
The post Checking for Excessive Permissions in SQL Server...
2015-09-02
512 reads
Columnstore Indexes – part 64 (“T-SQL Improvements in SQL Server 2016”)
Continuation from the previous 63 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have decided to write a rather...
2015-09-02
628 reads
Learning Regular Expressions
I’m a regular watcher of the Midnight DBA Webshow and one day they mentioned regular expressions. Not a new term...
2015-09-02
961 reads
Monitoring of free space in database files
Monitoring of the size of database files is one of the important DBA tasks and this process should be automated....
2015-09-02
652 reads
Nominated for Author of the Year 2015
I have the great pleasure to announce that I have been nominated for the “Author of the Year 2015” award...
2015-09-02
411 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