PuttyQ

PuttyQ

Menu
  • Home
  • Code
    • PSMA Library
    • GitHub
    • My Gists
  • MyPass
  • Integralis
  • About Me

Category: SQL Server

Import CSV Files into SQL using a dynamic table schema

August 3, 2018
| No Comments
| PowerShell, SQL Server

I recently had an perfect scenario that required a bit of automation. In short, we needed to complete some weird performance monitoring across an entire Hyper-V cluster that consisted of a large number of nodes. In order to get the data into a platform to analyse and report on the data within a reasonable amount […]

Read More »

Posted in PowerShell, SQL Server

Building a SQL 2012 Always-On Cluster – Part 1

May 10, 2012
| No Comments
| SQL Server

Over the past few weeks I have been involved in a major SQL cluster roll-out and as such got my hands dirty with getting SQL 2008 R2 clusters built. With the release of SQL Server 2012 I decided I might just was well contrast the two builds for the fun of it. As it turns […]

Read More »

Posted in SQL Server Tagged Clustering

Element not found. (Exception from HRESULT: 0x80070490) – SQL Server 2008 R2

March 12, 2012
| No Comments
| SQL Server

When using any SQL Server 2008 or later version there is a possibility of getting the following error: Element not found. (Exception from HRESULT: 0x80070490) – SQL Server 2008 R2 This appears right after feature selection (with the installer failing – or the installer hangs). There are no specific logs that provide adequate information as […]

Read More »

Posted in SQL Server

“WmiPrvSe.exe process is not controlled by…”

March 12, 2012
| No Comments
| SQL Server

This morning when applying SQL Server 2008 R2 SP1 i came across the following error during the installation “Check File In Use” page: The ‘WmiPrvSE.exe’ process is not controlled by the update wizard. You have to manually stop this process to avoid a computer restart.   There where two theads being identified by the SQL […]

Read More »

Posted in SQL Server

MSDTC Cluster “No Storage available”

March 11, 2012
| No Comments
| SQL Server

One of the primary requirements for a proper Microsoft SQL Server environment is MSDTC (Microsoft Distributed Transaction Coordinator). When installing a SQL Server clustered environment it is required to add this clustered resource before installing you SQL Server instances. To procedure to do this: To start the Failover Cluster Management program, click Start, Programs, Administrative Tools, and then click Failover Cluster Management. […]

Read More »

Posted in SQL Server Tagged Clustering, Windows Server

Recent Posts

  • Frustrated trying to Maintain PCNS in a Multi-Domain Environment
  • Granfeldt PSMA for Microsoft Azure B2B Management
  • Import CSV Files into SQL using a dynamic table schema
  • PuttyQ.com v4
  • SAP Integration using Granfeldt Powershell Management Agent – Part 1

Archives

  • November 2021
  • August 2018
  • June 2016
  • October 2015
  • October 2014
  • September 2014
  • July 2014
  • June 2014
  • March 2014
  • May 2012
  • March 2012

Categories

  • AADConnect
  • General
  • Identity Management
  • Microsoft
  • PowerShell
  • SQL Server

© PuttyQ 2023. Powered by coffee and cheesecake