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

Don’t forget the SIDs

2020-05-13 Jamie Leave a comment

When talking with people about databases and disaster recovery our conversation often sounds like this: Q: What does your backup…

Continue Reading →

Posted in: SQL Server Filed under: create login, database user, Login, relink user login, SID, SQL Server, System Identifier

Jupyter books in Azure Data Studio

2020-04-14 Jamie 1 Comment

Jupyter Book: A collection of SQL, PowerShell, and Python-based notebooks and markdown files. In a recent Channel9 segment, Vicky Harp…

Continue Reading →

Posted in: PowerShell, SQL Server Filed under: azure data studio, Jupyter book, notebook, PowerShell, SQL Server

Getting started with Windows containers & SQL Server

2020-03-17 Jamie 2 Comments

SQL Server containers are gaining popularity as a way of enhancing and standardizing development environments for Windows & Linux based…

Continue Reading →

Posted in: Containers, PowerShell, SQL Server Filed under: Docker, PowerShell, SQL Server, Windows container

Troubleshooting slow reports in PowerBI Report Server.

2020-02-04 Jamie 1 Comment

Troubleshooting “slow” reports in PowerBI Report Server (or SQL Server Reporting Services) can be an arduous task. End users are…

Continue Reading →

Posted in: PowerBI, SQL Server Filed under: Execution Log, PowerBI, PowerBI Report Server, Reports, SQL Server, troubleshooting

Delegated Authentication with Managed Service Accounts

2020-01-06 Jamie 4 Comments

Delegated authentication (or double-hop authentication as it’s sometimes called) is a common requirement with SQL servers that are using Kerberos…

Continue Reading →

Posted in: PowerBI, SQL Server Filed under: Active Directory, delegate authentication, double-hop authentication, Group Managed Service Account, kerberos, Managed Service Account, msDS-AllowedToDelegateTo, PowerBI Report Server, SQL Server, userAccountControl

Managing Azure On-Premises Data Gateways

2019-12-17 Jamie 1 Comment

When organizations become aware of the On-premises Data Gateway application, there can be an explosion in the number of gateways…

Continue Reading →

Posted in: Azure, PowerBI, SQL Server Filed under: Azure, On-Prem Data, on-prem data gateway, Power Platform, PowerApps, PowerBI

Troubleshooting Deadlocks with Extended Events

2019-11-05 Jamie Leave a comment

Continue Reading →

Posted in: SQL Server Filed under: deadlock, extended events, SQL Server, troubleshooting

Branding PowerBI Report Server & SSRS 2017

2019-10-14 Jamie 18 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

Post navigation

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

Categories

Connect with

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

Loading Comments...