Oct
13

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

By

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

Presenting “PowerShell: Automating SQL Stats Collection”

By

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 from all SQL Servers in [...]

Read More...
Mar
21

SQL Server 2012 Unattended Installation on Windows Server 8

By

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 and how they should be [...]

Read More...
Mar
11

Configure Windows Server 8 ISCSI Target

By

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 be using for setting up SQL Server FCI cluster

Read More...
Mar
10

Configure Windows Server 8 Hyper-V and Domain controller

By

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

Windows Server 8 Hyper-V Lab boot from VHD

By

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

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

By

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

Read More...
Feb
27

Detect Worst Performing SQL Queries – Part 3

By

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

24 Hours of Free, Nonstop SQL Server Training

By

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

SQL server 2012 – NextGen HADR Solution

By

SQL server 2012 – NextGen HADR Solution – Thanks you everyone for attending session, here is the presentation DAC for SQL Saturday 95 (San Diego)….

Read More...