Resumable online index rebuild
continue on whats new SQL Server 2017 their is a great feature call resumable online index, means online index now has an option to PAUSE and RESUME or ABORT...
2019-11-04
142 reads
Blog Posts
SQL Homework – November 2019 – SSMS built in reports
Time for some homework again. I know Pass Summit is this week so you may be a bit busy but ... Continue reading
2019-11-04
33 reads
SQL Server Stored Procedures vs Functions vs Views
Watch this week’s episode on YouTube. SQL Server has several ways to store queries for later executions. This makes developers happy because it allows them to follow DRY principles: Don’t Repeat Yourself....
2019-11-04 (first published: 2019-10-22)
3,049 reads
SQLSaturday Orlando Notes – Post Event Speaker Survey
One of the follow up items I have from the event was to poll speakers on what hotel they used (see my previous post). In jotting down some notes...
2019-11-04
30 reads
SSIS Scaleout: Cannot open certificate store on the machine
When attempting to connect a worker node to the current Master node of a SQL Server Integration Services (SSIS) Scaleout, for on-prem SQL Servers, if you receive the error:...
2019-11-04 (first published: 2019-10-22)
796 reads
Teams in SQL Clone and SQL Provision
SQL Clone v4 is out, and the big change is the addition of the Teams feature. I guess technically this is just for SQL Clone, which is included in...
2019-11-04
49 reads
You Are A Coder
So, you say you’re a DBA. I say you’re not. You say you’re a system administrator. I say you’re wrong. We are all coders now. Every single one of...
2019-11-04
38 reads
Last Week Reading (2019-11-03)
This week I’m offering you many posts about Cosmos DB, Azure Data Factory and how to design reliable Azure applications. Have a great week also for those of you...
2019-11-03
17 reads
SQLSaturday Orlando Notes – Designated Hotel
Almost every year we select an “official” hotel for the event. For those coming in who don’t know the area it’s a way to avoid figuring out what is...
2019-11-03
14 reads
Back to school
Hey, I realize that future we need to know Database system, No SQL and Big Data. with that as things are moving to machine learning and AI system which...
2019-11-02
17 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCU THAMRIN Telpon/WA:08137887595
BCA KCU THAMRIN Telpon/WA:08137887595.Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng,...
BCA KCP Pinangsia Tlpn/wa:085373737551
Jl. Pinangsia II No.3 & 3A, Pinangsia, Kec. Taman Sari, Kota Jakarta Barat, Daerah...
BCA KCP South Quarter Telpon/WA:08137887595
BCA KCP South Quarter Telpon/WA:08137887595.South Quarter Tower, Jl. R.A. Kartini No.Kav. 8 B, Ground...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers