Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

SQL Server management, tutorials, scripts, coding, programming and tips for database administrators

MS SQL

Implementing Azure SQL Database Elastic Database Jobs 05/02/2016

In a recently published article we described the basic characteristics of Azure SQL Database elastic database jobs. As we pointed out, their name is somewhat misleading since it implies that they are intended specifically for Elastic Database pools. However, their scope can include any custom-defined group of Azure SQL Databases, although the implementation in such cases is not yet available via the Azure portal but requires the use of Azure PowerShell (or the equivalent REST API). In this article, we take you through the sequence of steps illustrating this scenario.

Getting Started with Temporal Table in SQL Server 2016 – Part 2 04/25/2016

With the new temporal table feature, SQL Server 2016 internally manages two tables--a base table, which contains the latest data and a history table, which contains the history of changes. Read on to learn about this new feature, how it works, how to create a new table or enable the feature for an existing table.

Row Level Security with SQL Server 2016: Part 2 - Blocking Updates at the Row Level 04/18/2016

With the new security policy feature in SQL Server 2016 you can restrict write operations at the row level by defining a block predicate. Read on to learn why a block predicate is important when you implement row level security using SQL Server 2016.

Azure SQL Database Elastic Database Jobs 04/07/2016

One of more common concerns among database administrators who consider migrating their estate to Azure SQL Database is their ability to efficiently manage the migrated workloads. In particular, the absence of the SQL Server Agent introduces the challenge of identifying a means to perform ad-hoc and scheduled automated management tasks across multiple databases. Fortunately, recently introduced Elastic Database jobs provide a convenient and efficient way to address this concern.

Row Level Security with SQL Server 2016: Part 1 – Allow Access to Only a Subset of Rows Using Row Level Security 04/04/2016

Have you ever wanted an easier way to provide security at the record level? If so, you can now easily do this with the Row Level Security feature that is being introduced with SQL Server 2016. Greg Larsen shows you how easy it is to use this new feature as a way to provide user access to a specific set of records.

Getting Started with Temporal Table in SQL Server 2016 – Part 1 03/21/2016

With the new temporal table feature, SQL Server 2016 internally manages two tables; a base table, which contains the latest data all the time and a history table, which contains a history of all of the changes. Read on to learn about this new feature, how it works, and how to either create a new table with this feature or enable it for an existing table.

Exploring SQL Server 2016 Dynamic Data Masking – Part Two - Masking and Exporting Data in Existing Tables 03/17/2016

Dynamic Data Masking allows you to obscure your confidential data column values at the database engine level for both new and existing SQL Server data. Being able to alter the definition of an existing column to add a masking rule makes it very simple to obscure your existing column values without even changing your application code. Read on to learn more.

Introduction to Protecting SQL Server with Azure Site Recovery 03/07/2016

Microsoft cloud platform allows you to provide resiliency for your on-premises SQL Server deployments. Marcin Policht describes this functionality, available as part of the Azure Site Recovery solution.

10 New Features Worth Exploring in SQL Server 2016 03/03/2016

There is a lot of buzz around SQL Server 2016. It will not be too long until SQL Server 2016 will be fully baked and ready for shipping. As always there are a ton of new features and in this article Greg Larsen explores 10 of those new features.

Getting Started with JSON Support in SQL Server 2016 – Part 2 02/22/2016

Arshad Ali discusses the native support of JSON in SQL server 2016 and provides a step-by-step guide to start parsing and using JSON content in SQL Server 2016.

Exploring SQL Server 2016 Dynamic Data Masking – Part One - Creating a Table that uses Dynamic Data Masking 02/18/2016

Greg Larsen investigates a new feature in SQL Server 2016 known as Dynamic Data Masking. By using data masking you can obscure the real value of a data column with a masked value. In this article he explores the different features of how to hide the value of sensitive data by applying Dynamic Data Masking.

Introduction to Azure SQL Database Elastic Database Pools 02/04/2016

Traditional deployments of Azure SQL Database involve identifying projected resource requirements and selecting individual Azure SQL Database instances. For fluctuating workloads, this frequently results in over- or under-provisioning. To address this challenge, Microsoft offers another approach to sizing Azure SQL Database that relies on Elastic Database Pools. Read on to learn more.

Exploring SQL Server 2016 Always Encrypted – Part 4 – Encrypting Existing Data 02/01/2016

Greg Larsen explores the different ways that you can encrypt your existing confidential data using Always Encrypted Columns in SQL Server 2016.

Exploring SQL Server 2016 Always Encrypted – Part 3 – Differences between Deterministic or Randomize Encryption 01/25/2016

In this third article of the exploring SQL Server 2016 Always Encrypted series, Greg Larsen looks at the differences between an Always Encrypted column that uses an encryption type of Deterministic and those that use encryption type of Randomized.

Getting Started with JSON Support in SQL Server 2016 – Part 1 01/19/2016

SQL Server 2016 introduces built-in support for storing, managing and processing JSON data. Read on to learn about this new feature and follow along with a step-by-step guide to start parsing and using JSON content natively in SQL Server 2016.

MS SQL Archives




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM