SQL SSMS CTRL+R Not working

Tools-> Environment -> Keyboard ->Reset

VMWare workstation Copy/Paste not working

Suspending and restarting VMware itself.
Restart the service VMware Workstation Server on host
or

taskkill /F /IM vmtoolsd.exe
"C:\Program Files\VMware\VMware Tools\vmtoolsd.exe" -n vmusr

Trust, reinstall VMTools is not working.

Replication SQL Server Error 21684 Raised for Oracle Publication

If you already installed Oracle Client software and have an Oracle Login ready to be used as a Replication user. Below is the solution

Pre-login handshake failed

Replication between SQL Server 2012 and Oracle

Replication has 3 roles: Publication, Distribution and Subscription.
The source is from Oracle, and I want the data from Oracle push to SQL Server and not updatable.
Publication: Oracle
Distribution: SQL Server A
Subscriptions: SQL Server A ( I installedont the same Server/Instance), you can add/change it if you want.

[SQL]Index Usage Practice

Today’s practice is “Index usage”.  
Database: Adventurework2012.   Table: Sales.Customer.     T-SQL Scripts: 8 segments
Why i chose the table? Because the table is simple and has 4 Indexes. No including filter, XML index. So it’s simple to test.

[SQL]T-SQL, Find out SQL Missing Index through DMVs.

The source was from bartduncan, here.

SQL Server 2012 Performance Dashboard Reports Installation

1) Download SQL Server Performance Dashboard Reports
2) Install it

MCSE Certification Update: SQL Server 2014

http://borntolearn.mslearn.net/btl/b/weblog/archive/2014/03/10/certification-update-sql-server-2014.aspx

To help students stay current with upcoming release of SQL Server 2014, all MCSE-level SQL exams (464 through 467) will be updated on April 24, 2014 to cover solutions based on both SQL Server 2012 and 2014 products.

[SQL]Concurrency-Lock:Timeout on SQL Server profiler

Recently, I’ve found one of my server has lots lock: timeout happened. I am curious what caused this? So I opened SQL Server Profiler to watch the server

[SQL]HotFix KB2969896 - a dangerous data loss bug in SQL Server 2012 and 2014

Important!!

The online index rebuild can cause index corruption or data loss when it is used together with concurrent queries that modify many rows in Microsoft SQL Server 2012 Service Pack 1 or Microsoft SQL Server 2014. 

This issue occurs when the following conditions are true:

• The online index build query runs in parallel mode.
• Deadlock error and a fatal error such as "lock timeout" occur in a specific order

FIX: KB2969896

Happy 4th of July. God Bless America.

Happy 4th of July. God Bless America.

[SQL]Get SQL Connections Sessions TCP Statement Info - Part 1

Purposes: Collection of Connections, Sessions, T-SQLs..etc

• These DMV could do a collection of I/O-related database management objects(DMOs), also will help you investigate the related I/O info 
• I/O investigation derived from 

DMVs Used:

    --sys.dm_exec_connections, http://msdn.microsoft.com/en-us/library/ms181509.aspx
    --sys.dm_exec_sessions, http://msdn.microsoft.com/en-us/library/ms176013.aspx
    --sys.dm_exec_requests, http://msdn.microsoft.com/en-us/library/ms177648.aspx
  
    --sys.dm_exec_query_stats, http://msdn.microsoft.com/en-us/library/ms189741.aspx
    --sys.dm_exec_sql_text, http://msdn.microsoft.com/en-us/library/ms181929.aspx