Nice things inside SQL Server, System Center Configuration Manager

In SCCM 2012 R2 RTM, There is a known issue that if an application contains multiple Deployment...

Date: 01/29/2014

Prerequisites Add AdminUI.WqlQueryEngine.dll as a reference Get the ContainerID of a folder by...

Date: 10/08/2013

It is a common question in Forums why Uninstall button is disabled in Software Centre : There are...

Date: 10/04/2013

Here are the sample examples to create deployment types: Android App From Google Play: PS DEV:>...

Date: 09/04/2013

If the MSI app fails with an exit code...

Date: 05/28/2013

Virtual Environment concept makes the virtual applications on the client to share the same file...

Date: 03/02/2013

  1. Surround With Feature This feature allows us to select a set of T-SQL statements and enclose them...

Date: 05/10/2011

Customers have been asking for sequences for a very long time and now finally it is included with...

Date: 04/18/2011

SQL Server 2000: CREATETABLE#TempTable ( [Index]VARCHAR(MAX), NameVARCHAR(MAX),...

Date: 08/11/2010

SQL Server 2008 SP2 contains the following features: · All hotfixes released up to Microsoft...

Date: 07/08/2010

i) Open SQL Server Management Studio->View Menu-> Select Template Explorer-> Expand...

Date: 07/07/2010

To verify the SQL Server Express instance installed, you could use Microsoft SQL Server 2008 Setup...

Date: 03/15/2010

Here are the following guidelines to increase performance during INSERT operation: 1. Inserting data...

Date: 03/06/2010

Script: SELECT objectname=OBJECT_NAME(s.OBJECT_ID) , indexname=i.name , i.index_id ,...

Date: 03/06/2010

Download links for SSMS in 32bit and 64bit flavors. The full download of SQL Server 2008 R2 November...

Date: 02/08/2010

There are many ways to move/copy a database from one server to another server using SQL Server...

Date: 09/11/2009

You can use these docs for uninstalling your 2005 sql instance based on your requirement....

Date: 04/14/2009

Introduction In the real world customer scenarios, the customer data can be of heterogeneous and...

Date: 01/08/2009

Prior to SQL Server 2008, the only way to audit the SELECT statements is to use SQL Server Profiler...

Date: 01/05/2009

Data Compression in SQL Server 2008: The size of the databases are increased drastically due to -...

Date: 12/29/2008

What is Change Tracking? Change tracking is a new feature in SQL Server 2008 that allows...

Date: 12/23/2008