Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLFeatures

Prakash Heda works as Sr. Database Administrator at Advent Software. His expertise includes Performance Tuning/Troubleshooting, high availability, SAN configuration and windows administration. He has 13+ years of experience managing enterprise-wide data needs in both high volume transactional and data warehouse environments. Prakash holds certifications for MCDBA and MCITP. His background includes administration & development using VB/ASP/SSIS using SQL Server 2000, 2005 and 2008/R2 and SQL server 2012. He is an active member of PASS, SQL Saturday. He’s a frequent presenter at user groups, SQL Saturdays, and other community events. He is also an avid tweeter, blogger and runner.

May 13th – Standardized SQL Installations – Script Review & Demo

This session is mostly demo-focused. I will cover prerequisites for scripts and show how to do multiple SQL Server installations using scripts and demonstrate how to Streamline SQL Server implementations.

Read more

0 comments, 121 reads

Posted in SQLFeatures on 2 May 2015

Speaking on Streamlining SQL Server Implementations Across Organization – Silicon Valley!!

In this session Prakash will walk through the process implemented to alleviates many of the pain points for deploying, managing, and supporting multiple SQL Server deployments from development to production.

Read more

0 comments, 163 reads

Posted in SQLFeatures on 3 March 2015

Speaking on Standardize SQL Server Implementations (Dev to Prod)

In this session Prakash will walk through the process he has implemented to alleviates many of the pain points for deploying, managing, and supporting multiple SQL Server deployments from development to production.

Read more

0 comments, 243 reads

Posted in SQLFeatures on 31 October 2014

Webinar: Presenting to the PASS Database Administration Virtual Chapter

In this Webinar, Prakash will walk you through design considerations, accompanied with a script demo using PowerShell to generate a dynamic re-indexing script, created based on his real-life experience from managing high performing database systems.

Read more

0 comments, 262 reads

Posted in SQLFeatures on 20 October 2014

Re-Indexing – The quest of ultimate automation

In this session, Prakash will walk you through design considerations, accompanied with a script demo using PowerShell to generate a dynamic re-indexing script , created based on his real-life experience from managing high performing database systems.

Read more

0 comments, 223 reads

Posted in SQLFeatures on 26 September 2014

Standardize SQL Server Implementations (Dev to Prod)

In this session Prakash will walk through the process he has implemented to alleviates many of the pain points for deploying, managing, and supporting multiple SQL Server deployments from development to production.

Read more

0 comments, 302 reads

Posted in SQLFeatures on 19 September 2014

PASS SQLSaturday – speaking on “Streamlining SQL Server Implementations across organization”

In this session Prakash will walk through the process he has implemented to alleviates many of the pain points for deploying, managing, and supporting multiple SQL Server deployments from development to production.

Read more

0 comments, 284 reads

Posted in SQLFeatures on 30 June 2014

Presentation DAC “SQL Server Implementation Framework From Dev to Prod”

The San Francisco SQL Server User Group – June 11 2014 Uploading presentation DAC for Today’s session….

Read more

0 comments, 242 reads

Posted in SQLFeatures on 12 June 2014

SQL Server Implementation Frameworks From Dev to Prod

On 11th June 6.30 PM, I will be presenting “SQL Server Implementation Frameworks From Dev to Prod”@ at San Francisco SQL Server User Group, If you are in the area I hope to see you… Location:Microsoft 835 Market Street, San Francisco, CA Register Here Session Detail: You’ll learn about a…

Read more

0 comments, 227 reads

Posted in SQLFeatures on 10 June 2014

Presentation DAC “AlwaysOn Multisite Cluster Implementation In The Cloud”

The San Francisco SQL Server User Group – Jan 08 2014 Thanks you everyone for attending session, here is the presentation DAC….

Read more

0 comments, 304 reads

Posted in SQLFeatures on 8 January 2014

Presentation DAC “AlwaysOn Multisite Cluster Implementation In The Cloud”

The San Francisco SQL Server User Group – Jan 08 2014 Thanks you everyone for attending session, here is the presentation DAC….

Read more

0 comments, 112 reads

Posted in SQLFeatures on 8 January 2014

