netnerds.net
Home
Book
Links icon
Data Platform GitHub Org GitHub Profile GitHub Star Profile MVP Profile Twitch
About
Subscribe
  • 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 controller, …


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


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


    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
  • PowerShell Get-WinEvent Bug Workaround on Windows 2008 R2 Server -- Importing Windows Forwarded Events into SQL Server using PowerShell

    Apr 10, 2013 · 2 min read  ·
    Share on:

    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 …


    Read More
  • Quick and Dirty: Backup SQL Server Express Instances on Enterprise Networks

    Apr 5, 2013 · 2 min read  ·
    Share on:

    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 …


    Read More
  • Safely Enable SQL Server Agent MultiServer Administration using PowerShell

    Apr 5, 2013 · 4 min read  ·
    Share on:

    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 …


    Read More
  • Importing Windows Forwarded Events into SQL Server using PowerShell

    Mar 20, 2013 · 5 min read  ·
    Share on:

    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 …


    Read More
  • Leveraging SQL Database Snapshots

    Aug 2, 2012  · Brandon Abshire   · 4 min read  ·
    Share on:

    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 …


    Read More
  • SQL Server Discovery Tools and Scripts

    May 24, 2012 · 2 min read  ·
    Share on:

    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 …


    Read More
    • ««
    • «
    • 4
    • 5
    • 6
    • 7
    • 8
    • »
    • »»

Chrissy LeMaire

SQL & PowerShell MVP. GitHub Star. Creator of dbatools. Need to oil my knees.

dbatools book

Physical books ship from manning.com on June 10, 2022! Arrives in stores and Amazon on July 5 🥳. Order or preorder now.

dbatools

dbatools is an awesome PowerShell module that helps you migrate entire instances with a single command, plus a whole lot more.

available from dbatools.io and github

dbachecks

dbachecks validates SQL Server environments using crowdsourced DBA checklists and outputs to Power BI and is available on github.com 📊

recent posts

  • Signing Windows Software with GitHub Actions, Encrypted Secrets and PowerShell
  • ExpressVPN on macOS: No internet detected
  • RBAR Performance in PowerShell
  • Import-DbaCsv Design Considerations
  • Rebuilding a Proxmox cluster node
  • Default PowerShell Paths (PSModulePath) on GitHub Runners
  • Add existing directory storage to proxmox without wiping it first
  • InspecTools on Offline Windows

categories

sql-server 117 powershell 109 general 63 security 59 windows 47 sharepoint 41 active-directory 37 linux 31 networking 30 vbscript 30 apple 23 virtualization 22 iis 19 apache 7 exchange 7
All Categories
active-directory37 apache7 apple23 asp-net2 bi4 db24 exchange7 general63 github4 iis19 linux31 livestreaming4 lync2 networking30 oracle1 powershell109 security59 sharepoint41 sql-server117 vbscript30 virtualization22 windows47 wpf7
[A~Z][0~9]
 

Copyright 2003 -  Chrissy LeMaire. All Rights Reserved