A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...
Windows Authentication is one of the features of the Native SQL server which is a secure way of connecting to the SQL server. Windows authentication is one of the authentication methods where the ...
Admin Pack for SQL Server VSIX Microsoft/azuredatastudio A collection of popular database administration extensions to help manage SQL Server Database Administration Tool Extensions for Windows VSIX ...
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 ...
Have you experienced breaking an app because you forgot to add or update new database objects? That’s one hell of a disruption to your users. Doing some Oracle schema compare could have avoided the ...
Indexes Query Optimization Statistics Hardware & Configuration High Availability and Disaster Recovery (HADR) Replication Partitioning Tempdb Optimization Regular Maintenance Different Types of ...
In SQL Server 2016 there have been several significant changes to the SQL Client Tools. Central to these changes are two primary goals: The ability to ship tooling updates on a regular, monthly ...
Microsoft Dynamics NAV 2013 has a feature that allows you to see the AL call stack for a SQL commands. Here I am going to describe how it can be used to profile your application code. There are ...