Database Fundamentals #3: What’s In a Database?
It’s worth noting that a lot of people will never need to create their own database. You may never create...
2017-06-20
494 reads
Blog Posts
How to use Python in SQL Server 2017 to obtain advanced data analytics
On the 19th of April 2017, Microsoft held an online conference called Microsoft Data Amp to showcase how Microsoft’s latest...
2017-06-20
791 reads
Power BI Custom Visuals Class (Module 55 – Enlighten World Flag Slicer)
In this module you will learn how to use the Enlighten World Flag Slicer Custom Visual. The Enlighten World Flag...
2017-06-20 (first published: 2017-06-13)
2,039 reads
Power BI Custom Visuals Class (Module 56 – Rotating Tile)
In this module you will learn how to use the Rotating Tile Custom Visual. The Rotating Tile gives you the...
2017-06-20
720 reads
Speaking at the Data Platform Summit 2017
I am honored to be speaking at the Data Platform Summit 2017. The event takes place August 17-19, 2017 in...
2017-06-20
562 reads
SQL Server 2017 Concatenation With STRING_AGG
One of the new less publicized features in SQL Server 2017 is STRING_AGG. This new feature can take an expression...
2017-06-20
97 reads
SQLpassion Online Trainings in July 2017
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-06-20
180 reads
Where’s the Trend Line in Power BI Desktop?
A quick blog post on finding where the trend line is hiding in Power BI Desktop. Docs will state it...
2017-06-20 (first published: 2017-06-13)
10,595 reads
Adding Identity to an existing column
A friend had an interesting problem today. A really big table (multiple millions of rows) and no primary key. He...
2017-06-19
2,957 reads
dbfs – command line access to SQL Server DMVs
With SQL Server on Linux, Microsoft has recognized that they’re opening up their products to a new set of users. People that aren’t used to Windows and it’s tools....
2017-06-19
17 reads
Blogs
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
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...
Forums
Alamat BCA KCP Thamrin Nine Telp:0821°7555°651
Telp/Wa 628217555651 Thamrin Nine Podium Area - UG Unit A, Jl. MH Thamrin No.10,...
Alamat BCA KCP Samanhudi Telp:08218200203
Telp/Wa 628218200203 Jl. Samanhudi No.57 B, RT.5/RW.3, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta...
Alamat BCA KCP AM Sangaji Telp:08218200233
Telp/Wa 628218200233 Jl. A.M Sangaji No.020 A, RT.3/RW.04, Petojo Utara, Kecamatan Gambir, Kota Jakarta...
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