Chrissy LeMaire's blog

How to drop a SQL database stuck in Restoring...
Jun 21, 2015 · 1 min read ·
Share on:
No idea where I got this (it's been in Drafts forever), and now I kinda want to do it in PowerShell, but here's some T-SQL to drop a hella stuck database (if plain old restore database @dbname doesn't work).
1DECLARE @dbname sysname 2DECLARE @spid int 3DECLARE @dbid int 4SET @dbname = 'big' 5 6SELECT …
Read More
Reset-SqlSaPassword: Easily regain sa/sysadmin access to your SQL Servers
Jun 7, 2015 · 2 min read ·
Share on:
It's obvious that I love PowerShell and SQL Server. Together, they allow SQL Server DBA's to solve just about any problem. Most of my projects have come from questions posted in Reddit's SQL Server subreddit, including my most recent project, Reset-SqlSaPassword, which allows you to regain syadmin access to your SQL …
Read More
Getting Total Number of Rows Copied in SqlBulkCopy Using PowerShell
May 18, 2015 · 2 min read ·
Share on:
Getting the total number of inserted rows for SqlBulkCopy should be easier, but I believe the easiest (and fastest) is by using reflection and some C# code within your PowerShell script. Thanks to user601543 at stackoverflow, I was able translate his code for use within one of my own scripts. …
Read More
Simplifying SQL Server Migrations using PowerShell
May 15, 2015 · 1 min read ·
Share on:
Recently, I did a webcast for the PowerShell Virtual Chapter of PASS on Simplifying SQL Server Migrations using PowerShell. If you're planning for a SQL Server migration, I wrote a bunch of scripts that can help, and put them all on github.
Check out the sqlmigration repository, and the accompanying PowerPoint Slides. …

Read More
Sudden High CPU Utilization and Query Performance Decrease | When Query Plans Go Bad
Apr 20, 2015 · Brandon Abshire · 7 min read ·
Share on:
Each morning when I get into the office, I check performance graphs in SolarWinds Database Performance Analyzer (DPA - formerly Confio Ignite). Monday mornings are usually the most important, because I run full system maintenance on a specific monitored database on Sunday. Monday is the first day of heavy utilization …
Read More
Making Bootable USB sticks on Windows
Apr 2, 2015 · 1 min read ·
Share on:
Just because I always forget.. All of my workstations are Macs, which I then use to connect to my vSphere and Hyper-V labs. This can make it a challenge to create bootable Windows-based USB sticks for my servers. I used to use unetbootin for Mac, but I found it worked well for my ESX servers (sometimes), but not …
Read More
Get SQL Server Product Keys for Local and Remote Servers using PowerShell
Mar 22, 2015 · 1 min read ·
Share on:
I just released a new PowerShell script, Get-SQLServerKeys.ps1. The script works works with several versions of SQL Server (2005-2014), and can use Central Management Server, a text file, or just a string of servers as input.
<img …</picture></figure></a></p>

Read More
Creating a WCF Net.TCP Service and Client using PowerShell
Mar 4, 2015 · 2 min read ·
Share on:
I'm currently attending Regis University for my grad degree, and just finished up a networking class. For my final, I chose to explore the Windows Net.TCP Port Sharing Service. I had this glorious vision of translating some C# code to 100% PowerShell code, but eventually gave into the fact that PowerShell doesn't …
Read More
Securely Administer Your Remote Windows Network using RDP over SSL
Feb 17, 2015 · 4 min read ·
Share on:
Back in 2013, I wrote a blog post about setting up RD Gateway in Windows 2012 using an AD domain certificate. This post is directed to Windows 2012 R2. There isn't much difference, but in this tutorial, I'll demonstrate how to setup RD Gateway with a globally recognized SSL certificate.
Like my previous post about …

Read More
Setup an SSTP SSL VPN in Windows Server 2012 R2
Feb 17, 2015 · 6 min read ·
Share on:
So here's what's awesome about Secure Socket Tunneling Protocol SSL VPNs: they give your connecting client an IP and make it a full-on part of the network. And this is all done over port 443, a commonly used port which is often enabled on firewalls. SSTP SSL VPNs are not like some fake "SSL VPNs" that just …
Read More
- 10
- 11
- 12
- 13
- 14