netnerds.net
Home
Book
Links icon
Data Platform GitHub Org GitHub Profile GitHub Star Profile MVP Profile Twitch
About
Subscribe
  • 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
  • SQL Server Client Tools, Linux and Integrated Authentication in a Few Easy Steps

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

    Back in 2013, I wrote about "Using Windows Authentication to Connect to SQL Server from Linux". Considering how convoluted using Linux can get, doing so was surprisingly straightforward then and it's even easier now. Want to see a webcast about this topic? Aaron Nelson and I recorded a session for the SQL …


    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
  • SQL Server Solution Least Likely to Work, Actually Did

    Feb 29, 2016 · 1 min read  ·
    Share on:

    Two of my SQL Servers stopped working after an unexpected power outage. When I attempted to start them, they gave me an Access Denied error. These are two totally different machines (diff Win & diff SQL version) that both, after years of working, just stopped in their tracks with an Access Denied. This isn't an …


    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
  • 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' 5 6SELECT @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
    • ««
    • «
    • 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

  • Making VS Code Themes with ChatGPT
  • Update-Module dbatools Authenticode Issuer Error
  • Install-DbaMaintenanceSolution now supports auto-scheduling
  • [Solved] OmniSharp 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

categories

sql-server 122 powershell 117 general 63 security 60 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 ai1 apache7 apple24 asp-net2 azure-functions1 bi4 db24 devcontainers1 exchange7 general63 github8 iis19 linux31 livestreaming4 lync2 mastodon4 networking30 oracle1 powershell117 security60 sharepoint41 sql-server122 vbscript30 virtualization22 windows47 wpf7
[A~Z][0~9]
 

Copyright 2003 -  Chrissy LeMaire. All Rights Reserved