Enhanced PolyBase SQL 2019 – MongoDB and external table December 14, 2018 by Rajendra Gupta In this 5th part of the ongoing series of SQL Server 2019 Enhanced PolyBase, we will learn how to install and configure MongoDB and create an external table. Read more »
Helpful Linux commands for SQL Server DBAs – iotop and iostat December 13, 2018 by Rajendra Gupta In the article, we will learn how to use the ‘iotop’ and ‘iostat’ commands with various configuration options.
Columnstore Index Enhancements – online and offline (re)builds December 13, 2018 by Rajendra Gupta In this article, we will explore ‘ Clustered columnstore online index build and rebuild’ feature of SQL Server 2019 including comparing execution plans, offline builds and more Read more »
Six methods to automatically Discover SQL Server instances December 12, 2018 by Prashanth Jayaram DBAs have plenty of day-to-day tasks to do as part of administration, but one overarching task is managing the entire SQL Server environment. To do this, the full SQL Server estate must be discovered and inventoried. To accomplish that all SQL Server instances, that exist, must be found.
Renaming Logical and Physical file names in SQL Server on Linux December 12, 2018 by Rajendra Gupta Each database in SQL Server contains at least two files i.e. Data file (*.mdf) and log file (*.ldf). These database files have a logical name and the physical file name. Below we can view the simple architecture of a database in SQL Server.
Helpful Linux commands for SQL Server DBAs – top December 11, 2018 by Rajendra Gupta SQL Server 2017 and SQL Server 2019 supports both the Linux operating system. As part of performance troubleshooting or monitoring resources in Windows system, we need to check certain things like disk space, CPU or Memory consumption, check running processes, uptime etc. We can get the information, on a windows based SQL server, from the task manager.
CRUD operations in SQL Server December 10, 2018 by Prashanth Jayaram CRUD operations are foundation operations every database developer and administrator needs to understand. Let’s take a look at how they work with this guide. Read more »
SQL Server 2019 installation on Ubuntu without a Docker Container December 10, 2018 by Rajendra Gupta Until now, we learned to install and configure SQL Server 2019 using the Docker container. In this article, we will directly install SQL Server on the Ubuntu Linux and explore more on this.
Database Upgrade using the Query Tuning Assistant wizard in SSMS 18 December 6, 2018 by Rajendra Gupta This article will cover managing a SQL Server database upgrade using new features in SQL Server Management Studio 18 including the query tuning assistant wizard, database upgrade feature, query store and more
Static Data Masking in SSMS 18 December 6, 2018 by Rajendra Gupta In this article we are going to talk about Static Data Masking, a new feature for the SQL Databases in SSMS. Static Data Masking feature previously was available only for the Azure SQL DB.
Row Mode Memory Grant Feedback in SQL Server 2019 December 6, 2018 by Rajendra Gupta In this article, I’ll be exploring another new feature with SQL Server 2019, row mode memory grant feedback, along with a retrospective on adaptive query processing, examples and more. Read more »
What is SQL in SQL Server? December 5, 2018 by Prashanth Jayaram What is SQL, in the context of SQL Server, is a common question asked by beginners. This article is meant to answer that question, while providing some history, context and an overview of the fundamentals of the language Read more »
How to markup, annotate content like a boss December 5, 2018 by Bojan Petrovic Overview As a writer and content creator, I often use annotation and drawing markup tools to add value to the content I’m creating. You might not think of it as a big deal, but the human brain processes visuals 60,000 times faster than text. Is it true? Probably not. There’s no scientific evidence to back up this figure. However, it’s a fact that humans process visual data better. Therefore, I always try to deliver helpful, value-added content with a lot of visuals suitable for easy reading and understanding.
The STRING_SPLIT function in SQL Server December 3, 2018 by Esat Erkec This article will cover the STRING_SPLIT function in SQL Server including an overview and detailed usage examples.
An MDS Driven Approach to a Turnaround Time Calculation in SQL Server November 30, 2018 by Sifiso W. Ndlovu One calculation that you are almost guaranteed to have to produce in your career as a T-SQL developer relates to the calculation of a turnaround time. This is often a key KPI for measuring the performance of both individuals and teams, particularly when the business operates within a service-oriented sector i.e. customer support, transportation, healthcare etc. Turnaround time calculation does not only refer to business metrics rather any activity (i.e. ordering a pizza) with a recorded start and an end time can have its own turnaround time calculated. In this article we evaluate different options for calculating a turnaround time including using DATEDIFF function, creating your own user-defined function (UDF) as well as an integration with SQL Server Master Data Services. Read more »
SQL Server 2019 on Linux with Ubuntu November 29, 2018 by Rajendra Gupta In my previous articles, we installed SQL Server 2019 on the windows environment (vs Linux / Ubuntu). We also explored some of the important enhancements in SQL Server 2019
SQL Server 2019 on Linux with a Docker container on Ubuntu November 29, 2018 by Rajendra Gupta In the first article of the series on SQL Server 2019 and Ubuntu, we prepared the virtual machine environment and installed Ubuntu 18.10 in it. In this part of the article, we will install the latest SQL Server 2019 Preview CTP 2.1. Read more »
SQL Server 2019 on Linux with Ubuntu and Azure Data Studio November 29, 2018 by Rajendra Gupta In the previous articles of this series on using SQL Server 2019 on Ubuntu, we have explored the following Read more »
Saving your SQL Execution Plan November 28, 2018 by Ahmad Yaseen In the previous articles of this series (see the index at bottom), we discussed the characteristics of the SQL Execution Plan from multiple aspects, that include the way the SQL Execution Plan is generated by the SQL Server Query Optimizer internally, what are the different types of plans, how to identify and analyze the different components and operators of the Execution Plans, how to work with the plans using different tools and finally, tuning the performance of simple and complex T-SQL queries using the Execution Plans. In this, the last article of this series, but not the least, we will discuss where the Execution plan is stored and how to save it for future use.
How to create an email alert in SQL Server Agent for job failures November 28, 2018 by Esat Erkec SQL Server Agent is a Microsoft Windows service which helps to execute, schedule and automatize T-SQL queries, Integration Service Package, SQL Server Analysis Service queries, executable programs, operating system, and PowerShell commands. These actions which are performed by SQL Server can be called by the SQL Server Agent. Maybe, we can liken SQL Server Agent to an alarm clock because the agent will execute the scheduled task when the time comes Read more »
