Before you can document your SQL Server environment with SQL Power Doc you'll to meet the following requirements: Permissions - SQL Power Doc makes connections to standalone SQL Server instances using ...

However, if you want to customize the way a field maps to a database column, you can decorate a property with the @Column annotation. Along with the name property, the JPA @Column annotation can ...

Below is a cheat sheet that can be used for configuring SQL Server audit policies to log and detect potentially malicious behavior. It also includes some TSQL cheats for viewing the current audit ...

Part of the SQL Server 2022 blog series. In SQL Server 2008 Enterprise Edition, backup compression was introduced adding WITH COMPRESSION as an option in the T-SQL backup command. SQL Server backup ...

In part 1 of my SQL Server 2022 features series, you learned about the improvements to the cardinality estimator component of query optimization. In this installment, you will learn about another ...

For the last 7 years, I have worked professionally with Tableau, and for 7 years we have been asked questions about write back to a database. Can it be done, and what does it require? This blog post ...

Here, I am going to discuss some basic and most important configurations of the SQL Server Instance and Database Level which might be ignored and can cause performance issues. Although this is not the ...

This paper aims to establish a relative study between a relational Microsoft SQL Server database and a non-relational MongoDB database within the unstructured representation of data in JSON format.

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...