netnerds.net
Home
Book
Links icon
Data Platform GitHub Org GitHub Profile GitHub Star Profile MVP Profile Twitch
About
Subscribe
  • 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
  • Import Large CSVs into SQL Server Using PowerShell

    Jul 4, 2014 · 6 min read  ·
    Share on:

    A buddy of mine was running into issues importing a 1 GB CSV of Longitudes and Latitudes available from geonames.org. The CSV contains over 9 million rows, and no matter what he did, DTS/SSIS would not import the data because of conversion issues. That's actually been happening to me a lot lately, too, so I find myself …


    Read More
  • [SOLVED] Degraded Performance on HP DL580 G7 on BIOS v. 7/01/2013

    Feb 27, 2014  · Brandon Abshire   · 1 min read  ·
    Share on:

    After a December 2013 patching downtime, I noticed an abrupt decrease of almost 50% in the performance of 2 SQL Servers. Both servers were running on HP DL580 G7s. After many hours of testing and data collection, we finally updated the BIOS firmware from 7/01/2013 to 10/31/2013. The issue immediately resolved itself. …


    Read More
  • SQL Troubleshooting: Searching the Plan Cache for Missing Indexes and Execution Statistics

    Feb 26, 2014  · Brandon Abshire   · 6 min read  ·
    Share on:

    I've always found basic administration of SQL Server to be fairly straight-forward, but for a long while, I felt very uneasy about troubleshooting SQL Server performance issues. Any DBA knows that the most productive periods of learning arise when there are problems. For the past few months, I've been trying to track …


    Read More
  • SQL Server System Processes Blocking User Processes when Auto Update Stats Async is Enabled.

    Jan 28, 2014  · Brandon Abshire   · 3 min read  ·
    Share on:

    Recently, we decided to buy a few licenses of Confio Ignite (Now SolarWinds Database Performance Monitor) to monitor some of our high-profile SQL Servers. I'm definitely not posting a sales pitch, but for me, it's provided insight into SQL Server that is much more difficult to obtain through traditional methods. One of …


    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

  • 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