Managing personally identifiable information when moving databases to unsecure environment can be challenging. With this flexible and extendable solution for scrubbing it, you can save yourself some time and effort.
A “multi-subnet” environment is defined when the OS cluster used as the backbone for AlwaysOn has server nodes that are located in multiple/different subnets. Deploying SQL Server AlwaysOn Availability Groups requires a Windows Server Failover Clustering (WSFC) cluster and each availability replica of a given availability group must reside on a different node of the same WSFC cluster. This post from Manvendra Singh will help you in configuring an HA and DR solution for SQL Server AlwaysOn in multi-subnet networks.
Learn how easy the new SQLServer module makes backups of SQL Server databases.
We need better security for our data, especially for our choices in managing data.
Finding the nightly job failures is just one of a DBA's morning rituals. It is fairly easy to scan all the email with a number of creative search criteria, but what if you would like a more automated approach? Read on to learn how to find and report all job failures using a script.
U-SQL introduces two new data types - SQL.ARRAY and SQL.MAP. Here, we look at what we can do with SQL.ARRAY and the CROSS APPLY EXPLODE expression.
Database provisioning for development work isn't always easy. The better that development teams meet business demands for rapid delivery and high quality, the more complex become the requirements for the work of development and testing. More databases are required for testing and development, and they need to be more rapidly kept current. Data and loading needs to match more closely what is in production. Grant Fritchey explains.
This article is a case study and an attempt to explain an interesting phenomenon with data anomalies that is commonly called Simpson's Paradox.
Today, Steve Jones looks at the popularity of SQL Server, which was named DBMS of 2017.
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, Kota Bambu Sel., Kec. Palmerah, Kota...
BCA KCU THAMRIN. Tlp :085373737845.Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec....
Blok A.7 No, Komplek, Jl. Perumahan Green Garden 31-35, RT.1/RW.3, Kedoya Utara, Kec. Kb....
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers