Copied from here. http://blogs.technet.com/b/sqlthoughts/archive/2008/10/03/out-sql-powershell-function-export-pipeline-to-a-new-sql-server-table.aspx http://tools.perceptus.ca/text-wiz.php http://dnhlmssql.blogspot.com/2013/05/from-excel-to-insert-into-another.html ############################################################################## ## ## out-sql.ps1 ## ## by Alexey Yeltsov, Microsoft Corp. ## Raju Venkataraman Added some fixes for Table creation and Inserts ## Export pipeline contents into a new SQL table ## ## Parameters: ## $SqlServer – SQL Server …
How do I Change SQL Database from Single_User to Multi_User Mode
How do I Change SQL Database from Single_User to Multi_User Mode: Sometimes, we have the need to set the database in Single User Mode to do some upgrades or blocking all the access to the Database. Set the Database to Single User Mode : ALTER …
SQL Server – Generic Error Handling I use
This is generic Error Handler I use for my Adhoc Scripts as Well as functions, stored procedures,etc. — Adding the error message. USE master; GO EXEC sp_addmessage 50001, 16, N’The Record doesn”t exist. Parameter : %s , Value : %s’,@replace=’Replace’; GO — Standard Variables Declarations …
PHP Drivers for MSSQL Issues
PHP Drivers for MSSQL Issues I wanted to setup my Mac Book Pro to access the SQL Server RDS Instance on AWS.My intial thinking was just google on how to setup PHP Drivers on Mac OSX and follow the steps. So I thought it shouldn’t …
SQL Script Header Footer I use
SQL Script Header Footer I use : /****************************************************************************************************** ** Desc: This File will create the XXXXXXXXXXXXXXXXXXXXXXX . ** Auth: Raju Venkataraman ( [email protected] ) ** Date: 09/21/2014 Created ************************** ** Change History ************************** ** CR Date Author Description ** —– ———-– ———– ———————————————————— ** 1 …
Checklist for SQL Server Installation
Feature Selection : We don’t want to install all the features. Identify the features needed and install only those features. Model Database Properties : Figure out all the Model database Properties and configure them Correctly. File Layout : Make sure Data and log files are …
SQL Server – Interview Questions
Database Professional – Interview Questions What factors do you usually consider for your datastore selection ? Data Volume , Variety and Velocity. Whats CAP Theorem?. Consistency , Availability and Partition Tolerance and you can’t all three together. In theoretical computer science, the CAP theorem, also known …
Connect to SQL Server When SA or Service Account Credentials not Available
Connect to SQL Server When SA Account or Service Account Credentials not Available : I recently inherited the SQL Serer which was running under a user account who left the company and no one knows the password for sa account. My task was to fix …
Move SQL Server Database to Different Location
Move SQL Server Database to Different Location : There are several way to do this but I find this option being simple.Sometimes we face the issue with Drive being full. It happens when we have Database on C Drive and we usually don’t allocate much …
SQL Server Waits and Queues
SQL Server Waits and Queues : I watched Paul Randall Videos on Wait Types and which inspired me to write a simple post on wait types on logical way. We all have written queries, TSQL statements to perform CRUD ( Create, Read, Update , Delete …