SQL Server Partition Swapping
When working with large amounts of data in ETL jobs it can often can sink a lot of time inserting...
2018-05-10
823 reads
How to deploy data for the lookup tables, small dimensions and other meta-data with your database code
Deployment process equally responsible for deploying both database objects as well as an initial state of the database/applications. In this...
2018-05-10
629 reads
PASS Summit Session – On-Prem SQL Servers, Interstellar Performance
I’m very pleased to announce that one of my sessions submitted for this year’s PASS Summit in Seattle, held from...
2018-05-10
263 reads
Power BI Custom Visuals Class (Module 102 – Slim Data Bar KPI Visual)
In this module you will learn how to use the Slim Data Bar KPI Visual. The Slim Data Bar KPI...
2018-05-22 (first published: 2018-05-09)
2,357 reads
First Wave of Sessions for PASSSummit Now Available
The first wave of sessions for the #PASSSummit have been released. You can see the list at: http://www.pass.org/summit/2018/Learn/ConferenceSessions.aspx
I am honored...
2018-05-09
933 reads
Relaxing on the Tab Management Terraces with #SQLPrompt
I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes...
2018-05-09
1,250 reads
A big thank you
Thank you! Thank you for reading my blog. Thank you for buying my book. Thank you for attending my sessions...
2018-05-09
256 reads
Day 9 Variables
In earlier days we have discussed about providing options with environmental variable and command line, today we will be discussing...
2018-05-09
191 reads
Pushing SQL Server images to the Azure Container Registry
The Azure Container Registry is an online repository for storing Docker images (think the Docker Hub).
What’s cool about this is...
2018-05-23 (first published: 2018-05-09)
1,436 reads
T-SQL Tuesday #102: Giving Back
This is my diatribe about service and giving back to the community. When done properly, there is a natural born effect of enhancing one's personal life equal in some...
2018-05-09
6 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
Alamat Kantor BCA KCU Galaxy Tlp:(08218154374)
WA CS 628218154374 Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya,...
Alamat Kantor BCA KCU Malang Tlp:(08217555651)
WA CS 628217555651 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa...
Alamat Kantor BCA KCU Rungkut Tlp:(0817825533)
WA CS 628217825533 Jl. Raya Kendangsari Industri No.2, Kendangsari, Kec. Tenggilis Mejoyo, Surabaya, Jawa...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers