Automate Sliding Window Partition Maintenance: Part III
Part 3 of Hugh Scott's series on automating sliding window partitions in SQL Server using PowerShell
2014-03-21 (first published: 2010-12-28)
7,552 reads
Hugh Scott
Automate Sliding Window Partition Maintenance: Part II
Part 2 of a series on how to automate partition management. In this article learn how easy managing and maintaining a sliding window partition scheme can be with PowerShell.
2014-03-14 (first published: 2010-12-21)
10,038 reads
Automate Sliding Window Partition Management: Part I
A new series on how you can automate partition management and administration. Hugh Scott explains how this technique helps him manage large deletes.
2014-03-07 (first published: 2010-12-14)
19,906 reads
Automate Range Right Partition Management with Powershell (Part II)
In the last script, we covered removing the trailing partition in a Range Right, date valued partition. This script adds a new (empty) partition to the partition scheme.
2010-11-12 (first published: 2009-12-17)
1,068 reads
Automate Range Right Partition Management with PowerShell
This script automatically splits a partitioned table, merges the partition function and then drops the associated file group for the partition.
2010-11-11 (first published: 2009-12-17)
2,210 reads
Extracting Logins From SQL Server
This script will help you transfer logins between one instance of SQL and another.
2010-11-08 (first published: 2010-01-07)
4,603 reads
2006-09-04
5,971 reads
SQLAnswers Review
How many of you using SQL Server 2000 have the need to send email from SQL Server? How many of you hate Outlook? Here is a software package that can send not only HTML, but PDF as well and through SMTP. Read Hugh Scott's review and thoughts on this product.
2005-09-22
7,436 reads
A SAN Primer
Storage is getting cheaper and cheaper, which means that more and more SQL Server servers will be incorporating SAN storage as an architecture moving forward. It seems that most DBAs, however, have never worked with this technology. New author Hugh Scott brings us a primer on this Storage Area Networks for DBAs new to this technology.
2005-06-22
15,360 reads
Blogs
AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
Flyway Tips: Multiple Projects
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
What DevOps Look Like in Microsoft Fabric
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
Forums
Can an Azure App Service Managed Identity be used for SQL Login?
I'm fairly certain I know the answer to this from digging into it yesterday,...
Azure Synapse database refresh
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
how to write this query?
hi everyone I am not sure how to write the query that will produce...
Question of the Day
Fun with JSON I
I have some data in a table:
CREATE TABLE #test_data
(
id INT PRIMARY KEY,
name VARCHAR(100),
birth_date DATE
);
-- Step 2: Insert rows
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned?
SELECT *
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t; See possible answers