netnerds.net
Home
Book
Links icon
Data Platform GitHub Org GitHub Profile GitHub Star Profile MVP Profile Twitch
About
Subscribe
  • FIX: SQL Server System Configuration Checker cannot be executed due to WMI configuration (Error:2147500034)

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

    I don't know what on Earth AOL developers do in their AIM 6.x setup but they sure manage to mess things up in Vista. Once AIM is installed, my network detection no longer works and it gives an error that reads: "No network - server execution failed." The problem seems to be some kind of COM error and the fix …


    Read More
  • SQL Server DTS: Dynamically Change Source and Destination in Transform Data Task

    Aug 24, 2007 · 4 min read  ·
    Share on:

    I really wish I had more experience with DTS and SSIS (Replication, Clustering, Hardcore HA too), especially since I've been a DBA for 8 years. I bought the Wrox book "Professional SQL Server 2000 DTS" years ago hoping that one day I'd be making 50-step DTS packages but I never had the need. Today, I finished …


    Read More
  • DBAs: What Do You Do When Major Installations Require Sysadmin Access?

    Aug 17, 2007 · 2 min read  ·
    Share on:

    This is driving me absolutely crazy. For the 80th time, I'm required to create a user and give it the sysadmin role. I *have* to do this because the software is business critical (Blackberry Enterprise Server, Interwoven DMS) and installs will fail without it. With some software, I can temporarily grant access the take …


    Read More
  • Do My SQL Statements Conform to the SQL Standard?

    Jul 10, 2007 · 1 min read  ·
    Share on:

    While researching for a paper I have to write in class about hierarchical data in relational databases, I was reading Joe Celko's book Trees and Hierarchies in SQL for Smarties. In the intro, he mentions a really useful website for validating SQL-92, SQL-99 and SQL-2003. The site is nice enough but could really benefit …


    Read More
  • T-SQL Equivalent of VBScript's FormatDateTime Function

    Jul 3, 2007 · 2 min read  ·
    Share on:

    Looking for the T-SQL (somewhat) equivalent to VBScript's FormatDateTime function? I've been too, for years. I finally found it within the CONVERT() function. As stated in SQL Server Books Online: In CONVERT ( data_type [ ( length ) ] , expression [ , style ] ), style is the style of the date format used to convert …


    Read More
  • T-SQL: Convert Seconds to Datetime / Get Total Seconds from Datetime Field

    Jul 3, 2007 · 2 min read  ·
    Share on:

    For my final project in my database class at USF, I chose to create a database for a small record label looking to sell albums online as well as provide artist bios, tour information and news. The database, which was scaled down version of a project I worked on in the past, looked something like this: Image not found …


    Read More
  • VBScript: Forward SQL Server Alerts/Windows Events to (Cingular) SMS

    May 11, 2007 · 3 min read  ·
    Share on:

    Someone recently asked why I don't use SQL Mail on my SQL Servers (2000 and below). The answer is: I don't want to install Outlook on my SQL Servers. Sure, there are ways around it but I prefer just using "net send" to alert the Operator (moi) then forwarding those messages on to my inbox and phone. Although …


    Read More
  • MSSQL: Parse Search Engine Querystrings for Search Terms

    Feb 22, 2007 · 7 min read  ·
    Share on:

    As a compliment to my MaxMind GeoIP Locator scripts and the parse top-level domain from URL function, I've created another function to parse the search term from an URL. I've heard that T-SQL is a bit slow with parsing strings and wanted to test this myself so I created this in both C# and T-SQL. The difference is very …


    Read More
  • SQL Server 2005: SP2 Now Available for Download

    Feb 21, 2007 · 1 min read  ·
    Share on:

    You can now download SQL Server 2005 SP2 on Microsoft's website. Here's hoping that the install issues in SP1 won't plague SP2 as well!


    Read More
  • MSSQL: The Differences Between SAFE, EXTERNAL_ACCESS and UNSAFE Assembly Permissions

    Feb 20, 2007 · 2 min read  ·
    Share on:

    I found this useful security tip on Microsoft.com. SAFE is the recommended permission setting for assemblies that perform computation and data management tasks without accessing resources outside an instance of SQL Server. We recommend using EXTERNAL_ACCESS for assemblies that access resources outside of an instance of …


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

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