netnerds.net
Home
Book
Links icon
Data Platform GitHub Org GitHub Profile GitHub Star Profile MVP Profile Twitch
About
Subscribe
  • 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
  • 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. Like many of the Windows Key scripts available, this one relies on Remote Registry being …


    Read More
  • Using .NET DataTable Computes and Column Expressions in PowerShell

    Feb 3, 2015 · 5 min read  ·
    Share on:

    As a SQL Server DBA, I'm used to SQL being able to perform aliasing, super fast subselects, and easy aggregation. My most recent project, Invoke-Locate.ps1, however, uses SQLite because of its portability and speed when performing simple selects and inserts. The downside is that SQLite doesn't handle some subselects …


    Read More
  • Working with Basic .NET DataSets and DataTables in PowerShell

    Feb 1, 2015 · 3 min read  ·
    Share on:

    This is mostly for my reference, but you can use it, too :) Create Basic Datatable 1$dt = New-Object System.Data.Datatable 2[void]$dt.Columns.Add("First") 3[void]$dt.Columns.Add("Second") 4[void]$dt.Columns.Add("Third") 5 6# Add a row manually …


    Read More
  • High-Performance Techniques for Importing CSV to SQL Server using PowerShell

    Jan 18, 2015 · 10 min read  ·
    Share on:

    If you've ever tried to use PowerShell's Import-CSV with large files, you know that it can exhaust all of your RAM. Previously, I created a script on ScriptCenter that used an alternative technique to import large CSV files, and even imported them into SQL Server at a rate of 1.7 million rows a minute. I've now gotten …


    Read More
  • Professional PowerShell-based SQL Server SMO Recipes

    Jan 8, 2015 · 2 min read  ·
    Share on:

    Last year, I finally started working with SMO (SQL Management Objects) within PowerShell and I absolutely love it. Below are a few recipes that I created and use extensively throughout my SQL Management scripts, which you can find on ScriptCenter. Some recipes show more than one way to perform a task. These SMO recipes …


    Read More
  • Enumerate file structure within detached MDF database file using SMO

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

    While researching how connect to a detached MDF and read the internal file structure of the internal files, including LDF files, I kept seeing suggestions for using the undocumented DBCC command DBCC checkprimaryfile. Initially, my code looked like this: 1# SQL Server is required to read the file contents 2$servername …


    Read More
  • Workaround for SMO Bug: urn could not be resolved at level OleDbProviderSetting

    Jan 3, 2015 · 1 min read  ·
    Share on:

    Microsoft ConnectM isn't letting me sign in to post this workaround, but I just ran into a bug with the OleDbProviderSettings within SMO. To get around it, I used $server.Settings.OleDbProviderSettings instead of $server.OleDbProviderSettings 1$server.Settings.OleDbProviderSettings.Name.Contains("SQLOLEDB") …


    Read More
  • About Invoke-Locate, a PowerShell port of GNU findutils' locate and updatedb.

    Dec 1, 2014 · 5 min read  ·
    Share on:

    Tonight, I published Invoke-Locate.ps1 to ScriptCenter because I was tired of mounting my Windows drive to my Linux servers to quickly and reliably find files. Originally, it was going to be a small script, but then I decided to trick it out, add an installer and automatic Task Scheduling to run updatedb. The installer …


    Read More
  • Downgrade SQL Server Cluster from Enterprise to Standard

    Sep 8, 2014 · 3 min read  ·
    Share on:

    I'm currently working on a PowerShell/SQL set of scripts to ease SQL Server Migrations. A few of the scripts have been posted to Microsoft's ScriptCenter. Recently, one of the ScriptCenter visitors asked: Can this script be used to backup all server configuration and restore at a later date. The use case I have is that …


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

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

  • Install-DbaMaintenanceSolution now supports auto-scheduling
  • [Solved] OmniSharp.Extensions.JsonRpc.RpcErrorException in VS Code Dev Containers for PowerShell-based Azure Functions
  • Exploring GitHub Copilot Chat
  • Offline Installation of dbatools 2.0 with the dbatools.library Dependency
  • New Encryption and Certificate Defaults in Microsoft's SQL Server Connection Provider
  • What's new and different in dbatools 2.0
  • Don't waste your time with ($PSEdition -eq 'Core') in your PowerShell module manifest/psd1
  • Exploring faster PowerShell import times.. again

categories

sql-server 121 powershell 116 general 63 security 59 windows 47 sharepoint 41 active-directory 37 linux 31 networking 30 vbscript 30 apple 24 virtualization 22 iis 19 github 8 apache 7
All Categories
active-directory37 apache7 apple24 asp-net2 azure-functions1 bi4 db24 devcontainers1 exchange7 general63 github8 iis19 linux31 livestreaming4 lync2 mastodon4 networking30 oracle1 powershell116 security59 sharepoint41 sql-server121 vbscript30 virtualization22 windows47 wpf7
[A~Z][0~9]
 

Copyright 2003 -  Chrissy LeMaire. All Rights Reserved