Skip to content
December 4, 2023
  • Subscribe
  • Twitter
  • LinkedIN Group (Forum)
  • Facebook Group (Forum)
  • Facebook Page
  • YouTube
  • Telegram Group (Forum)
SQLServerGeeks

SQLServerGeeks

SQL Server Education (by the geeks, for the geeks)

Free Live Event Free Live Training Virtual Symposium DPD banglore
  • Free Courses
  • Blogs
    • Subscribe To Our Newsletter
    • SQLServerGeeks Bulletin Index
    • The Scripts Garage
    • All Blog Posts
    • One DMV a Day Series
    • Accidental DBA Series
    • One Operator a Day Series
    • One Trace Flag a Day Series
  • Magazine
  • Events
    • Browse Events
    • Suggest Topics
  • Videos
    • SSG Videos Lobby
    • Premium Content (SQLMaestros)
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra Recordings
    • Virtual Symposium Recordings
      • SQL Server & Azure SQL – May 2021
      • SQL Server 2019 & Azure SQL – May 2020
    • Geek Talks
  • RESOURCES
    • SQL Server Resources
    • SQL Server Notes by Amit Bansal (AB)
  • About Us
    • Subscribe To Our Newsletter
    • Social Channels
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
  • Log In
  • Join Now
Main Menu

Tag: PowerShell

SQL Server

Setting SQL Server Start-up Parameters across Multiple Instances

December 16, 2016July 3, 2020 - by Manohar Punna - 2 Comments.

Hello Geeks, This is the first blog of the part of blogs set I am going to write for next few months. I have been working on a centralized approach for …

Setting SQL Server Start-up Parameters across Multiple Instances Read More
SQL Server

SQL Server Database Migration : DB-Migrate V 5.0 : PowerShell Module to Migrate Databases

February 20, 2014December 23, 2019 - by SQL Geek - Leave a Comment

SQL Server Database Migration between sql instances is a time taking and a tedious task which becomes even more complicated when one has more than 10-12 databases to migrate. This PowerShell module …

SQL Server Database Migration : DB-Migrate V 5.0 : PowerShell Module to Migrate Databases Read More
SQL Server

SQL Server Database Migration : DB-Migrate V 4.0 : PowerShell Module to Migrate Databases

December 27, 2013December 23, 2019 - by SQL Geek - 1 Comment

This is an update on DB-Migrate Module. The change log is mentioned below. Changes in SQL Server Database Migration PowerShell Module on 27th Dec 2012 Version Check. Move-Database function now checks for Source …

SQL Server Database Migration : DB-Migrate V 4.0 : PowerShell Module to Migrate Databases Read More
SQL Server

SQL Server Database Migration : DB-Migrate V 3.0 : PowerShell Module to Migrate Databases

December 25, 2013December 23, 2019 - by SQL Geek - Leave a Comment

This is an update on SQL Server Database Migration PowerShell Module. The change log is mentioned below. Changes in DB-Migrate V3 on 25th Dec 2012 Reviewed by Aman Dhally – Powershell MVP. …

SQL Server Database Migration : DB-Migrate V 3.0 : PowerShell Module to Migrate Databases Read More
SQL Server

SQL Server Copy table data from higher to lower SQL version using PowerShell

November 26, 2013December 23, 2019 - by SQL Geek - 2 Comments.

I came across a scenario where in I had to move database from SQL Server 2008R2 to SQL Server 2005. As most of you must be aware that Detach/Attach and Backup/Restore …

SQL Server Copy table data from higher to lower SQL version using PowerShell Read More
SQL Server

SQL Server – Monitor SQL Server Services using Powershell

July 10, 2013August 28, 2014 - by admin - 1 Comment

Last month on 26th June I delivered a webcastHow to Monitor SQL Servers using Powershell – Part 1 under Microsoft Lunch Time Banner.  For those who don’t know about Lunch Time Series …

SQL Server – Monitor SQL Server Services using Powershell Read More
SQL Server

SQL Server Parse DBCC MemoryStatus using Powershell

May 19, 2013December 23, 2019 - by SQL Geek - Leave a Comment

A few days back I was resolving a memory issue which caused sql server to stop responding. I was able to figure out the issue by looking into SQL Server Parse …

SQL Server Parse DBCC MemoryStatus using Powershell Read More
SQL Server

SQL Server Using Powershell to Move databases between Instances

March 29, 2013December 23, 2019 - by SQL Geek - Leave a Comment

It’s sometime needed to move database between instances as in when migrating to a different instance. Let’s see how this can be achieved with powershell. This script assumes that both the …

SQL Server Using Powershell to Move databases between Instances Read More
SQL Server

SQL Server Using Powershell to Move Logins between Instances

March 22, 2013December 23, 2019 - by SQL Geek - 3 Comments.

Moving logins between instances is one of the critical migration activities. Let’s see how it can be done in powershell with the help of SMO.When transferring logins, two things need to …

SQL Server Using Powershell to Move Logins between Instances Read More
SQL Server

SQL Server Using Powershell to Move Indexes to New File group

March 21, 2013December 23, 2019 - by SQL Geek - 2 Comments.

Recently I was involved in a project where in non-clustered indexes were to be moved to a different file group for the sake of performance benefit. It has to be done …

SQL Server Using Powershell to Move Indexes to New File group Read More

Posts navigation

1 2 Next

Looking for Premium SQL Content?
Check out advanced SQL tutorials
on SQLMaestros


Subscribe to SQLServerGeeks

Free Live Event


Ad

Virtual Symposium

master classes



SSG_linkedin

SSG_fb

About Us

  • Core Team
  • Authors
  • Blog With Us
  • Testimonials
  • Contact Us
  • Join DataPlatformGeeks Community

Virtual Symposium

Copyright © 2022 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by WordPress and HitMag.