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
- 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