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

Getting started with Query Store feature in SQL Server 2016 – Part 2 06/20/2016

Query Store is a new feature in SQL Server 2016 which, once enabled, automatically captures a history of queries, execution plans, and runtime statistics, retaining them for your troubleshooting performance problems caused by query plan changes. This new feature greatly simplifies performance troubleshooting by helping you quickly find performance differences, even after server restart or upgrade. Read on to learn more.

Introduction to the Azure SQL Database Advisor 06/06/2016

One of the challenges associated with running your workloads in Azure SQL Database is the limited level of management oversight. While you can easily scale it vertically by changing the associated service tier and performance level, you do not have the option of running SQL Server Profiler or Index Tuning Wizard, commonly used to evaluate, troubleshoot, and optimize database performance. Fortunately, there is an alternative approach that leverages the functionality incorporated into the recently introduced Azure SQL Database Advisor component of Azure SQL Database. In this article, we will present its basic characteristics.

Altering an Existing Table to Support Temporal Data 06/02/2016

If you are looking for a way to track the history of all the data changes to a table then SQL Server 2016 has you covered with the new temporal table support. With Temporal tables SQL Server is able to store all the older data records into in a history table while keeping the current records in the original table. Greg Larsen explores using the temporal table feature of SQL Server 2016 to create a history table for an existing SQL Server table.

Getting Started with the Query Store Feature in SQL Server 2016 – Part 1 05/23/2016

Arshad Ali discusses SQL Server 2016 Query Store and how it greatly simplifies the performance troubleshooting process.

Row Level Security Part 3 – Disabling Row Level Security for DBAs and Database Owners 05/05/2016

Row Level security is all about restricting database users from being able to view or update rows based on who they are and what roles they are in. But there are some users who you “might” not want to restrict access at the row level at all, like the database owner, or someone with sysadmin permissions. In this article Greg Larsen shows you how to disable RLS for database administrators (users in the sysadmin role) and database owners.

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.

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