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


 

Get Your Own Blog

If you would like to blog on SQLServerCentral.com then send an email to webmaster@sqlservercentral.com.

Contact the author

All Blogs

Feeds

Archives for this blog

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.

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, 258 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, 274 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, 370 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, 631 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, 430 reads

Posted in SQLFeatures on 10 March 2012

Windows Server 8 Hyper-V Lab boot from VHD

Windows Server 8 Beta is out, check this video to use existing windows laptop/desktop to build VHD bootable Windows server 8 Hyper-v Test lab without formatting existing OS. You will learn how to boot to Windows Server 8 Virtual Hard Disk (VHD)...

Read more

0 comments, 443 reads

Posted in SQLFeatures on 7 March 2012

Low Power SQL Server Test Lab on Windows Server 8 Hyper-V / ESXi5

Windows Server 8 Beta is released, if you are looking to build a low cost, Low power PC which can server as 24x7 W7 HTPC as well as Windows Server 8 Hyper-V (Beta) or ESXi5 Hypervisor than this is what to start with…

Read more

0 comments, 351 reads

Posted in SQLFeatures on 3 March 2012

Detect Worst Performing SQL Queries – Part 3

Best way to tune production server is to find out what are the queries executed in a particular duration and how many times it got executed, thus to concentrate on tuning top hitting queries ASAP...check out the video and scripts

Read more

0 comments, 373 reads

Posted in SQLFeatures on 27 February 2012

24 Hours of Free, Nonstop SQL Server Training

Join SQL Server experts as they take an in-depth look at the hottest SQL Server topics over 24 consecutive (and free!) technical webcasts. The learning starts on March 21, 2012 beginning at 00:00 GMT (that’s a March 20 evening start for the Americas).

Read more

0 comments, 309 reads

Posted in SQLFeatures on 17 February 2012

SQL server 2012 – NextGen HADR Solution

  SQL Saturday – San Diego – Sep 17 2011 Thanks you everyone for attending session, here is the presentation DAC….  

Read more

0 comments, 236 reads

Posted in SQLFeatures on 2 February 2012

Detect Worst Performing SQL Queries – Part 2

This series of Videos will walk through how to detect worst performing sql queries which is slowing down Microsoft SQL Server, after this session you should be able to achieve below objectives… How to use SQL Server DMO’s to gather what resources are the bottlenecks and which queries are causing…

Read more

0 comments, 477 reads

Posted in SQLFeatures on 31 January 2012

Detect Worst Performing SQL Queries

This series of Videos will walk through how to detect worst performing sql queries which is slowing down Microsoft SQL Server, after this session you should be able to achieve below objectives… How to use SQL Server DMO’s to gather what resources are the bottlenecks and which queries are causing…

Read more

0 comments, 287 reads

Posted in SQLFeatures on 29 January 2012

Fine Tuning Production SQL Servers

  The Silicon Valley SQL Server User Group – Jan 17 2012 Thanks you everyone for attending session, here is the presentation DAC….

Read more

0 comments, 204 reads

Posted in SQLFeatures on 18 January 2012

Prepare Windows 7 to create Hyper-V Virtual lab to implement SQL Server 2008 R2 SP1 Active/Active Cluster

This series of Videos will walk through how to prepare existing windows 7 machine to test and validate active/active node SQL server cluster configuration prior to production…not only will try how to build a Hyper-V test lab to validate SQL clusters, I will also cover overall knowledge of dependent technologies… Read more

0 comments, 306 reads

Posted in SQLFeatures on 24 August 2011

Prepare one box Virtual lab to evaluate SQL Server Denali Always-ON Features

This series of Videos will walk through on how to prepare one box HyperV lab to understand, evaluate & validate SQL Server Denali Always-ON HADR Features

Part 1: Denali setup & Network Configuration
Part 2: Configure Windows 2008 R2 Domain Controller
Part 3: Preparing nodes for failover cluster
Part 4:… Read more

1 comments, 216 reads

Posted in SQLFeatures on 2 February 2011

Quick SQL Server Sessions Troubleshooting

Summary

I get lot of queries from DBA’s asking what is the quickest way to figure out issue on SQL Server. For me almost every SQL Server performance troubleshooting starts with checking how sessions are doing, trying to find out which sessions are problem and needs quick fix…

In this… Read more

0 comments, 236 reads

Posted in SQLFeatures on 5 January 2011

 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.