Skip to content

SimpleSQLDBA | Shadab Mohammad

Microsoft SQL Server Tips and techniques

Home
Scripts
- Check Memory Pressure for the Current Processes in SQL Server
About

Month: November 2013

AlwaysOn versus Active Data Guard—A Value Proposition

November 21, 2013November 21, 2013 ~ easyoradba ~ Leave a comment

TRANSFER SQL SERVER LOGINS BETWEEN 2 DIFFERENT SERVERS

November 14, 2013 ~ easyoradba ~ Leave a comment

1. RUN BELOW SCRIPT ON SOURCE SERVER 2. RUN BELOW COMMAN ON SOURCE SERVER TO CREATE LOGIN SCRIPTS 3. APPLY THE LOGIN SCRIPTS ON DESTINATION DATABASE FOR EG:

Shadab Mohammad, MCITP

Pages

About
Scripts
- Check Memory Pressure for the Current Processes in SQL Server

2005 2005 2008 2012 2008 2012 Attach Backup Change Command Create Database Mirroring Data Mirroring Deatach Delete DUPLICATE Enable Encryption Execute failover Indexed views Insert Job large Listener Log Login Logins manual Microsoft mirror Mirror Database Mirroring Mode MSSQL Null Offline Online Oracle Partner Powershell Random Rebuild Indexes reconfigure Restore Rows Safety scheduler Scripts Select Server Snapshot Database sp_start_job sql sql-authority sql-query sql-scripts sql-server sql-stored-procedure sql-tips-and-tricks sqlcmd SQL Server 2000 SQL Server 2005 SQL Server 2008 SQL Server 2008 2012 Stored Procedure T-LOG T-SQL Table task technology Transaction Transfer Truncate Log TSQL Windows XP_CMDSHELL

Archives

Recent Posts

SQL Serve 2019 CTP 2.5
Create C2 Native Auditing for SQL Server
Install SQL Server 2019 on Docker
Microsoft SQL Server Clustering – Advanced Interview Questions
Enable TDE (Transparent Data Encryption) for SQL Server 2016

Email Subscription

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Email Address:

Join 380 other subscribers

Blog at WordPress.com.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Follow Following
- SimpleSQLDBA | Shadab Mohammad
- Already have a WordPress.com account? Log in now.