Using the SSMS ConnectionDialog

I was attempting to add the SSMS connection dialog to my utility and ran into problems with referenced assemblies. The ConnectionDialog is documented here: https://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.ui.connectiondlg.aspx The following is a snippet using the SSMS ConnectionDialog in a C# application. Microsoft.SqlServer.Management.UI.ConnectionDlg. ConnectionDialog dlg = new Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog(); Microsoft.SqlServer.Management.Smo.RegSvrEnum. UIConnectionInfo connInfo = new Microsoft.SqlServer.Management.Smo.RegSvrEnum.UIConnectionInfo { ApplicationName = “My App”…


XEvent Timestamp is a large integer value not the expected datatime value

The timestamp column for XEvent is stored internally as an offset from the start of the trace.   The XEvent header contains the starting, UTC time and each event stores the offset in ticks from the value stored in the header. On a system where the time is adjusted, for example daylight savings time falls backward,…


Kerberos Configuration Manager updated for Analysis Services and SQL 2014

Kerberos Configuration Manager was released back in May of 2013.  It initially released with only SQL Server support. This was followed up with support for Reporting Services in November 2013. You can download the latest release from the following link: Microsoft® Kerberos Configuration Manager for SQL Server® http://www.microsoft.com/en-us/download/details.aspx?id=39046 This month we have released Version 3…


Version 9.04.0013 of the RML Utilities for x86 and x64 has been released to the download center

        X64: http://download.microsoft.com/download/0/a/4/0a41538e-2d57-40ff-ae85-ec4459f7cdaa/RMLSetup_AMD64.msi X86: http://download.microsoft.com/download/4/6/a/46a3217e-f523-4cc6-96e9-df73dd0fdd04/RMLSetup_X86.msi   This build encompasses previous features, fixes and enhancements designed from recent case work.    ·         SQL Server 2014 compliant ·         SQL Server 2012 and 2014 XEL input to ReadTrace compliant (sample .XEL capture script shipped with help documentation) no need for .TRC anymore. (PSSDiag updates align…


DReplay Message: “Active connections exceed 8192, connection 8409 is waiting.”

This message was an interesting dive into the DReplay, session boundary logic that I thought I would share.  Internally DReplay maintains a progressive, session queue.  This queue is limited to 8192 entries and populated in connection replay order based on the connect/disconnect boundaries.   A background worker maintains the queue for the replay workers, adding new…


SQLIOSim Checksum Validations

I had a very specific question asked of me related to the SQLIOSIM.exe, checksum validation logic.  It is pretty simple logic (on purpose) but effective so here are the basics. The key is that there are multiple memory locations used to hold the data and do the comparison.  1.     Allocate a buffer in memory of…


SQL Server: Correlating Timestamps From Various Data Points

I was looking at data from a customer, in a different time zone (UTC+1) from mine, this week involving SQL Server AlwaysOn (HADRON) and found that lining up the timestamps in the various logs was challenging.   Some times are local to the SQL Server instance, others UTC and yet other utilities attempt to adjust the…


Management Studio tricks you may or may not know about

I was sitting through SQL Server 2012 training, and Ajay Jagannathan was showing us Management Studio.  Eric Burgess had worked on this topic.  He started covering some neat things, that have apparently been there for a while, but I just never played around with it enough to see what all you could do.  I’m sure…


Pssdiag/Sqldiag Configuration Manager released to codeplex

  A lot of you are probably familiar with pssdiag tool released for SQL Server 7.0 and 2000 and sqldiag.exe utility shipped with SQL Server 2005, 2008 and 2008 R2. These are data collection diagnostics tools that allow collecting data such as profiler trace, perfmon and DMV information. For sqldiag.exe shipped with SQL Server 2005…