Articles

SQLServerCentral Article

Advanced SQL Server installation using Powershell DSC

Introduction In the previous article, we learned how to install a SQL Server instance with basic parameters like InstanceName, Features, SourcePath, SQLSysAdminAccounts, etc using Powershell DSC. In this article, we'll discover how to enhance our SQL Server installation with additional configurations. We'll cover things like setting up service account credentials, custom installation directories, configuring TempDB […]

5 (3)

You rated this post out of 5. Change rating

2023-11-22

1,370 reads

SQLServerCentral Article

5 (3)

You rated this post out of 5. Change rating

2023-11-20 (first published: )

1,376 reads

SQLServerCentral Article

Scheduling SQL Agent Jobs on Alternating Weeks

Bi-week... semi-week... fortnight... "every two weeks" Recently on the SQL Community Slack group, someone asked if there was a way to schedule a backup to run on alternate weeks. I'm not exactly sure why (maybe they wanted to run full and differential backups on alternating weeks), but yes, we can do that. In part one […]

You rated this post out of 5. Change rating

2023-11-17

1,171 reads

Blogs

Friday Flyway Tips–Comparison Options

By

Recently a customer asked how they could get index changes to be captured in...

A New Word: Guiltwrights

By

giltwrights  – n. the imaginary committee of elders that keeps a running log of...

Becoming Kristyna Ferris <3

By

Hey folks, fun personal post today. A few weeks ago, I got married! My...

Read the latest Blogs

Forums

Love

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Love

Drop or delete a existing partition

By Siten0308

Hello, so I was reading on partitioning a large table, Which i successfully did,...

PostgreSQL authenticated against Microsoft Active Directory

By SSRSNoob

Can I authenticate with Active Directory and get into PostgreSQL? Version: PostgreSQL 16.1 on...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers