Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: powershell

SQL Server AS: Set ImpersonationMode via PS

By adminPosted on January 11, 2023

Question : Try to create a database in SQL Server Analysis Server (SQLAS, SSAS) version 2012 SP2 if that matters […]

Invoke-SQLCMD with special characters

By adminPosted on January 9, 2023

Question : I’m currently working on a project integrating AD with SQL Server data, which I am handling mainly via […]

How to catch error from sql server on powershell?

By adminPosted on January 8, 2023

Question : I have written powershell script that executes all sql from folder, but I want to stop executing on […]

SQL Server 2019 setting Force Encryption with a script

By adminPosted on January 8, 2023

Question : I have to update 50+ servers to use encrypted connection strings. Is there a way to script setting […]

To generate a script to drop or map the orphan users in a SQL Server Instance

By adminPosted on January 3, 2023

Question : I am very new to SQL Server. I have a script which find the orphan users in all […]

Query Multiple SQL Server Instances using Powershell referencing the list of instances in a text file

By adminPosted on December 28, 2022

Question : Rather than issuing a query per instance via SQL Server Management Studio, we are trying to create a […]

SQL Visual Studio Find and Replace in Publish Profile

By adminPosted on December 27, 2022

Question : We have source control in Visual Studio Database Projects (SSDT). To make cross database references, we utilize something […]

How to get table columns with datatypes (and lengths) using PowerShell?

By adminPosted on December 23, 2022

Question : I’m trying to get column names with data types (and lengths) for SQL Server instance using PowerShell. I […]

Automation of MSSQL database transaction log file truncation

By adminPosted on December 21, 2022

Question : I am looking into setting up an automated process through PowerShell or anything for truncating SQL Server transaction […]

Powershell SQL Script Execution in Selected Schemas Only

By adminPosted on December 18, 2022

Question : I have many schemas in one database. In that database I have some SQL scripts to be executed. […]

  • 1
  • 2
  • 3
  • …
  • 15

Recent Posts

  • Order of returned rows with IN statement
  • Do not want to allow Queries to take more than x minutes?
  • How would i create a report involving multiple many to many relationships
  • web interface port for oracle 11g
  • Getting the exact and closest Search using CONTAINS/CONTAINSTABLE in SQL
  • How can I check if a user have a quota on tablespace
  • Can alias in SQL Server contain slash?
  • Why store /var/lib/mysql when you can just create SQL dumps for backup purposes?
  • Fix OGR2OGR “failed when converting the varchar value to data type int” issue in the MSSQL table –
  • Sum on distinct and group by
  • Is a join optimized to a where clause at runtime?
  • Simple select is taking too long
  • GROUP BY with subqueries for a Group?
  • SERVERPROPERTY(‘Edition’) AS [Edition]
  • Do MySQL sub-queries essentially use as much overhead as separate queries?
  • select fieldvalues and column-description of a table
  • Secure database access from particular applications
  • How to optimize and estimate DB recovery times?
  • How to make a FULLTEXT search with ORDER BY fast?
  • De-duplicate rows in place vs de-duplicate on transfer

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding