BeejBlog

-- this code returns the start and end datetime’s for DST in the current year -- DST begins at 2am on the SECOND SUNDAY of March and ends the FIRST SUNDAY of November [Read More]

“SQL Server Transport Encryption” is a good Google phrase for this technology. Reference: https://msdn.microsoft.com/en-us/library/ms191192.aspx Obtain an SSL Certificate A self signed certificate is easy and works fine... here’s one way: Get the IIS 6.0 Resource Kit Tools: https://www.microsoft.com/download/en/confirmation.aspx?id=17275 All you'll need is the "SelfSSL.exe" tool so the custom install is... [Read More]

I have to say, SQL Server’s setup.exe seems pretty dang fragile… I realize it’s a complicated script with endless dependencies and such, just saying… year after year I continue to run into various reasons that the setup twists it’s ankle on something, bombs out midstream and leaves behind a partial... [Read More]

Nutshell [Read More]

We can download the SQL Server Management Studio Express installer for free which makes for a convenient source for this tool when firing up a new Windows machine that you just want to connect to some servers and get to work – https://www.microsoft.com/en-us/download/details.aspx?id=22985 But SSMS Express doesn’t provide the Profiler... [Read More]