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. Read more »
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. Read more »
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. Read more »
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. Read more »
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). Read more »
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. Read more »
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. Read more »
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. Read more »
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. Read more »
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. Read more »
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. Read more »
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: Read more »
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. Read more »
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. Read more »
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 Read more »
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: Read more »
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. Read more »
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. Read more »
Using the SQL Server Audit Feature to Audit Different Actions April 22, 2019 by Ahmad Yaseen In the previous article of the SQL Server Audit series, SQL Server Audit Feature Components, we discussed the three main components of the SQL Server Audit feature; the SQL Server Audit, the Server Audit Specifications, and the Database Audit Specifications in details. In this article, we will show how to use the SQL Server Audit feature to track, log and review the different operations performed at both the SQL Server and the database levels. Read more »
SQL Server Transaction Log Administration Best Practices April 22, 2019 by Ahmad Yaseen In this article, we will go through a number of SQL Server Transaction Log recommendations and best practices that each database administrator needs to follow in order to enjoy his holidays and have a pleasant sleep without nightmares or calls during the night. Read more »
