PHP SQL Server blob hosting

from here see this post for sql server driver downloads   downloadPDF.php

SQLConnect.php

Read More

SQL Server PDO PHP7

get the DLL – grab latest x64.zip add to your php.ini extension list:

here’s sample call code:

Read More

Shred GPX WPT XML with SQL Server

namespace example

output Id Value 5637163536 1014 5637163580 1288

Read More

SQL Server Aliasing

Done via “SQL Server Configuration Manager” > “SQL Native Client vXY.Z Configuration” > Aliases tip: SSMS.exe is a 32bit app (because Visual Studio, upon which it is based, still has a well established justification for 32bit) and therefore it depends on the (32bit) Client Configuration node above to find your server alias For mainstream sql […]

Read More

DST T-SQL

Read More

Enable SSL Connections to SQL Server

“SQL Server Transport Encryption” is a good Google phrase for this technology. Reference: http://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: http://www.microsoft.com/download/en/confirmation.aspx?id=17275 All you’ll need is the “SelfSSL.exe” tool so the custom install is minimal. Find SelfSSL.exe in default […]

Read More

Hacking Profiler into SSMS Express

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 – http://www.microsoft.com/en-us/download/details.aspx?id=22985 But SSMS Express doesn’t provide the Profiler (aka SQL Trace) component that […]

Read More