What’s that SSIS Password
A recurring theme over the past several weeks (there are always recurring themes it seems) has been an issue that...
2017-10-30
1,360 reads
Blog Posts
A Pretty PowerBi Pester Results Template File
I have left the heat and humidity of Singapore where I have been presenting at the PowerShell Conference Asia and...
2017-10-29
606 reads
Columnstore Indexes – part 114 (“Machine Learning Services”)
Continuation from the previous 113 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blogpost is focusing on the unsung...
2017-10-29
714 reads
It’s All About The Joins
One of the most common mistakes I see made when creating tables (and I’ve been guilty of this myself too...
2017-10-29
536 reads
Monday Night Networking Dinner 2017
It’s on! Free registration at EventBrite.
I wrote last month about not being able to make it to Seattle on Monday...
2017-10-29
599 reads
The #SQLSAT Speaker Goodie Bag
Last summer, I heard about an awesome idea for speaker gifts at SQLSat Pensacola 2017 from organizer Karla Landrum and...
2017-10-29
622 reads
Create a Login in a SQL Server Availability Group
Situation In SQL Server Availability Groups (AG), Logins must have the same SID (Security identifier) on all the nodes where...
2017-10-28
377 reads
Data Visualization Panel at PASS Summit
Next week is PASS Summit 2017, and I’m excited to be a part of it. One of the sessions in...
2017-10-28
376 reads
Exit Codes, systemd and SQL Server on Linux
In this blog post we’re going to cover systemd, process exit codes and highlight how systemd reacts in certain exit conditions from SQL Server on Linux. My friend and...
2017-10-28
18 reads
Exit Codes, systemd and SQL Server on Linux
In this blog post we’re going to cover systemd, process exit codes and highlight how systemd reacts in certain exit...
2017-10-28
1,318 reads
Blogs
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
An Eventual Consistency Scam
Comments posted to this topic are about the item An Eventual Consistency Scam
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers