GDPR: Your Hair Is Not On Fire
Along with a lot of other people, I’ve been attempting to call people’s attentions to the new General Data Protection...
2018-02-26
485 reads
How to setup Azure SQL Analytics
I am a big fan of this feature, I have written and spoken about it before ( https://blobeater.blog/2018/01/04/azure-sql-analytics/) but I did...
2018-02-26
1,073 reads
Double hop error when using SQLCMD
tl;dr; SQLCMD v2014 and up has special requirements for Kerberos.
One of the problems with linked servers (no rude noises please)...
2018-02-26
2,121 reads
My experience with TechOutbound 2018 – Caribbean
I am a passionate, regular attendee of Techoutbound (formerly SQLCruise) events. I try to do at least one every year. ...
2018-02-26
383 reads
SQL Server Tune Your Transaction Log
Whenever a transaction log file grows the space it is allocated is divided up into virtual log files (VLFs). Depending...
2018-02-26
106 reads
The Data Platform has expanded – so too should our approach in using it….
In recent years we as data professionals have moved from dealing with SQL Server databases with SQL Server Reporting Server...
2018-02-26
502 reads
Change the name of master database files – SQL Server on Linux
In my recent blog, I discussed about how to move master database to another location. One of the readers requested...
2018-02-26
752 reads
Stop Worrying About Index Fragmentation and Manage Your Statistics
I see a lot of posts online about rebuilding indexes in a scheduled maintenance task, this is a pretty intensive...
2018-02-25
85 reads
Guide for Set Up of Telegraf for Monitoring SQL Server xPlat
Problem
We need a way to collect performance metrics for all our SQL Servers (Windows and Linux) into one system and...
2018-02-24
4,862 reads
If your Surface Book loses it’s keyboard and trackpad – try removing KB4074588 update
My Surface Book (gen 1) recently did updates and then a day or so later the keyboard and trackpad mysteriously...
2018-02-24
456 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
Alamat BCA KCU PURWOKERTO Tlp:0817825533
WA CS 62817825533 Alamat Jl. Jend. Sudirman No.391 A, Brubahan, Purwanegara, Kec. Purwokerto Tim.,...
Alamat BCA KCU SOLO BARU Tlp:08217555651
WA CS 628217555651 Alamat Kawasan Terpadu The Park, Jl. Ir. Soekarno, Solo Baru, Madegondo,...
Alamat Kantor BCA KCU CILACAP Tlp:08218154374
WA CS 628218154374 Alamat Jl. Jend. Ahmad Yani No.118, Sidakaya Dua, Sidakaya, Kec. Cilacap...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers