Skip to content
Thursday, February 9, 2023
Latest:
  • Changing Service tiers? Do you need downtime?
  • Different Database Services in AWS
  • Google Launched second Cloud Region in India
  • SQL Server IaaS Agent Extension |Part-1
  • Day-3 | SQL Server Internals and SQL Azure Workshop | IBM Noida

SQLChamp

Let's learn together!

  • Home
  • LearnSQL
  • SQLServer
  • SQLTips
  • Azure Data Platform
    • SQLAzure
    • SQLServer on Azure VM
  • Best Practices
  • Speaking Events
    • In-Person Events
    • Events

Powershell for SQL

Powershell for SQL 

Where are my system databases?

July 14, 2012 Sarabpreet Singh Anand dir, force, SQL Server system databases, system databases, using force switch with get-childitem

Hi Friends, In last post, we saw that we can very easily use powershell to connect to SQL Server instance

Read more
Powershell for SQL 

How to Connect to SQL Server using Powershell

July 13, 2012 Sarabpreet Singh Anand connect to SQL, how to connect to database using powershell, Server, sqlps

Hi Friends, In this blog I’ll show you how to connect to SQL Server using Powershell Step-by-Step. There are basically

Read more
Powershell for SQL Powershell-Basics 

Quotes in Powershell

July 8, 2012 Sarabpreet Singh Anand `, `n, `t, Back quote, back tick, Double Quote, Horizontal Tab, New line, posh, powershell, ps, Quotes, Single Quote, variable expansion

In General Quotes are considered to be there just to let interpreter know that the value enclosed within quotes should

Read more
Powershell for SQL 

SQL Server Management Objects (SMO)

July 6, 2012 Sarabpreet Singh Anand SMO, SMO compatible, SMO dependency, SQL

SMO is a collection of objects that are designed for programming all aspects of managing Microsoft SQL Server. SQL Server

Read more
Powershell for SQL 

SQL with its own Powershell?

July 6, 2012 Sarabpreet Singh Anand powershell, snappin, SQL, sqlps

SQL Server 2008 and powershell are strongly integrated. In fact, SQL Server 2008 comes with its own Powershell. Microsoft SQL

Read more
  • Azure (2)
  • Azure Data Platform (2)
  • Azure Data Platform (32)
  • Best Practices (37)
  • Events (9)
  • In-Person (9)
  • In-Person Events (22)
  • Latest Announcements (6)
  • LearnSQL (32)
  • Powershell for SQL (5)
  • Powershell-Basics (1)
  • Pro-Tip (1)
  • Product Reviews (1)
  • Speaking Events (18)
  • SQL for Beginners (5)
  • SQL Server (1)
  • SQLAzure (33)
  • SQLServer (15)
  • SQLServer on Azure VM (1)
  • SQLServer on Azure VM (17)
  • SQLTips (22)
  • Uncategorized (9)
  • Webcast (6)

Always Encrypted (6) azure (32) azure portal (6) Azure SQL Database (10) backup (5) backup encryption (6) cloud (6) Database (4) DDM (5) deadlock (4) Dynamic Data Masking (5) error log (3) event (21) Execute As (4) Execution context (3) free (10) Free event (8) free sql learning (6) Function (3) grant (3) gurgaon (9) in person (9) learn (3) Learning (9) limitations (4) MCT (8) Microsoft (8) MVP (8) permissions (3) powershell (8) Powershell4SQL (3) restore (3) sarab (19) sarabpreet singh anand (4) security (11) SQL (51) SQL 2012 (5) SQL 2014 (8) SQL Azure (12) SQLAzure (10) SQL Database (10) SQL Saturday (9) sql server (17) SQLServer (31) sql server 2012 (6) SQLServer 2014 (9) sql server 2014 (4) SQL Server 2016 (8) SQL Server day (9) SQLServerday (13) SQLServer Workshop (3) sql tips (4) step-by-step (4) t-sql (8) tech days (3) tips (4) Training (10) tricks (3) webcast (7) windows azure (6)

Copyright © 2023 SQLChamp. All rights reserved.
Theme: ColorMag by ThemeGrill. Powered by WordPress.