Need to output CSV, TSV, or other?
Ever have the need to create a CSV list in SQL Server? Not sure how? Starting in SQL Server 2017...
2017-07-31
417 reads
Blog Posts
Start Your Engine’s with Startup Procedures
After reviewing some recent audit results for a couple of our SQL Servers, I noted the audit checked for start up...
2017-07-31
388 reads
Streaming Reporting: SQL Change Data Capture (CDC) to Power BI
[read this post on Mr. Fox SQL blog] Extending on my previous post about redirecting SQL CDC changes to Azure Event Hub, I have had a few people ask for details/options...
2017-07-31
39 reads
Streaming Reporting: SQL Change Data Capture (CDC) to Power BI
[read this post on Mr. Fox SQL blog]
Extending on my previous post about redirecting SQL CDC changes to Azure Event Hub, I...
2017-07-31
2,811 reads
Twilight TimeZone: Handling Time in Your App Architecture at SQLSaturday Baton Rouge
Thanks to everyone who joined my colleague Steve Schaneville and me for a presentation on date/time data architecture in modern...
2017-07-31
659 reads
Video Tutorial: Creating a SQL Server Databases
In this Video tutorial we will look at creating a SQL Server database using both Management Studio and TSQL. We’ll...
2017-07-31
587 reads
What Immediate_sync means in Transactional Replication – Part1
In my previous two blogs – Capture Important Parameters of the SQL Server Replication and Add new articles to existing Transactional Replication...
2017-07-31 (first published: 2017-07-18)
2,817 reads
Columnstore Indexes – part 108 (“Computed Columns”)
Continuation from the previous 107 parts, the whole series can be found at http://www.nikoport.com/columnstore/
As we are approaching the RTM (release...
2017-07-29
856 reads
Dynamics 365 AX – Creating Data Entities for BYOD Azure Database including those without a natural key
We, BI professionals, sometimes take for granted that we can access the database of an ERP system quite easily, especially...
2017-07-29
759 reads
That thing you want to do? Do the thing.
You're thinking of starting a blog, or teaching, or training videos. Will it pay off? Will it be worth it?...
2017-07-29
692 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers