Every year, July 1 is the Microsoft MVP Renewal date and quite a few people received good news that day. I was one of those renewed for another year, and I am honored that Microsoft chose me again. I also congratulate all the others that received the award for the first time as well as […]
Temporal tables a.k.a Table Versioning was introduced in SQL Server 2016 and is an easy, convenient way to track changes to data. A good introduction to temporal tables can be found here. One of the key advantages of versioning tables is easy of querying – or getting a ‘single pane of glass’ look of how […]
Some of the terms in the DevOps pipeline, such as CI and CD, can be confusing. In the second article of this series, Robert Sheldon explains these terms and how they fit in the DevOps pipeline. He also talks about some of the tools you might use.
The newest version of Data Masker for SQL Server includes a new rules window with in-product guidance for choosing the right rule, and a new menu bar for fast access to the items you need.
Microsoft announced CTP 3.2 for SQL Server 2019 just a few days ago, but many people working with SQL Server don’t care about this. I run into people at user group meetings and SQL Saturdays who are stuck supporting versions as old as SQL Server 2000, and SQL Server 2008 R2 is still prevalent. I’m […]
Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.
In this post we will discuss Azure Data Factory transformation related pipeline activities using Stored Procedure activity.
If we want the behavior and performance of our test databases to mimic that observed in production, then we must consider not only the database but also the server. Grant Frtichey reviews the server-level objects, settings and features that we may need to consider, and then shows how to 'synchronize' the linked servers, user logins and SQL Agent jobs, as part of an automated provisioning process, using SQL Provision.
Explaining how computers work can be hard for technical people, but it's important for us to help our clients, customers, and managers appreciate why building new software is hard.
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Jl. Raya Kutabumi No.16-17 Blok B-18, Kutabumi, Kec. Ps. Kemis, Kabupaten Tangerang, Banten 15560
Whatsapp:083188951403 Pd. Candra, Komp. Pertokoan Jl. Palem Timur No.TC 09, Palem, Wadungasri, Kec. Waru,...
Whatsapp.083831617937 Jl. Bongkaran No.17-19, Bongkaran, Kec. Pabean Cantian, Kota SBY, Jawa Timur Surabaya, Jawa...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers