SQL Server DBA, BI Analyst and Microsoft MVP

Posts Archive

Month: July 2015

Back to Archive

How to calculate business days in SQL Server (dCalendario Table)

July 29, 2015 7 min read

Continue reading

Free SQL Server ebooks for Download

July 29, 2015 3 min read

Continue reading

How to create a table with the national, state and movable holidays in SQL Server

July 28, 2015 5 min read

Continue reading

How to remove accents and special characters from a string in SQL Server

July 27, 2015 2 min read

Continue reading

Consuming the Google Maps API using OLE Automation in SQL Server

July 27, 2015 3 min read

Continue reading

How to use JSON in SQL Server 2008, 2012 and 2014 - Reading JSON strings, importing into the database and exporting to XML

July 25, 2015 14 min read

Continue reading

How to kill all connections to a database in SQL Server

July 19, 2015 3 min read

Continue reading

SQL Server - How to Implement Login Audit and Control (Logon Trigger)

July 19, 2015 9 min read

Continue reading

How to create an audit trigger to log object manipulation in SQL Server

July 18, 2015 6 min read

Continue reading

How to export data from a SQL Server table to HTML

July 12, 2015 7 min read

Continue reading