Performing a SQL Server Audit using System-Versioned Temporal Tables

May 14, 2019 by Ahmad Yaseen

In previous articles of this SQL Server Audit series (see the TOC at the bottom), we discussed the main concept and real-life needs for having a SQL Server Audit solution. After that, we went through the different methods that can be used to audit the SQL Server instances and databases. In this article, we will show how to take advantages of the System-versioned Temporal Tables feature to audit database table DML changes.

Top MySQL bloggers of 2018

May 14, 2019 by SQLShack

We made a collection of the most popular MySQL bloggers, including a link to each individual blog. The ranking is based on Alexa global score as of April 25, 2019.

SQL Server CONCATENATE Operations with SQL Plus (+) and SQL CONCAT functions

May 13, 2019 by Rajendra Gupta

This article explores SQL Server Concatenate operations using the SQL Plus (+) operator and SQL CONCAT function.

SSAS interview questions for Multidimensional models

May 13, 2019 by Daniel Calbimonte

Introduction

SSAS interview questions is a new article for people looking for SSAS jobs.

In our previous article, we talked about SSIS interview questions. In this new article, we will talk about the SSAS interview questions to be prepared for an interview for a job using SQL Server Analysis Services.

Controlling Azure Costs Using Scaling and Tags

May 13, 2019 by Timothy Smith

Depending on our design and security, we can create functions or use built-in tools to control our Azure costs. In some contexts, we may look at the overall cost of what tools we’re using, which the Azure portal conveniently shows. Applying what we’ve looked at on the organization and development level, we can organize resources on their design (or ad hoc, as we’ll see) along with creating scripts that control our scale for situations where we may want higher or lower scale. We’ll look at both of these scenarios and how they can help us in both organization and development contexts.

SQL Server Always On Listeners

May 13, 2019 by Rajendra Gupta

This article on SQL Server Always On Listeners includes an overview and various connection configurations for specifying MultiSubnetFailover including SSMS, ODBC, ADO.NET, as well as MultiSubnetFailover limitations and how to connect to all IP addresses via RegisterAllProvidersIP.

SQL Server Always ON Availability Group Log Backup on Secondary Replicas

May 10, 2019 by Rajendra Gupta

In a high OLTP environment, we may observe strain on CPU and IO due to frequent backups. It might include further complexity due to backup compressions. SQL Server Always On Availability groups provides the capability to perform database backups from the secondary replicas. This article explores Log backups in SQL Server Always On Availability Group.

AWS RDS SQL Server migration using native backups

May 10, 2019 by Ranga Babu

In this article, we will review how to migrate database from on-premises SQL Server instance to AWS RDS SQL Server instance and between AWS RDS instances using native backup, restore and amazon simple storage service(S3).

SQL ISNULL function

May 10, 2019 by Rajendra Gupta

This article explores the SQL ISNULL function to replace NULL values in expressions or table records with examples.

SQL Server Always On Availability Group Data Resynchronization

May 9, 2019 by Rajendra Gupta

In my previous article Data Synchronization in SQL Server Always On Availability Group, we described a scenario where if a secondary replica goes down in synchronous data commit mode, SQL Server Always on Availability group changes to asynchronous data commit mode. It ensures that users can get their transaction commit irrespective of waiting for a secondary replica to come online.

SQL CHARINDEX

May 9, 2019 by Rajendra Gupta

We use the SQL CHARINDEX function to find the position of a substring or expression in a given string. We might have a character in different positions of a string. SQL CHARINDEX returns the first position and ignores the rest of matching character positions in a string.

Data Sampling with Python SQL Scripts

May 9, 2019 by Rajendra Gupta

Introduction

The Python programming language is object oriented, easy to use and, widely used programming language. We can write simple Python SQL Scripts and it performs the task that is not easy to do with t-SQL.

SQL Unit Testing Mocking Stored Procedures

May 8, 2019 by Esat Erkec

In this SQL Unit testing article, we will continue our journey with SQL unit testing. In the previous articles of this series (see the TOC at the bottom), we mentioned about SQL unit testing essentials and designing approaches as well and then we reinforce these notions with various tSQLt framework practical examples. In this article, we will continue to learn how to mock stored procedures in the tSQLt framework and we will provide it with two examples.

SQL Server cursor attributes

May 8, 2019 by Ranga Babu

A SQL Server cursor is a database object that is used to process the data in a set row by row. In this article, we will review how to create a cursor and different attributes used while declaring a cursor.

10 Most Common SQL Unit Testing Mistakes

May 7, 2019 by Haroon Ashraf

This SQL unit testing article is based on the fact that we often learn from the mistakes so the idea is to highlight the mistakes to understand them clearly so that they can be avoided straight away.

DATEADD SQL function introduction and overview

May 6, 2019 by Rajendra Gupta

This article explores the DATEADD SQL function and its usage scenarios with various examples.

Data synchronization in SQL Server Always On Availability Groups

May 3, 2019 by Rajendra Gupta

This article describes the data synchronization process on SQL Server Always On Availability Groups in both Synchronous, and Asynchronous data commit mode.

SQL Server monitoring tool for CPU performance

May 3, 2019 by Bojan Petrovic

CPU pressure slowing down the server

This article is the sequel in a series about SQL Server monitoring tools and common performance issues. Before reading this piece, it advisable to read the previous two articles about monitoring tools for disk I/O and memory performance:

How to use fake functions with SQL unit testing?

April 30, 2019 by Esat Erkec

In this article series, we are exploring SQL unit testing, in general, and also we are reinforcing details and topics with various practical examples. We are using the tSQLt framework because it is the quite powerful and handy tool in order to develop and code SQL unit tests.

Fix Orphan users in SQL Server using DBATools PowerShell

April 30, 2019 by Rajendra Gupta

This article gives an overview of Orphan users and fixing them using DBATools PowerShell.

Azure Costs Tracking with Security and Design Considerations

April 30, 2019 by Timothy Smith

Azure costs can quickly mount, without careful supervision and management. This article will detail cost mitigation strategies using security and design

AWS RDS SQL Server Migration using AWS Database migration service

April 30, 2019 by Ranga Babu

In this article, we will review how to migrate database from on-premise SQL Server instance to AWS RDS SQL Server instance using AWS Database migration service. There are different ways to migrate the database to the AWS RDS instance:

SQL TRIM function

April 24, 2019 by Rajendra Gupta

In this article, we will review the new SQL TRIM function in SQL Server 2017 onwards as well as providing some information on strings functions that pre-date it like LTRIM AND RTRIM.

DATEPART SQL function

April 23, 2019 by Rajendra Gupta

This article explores the DATEPART SQL function and its use in writing t-SQL queries. In the previous article, SQL Convert Date Functions and Formats, we explored various data formats and convert them using SQL Convert function.

SQL Add Column operations

April 22, 2019 by Rajendra Gupta

This article explains the SQL add column operation into an existing SQL table. We will also explore different examples of SQL add column operations.