Showing posts from 2015

SQL - Determine Locking

Gets the list of sessions which are blocking others in SQL WITH [Blocking] AS (SELECT w.[session_id] ,s.[original_login_name] ,s.[login_name] ,w.[wait_duration_ms] ,w.[wait_type] ,r.[status] ,r.[wait_resource] ,w.[resource_description] ,s.[program_name] ,w.[blocking_session_id] ,s.[host_name] ,r.[command] ,r.[percent_complete] ,r.[cpu_time] ,r.[total_elapsed_time] ,r.[reads] ,r.[writes] ,r.[logical_reads] ,r.[row_count] ,q.[text] ,q.[dbid] ,p.[query_plan] ,r.[plan_handle] FROM [sys].[dm_os_waiting_tasks] w INNER JOIN [sys].[dm_exec_sessions] s ON w.[session_id] = s.[session_id] INNER JOIN [sys].[dm_exec_requests] r ON s.[session_id] = r.[session_id] CROSS APPLY [sys].[dm_exec_sql_text](r.[plan_handle]) q CROSS APPLY [sys].[dm_exec_query_plan](r.[plan_handle]) p WHERE w.[session_id] > 50 AND w.[wait_type] NOT IN ('DBMIRROR_DBM_EVENT' ,'ASYNC_NETWORK_IO')) SELECT b.[session_id] AS [Waitin

SQL Currently Running Sessions

Get all current sessions running on sql instance. SELECT r.session_id, r.status, r.start_time, r.command, s.text, r.wait_time, r.cpu_time, r.total_elapsed_time, r.reads, r.writes, r.logical_reads, r.transaction_isolation_level ,r.* FROM sys.dm_exec_requests r CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) s

SQL - Get Connected Hosts

Gets a list of all the connections currently open on SQL SELECT HOST_NAME, PROGRAM_NAME, wait_resource, wait_time, wait_type, net_transport, DMER.session_id, start_time, DMES.status, plan_handle, auth_scheme, local_tcp_port, local_net_address FROM sys.dm_exec_requests DMER INNER JOIN sys.dm_exec_sessions DMES ON DMES.session_id=DMER.session_id INNER JOIN sys.dm_exec_connections DMEC ON DMEC.session_id=DMES.session_id

Online PDF Permissions Remover

Based upon the 20 or so PDF unlockers I have used this one has always worked the best for me. Key Features of CrackMyPDF: - Remove PDF restrictions for copying, editing, printing & extracting.  - No Software Installation Required. Everything is done online. What CrackMyPDF Can't Do Our PDF Restrictions Remover can work to remove the restrictions in standard password protected PDF file, including 40-bit RC4 ecryption, 128-bit RC4 decryption and 128-bit AES decryption.  But it can NOT:  - Remove or find the user/open password automatically.  - Remove other protections, such as DRM or third part plug-in.

Import CRM 2011 Solution Into 2015

In order to import a 2011 solution into 2015 you must first import it into 2013 then re-export from there.  Additionally if you solution contains all 2015 compliant components you can manually edit the solution.xml file within the solution to the following…...

Publishing CRM Using WAP, AD FS and DoD PKI

With TMG going the way of the dodo Microsoft has moved much of it's functionality into Server 2012R2.  This includes publishing applications utilizing Windows Authentication and Kerberos Constrained Delegation (KCD).  This is done through a combination of a feature called Web Application Proxy and ADFS 3.0. Requirements Windows Server 2012R2 The Web Application Proxy server should be joined to the domain in order to pass KCD tickets.  The WAP server actually can be in another domain but it would require additional setup not covered in this article. The External DNS of CRM should point to the WAP server. WAP server will need two virtual or physical network cards.  One for external communications and one for internal. The Federation Service URL cannot match the machine name of the AD FS server. Example Configuration This diagram represents the configuration for our sample environment. Additional setup scenarios for load balancing the WAP and CRM server are possible but not c