In Windows Server 2016, Microsoft have implemented a strong security concept called Shielded Virtual Machines. Shielded VMs have been improved in the Windows Server 2019 release. In the second part of this series, Nicolas describes what Shielded Virtual Machines are and how to configure them using PowerShell.
2018-06-18
2,979 reads
Describes the idle connection resiliency feature, which allows ODBC and SqlClient data access applications to maintain their connections to SQL Server 2014 or an Azure SQL Database.
2018-06-18
2,632 reads
Comparison of the new methods of splitting strings in SQL Server 2016 to the tried and true methods
2018-06-15 (first published: 2016-04-12)
9,361 reads
Brent shows what Perfmon counter to watch after your SQL Server restarts.
2018-06-15
5,646 reads
A basic introduction for developers (or anyone) about reading the metadata of a SQL Server database from a .Net application.
2018-06-14
3,424 reads
Its possible to use some comparable expressions to a full regular expression library for matching certain patterns with T-SQL using the like operator. This tutorial uses these expressions for filtering price phrases involving alphabetic, numeric, and special characters
2018-06-14
4,713 reads
Data governance must be included in DevOps practices. William Brewer explains how to define business policies and standards to ensure compliance with privacy regulations and bring data governance to all aspects of continuous delivery.
2018-06-13
2,693 reads
An efficient and reliable method for reading CSV files with variable columns.
2018-06-12
28,332 reads
Greg Larsen talks about how indexes that are not being used are costing you valuable resources and causing your update statements to run longer.
2018-06-12
3,648 reads
This paper describes best practices for security, networking, and component architecture for building a hybrid business intelligence (BI) environment by using a combination of Microsoft Office 365, Microsoft Azure, and on-premises data sources. Many organizations are taking advantage of the benefits of cloud computing such as lower capital expenditures and increased agility, while still maintaining data in on-premises data stores.
2018-06-12
2,710 reads
By James Serra
Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting...
By Steve Jones
In a previous post, I deployed a model to a database using SQL Compare...
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
Comments posted to this topic are about the item Automating Database Cleanup for PostgreSQL...
Comments posted to this topic are about the item The Query Optimizer and Page...
Comments posted to this topic are about the item There Are a Lot of...
If I have a fillfactor set to 70%, this reduces my page density to roughly 70%. Does this affect the query plans that the optimizer chooses?
See possible answers