Out with the Old, In with the New
In a few days the year 2017 will come to a close. The brand new year 2018 is on deck...
2017-12-29
332 reads
Blog Posts
Power BI Sankey Chart: a case to review your Budget books
(2017-Dec-29) Sankey diagram (chart), named after Matthew H Riall Sankey, is a good visualization tool for information flow within a system....
2017-12-29
3,219 reads
Presentations & Blogging of 2017 in Review
And here comes the 5th time I am reviewing what happened on the presentation an blogging side of my life,...
2017-12-29
602 reads
Columnstore Indexes – part 116 (“Partitioning Specifics”)
Continuation from the previous 115 parts, the whole series can be found at http://www.nikoport.com/columnstore/
After delaying for a couple of years...
2017-12-28
510 reads
Correlate Trace and XE Events
Several years back, when Extended Events was brand new, it was downright painful to try and convert the classic Profiler or Server Side trace to something meaningful and useful...
2017-12-28
4 reads
Correlate Trace and XE Events
Several years back, when Extended Events was brand new, it was downright painful to try and convert the classic Profiler...
2017-12-28
544 reads
Correlate Trace and XE Events
Several years back, when Extended Events was brand new, it was downright painful to try and convert the classic Profiler...
2017-12-28
235 reads
Design Concepts For Better Power BI Reports Part 5: Affordances
Affordances are a general design concept that comes from physical product design but can be applied to visual design. I...
2017-12-28
495 reads
RegEx in SSMS: A gift for quick code
I had yet another example of how beautiful Regular Expressions can be in SQL coding today, and so I thought...
2017-12-28
719 reads
Some New Cool Features in SSMS
SSMS new versions come up with some cool features. The new features provide support for the SQL Server 2008 databases and onward. Vulnerability Assessment (active from SSMS 17.4) Right...
2017-12-28
10 reads
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Backup Availability Group
Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022...
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers