A high level view of how enterprises should manage their data and information.
The post The Changing Landscape of Information Management appeared first on SQLServerCentral.

Overview As we all know, data security is a never-ending battle. Every day, we hear of new data breaches. It's a hard problem, and there is no single solution, other than a defense in depth. Let's look at one of those defenses for databases: query control. Query control is a simple idea: most applications access […]
The post Query control made easy appeared first on SQLServerCentral.

Infragistics Reveal is a data visualization solution that simplifies the way you add embedded analytics and visualizations to your apps. Reveal supports connecting to OData APIs, but many enterprise APIs are not built using the OData standard. By combining Reveal with CData solutions, you can instantly build dynamic dashboards from live enterprise data sources like Salesforce. […]
The post Analyze Live Salesforce Data in Infragistics Reveal  appeared first on SQLServerCentral.

Use Flyway to run your database migrations, each time automatically creating a SQL Change Automation release object to provide object-level scripts and a build script for the new version, along with change reports and code analysis reports.
The post Using Flyway Teams with SQL Change Automation PowerShell Cmdlets appeared first on SQLServerCentral.

You can define policies for your Azure SQL Databases for security and meeting your organization’s standards. Management groups simplify policies over multiple subscriptions. Michael Wood explains Azure Policies and Management Groups.
The post Azure Policies and Management Groups appeared first on SQLServerCentral.

Phil Factor presents a useful but slightly flawed 'table report' script as an adventure playground for exploring SQL Code analysis issues. He demonstrates use of the auto-fix feature, to arrive at a pristine script free from wavy green underlines.
The post Exploring Auto-fix in SQL Code Analysis appeared first on SQLServerCentral.

Developers can work with multiple range values at once using sp_sequence_get_range. Greg Larsen explains how to return multiple sequence numbers with sp_sequence_get_range.
The post How to return multiple sequence numbers with sp_sequence_get_range appeared first on SQLServerCentral.

Problem Some time ago Argenis Fernandez(@DBArgenis) found and described a vulnerability that allows you to get into SQL Server with 'sa' rights. This method does not require a restart of the SQL Server service or the whole machine, the condition is a local administrator account on the server. Reminder SQL Server until 2008R2: Until SQL 2008R2, […]
The post How to (Somewhat) Increase SQL Server Security appeared first on SQLServerCentral.