Code-snippets

Checking installed .Net frameworks in Powershell

PowerShell is a powerful scripting language that can be used to automate various administrative tasks, including data management and analysis. In this article, we will show you how to export data from a SQL database to a CSV file using a SQL query and the command-line tool.

Resolution for Error The server principal is not able to access the database under the current security context in SQL Server

Calculate Product in SQL server

Partition SQL Server Tables with File Groups

Delete Millions of Rows in a Table in SQL Server using

SQL query to find referencing Tables by column name

SQL query to Drop tables in a schema

SQL query to find database size

Build SQL connection string in powershell using SqlConnectionStringBuilder