Presenting “AlwaysOn Multisite Cluster Implementation In The Cloud”

On 8th Jan 6.30 PM, I will be presenting “AlwaysOn Multisite Cluster Implementation In The Cloud”@ at San Francisco SQL Server User Group, If you are in the area I hope to see you… Location:Microsoft 835 Market Street, San Francisco, CA Register Here Session Detail: Your company is looking to…

Read more

0 comments, 119 reads

Posted in SQLFeatures on 3 January 2014

Presenting “AlwaysOn Multisite Cluster Implementation In The Cloud”

On 8th Jan 6.30 PM, I will be presenting “AlwaysOn Multisite Cluster Implementation In The Cloud”@ at San Francisco SQL Server User Group, If you are in the area I hope to see you… Location:Microsoft 835 Market Street, San Francisco, CA Register Here Session Detail: Your company is looking to…

Read more

0 comments, 260 reads

Posted in SQLFeatures on 3 January 2014

Presentation DAC: PowerShell: Automating SQL Stats Collection for Performance Tuning

The San Francisco SQL Server User Group – Oct 10 2012 Thanks you everyone for attending session, here is the presentation DAC…. Check how to use DMO sys.dm_exec_query_stats and sys.dm_io_virtual_file_stats for finding top CPU/Memory/IO queries with scripts… Detect Worst Performing SQL Queries – Part 3

Read more

0 comments, 447 reads

Posted in SQLFeatures on 13 October 2012

Presentation DAC: PowerShell: Automating SQL Stats Collection for Performance Tuning

The San Francisco SQL Server User Group – Oct 10 2012 Thanks you everyone for attending session, here is the presentation DAC…. Check how to use DMO sys.dm_exec_query_stats and sys.dm_io_virtual_file_stats for finding top CPU/Memory/IO queries with scripts… Detect Worst Performing SQL Queries – Part 3

Read more

0 comments, 100 reads

Posted in SQLFeatures on 13 October 2012

Presenting “PowerShell: Automating SQL Stats Collection”

On 10th Oct 6.30 PM, I will be presenting “PowerShell: Automating SQL Stats Collection for Performance Tuning”@ at San Francisco SQL Server User Group, If you are in the area I hope to see you… Location:Microsoft 835 Market Street, San Francisco, CA Register Here Session Detail:Use PowerShell to collect stats…

Read more

0 comments, 110 reads

Posted in SQLFeatures on 5 October 2012

Presenting “PowerShell: Automating SQL Stats Collection”

On 10th Oct 6.30 PM, I will be presenting “PowerShell: Automating SQL Stats Collection for Performance Tuning”@ at San Francisco SQL Server User Group, If you are in the area I hope to see you… Location:Microsoft 835 Market Street, San Francisco, CA Register Here Session Detail:Use PowerShell to collect stats…

Read more

0 comments, 503 reads

Posted in SQLFeatures on 5 October 2012

SQL Server 2012 Unattended Installation on Windows Server 8

In part 5 will install SQL Server 2012 on 3 Windows Server 8 VM’s using GUI and unattended installation to complete SQL Server 2012 Next Gen HADR labs prequisites Installing new instance of SQL Server at the command prompt enables you to stadardized SQL Server installation, selective features to install…

Read more

0 comments, 747 reads

Posted in SQLFeatures on 22 March 2012

Configure Windows Server 8 ISCSI Target

In part 4 will configure Windows Server 8 ISCSI Target to complete SQL Server 2012 Next Gen HADR labs prequisites, In this Video will use domain controller to also play role of iSCSI target and create ISCSI disk then connects to this disk over the network to VM which then…

Read more

0 comments, 1,189 reads

Posted in SQLFeatures on 11 March 2012

Configure Windows Server 8 Hyper-V and Domain controller

In Part 3 video series to prepare SQL Server 2012 test lab using Windows Server 8 Beta Hyper-V, will configure Hyper-V, Parent disk for differential VHDs and a test domain controller using diff disk, for testing SQL Server 2012 Next Gen HADR test lab...

Read more

0 comments, 870 reads

Posted in SQLFeatures on 10 March 2012

Older posts