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 controller, …

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. yast-wdm Note that if "Windows Domain …

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 fully …

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 …

This is sort of a continuation of my earlier post, Importing Windows Forwarded Events into SQL Server using PowerShell, where I mentioned that I was unable to get the script to work on Windows 2008 R2 due to a known bug in Get-WinEvents. I had to end up deploying my solution to a Windows 2008 R2 Server and was required …

I know the ideal Enterprise network won't have any SQL Server Express instances, but every large network that I've ever worked on has at least a few. Many times, it's powering apps like SolarWinds or BackupExec. Since SQL Express doesn't run SQL Agent, it can be a pain to backup and maintain the systems. There are a …

Update: You can't even independently schedule slave jobs. Count my organization as yet another that won't be implementing MultiServer Administration. Grrr. I always forget about Multiserver Administration. I've actually never worked in an environment that uses it, even though it seems to have a lot of potential. I …

Over the past couple weeks, I've looked into a number of ways of parsing and importing Windows Forwarded Events into SQL Server: from using SSIS to LogParser to PowerShell to setting up a linked server to the "Forwarding Events.evtx" file. Ultimately, the only thing that worked was PowerShell's Get-WinEvent …

I've known about SQL Database Snapshots for a while, but never really took the time to use the feature. Lately, I've gotten into mirroring again and decided to play around with Database Snapshots. I should clarify at this point that I'm speaking about the native SQL snapshot capabilities, and not a filer technology …

Each time I start a new contract, the first thing I do is search for all SQL Servers across any network/subnet to which I have access. While the documentation I get is usually paltry or non-existent. When it does exist, it's usually only for the production SQL Servers. Sometimes, most production SQL Servers aren't even …