Steps to Restore .bak SQL Server backup file to Amazon SQL Server RDS
Step by Step Guide to backup and restore SQL Server backups on AWS RDS through S3 Buckets.
Dynamic SQL Search Stored Procedure
Dynamic SQL Search Stored Procedure
This also includes how to safeguard against SQL Injection by escaping single quotes through SQL function.
Caching SQL Server Tables After Restart
SQL Server Cached Pages and ways to bring data pages to memory
We noticed considerable latency in stored procedure execution after restarting SQL Server Instance which was triggered by accessing data from disks instead of memory. So we ended up writing a simple script to bring data pages to memory. This helped us to avoid first touch penalty after restart in production environment.
Dynamically Restore SQL Server Database from Backup
Dynamically Restore SQL Server Database from Backup We always get requests to restore databases from production to lab environment.This script dynamically restores the backup file and moves the data and log files to default locations. /****************************************************************************************************** ** Project: Operations ** Issue: Restore Database from Backup …
Launching AWS SQL Server RDS
Learning from Launching AWS SQL Server RDS
We are evaluating options to migrate our read/write heavy production SQL Server database to amazon SQL Server RDS. We have pretty high throughput needs for few hours a day for few months in a year ,which is mission critical for our business success. We are evaluating pros and cons of moving to amazon RDS with provisioned IOPS. Current hosted provider doesn’t offer on-demand scaling solution .
Change SQL Server Authentication login password
We have numerous applications using SQL Login accounts . Simple powershell scripts saves time for rotating passwords for SQL Logins.
SQL Server Recursion / CTE
Simple Employee data hierarchy to illustrate recursion through traditional while loop as well as Common Table Expressions. ( CTE )
AWS RDS vs Azure vs Managed Services for SQL Server
We are evaluating pros and cons of different hosting solutions for SQL Server which best suits our business needs.
Our plan is to evaluate AWS SQL Server RDS, Azure RDS , Managed solutions from hosting provider.
Evaluate each option in these categories.
1. Performance and Reliability
2. Ability to scale up during peak loads
3. Cost ( Based on Network , Storage, Memory and CPU )
4. Operations Efficiency
5. Compliance
SQL Server – Set Max Memory
SQL Server – Set Max Memory MSDN Link on Changing Max Memory /* (4 row(s) affected) Msg 15123, Level 16, State 1, Procedure sp_configure, Line 62 [Batch Start Line 0] The configuration option ‘max server memory’ does not exist, or it may be an advanced …
SQL Server Internal Versions
SQL Server Internal Versions SQL Server Versions Database Internal Versions and Compatibility Levels Useful Query SELECT SERVERPROPERTY(‘ServerName’) ‘ServerName’ , @@VERSION ‘@@version’ , SERVERPROPERTY(‘ComputerNamePhysicalNetBIOS’) ‘ComputerNamePhysicalNetBIOS’ , SERVERPROPERTY(‘MachineName’) ‘MachineName’ , SERVERPROPERTY(‘InstanceName’) ‘InstanceName’ , SERVERPROPERTY(‘IsClustered’) ‘IsClustered’ , SERVERPROPERTY(‘BuildClrVersion’) ‘BuildClrVersion’ , SERVERPROPERTY(‘Collation’) ‘Collation’ , SERVERPROPERTY(‘CollationID’) ‘CollationID’ , SERVERPROPERTY(‘ComparisonStyle’) ‘ComparisonStyle’ …