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,564 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,047 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,982 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,070 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,212 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,607 reads
2006-09-04
5,972 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,437 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,361 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Gatot Subroto Barat TLP/WA 0821-697-7749
Jl. Gatot Subroto Barat No.334 Blok B, Padangsambian Kaja, Kec. Denpasar Bar., Kota Denpasar,...
BCA KCP Gatot Subroto Dps TLP/CS 0821•697•7749
Jl. Gatot Subroto Barat No.80 unit 8-9, Dangin Puri Kaja, Kec. Denpasar Utara, Kota...
Alamat kontak resmi BCA KCU YOGYAKARTA | Telp: 0817825533
phone, Wa: 0817825533, Jl. Jend. Sudirman No.49-51, Terban, Kec. Gondokusuman, Kota Yogyakarta, Daerah Istimewa...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers