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 Access
Database Tools
SQL Scripts & Samples
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
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


Real-time Operational Analytics in SQL Server 2016 - Part 1 08/22/2016

Arshad Ali takes a look at traditional analytics architecture, the challenges it faces, and how the newly introduced Real-time Operational Analytics feature overcomes those challenges.

Introduction to SQL Server Stretch Database 08/04/2016

In many cases Azure SQL Database offers an economically and functionally viable alternative to SQL Server deployments. However, there are also scenarios where we might discover that rather than serving as a replacement, it provides synergy, working side by side with your on-premises databases. One of technologies that illustrate this paradigm is Stretch Database, introduced in SQL Server 2016. We will describe its basic characteristics and review its implementation steps in this article.

Temporal Data Part 3 – Reporting Out Current and Historical Information 08/01/2016

With the introduction of temporal table support in SQL Server 2016 Microsoft also added some additional functionality that makes it easy for you to join the current and history records of a system-versioned table. Greg Larsen shows you some of the different ways to do analysis of your system-versioned records over time.

Getting started with Query Store feature in SQL Server 2016 – Part 3 07/21/2016

Arshad Ali demonstrates how you can analyze the data collected by Query Store either with T-SQL scripting or with the graphical user interface in SSMS.

Introduction to Azure SQL Database Temporal Tables 07/07/2016

As announced on June 1, 2016, SQL Server 2016 has reached its general availability. This means that you finally have the option to implement some of its new features in the production environment. While we still have to wait for their full support in Azure SQL Database V12, it is likely that their preview stage will be concluded soon. In this article, we will focus on Temporal tables, which is one example of these new features.

Temporal Data Part 2 - Creating and Deleting System-Versioned Tables 07/05/2016

Greg Larsen expands on his topic of how to modify an existing table to take advantage of the new temporal data feature in SQL Server 2016. In this article he shows you how to create and deleted system-versioned tables and the associated history temporal table.

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.

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