netnerds.net
Home
Book
Links icon
Data Platform GitHub Org GitHub Profile GitHub Star Profile MVP Profile Twitch
About
Subscribe
  • Create a DB2-C Express 9.5 Linked Server in SQL Server 2008

    Feb 16, 2009 · 4 min read  ·
    Share on:

    In order to emulate a DB2/iSeries<->SQL Server setup that I deal with at work, I installed DB2 Express-C on SuSE Linux Enterprise Server 10. The DB2/Linux Server details, as well as a sample database and table name, are as follows: IBM DB2 DatabaseNetwork NameLUCASTCP …


    Read More
  • Migrate/Transfer SQL Server 2008/2005/2000/7 Logins to SQL Server 2008

    Jan 26, 2009 · 10 min read  ·
    Share on:

    UPDATE: Just use my PowerShell script, Copy-SqlLogin. You just gotta execute one line and DBA's love it. To my knowledge, Microsoft has not yet updated their Knowledge Base to inform administrators how to migrate SQL Server logins to SQL Server 2008. The good news is that the SQL Server 2005 login migration knowledge …


    Read More
  • PowerShell 1.0: Backup and Restore a Database Between Two SQL 2005 Servers

    Jan 25, 2009 · 2 min read  ·
    Share on:

    My technical partner-in-crime, Brandon, created this PowerShell script last year in an effort to help him understand PowerShell a bit more. He noted that while it may not all be best practices SQL-wise, he tried his best to use as much PowerShell as possible. #Powershell to backup and restore a SQL database from …


    Read More
  • SharePoint Server 2007 SP1: Incorrect syntax near 'COLLATE' When Joining a Farm

    Jan 25, 2009 · 2 min read  ·
    Share on:

    While attempting to add a new Indexing Server to my firm's SharePoint farm using the SharePoint Products and Technologies Configuration Wizard, I ran into the following error when clicking Retrieve Database Names: ************** Exception Text ************** System.Data.SqlClient.SqlException: Line 1: Incorrect syntax …


    Read More
  • Efficiently Compare Two SQL Server Tables Using Mostly VBScript

    Jan 14, 2009 · 3 min read  ·
    Share on:

    Recently, a friend of mine asked to write a script to compare two SQL Server tables using mostly VBScript. The very thought made me shudder; I wanted desperately to compare the tables in SQL Server but ultimately, the company's requirements prevented us from doing so. Here were the stipulations: First, the script …


    Read More
  • SQL Server: Creating a User-Defined Data Type from Scratch

    Dec 16, 2008 · 3 min read  ·
    Share on:

    I've always been slightly jealous of PostgreSQL's network data types, speficially, it's IPv4-supporting cidr type. I wondered if Microsoft would ever implement a similar type (I'm still wondering) but until they do, I'll work with the ghetto I've got: User-Defined Datatypes, which were introduced in SQL Server 2005. …


    Read More
  • SQL Server: Free Yet Noteworthy E-book Package from Red Gate Software/Simple-talk.com

    Dec 15, 2008 · 3 min read  ·
    Share on:

    Before I start, I thought I would mention that I've always thought there was something a little suspicious about simple-talk.com. I couldn't quite put my finger on it, but.. ok for instance, one of their bloggers, "Phil Factor" (FILLFACTOR -- get it?), kinda freaks me out. Maybe it's his avatar. Image not …


    Read More
  • T-SQL: Find Duplicates Without Using JOIN

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

    I'd forgotten about this lil trick. select eUserName from eAttribute GROUP BY eUserName HAVING COUNT( eUserName) > 1


    Read More
  • SQL Server: Change the Owner of All Tables to "dbo"

    May 8, 2008 · 1 min read  ·
    Share on:

    Reference for me. Reference for you. sp_MSforeachtable @command1="EXEC sp_changeobjectowner '?','dbo'"


    Read More
  • Create a Basic SQL Server 2005 Trigger to Send E-mail Alerts

    Feb 5, 2008 · 2 min read  ·
    Share on:

    For as many times as I have read about sending e-mails using SQL Server triggers, I've rarely come across actual code samples. After someone asked for a "Triggers for Dummies" example in a Facebook SQL group, I created the following example which uses a trigger to alert a manager that an expensive item has …


    Read More
    • ««
    • «
    • 8
    • 9
    • 10
    • 11
    • 12
    • »
    • »»

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

  • Update-Module dbatools Authenticode Issuer Error
  • 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

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 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