Upcoming Speaking Engagements
In the next few months I will be speaking at some awesome events around Europe.
SQLBits – April 5-8
SQLBits is THE SQL...
2017-02-27
606 reads
Blog Posts
Columnstore Indexes – part 99 (“Merge”)
Continuation from the previous 98 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is focused on the...
2017-02-26
837 reads
Friday Reading 2017-02-24
Wow that week absolutely flew by! Here’s what I’ve been reading…
Seatbelt learning with Uncle Buck
Buck Woody goes through how he...
2017-02-24
335 reads
Improve performance by replacing temp tables with memory optimized tables - Part 3
Welcome to the last part of this series, you can find the previous post here (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2017/02/01/improve-performance-by-replacing-temp-tables-with-memory-optimized-tables-part-1/) and here (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2017/02/08/improve-performance-by-replacing-temp-tables-with-memory-optimized-tables-part-2/).
Previously we...
2017-02-24 (first published: 2017-02-21)
5,075 reads
Permanent Employment v Contracting: How the figures stack up
In my latest learning tree newsletter, I discussed analysing some of the salary survey data that the good folks over...
2017-02-24 (first published: 2017-02-21)
3,500 reads
Adding a T-SQL Job Step to a SQL Agent Job with PowerShell
In my last post, I explained how to alter an existing job step across many servers. I also had cause...
2017-02-23 (first published: 2017-02-20)
3,157 reads
Confusion of An Old Technologist
As someone who still actively pursues a career in technology, I’m a little on the older side. I got started...
2017-02-23
414 reads
Database Security Webinar Today (Feb 23)
Today at 3 PM EST I’m giving a webinar on designing a successful database security model with SQL Server.
Register Here for...
2017-02-23
444 reads
External SQL files vs. Stored procedures in SSIS development
[2017-Feb-21] I'm creating this particular blog post more for myself to remember and use it as a reference to related discussions...
2017-02-23 (first published: 2017-02-21)
3,332 reads
SQL Server 2016: The Coolest New Feature – Live Query Stats
This is the first in a series of blog posts about how great SQL Server 2016 is, and why you should...
2017-02-23
1,489 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