Skip to content
WickTech Blog
Thoughts on SQL Server, PowerShell, and excursions with a Canon camera
  • About
  • Posts
  • Blog Roll
  • Presentations
  • Photo Gallery
  • Contact

Category: SQL Server

Commit or Rollback Dependent Transactions

2019-03-05 Jamie Leave a comment

Sometimes it is necessary to apply or fail multiple transactions together (all changes succeed or all changes fail). This can…

Continue Reading →

Posted in: SQL Server Filed under: commit transaction, dependent transactions, error handling, rollback transaction, t-sql, Try Catch

PowerShell and Group Managed Service Accounts (gMSA)

2019-02-19 Jamie 4 Comments

This is one article in a series that cover how to use PowerShell scripts to automatically install SQL Server. The full script set can be found here. Service Accounts are a requirement for installing and running a SQL…

Continue Reading →

Posted in: PowerShell, SQL Server Filed under: Active Directory, gMSA, install, Managed Service Account, PowerShell, SQL Server

Who Dropped The Database?

2019-02-05 Jamie Leave a comment

Occasionally I find it necessary to determine the Who and When of a database being created or deleted on one…

Continue Reading →

Posted in: SQL Server Filed under: Audit, Create Database, DDL, Drop Database, Trace Log

Monitoring Virtual Log File Information

2019-01-02 Jamie 1 Comment

Monitoring transaction log usage is an important part of database maintenance. High numbers of Virtual Log Files (VLFs) within a…

Continue Reading →

Posted in: SQL Server Filed under: database maintenance, DBCC, Transaction Log, Virtual Log File, VLF Count, VLF Stats

SQL Events and the #sqlPhotowalk

2018-09-08 Jamie Leave a comment

We’re coming up on a great time of year again, for SQL database geeks. The PASS Summit. I’ll leave off…

Continue Reading →

Posted in: Photography, SQL Server

How Secure Are Your Client Connections?

2018-09-04 Jamie 1 Comment

First, thanks to Sean McCown (t|w) and Mladen Prajdic (t|w) for their assistance with finding & confirming some of the…

Continue Reading →

Posted in: PowerShell, SQL Server Filed under: Encryption, encryption cipher, encryption protocol, Schannel, Security, SQL client, SQL Server, SSL Certificate, TLS

Log Backups, Auto Growth Settings & Alerts (Part 2 – Missing Log Backup Alert)

2018-08-02 Jamie 1 Comment

In the previous post we looked at how log backups and auto growth settings can affect performance. Now let’s look…

Continue Reading →

Posted in: SQL Server Filed under: backups, PBM, Policy, SQL Server

Log Backups, Auto Growth Settings, & Alerts (Part 1)

2018-07-09 Jamie 1 Comment

Why does missing a few log backups matter? I was asked that question last week when one of our backup…

Continue Reading →

Posted in: SQL Server Filed under: backups, configure, database maintenance, growth setting, SQL Server

PowerShell & JSON – a good match to tame numerous parameters

2018-06-04 Jamie Leave a comment

There are more than 1000 different ways to configure a SQL Server instance. Just to install a new SQL Server…

Continue Reading →

Posted in: PowerShell, SQL Server Filed under: configure, install, JSON, parameters, PowerShell, SQL Server

Post navigation

Page 3 of 3
← Previous 1 2 3

Categories

Connect with

  • LinkedIn
  • Twitter
Tweets by Jamie_Wick
Copyright © 2023 WickTech Blog
 

Loading Comments...