netnerds.net
Home
Book
Links icon
GitHub Org GitHub Star Profile MVP Profile Twitch
About
Subscribe
  • Import-CsvToSql: Super Fast CSV to SQL Server Import PowerShell Module

    Sep 6, 2015 · 3 min read  ·
    Share on:

    A while back, I wrote about High-Performance Techniques for Importing CSV to SQL Server using PowerShell. Earlier today, I released a PowerShell module, CsvSqlImport.psm1, which puts that post into practice. Using this module, it's possible to import over 90,000 records a second in optimized environments. In addition …


    Read More
  • How to drop a SQL database stuck in Restoring...

    Jun 21, 2015 · 1 min read  ·
    Share on:

    No idea where I got this (it's been in Drafts forever), and now I kinda want to do it in PowerShell, but here's some T-SQL to drop a hella stuck database (if plain old restore database @dbname doesn't work). 1DECLARE @dbname sysname 2DECLARE @spid int 3DECLARE @dbid int 4SET @dbname = 'big' 56SELECT @spid = …


    Read More
  • Reset-SqlSaPassword: Easily regain sa/sysadmin access to your SQL Servers

    Jun 7, 2015 · 2 min read  ·
    Share on:

    It's obvious that I love PowerShell and SQL Server. Together, they allow SQL Server DBA's to solve just about any problem. Most of my projects have come from questions posted in Reddit's SQL Server subreddit, including my most recent project, Reset-SqlSaPassword, which allows you to regain syadmin access to your SQL …


    Read More
  • Getting Total Number of Rows Copied in SqlBulkCopy Using PowerShell

    May 18, 2015 · 2 min read  ·
    Share on:

    Getting the total number of inserted rows for SqlBulkCopy should be easier, but I believe the easiest (and fastest) is by using reflection and some C# code within your PowerShell script. Thanks to user601543 at stackoverflow, I was able translate his code for use within one of my own scripts. The Code Here's an …


    Read More
  • Simplifying SQL Server Migrations using PowerShell

    May 15, 2015 · 1 min read  ·
    Share on:

    Recently, I did a webcast for the PowerShell Virtual Chapter of PASS on Simplifying SQL Server Migrations using PowerShell. If you're planning for a SQL Server migration, I wrote a bunch of scripts that can help, and put them all on github. Check out the sqlmigration repository, and the accompanying PowerPoint Slides. …


    Read More
  • 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") 56# Add a row manually …


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

    Jan 18, 2015 · 9 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
    • ««
    • «
    • 2
    • 3
    • 4
    • 5
    • 6
    • »
    • »»

Chrissy LeMaire

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

preorder

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

  • 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
  • Chef inspec: Unable to detect your platform
  • Migrating my WordPress sites to GitHub Pages
  • URL Shortening/Redirects using GitHub Pages and Jekyll

categories

sql-server 116 powershell 107 general 63 security 58 windows 47 sharepoint 41 active-directory 37 linux 31 networking 30 vbscript 30 apple 22 virtualization 22 iis 19 apache 7 exchange 7
All Categories
active-directory37 apache7 apple22 asp-net2 bi4 db24 exchange7 general63 github3 iis19 linux31 livestreaming4 lync2 networking30 oracle1 powershell107 security58 sharepoint41 sql-server116 vbscript30 virtualization22 windows47 wpf7
[A~Z][0~9]
 

Copyright 2003 -  Chrissy LeMaire. All Rights Reserved