Ashish Kumar Mehta

Bio is coming soon...
2013 Awards
2011 Awards
2010 Awards
2013 Awards

2011 Awards

2010 Awards

Analysis Services Administration
- How to Detach and Attach a SQL Server 2008 Analysis Services Database (last update: 7/20/2010)
- How to restore a SQL Server Analysis Services Database (last update: 12/22/2009)
- Process a SQL Server Analysis Services Cube Using an XMLA Query (last update: 1/20/2011)
- Processing an Analysis Services Cube Using SQL Server Management Studio (last update: 1/7/2011)
Analysis Services Measure Groups
- Using XMLA Command to Clear Cache of a SQL Server Analysis Service Database (last update: 8/20/2010)
Analysis Services Security
- Surface Area Configuration for SQL Server Analysis Services Using PBM (last update: 4/29/2010)
Backup
- Mirrored Database Backup Feature in SQL Server 2005 and SQL Server 2008 (last update: 6/24/2009)
Contained Databases
- SQL Server 2012 Contained Database Feature (last update: 6/30/2011)
Database Administration
- Attach SQL Server Database Without Log File (last update: 4/17/2019)
- Identify SQL Server Instance and Database Collation Using T-SQL and SSMS (last update: 10/18/2011)
- Limitations when attaching a SQL Server Database (last update: 8/31/2011)
Database Design
- Identifying Object Dependencies in SQL Server (last update: 6/9/2009)
Dates
- New Date and Time Functions in SQL Server 2012 (last update: 1/9/2012)
DBA Best Practices
- Best Practice Recycling SQL Server Agent Error Logs (last update: 3/1/2019)
- Best Practices Backup System Databases in SQL Server (last update: 10/9/2009)
- Steps to Rename a SQL Server Database (last update: 1/3/2019)
- Using the Microsoft SQL Server 2005 Best Practices Analyzer (last update: 3/29/2010)
- Using the Microsoft SQL Server 2008 R2 Best Practice Analyzer (last update: 12/7/2010)
Dedicated Administrator Connection
- Enable SQL Server Dedicated Administrator Connection (last update: 7/24/2009)
- Enabling Dedicated Administrator Connection in SQL Server 2008 Express Edition (last update: 11/7/2011)
Dynamic Management Views and Functions
- New SQL Server 2012 DMVs to get configuration, installation and memory dump information (last update: 11/29/2011)
Error Handling
- SQL Server 2012 Throw Statement Introduction (last update: 3/21/2012)
Error Logs
- Increase the Number of SQL Server Error Logs (last update: 9/11/2009)
FILESTREAM
- Best Practices When Using FILESTREAM Feature of SQL Server (last update: 11/6/2009)
- Different ways to enable FILESTREAM feature of SQL Server 2008 (last update: 9/16/2009)
- FileTable Feature in SQL Server 2012 (last update: 4/13/2012)
- How to Backup and Restore a SQL Server FILESTREAM Enabled Database (last update: 10/8/2009)
- How to Detach and Attach a SQL Server FILESTREAM Enabled Database (last update: 11/11/2009)
- Using INSERT, UPDATE and DELETE to manage SQL Server FILESTREAM Data (last update: 10/2/2009)
Functions - System
- New Data Type Conversion Functions in SQL Server 2012 (last update: 12/23/2011)
- New FORMAT and CONCAT Functions in SQL Server 2012 (last update: 1/24/2012)
- New Logical Functions in SQL Server 2012 (IIF and CHOOSE) (last update: 12/28/2011)
Indexing
- Disabling Indexes in SQL Server 2005 and SQL Server 2008 (last update: 7/7/2009)
- Missing Index Feature of SQL Server 2008 Management Studio (last update: 2/18/2010)
Install and Uninstall
- SQL Server 2008 Service Pack 1 (SP1) Uninstall (last update: 8/26/2009)
Integration Services Execute Package Options
- Different ways to execute a SQL Server SSIS package (last update: 6/18/2009)
Monitoring
- Capture Diagnostic Data and Health Information in SQL Server 2012 using sp_server_diagnostics System Stored Procedure (last update: 3/30/2012)
- Install SQL Server 2012 Performance Dashboard Reports (last update: 4/26/2012)
- Performance Analysis Using SQL Server 2008 Activity Monitor Tool (last update: 1/12/2010)
Paging
- Overview of OFFSET and FETCH Feature of SQL Server 2012 (last update: 4/18/2011)
Performance Data Warehouse
- Performance Data Collection and Warehouse Feature of SQL Server 2008 Part 1 (last update: 5/7/2009)
- Performance Data Collection and Warehouse Feature of SQL Server 2008 Part 2 (last update: 5/21/2009)
Policy Based Management
- Enable Data File Growth for all the Databases Using Policy Based Management (last update: 10/15/2010)
- Enable SQL Server Transaction Log Growth for All Databases (last update: 11/3/2010)
- Identify Databases Not in SQL Server 2008 Compatibility Mode (last update: 8/6/2010)
- Identify SQL Server Databases Not in Full Recovery Model (last update: 7/12/2010)
- Identify SQL Server Databases Not Recently Backed Up Using Policy Based Management (last update: 9/22/2010)
- Why SYSPOLICY_PURGE_HISTORY job fails in SQL Server 2008 Failover Cluster Instance (last update: 6/23/2010)
Reporting Services Configuration
- Surface Area Configuration for SSRS Using Policy Based Management (last update: 5/25/2010)
Restore
- How to Restart an Interrupted SQL Server Database Restore (last update: 5/21/2012)
- Point in Time Recovery Using New Timeline Feature in SQL Server 2012 (last update: 2/20/2012)
Security
- Creating a SQL Server 2012 User Defined Server Level Role (last update: 6/27/2011)
SQL Server Agent
- Built in SQL Server Agent Performance Reports in SQL Server 2005 (last update: 5/21/2010)
SQL Server Configurations
- Configure Windows Firewall for SQL Server 2008 Database Engine in Windows Server 2008 R2 (last update: 3/12/2010)
- Configure Windows Firewall for SSAS in Windows Server 2008 R2 (last update: 4/19/2010)
- Configure Windows Firewall for SSIS in Windows Server 2008 R2 (last update: 6/8/2010)
- Configuring Server Startup Parameters in SQL Server 2012 (last update: 5/3/2011)
- Identify location of the SQL Server Error Log file (last update: 10/6/2011)
- Identify SQL Server TCP IP port being used (last update: 9/21/2011)
- Using the Microsoft SQL Server 2012 Best Practice Analyzer (last update: 6/22/2012)
SQL Server Management Studio
- Change Default Value for Select Top n and Edit Top n Rows in SQL Server Studio (last update: 3/11/2011)
- Different Options for Query Results in SQL Server Management Studio (last update: 3/28/2011)
- Different SQL Server Management Studio Startup Options (last update: 2/15/2011)
- Display Line Numbers in a SQL Server Management Studio Query Window (last update: 7/23/2012)
- Hiding System Objects in Object Explorer in SQL Server Management Studio (last update: 2/25/2011)
- Improvement to Keyboard Shortcuts in SQL Server 2012 Management Studio (last update: 2/27/2012)
- SQL Server 2008 R2 Generate Scripts Wizard with Database Schema and Data (last update: 9/26/2011)
- SQL Server 2012 Cycle Clipboard Ring Feature (last update: 7/28/2011)
- SQL Server 2012 Task List Feature in SSMS (last update: 7/29/2011)
- Using Object Explorer Details and Object Search Feature of SSMS 2008 (last update: 2/4/2010)
- Zoom Feature for Query Text and Results Text in SQL Server Management Studio (last update: 5/6/2011)
T-SQL
- Overview of WITH RESULT SETS Feature of SQL Server 2012 (last update: 4/12/2011)
Tools
- Connecting to SQL Server Using SQLCMD Utility (last update: 8/25/2011)
Upgrades and Migrations
- Identify database features restricted to a specific edition of SQL Server 2008 (last update: 9/7/2010)
- Overview of Microsoft SQL Server 2008 Upgrade Advisor (last update: 12/14/2010)
- Steps to Install SQL Server 2008 Service Pack 1 (SP1) (last update: 6/3/2009)
- Upgrading to SQL Server 2008 Using Backup and Restore Method (last update: 11/19/2010)
- Upgrading to SQL Server 2008 using Copy Database Wizard (last update: 7/13/2009)
- Upgrading to SQL Server 2008 Using Detach and Attach Operations (last update: 10/6/2010)