netnerds.net
Home
Book
Links icon
Data Platform GitHub Org GitHub Profile GitHub Star Profile MVP Profile Twitch
About
Subscribe
  • It’s 2016, so why are you still using sp_help_revlogin?

    Jun 14, 2016 · 4 min read  ·
    Share on:

    Today's blog post is part of T-SQL Tuesday. T-SQL Tuesday is the brainchild of Adam Machanic. It is a monthly blog party on the second Tuesday of each month. Everyone is welcome to participate. sp_help_revlogin is now old enough to drive a car By now in your career, you may have needed to migrate a few databases and …


    Read More
  • Counting the number of occurrences of a string or file in PowerShell

    May 11, 2016 · 1 min read  ·
    Share on:

    I always forget how to do this, and Aleksandar Nikolić posted a really beautiful answer on Powershell.com For a file: 1-split (Get-Content .\test.txt | Out-String) | 2Where-Object { $_ -eq "test" } | Measure-Object | 3Select-Object -exp count For a string: 1$html.content -split …


    Read More
  • Keeping up with SQL Server Connect Items Marked Closed as Fixed

    May 11, 2016 · 1 min read  ·
    Share on:

    Earlier this week, I was trying to determine people's feelings about Microsoft Connect by looking through Twitter. A few scrolls down, and I came upon this @Ms_Alaina My problem is I sometimes stumble upon a Connect item I filed in 2008, and have no idea when it was closed as fixed. — Aaron Bertrand (@AaronBertrand) …


    Read More
  • Trello is awesome for everything

    May 1, 2016 · 2 min read  ·
    Share on:

    The other week, I was introduced to Trello for the first time by this tweet and I fell in love. In case you missed it, here’s my Trello of upcoming “How Stack Overflow does X” blog posts, please vote or suggest! https://t.co/6E8JRb4RSu — Nick Craver (@Nick_Craver) February 1, 2016 Basically, Nick uses Trello to gauge …


    Read More
  • WE DID IT! Microsoft Fixed Those 3 SQLPS Issues in SQL Server 2016

    Apr 3, 2016 · 2 min read  ·
    Share on:

    In my previous blog post "Can We Get These 3 SQLPS Issues Fixed before SQL Server 2016 RTMs?", Aaron Nelson and I asked the SQL and PowerShell community to help upvote 3 SQL Connect items. The items addressed three problems with SQL Server's PowerShell module, SQLPS. It took 3-5 seconds to load It changed the …


    Read More
  • More on SQLPS and SQL Server on Linux

    Mar 17, 2016 · 2 min read  ·
    Share on:

    In tonight's PowerScripting Podcast, I shared a few things about SQL Server on Linux, and talked a bit about SQLPS. All after a lengthy intro about my tech life and Cajun culture ;) You can watch the whole thing, skip to 28 minutes to the podcast intro, or skip to around 59 minutes for the SQL/Linux/SQLPS portion. Or …


    Read More
  • Can We Get These 3 SQLPS Issues Fixed before SQL Server 2016 RTMs?

    Mar 4, 2016 · 4 min read  ·
    Share on:

    YES WE CAN! Microsoft responded and fixed these 3 major issues in SQL Server Management Studio March 2016 Refresh. Read more at "WE DID IT! Microsoft Fixed Those 3 SQLPS Issues in SQL Server 2016". I'll be honest, I don't use the SQLPS module even though I'm the perfect candidate. I've been a SQL Server DBA …


    Read More
  • Failed Domain Relationships on SQL Server Cluster Nodes

    Jan 20, 2016 · 2 min read  ·
    Share on:

    You know what's scary as hell? When one node of an important cluster loses its trust relationship with the domain and you see the error "the trust relationship between this workstation and the primary domain failed". That happened to me late last year with one of my SQL Server 2008 R2 nodes. The scary part …


    Read More
  • PowerShell Conference EU 2016, psconf.eu

    Jan 20, 2016 · 1 min read  ·
    Share on:

    I'll be presenting some sessions about SQL Server and PowerShell at the PowerShell Conference EU in Hanover, Germany on April 20-22! You should join me, because the speaker and session lineup is amaaazing! Register at psconf.eu. Want to know more? Check out PowerShellMagazine.com and psconf.eu!


    Read More
  • PowerShell Tip: You may not need to load the DLL for that Assembly that can't be found

    Jan 7, 2016 · 1 min read  ·
    Share on:

    Recently, I wanted to access the System.Windows.Forms.Integration.ElementHost type, which uses the System.Windows.Forms.Integration namespace. When I tried to load that namespace, PowerShell complained that The assembly 'System.Windows.Forms.Integration' could not be found. I read up and found that the …


    Read More
    • ««
    • «
    • 2
    • 3
    • 4
    • 5
    • 6
    • »
    • »»

Chrissy LeMaire

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

dbatools book

Now available in bookstores and amazon 🥳 Buy it at manning.com for 50% off with code bldbatools50

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 📊

Find me

Find me on Mastodon

recent posts

  • You just joined Mastodon, now what?
  • Using GitHub Pages to Setup an Alias on Mastodon
  • Aliases on Mastodon: Add me! I'm also [email protected]
  • Moving to Mastodon: I actually like it better (Updated!)
  • Docker on GitHub Actions macOS Runners (2022)
  • Signing Windows Software with GitHub Actions, Encrypted Secrets and PowerShell
  • ExpressVPN on macOS: No internet detected
  • RBAR Performance in PowerShell

categories

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

Copyright 2003 -  Chrissy LeMaire. All Rights Reserved