Monday, March 31, 2014

SQL SERVER – Tips of Linked Server in SQL Server

        Linked Server is providing facility to access / connect data to other Data source like MS Access, Oracle, My SQL etc. To access other data source into SQL server instance. We can use Linked server option. To creating Linked Server we have to follow below steps-
Using User Interface-
1.       Open  SSMS(SQL Server Management Studio) and open server object(If not found this option then find it in ‘View’ menu )
2.       Then Right click on the Linked server and click on the ‘New Linked server’
3.       Then we need to provide required Stuff(Server name, Instance Name, Default database name, Data source type etc) and we can access data from newly connected Data Source.
Using SQL Query –
SQL Server has provided Stored procedure to creating Linked server.
Name - Sp_AddLinkedServer
EXEC sp_addlinkedserver
   @server = N'SEATTLE Mktg',
   @provider = N'Microsoft.ACE.OLEDB.12.0',
   @srvproduct = N'OLE DB Provider for ACE',
   @datasrc = N'C:\MSOffice\Access\Samples\MS_ACCESS_DATABASE.accdb';

Like and Share to SQL Integrity Blog

Tuesday, March 11, 2014


1. Column store index
2. Pagination. - get results into part.
3. Contained database - when user will login at that time it will check databases access  for logging user.
4. Sequence objects- it similar to Oracle sequence object.  It used for creating identity.
5.  Error handling- it introduced THROW keyword. More useful to raiserror option.
6. User defined roles- now user can can create new new server level role.
7. Windows Server Core support- sql user can be performed will windows level activities from sql server 2012.
8. Tabular model- (SSAS)
9. Power view
10.  DQS data quality service- it's used for change and purring data.

Like and Share to SQL Integrity Blog