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

Real-time Operational Analytics in SQL Server 2016 - Part 2 09/19/2016

Arshad Ali discusses the different design considerations for leveraging the Real-time Operational Analytics feature of SQL Server 2016, covering the different scenarios where it fits or does not fit, and how to get started with it for disk based tables.

Azure SQL Database - Azure AD Authentication 09/06/2016

One of the challenges when considering migrating your on-premises SQL Server databases to Azure SQL Database is its lack of support for Active Directory-integrated authentication. With the advent of Azure SQL Database V12, the authentication capabilities have been expanded, allowing for more flexibility that leverages Azure Active Directory. In this article, we will provide an overview of this functionality.

Managing SQL Server Backup and Restore History Information 09/01/2016

SQL Server provides a couple of different ways to delete backup and restore history.  If you want to remove backup and restore information for all databases based on a date you can use the sp_delete_backuphistory system stored procedure.  Or you can use the system stored procedure named sp_delete_database_backuphistory if you want to remove all backup and restore history for a specific database.

Masking Your Data with SQL Server 2016 09/01/2016

There are times when you want some users to see part of a column value but not the whole thing, but you want other users to see the complete column value without any masking. The new SQL Server 2016 Dynamic Data Masking feature will allow you to define these different kinds of masking rules.

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.

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