Stairway to SQL PowerShell Level 3: Input and Output with PowerShell
This level will cover some of the Input/Output operations you can use with PowerShell.
Stairway to SQL PowerShell Level 4: Objects in SQL PowerShell
This far, we have learned about installation and setup of the PowerShell environment. You should now have a foundation of SQL Server PowerShell. We now are ready to learn about Objects in SQL PowerShell.
Stairway to SQL Server Agent - Level 10: Using proxy accounts with your Jobs
Examines the proxy subsystem, which allows job steps to impersonate another user account in order to perform tasks as a user other than the SQL Server Agent service account. This is especially useful when you want jobs to run as lower privileged users of your SQL Server.
Stairway to SQL Server Agent - Level 11: Maintenance Plan Jobs
How maintenance plans are used as SQL Server Agent jobs to automate standard system tasks. This article will also lay out some suggested jobs that should be on virtually all SQL Server systems.
Stairway to SQL Server Agent - Level 12: Using MSX/TSX to scale out Job Management
Examines the scale-out capabilities of SQL Server Agent, using the MSX/TSX subsystem. This capability allows you to run jobs on multiple systems and consolidate the job results/history onto a single server.
Stairway to SQL Server Agent - Level 2: Job Steps and Subsystems
SQL Server Agent jobs are made up of a series of one or more Job Steps. A job step is assigned to a specific job subsystem, which identifies the kind of work the job step is going to perform. Each job step runs in a separate security context, although each job also has an owner that determines who can modify the job.
Stairway to SQL Server Agent - Level 3: Agent Alerts and Operators
How to be notified when a job succeeds or fails, or be notified when a SQL Server performance condition is met.
Stairway to SQL Server Agent - Level 4: Configuring Database Mail
Examines the database mail system configuration in depth. You will learn how to configure database mail to work with SMTP mail systems, and get some troubleshooting tips.
Stairway to SQL Server Agent - Level 5: Understanding SQL Agent Error Logs
How to interpret and configure the SQL Server Agent error logs. Critical information about SQL Server Agent is sent to this error log, so knowing how to find it and how to interpret information in the log will save you valuable troubleshooting time.
Stairway to SQL Server Agent - Level 6: Workflow within Jobs - Drilling into Job steps
How to configure and optimize job steps. Topics such as process flow between steps, security, and more details of the job subsystems are examined.
Blogs
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers