Adding a new shared disk to Windows Server failover Cluster is not a complex process but special care must be taken when you want to use the new disk for any existing SQL Instance. In this article, we will show you all the required steps to add the disk to WSFC and then to properly assign it to an existing SQL role in the WSFC.
2024-09-16
809 reads
Learn how to create a backup of an AWS RDS for SQL Server database and download the backup file to use on another SQL Server instance.
2024-09-16
Connect, share and learn with the global data community in Seattle this November. Whether you're a DBA, Developer, Architect, Engineer or you're just getting started in your data career, there's a huge range of content for you to choose from (over 150 sessions and counting across 5 different tracks). Speakers this year include Steve Jones, Grant Fritchey, Ryan Booz, Bob Ward, Deepthi Goguri and Jennifer Stirrup. Check out the full program and register before September 18 to secure your ticket at the standard price.
2024-09-16 (first published: 2024-08-19)
A list of articles in my series on Azure Data Studio along with a few other links.
2024-09-13 (first published: 2024-01-10)
2,568 reads
Three new speakers will be taking to the stage at this year's PASS Data Community Summit for the New Stars of Data Track. Sessions will be delivered by Haripriya Naidu, Vitalija Bartusevičiūtė, and Jarid McKenzie!
2024-09-13
In this article, I will cover a bit about the LIKE operator, including how it works, and a bit of history about why it is like it is. After establishing this, I will discuss a bit about how you can (and should) use the LIKE operator in your CHECK constraints to strengthen your data integrity.
2024-09-13
This next article examines the impact of transaction sizes on the performance of our Delta Parquet tables.
2024-09-11
1,752 reads
A list of all builds for SQL Server 2016. Updated with CU2 for SP2 and CU10 for SP1.
2024-09-11 (first published: 2017-01-25)
38,808 reads
2024-09-11 (first published: 2018-12-18)
8,700 reads
2024-09-11 (first published: 2018-12-20)
11,053 reads
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
Recently I received a cry for help over Teams. The issue was that an...
I have installed Machine Learning with SQL 2022 Enterprise Edition and installed and configured...
Comments posted to this topic are about the item A Guide to SQL Security...
Comments posted to this topic are about the item I Need a CS Degree....
I have run this on SQL Server 2022 for the Sales database:
ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)I then run this in the Sales database:
USE Sales GO CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFFThe dbo.Customer table is partitioned. How are statistics created? See possible answers