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

Author: Jamie

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

Server Maintenance – Snapshots & Maintenance Mode

2018-06-21 Jamie 1 Comment

Patching servers is an annoying, but critically necessary task. Every month, on every (virtual) server, we have to: Create a…

Continue Reading →

Posted in: PowerShell Filed under: maintenance mode, PowerShell, PSRemoting, SCOM 2016, script, server maintenance, snapshot, Using scope modifier, VMware

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

And so it begins….

2018-05-30 Jamie Leave a comment

Over the past few months I’ve had the opportunity give several presentations at various User Group meetings and SQLSaturday events. It’s…

Continue Reading →

Posted in: Uncategorized

Post navigation

Page 4 of 4
← Previous 1 … 3 4

Categories

Connect with

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

Loading Comments...