Troubleshoot Runaway Queries in SQL 2014 Using sys.dm_exec_query_profiles

Scenario You are tasked to identify the bottleneck of a slow or problematic T-SQL query which either never finishes, takes many hours to complete, or fails after many hours (for example with a tempdb space error). You would like to view execution plan details and runtime statistics while the query is still executing. The Challenge…

1

How to Start or Stop SQL Services without OS Admin Rights

Scenario You wish to grant users who do NOT have OS administrative rights the ability to start/stop SQL Server & SQL Agent services. Please review the following related blog post: http://blogs.msdn.com/b/sqlupdates/archive/2015/05/14/how-to-start-or-stop-sql-services-without-uac-prompts.aspx (Note: to see the pictures below at a better resolution, please click on the picture and this will open a link to the source…

0

How to Start or Stop SQL Services without UAC Prompts

Scenario You have OS administrative rights and would like to start/stop SQL Server & SQL Agent services via a script without getting any UAC elevation prompts in an environment where UAC is enabled. Please review this related blog post for steps to grant non-admin users permissions to stop/start SQL Services: http://blogs.msdn.com/b/sqlupdates/archive/2015/05/14/how-to-start-or-stop-sql-services-without-os-admin-rights.aspx. For an overview of…

0

SQL Updates Newsletter – April 2015

Recent Releases and Announcements Microsoft Disaster Response – Nepal Earthquake http://blogs.technet.com/b/microsoft_corporate_disaster_response_blog/archive/2015/04/27/microsoft-disaster-response-nepal-earthquake.aspx?pi47623=3 An updated announcement regarding the SQL Server 2014 Service Pack 1 release http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/04/16/sql-server-2014-service-pack-1-has-released.aspx Although the package was only briefly available on the Microsoft Download Center, we apologize for this mistake and the inconvenience you may have encountered as a result. The original release was…

1

SQL Updates Newsletter – March 2015

Recent Releases and Announcements   ·         SQL 2012 SP1 CU 15 o        http://support.microsoft.com/en-us/kb/3038001 ·         SQL 2012 SP2 CU 5 o        http://support.microsoft.com/en-us/kb/3037255 ·         An on-demand hotfix update package is available for SQL Server 2014 o        http://support.microsoft.com/en-us/kb/3043788 ·         SQL Release Services Blog o        http://blogs.msdn.com/b/sqlreleaseservices/ ·         Azure AD Connect Preview 2 is available o        http://blogs.technet.com/b/mackblog/archive/2015/03/25/azure-ad-connect-preview-2-is-available.aspx ·         Microsoft Enhances…

0

PowerShell Lessons Learned from Building an Automated SQL Installation and Patch Management Implementation

Attached are the PowerPoint slides from the recent presentation I gave for the SQL Server User’s Group meeting.  Thank you all for attending! Download the presentation here. <Extracted Slide Text> PowerShell Lessons Learned from Building an Automated SQL Installation and Patch Management Implementation Presented by: Fany Carolina Vargas, Microsoft Corp., Sr. PFE, SQL Dedicated Support…

0

SQL Updates Newsletter – February 2015

Recent Releases and Announcements ·         An on-demand hotfix update package is available for SQL Server 2008 R2 SP3 o        http://support.microsoft.com/kb/3033860/en-us ·         An on-demand hotfix update package is available for SQL Server 2008 SP4 o        http://support.microsoft.com/kb/3034373/en-us ·         Cumulative Update #6 for SQL Server 2014 RTM o        http://support.microsoft.com/kb/3031047 ·         SQL Release Services Blog o        http://blogs.msdn.com/b/sqlreleaseservices/ ·         Downloadable…

0

SQL Updates Newsletter – January 2015

Recent Releases and Announcements ·         Cumulative Update #14 for SQL Server 2012 SP1 o        http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/01/21/cumulative-update-14-for-sql-server-2012-sp1.aspx ·         Cumulative Update #4 for SQL Server 2012 SP2 o        http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/01/20/cumulative-update-4-for-sql-server-2012-sp2.aspx ·          SQL Release Services Blog o        http://blogs.msdn.com/b/sqlreleaseservices/ ·         Microsoft Security Bulletin Summary for January 2015 o        There is a critical Telnet update for this month: o        https://technet.microsoft.com/library/security/ms15-jan ·         Windows…

0

SQL Updates Newsletter – December 2014

Recent Releases and Announcements    ·         SQL Server 2014 CU5 o   http://support.microsoft.com/kb/3011055 ·         SQL Release Services Blog o   http://blogs.msdn.com/b/sqlreleaseservices/ ·         Microsoft Security Bulletin Summary for December 2014 o   There is a critical IE, Office, and Windows update for this month: o   https://technet.microsoft.com/library/security/ms14-dec ·         New Microsoft Intune capabilities o   http://blogs.technet.com/b/mackblog/archive/2014/12/02/new-microsoft-intune-capabilities.aspx ·         Security Compliance Manager Baselines for…

0

Guidelines for Setting SQL Permissions on Mount Point Folders

You can use Windows Disk Management to assign a mount-point folder path (rather than a drive letter) to a volume. In this manner you can access a new volume via a child folder path of a different volume’s drive letter. For example, say you have three 100GB volumes Vol1, Vol2, Vol3. We can initially mount…

0