Posts

SQL Troubleshooting: Searching the Plan Cache for Missing Indexes and Execution Statistics
Feb 26, 2014 · Brandon Abshire · 6 min read ·
Share on:
I've always found basic administration of SQL Server to be fairly straight-forward, but for a long while, I felt very uneasy about troubleshooting SQL Server performance issues. Any DBA knows that the most productive periods of learning arise when there are problems. For the past few months, I've been trying to track …
Read More
SQL Server System Processes Blocking User Processes when Auto Update Stats Async is Enabled.
Jan 28, 2014 · Brandon Abshire · 3 min read ·
Share on:
Recently, we decided to buy a few licenses of Confio Ignite (Now SolarWinds Database Performance Monitor) to monitor some of our high-profile SQL Servers. I'm definitely not posting a sales pitch, but for me, it's provided insight into SQL Server that is much more difficult to obtain through traditional methods. One …
Read More
SQL Server: Cannot Generate SSPI Context and KRB_AP_ERR_MODIFIED Errors
Dec 7, 2013 · Brandon Abshire · 4 min read ·
Share on:
As DBAs, one of the most common tasks performed is the installation of new SQL Servers. While I've installed hundreds of SQL Server instances over the years, I only recently come across the error described below. In the past, I've seen the SSPI context error, but it is usually tied to an issue with a domain …
Read More
[Solved]: New-WebServiceProxy / GetListItems Excessive Lookup Issue
Oct 30, 2013 · 2 min read ·
Share on:
Recently, while trying to use New-WebServiceProxy to automate some SharePoint form entries, I ran into a lookup issue.
First, I got this rather generic error: Exception calling "GetListItems" with "7" argument(s): "Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was …

Read More
Using Windows Authentication to Connect to SQL Server from Linux
Oct 22, 2013 · 4 min read ·
Share on:
One of the things I love most about SuSE is how well it integrates with Active Directory. Joining a domain is easy when using yast. First I ensured that the Linux server's DNS server is pointed to my DC, then yast -> Network Services -> Windows Domain Membership. …
Read More
Mounting NAS Volumes in Mac OS X the Right Way
Oct 8, 2013 · Brandon Abshire · 3 min read ·
Share on:
I've been using Mac OS X for a while now, but upgraded to a 13-inch Macbook Pro Retina about a year ago. I love having access to the command line and I just RDP when I need to do anything on a Windows machine at work. I often find myself needing to access my NAS and networking is one of the only features of OS X to …
Read More
PowerShell One-Liner: Get External IP Address
Sep 10, 2013 · 1 min read ·
Share on:
Need your External IP address? Just use the following in PowerShell 3 and above
$ip = (Invoke-WebRequest https://ipinfo.io/ip).Content.Trim()
As a bonus, you can also get additional IP information using ipinfo.io's JSON web service.
$jsonip = Invoke-WebRequest https://ipinfo.io/json $ipinfo = Convertfrom-JSON …

Read More
Setup a Fully Functional Lync 2013 Lab Using only One Public IP Address
Aug 23, 2013 · 4 min read ·
Share on:
Note: This article assumes you know how to setup Lync 2013 already and just need to know the intricacies of changing the default ports.
Ever since I was exposed to Lync in 2011, I've been a huge proponent of using chat to communicate at work. Years ago, I recall corporate chat being a hard sell, but now it seems …

Read More
Running Lync 2010 with a SQL Server 2012 Backend
Aug 10, 2013 · Brandon Abshire · 1 min read ·
Share on:
Recently I was tasked with migrating all SQL 2008 R1 and prior databases to SQL 2008 R2 and SQL 2012. One of my qualifying applications was Lync 2010. We were under the impression that SQL 2012 would be fine for the Lync 2010 installation. After migrating the database and updating the connections, Lync would not …
Read More
PowerShell v3: Get Volume Information for Clustered SQL Server Storage
Jul 23, 2013 · 2 min read ·
Share on:
Unfortunately, there are no native PowerShell Failover Cluster cmdlets which will give you the volume information for disks in a cluster. I've seen some bloggers use Get-ClusterSharedVolume but a Cluster Shared Volume or CSV is different from volumes used within a SQL cluster.
The script below, which was written with …

Read More
- 13
- 14
- 15
- 16
- 17