SQL Server Auditing for HIPAA and SOX – Part 4

Regulations may require that you audit exactly who does what in your databases. Robert Sheldon explains how SQL Server can help you meet those requirements with its built-in auditing capabilities.

Generate documents from SQL Server

Automating population of SQL Server data into Word and PDF document templates for contracts, invoices,letters etc. creation saves thousands of hours for businesses. This article explores various approaches and offers few suggestions on how to choose the best approach for your requirements.

ISNUMERIC function

Foundational Material: Microsoft SQL Server Book and Blogs From The Past

Erik Darling dusts off his favorite archival-quality bloggers and books.

Representing XML data in SQL Server

In this article, we will see how to use the FOR XML statement in SQL Server to represent the result of queries in XML format.

Placing a Mark in SQL Server's Transaction Log for Fall Back

How many times have you had a programmer come to you and say they want you (the DBA) to restore their database to sometime prior to when they accidentally corrupted it? If you are doing FULL transaction logging you can do a point in time recovery to restore the database to just prior to when the corruption occurred. But in order to do that you need to know exactly when the programmer corrupted the data, which in a lot of cases is not known down to the second.

Why SQL Developers Keep Making The Same Mistakes

They learned by reading your old code.

What to Do When SQL Server is Slow

Brent Ozar's session for the PASS DBA Fundamentals virtual chapter.

How to Tell If Your SQL Server Has Too Much Memory

Brent shows what Perfmon counter to watch after your SQL Server restarts.

SQL Server Graph Databases – Part 5: Importing Relational Data into a Graph Database

In the final article of this series, Robert Sheldon shows how to move from a relational structure to a graph structure using the Graph Database feature.