Skip to content
WickTech Blog
Thoughts on SQL Server & Technology
  • About
  • Posts
  • Blog Roll
  • Presentations
  • Photo Gallery
  • Contact

Author: Jamie

Branding PowerBI Report Server & SSRS 2017

2019-10-14 Jamie 20 Comments

Recently I was working on rolling out a new PowerBI Report Server, along with migrating our 2014-based SQL Server Reporting…

Continue Reading →

Posted in: PowerBI, SQL Server Filed under: branding, custom color, PowerBI, PowerBI Report Server, Reports, SQL Server

Using On-Prem Data With Azure Apps

2019-09-04 Jamie Leave a comment

One of the challenges many organizations face when beginning to work with Azure applications (PowerBI, PowerApps, Flow, etc.) is that…

Continue Reading →

Posted in: Azure Filed under: Azure Apps, Flow, gateway, On-Prem Data, PowerApps, PowerBI

Troubleshooting a renamed SQL Server

2019-06-05 Jamie 1 Comment

First, thanks to Sean McCown (@KenpoDBA) at MinionWare (@heyMinionware) for the help troubleshooting. Recently I had to rename a SQL…

Continue Reading →

Posted in: SQL Server Filed under: @@SERVERNAME, configure, rename, SQL Server, troubleshooting

Backup On-Prem SQL Databases to Azure

2019-04-16 Jamie 1 Comment

Azure storage, as a backup destination for SQL backups, is a great option for organizations that are contemplating replacing older…

Continue Reading →

Posted in: Azure, SQL Server Filed under: Azure, Azure Storage, backups, database maintenance, SQL Credential

Are Differential Backups Necessary?

2019-04-02 Jamie 1 Comment

SQL Server natively supports 3 types of backups: Full, Differential and Log. Full backups take a complete backup of the…

Continue Reading →

Posted in: SQL Server Filed under: database maintenance, Differential, recovery, Restore, restore process, SQL Server, stopat

PowerShell and Failover Clustering (WSFC)

2019-03-19 Jamie Leave a comment

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. High availability in production SQL Servers is often a desirable feature.…

Continue Reading →

Posted in: PowerShell, SQL Server Filed under: Availability Groups, failover cluster, PowerShell, SQL Server, wsfc

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

Post navigation

Page 3 of 4
← Previous 1 2 3 4 Next →

Categories

Connect with

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

Loading Comments...