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

2,903 reads

SQLServerCentral Article

Scheduling PowerShell Using Jenkins

Introduction PowerShell is a task-based command-line shell and scripting language; it is designed specifically for system administrators and power-users, to rapidly automate the administration of multiple operating systems (Linux, OSX, and Windows) and the processes related to the applications that run on those operating systems. For system administrators (DBAs\Wintel Admins), creating PowerShell scripts is a […]

5 (5)

You rated this post out of 5. Change rating

2020-12-10

4,047 reads

SQLServerCentral Article

Configuring SQL Server Always on Azure Servers(Iaas)

Configuration of SQL Server Always on in Azure Virtual machines differs in multiple ways comparing with the on-premise Implementations. This article will help you to have a handy note to configure always on in Azure servers from a DBA perspective.

5 (4)

You rated this post out of 5. Change rating

2020-09-04 (first published: )

13,610 reads

Blogs

Dynamic Warehouse & Lakehouse Connections in Microsoft Fabric Data Pipelines

By

When you develop data pipelines in Microsoft Fabric (the Azure Data Factory equivalent in...

New Pluralsight Course - Certified Kubernetes Administrator - Performing Cluster Version Upgrades

By

We’re working through the major refresh of my Certified Kubernetes Administrator series at Pluralsight! The...

What I actually do at Microsoft

By

I started working at Microsoft in January 2022. I enjoy it. I even wrote...

Read the latest Blogs

Forums

Strange behavior passing a variable in XML.value

By PatLap

Hi,  anyone would know why as soon as I add a WHERE statement (even...

What happened to my SSMS shortcuts in 20.1?

By Eric Mamet

I installed SSMS 20.1 and all my trusted keyboard shortcuts don't work anymore... <Ctrl>E...

logshipping is out of synch need to debug

By anoop.mig29

Hi We have logshipping which get out of synch in night due to purging...

Visit the forum

Question of the Day

Operator Precedence Order

What is the correct order of operator precedence from highest (evaluated first) to lowest?

See possible answers