SQL Server DBA, BI Analyst and Microsoft MVP

Posts Archive

Month: December 2016

Back to Archive

SQL Server - How to create a Secret Santa draw using Transact-SQL

December 27, 2016 3 min read

Continue reading

SQL Server - Msg 443: Invalid Use of a Side-Effecting Operator RAND Within a Function

December 26, 2016 3 min read

Continue reading

SQL Server - Using the SQLQueryStress Tool to Optimize Your SQL Queries

December 25, 2016 4 min read

Continue reading

SQL Server - Why You Should Not Use SET ANSI_WARNINGS OFF

December 23, 2016 5 min read

Continue reading

Reporting Services (SSRS) - Error when deleting mobile reports (Error invoking the authorization extension)

December 4, 2016 5 min read

Continue reading

How to Install and Configure Microsoft SQL Server Reporting Services (SSRS) 2016 on Windows Server 2016

December 4, 2016 7 min read

Continue reading

SQL Server - How to encrypt and decrypt passwords (with Salt) using CLR (C#)

December 2, 2016 4 min read

Continue reading

SQL Server - How to query national, state, municipal, and optional holidays from an API using OLE Automation and CLR (C#)

December 1, 2016 4 min read

Continue reading

Useful Things You Can Do with the .htaccess File

December 1, 2016 6 min read

Continue reading