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
For as long as I have worked with SQL Server, and on almost every system I've ever managed, tempdb has been a bottleneck in one way or another.
2020-02-26
In this article Filip Holub looks at how to configure and enable transparent data encryption for a SQL Server database using PowerShell.
2020-02-25
Stephanie Herr describes the new features in the Deployment Suite for Oracle that will help you automate your database releases safely, on Linux or Windows.
2020-02-24
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL...
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Comments posted to this topic are about the item Doing the Little Things
If I want to track historical data values, which mechanism should I use?
See possible answers