Skip to main content

PowerShell SQL Snapins


Ran into an issue with SQL snapins not registering in PS x86 (needed to run ADMT related scripts). The following resolved the issue.


Start PowerShell x86 (important - run as Administrator) execute the following sequence:
cd "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn"
$framework=$([System.Runtime.InteropServices.RuntimeEnvironment]::GetRuntimeDirectory())
Set-Alias installutil "$($framework)installutil.exe"

installutil Microsoft.SqlServer.Management.PSSnapins.dll
installutil Microsoft.SqlServer.Management.PSProvider.dll

Add-PSSnapin SqlServerCmdletSnapin100
Add-PSSnapin SqlServerProviderSnapin100



To verify that snapins registered correctly examine the output of the following command:
get-pssnapin -registered

Comments

  1. Thanks for sharing, nice post!

    Đến Casanova đây là những quán cafe sân vườn đẹp nhất sài gòn bạn không nên bỏ qua hay bạn muốn học bài thì cafe học bài cực thú vị đấy hay quán cafe view đẹp ở sài gòn bạn không nên bỏ qua hay quán cafe có đàn piano ở tphcm siêu lãng mạn hay casanovacafe là 1 trong cafe giá rẻ bạn nên đến 1 lần, hay tổng hợp những quán cafe dễ thương ở sài gòn hay những quán quan cafe nho va xinh đến là mê hay cafe doc dao o tphcm không đụng hàng hay casanova là quán cafe wifi mạnh tphcm thích hợp để làm việc hay cà phê sang chảnh bạn nên trải nghiệm hay quan cafe doc la cực đẹp hay quán cafe có bánh Pizza cực ngon ăn là nghiền hay đây là quán cafe nhạc acoustic cực lãng mạn hay may dua vong tu dong giúp bé ngủ ngon hay đây là quán cafe phong cách lạ bạn nên đến hay đây là quán cafe có chỗ cho trẻ em chơi hay bạn muốn hội họp thì đây là cafe may chieu cho bạn làm việc hay cafe phòng riêng tphcm cho làm offline làm việc hay điểm danh quán cafe thú cưng tphcm bạn nên đến hay quán cafe bói bài tarot cực thú vị.

    ReplyDelete

Post a Comment

Popular posts from this blog

Skype for Business and VTC Interoperability

Skype for Business (SfB) has a very, very strong potential, I have written about it in my previous post. I can't think of any other platform that shows as much promise in terms of bridging personal and business communications as well as unifying different modes and mediums. And all of this may have started with a strategic acquisition of Skype by Microsoft in 2011.

That said, the road ahead is not without challenges. For example, interoperability with other platforms. Making SfB work with existing Video TeleConferencing (VTC) systems, many of which represent significant capital investments in organizations' infrastructure, could be of a particular importance.

After reading statements like Skype for Business is based on Session Initiation Protocol (SIP) standards and supports H.264 (MPEG-4 video coding standard) one can come to a quick conclusion that integration and/or interoperability with other VTC solutions is easy or nearly automatic. Unfortunately, the industry is not qui…

PoSh Disable and Move AD Users

A quick and easy way to disable user accounts and move them into designated OU:

Import-Csv "C:\TEMP\users.csv" | ForEach-Object { `      $u=$_."sAMAccountName"; $l="Disabling and moving: " +$u; write-output $l; `      Get-ADUser -Identity $u | `      Disable-ADAccount -PassThru | `      Move-ADObject -TargetPath "OU=Disabled Users,OU=Organization,DC=domain,DC=local"
Input is provided via a CSV file:
users.csv (username) sAMAccountName  jdoe1  jdoe2  jdoe3  jdoe4  jdoe5  

To generate input file run something like this, review and edit as necessary:
Search-ADAccount –UsersOnly –AccountInactive –TimeSpan 180.00:00:00 | `      where {$_.enabled} | `      Get-ADUser | `      select sAMAccountName | `      Export-Csv -Path "C:\TEMP\users.csv"

WordPress displays weird characters

Sometimes after a database conversion (e.g. from MySQL to MariaDB) or due to encoding issues a situation might arise when WordPress is showing weird characters. A quick way of remedying the situation would involve examining the pages to discover a pattern (what characters are being substituted, in the example below the apostrophe was replaced by â€™) then running an queries against the database to reverse the effect. Here's a quick example (common tables that store content):



UPDATE wp_posts SET post_content = REPLACE(post_content, 'Â', '')     UPDATE wp_posts SET post_content = REPLACE(post_content, '’', "'")     UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, 'Â', '')     UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, '’', "'")     
Please, keep in mind that to permanently resolve the issue you would need to get to the root of the problem and may need to adjust encoding, run a databas…