MSDN's SQL 2005 tool kit updated to 2008, 2012, 2014, 2016, 2017, 2019 and 2022 for detecting metadata in SQL Server, SSIS, SSRS and SSAS. This project is an update on the project released on MSDN ...

remove-circle Internet Archive's in-browser bookreader "theater" requires JavaScript to be enabled. It appears your browser does not have it turned on. Please see ...

Abstract: A web application is prone to security threats due to its open nature. The security of these platforms is imperative for organizations of all sizes because they store sensitive information.

PolyBase, a data virtualization feature for SQL Server, allows users to seamlessly query data from various external sources directly using T-SQL (Transact-SQL) without the need for separate client ...

The focus of this article is on using Microsoft Purview to enable access to user data as well as specific system metadata in SQL Server 2022 running on Azure Arc–enabled servers. With the SQL Server ...

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 ...

The DB Schema Export Tool exports SQL Server or PostgreSQL database objects as schema files. Exported objects include tables, views, stored procedures, functions, and synonyms, plus also database ...

Four years ago, I created a Query performance insights library (QPI). This is a T-SQL library that enables troubleshooting and monitoring performance on #AzureSQL #ManagedInstance. While I worked on ...

Leveraging Microsoft SQL Server, we have made it easier for app makers to enable their users to take pictures and upload files in their apps. App makers can now use the Microsoft SQL Server connector ...

In SQL Server 2005 and later, you can create a transaction log backup while a full or differential backup is occurring, but the log backup will not truncate the log due to the fact that the entire ...