Nice things inside SQL Server, System Center Configuration Manager
Uninstall button is disabled in Software Centre in SCCM 2012 R2 for available Applications
In SCCM 2012 R2 RTM, There is a known issue that if an application contains multiple Deployment...
Date: 01/29/2014
How to move an application to a folder programmatically
Prerequisites Add AdminUI.WqlQueryEngine.dll as a reference Get the ContainerID of a folder by...
Date: 10/08/2013
Uninstall button is disabled in Software Centre
It is a common question in Forums why Uninstall button is disabled in Software Centre : There are...
Date: 10/04/2013
Creation of Deployment Types using Powershell Cmdlets in SCCM 2012 R2 Preview
Here are the sample examples to create deployment types: Android App From Google Play: PS DEV:>...
Date: 09/04/2013
Application failure retry behavior in SCCM 2012
If the MSI app fails with an exit code...
Date: 05/28/2013
Creation of App-V Virtual Environments in SCCM 2012 SP1
Virtual Environment concept makes the virtual applications on the client to share the same file...
Date: 03/02/2013
New Features in SSMS Denali
- Surround With Feature This feature allows us to select a set of T-SQL statements and enclose them...
Date: 05/10/2011
Sequences in SQL Server
Customers have been asking for sequences for a very long time and now finally it is included with...
Date: 04/18/2011
How to get Processors Count in SQL Server ?
SQL Server 2000: CREATETABLE#TempTable ( [Index]VARCHAR(MAX), NameVARCHAR(MAX),...
Date: 08/11/2010
SQL Server 2008 SP2 is released
SQL Server 2008 SP2 contains the following features: · All hotfixes released up to Microsoft...
Date: 07/08/2010
Setup Database Mail in SQL Server 2008
i) Open SQL Server Management Studio->View Menu-> Select Template Explorer-> Expand...
Date: 07/07/2010
SQL Express is not installed properly. Steps to be taken before reinstall again
To verify the SQL Server Express instance installed, you could use Microsoft SQL Server 2008 Setup...
Date: 03/15/2010
How to improve performance during Insertion
Here are the following guidelines to increase performance during INSERT operation: 1. Inserting data...
Date: 03/06/2010
How to find leastly used non-clustered indexes in SQL Server ?
Script: SELECT objectname=OBJECT_NAME(s.OBJECT_ID) , indexname=i.name , i.index_id ,...
Date: 03/06/2010
SSMS for SQL Azure
Download links for SSMS in 32bit and 64bit flavors. The full download of SQL Server 2008 R2 November...
Date: 02/08/2010
Move a database from one server to another server in SQL Server 2008
There are many ways to move/copy a database from one server to another server using SQL Server...
Date: 09/11/2009
How to un install SQL Server 2005
You can use these docs for uninstalling your 2005 sql instance based on your requirement....
Date: 04/14/2009
Sparse Columns in SQL Server 2008
Introduction In the real world customer scenarios, the customer data can be of heterogeneous and...
Date: 01/08/2009
Auditing SELECT statements in SQL Server 2008
Prior to SQL Server 2008, the only way to audit the SELECT statements is to use SQL Server Profiler...
Date: 01/05/2009
Managing Data Compression in SQL Server 2008
Data Compression in SQL Server 2008: The size of the databases are increased drastically due to -...
Date: 12/29/2008
SQL Change Tracking in SQL Server 2008
What is Change Tracking? Change tracking is a new feature in SQL Server 2008 that allows...
Date: 12/23/2008