Monday Coffee: The evolving DBA
Over the weekend I saw a few tweets about the role of the DBA. These tweets (and corresponding blog posts)...
2017-07-31
566 reads
Blog Posts
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
413 reads
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
386 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
32 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,800 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
658 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
582 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,809 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
855 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
737 reads
Blogs
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...
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....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers