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

Author: SREEKAR MANKALA [MSFT] 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...

Author: SREEKAR MANKALA [MSFT] 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...

Author: SREEKAR MANKALA [MSFT] 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:>...

Author: SREEKAR MANKALA [MSFT] Date: 09/04/2013

Application failure retry behavior in SCCM 2012

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

Author: SREEKAR MANKALA [MSFT] 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...

Author: SREEKAR MANKALA [MSFT] Date: 03/02/2013

New Features in SSMS Denali

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

Author: SREEKAR MANKALA [MSFT] 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...

Author: SREEKAR MANKALA [MSFT] Date: 04/18/2011

How to get Processors Count in SQL Server ?

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

Author: SREEKAR MANKALA [MSFT] Date: 08/11/2010

SQL Server 2008 SP2 is released

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

Author: SREEKAR MANKALA [MSFT] Date: 07/08/2010

Setup Database Mail in SQL Server 2008

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

Author: SREEKAR MANKALA [MSFT] 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...

Author: SREEKAR MANKALA [MSFT] Date: 03/15/2010

How to improve performance during Insertion

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

Author: SREEKAR MANKALA [MSFT] 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 ,...

Author: SREEKAR MANKALA [MSFT] 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...

Author: SREEKAR MANKALA [MSFT] 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...

Author: SREEKAR MANKALA [MSFT] 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....

Author: SREEKAR MANKALA [MSFT] 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...

Author: SREEKAR MANKALA [MSFT] 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...

Author: SREEKAR MANKALA [MSFT] 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 -...

Author: SREEKAR MANKALA [MSFT] 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...

Author: SREEKAR MANKALA [MSFT] Date: 12/23/2008