While VMWare hosts mission critical SQL Server applications around the world, there are several configuration and design choices that can bring your databases to a grinding halt. Learn how to optimally configure & optimize SQL Servers running on VMWare
2020-03-05
Microsoft added the In-Memory OLTP (aka memory optimized tables) feature to SQL Server 2014. Operations to this type of table do not need locks, therefore eliminating blocking and deadlocking. In this Article, Monica Rathbun demonstrates how to get started using memory optimized tables.
2020-03-04
Louis Davidson discovers the joy of using SQL Prompt code snippets to remove repetition from a variety of tasks, from inserting comment headers, to creating tables, to executing useful metadata queries.
2020-03-04
Phil Factor shows you how to prevent constraint violations from ‘breaking the build’, during SQL Compare deployments, by ferreting out any conflicting rows in advance, and developing a script to fix the data.
2020-03-03
In this article Aaron Bertrand looks at how to use SQL Server Extended Events to monitor performance of checkpoints for databases not using indirect checkpoints.
2020-03-03
Microsoft has added a group of features called Intelligent Query Processing to SQL Server 2017 and 2019. In this article, Greg Larsen explains one of the features, Scalar UDF Inlining.
2020-03-02
In the latest version of Data Masker for SQL Server, it’s now much easier to rapidly identify sensitive data that needs masking, set up appropriate rules, see which masking rules are applied to which column, and locate what sensitive data you've yet to mask.
We’ve also improved the performance of commonly used masking rules, which lets you run masking operations 3 times faster.
2020-03-02
17% of Enterprise respondents in this year's State of Database DevOps survey reported that DevOps has been adopted across all projects in their organization. This year’s State of Database DevOps report gave us some great insights into the landscape of Database DevOps. Kendra Little walks us through those insights specific to Enterprise organizations.
2020-02-28
Azure SQL Database offers a number of resiliency features that deliver a mix of high availability and disaster recovery capabilities
2020-02-28
As developers should not have access to production data, it’s possible that duplicate values can sneak in during migrations. In this article of the series, Phil Factor demonstrates a way to check for duplicates when unique constraints are disabled.
2020-02-27
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...
Kampus I Jl. Letjen S. Parman No.1 Blok I, RT.6/RW.16, Tomang, Kec. Grogol petamburan,...
Whatsapp:087757645171 Ruko Grand Sudirman, Jl. P.B. Sudirman Blok C5-C6, Dauh Puri Klod, Kec. Denpasar...
Whatsapp 083831618865 Komp. Pertokoan Jayapura, Jl. Pacific Permai Jl. Dr. Sam Ratulangi No.31 Blok...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers