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.
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 »
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 »
Lightweight performance profiling in SQL Server 2019 November 21, 2018 by Rajendra Gupta Database administrators are used to dealing with query performance issues. As part of this duty, it is an important aspect to identify the query and troubleshoot the reason for its performance degradation. Normally, we used to enable SET STATISTICS IO and SET STATISTICS TIME before executing any query.
Graph Database features in SQL Server 2019 – Part 1 November 21, 2018 by Rajendra Gupta SQL Server 2017 introduced Graph database features where we can represent the complex relationship or hierarchical data. We can explore the following articles to get familiar with the concept of the Graph database. Read more »
Enlighten World Flag Slicer in Power BI Desktop November 21, 2018 by Rajendra Gupta Power BI has a rich set of visuals to represent data according to our requirements. These custom visuals make it easy for us to highlight data effectively to understand and share the data in reports. We have learned many customized visuals so far in ongoing series of Power BI Desktop. Read more »
Columnstore Index Enhancements – data compression, estimates and savings November 14, 2018 by Rajendra Gupta Data compression is required to reduce database storage size as well as improving performance for the existing data. SQL Server 2008 introduced Data compression as an enterprise version feature. Further to this, SQL Server 2016 SP1 and above supports data compression using the standard edition as well. Read more »
Candlestick chart for stock data analysis in Power BI Desktop November 14, 2018 by Rajendra Gupta Candlestick chart for stock data analysis in Power BI Desktop Power BI Desktop contains a wide range of custom visualizations which helps to represent and analysis of the data with extensive formatting options. You can effectively showcase your data and save time as well by creating complex data chart with simple configuration options. Read more »
The new SQL Server 2019 function Approx_Count_Distinct November 9, 2018 by Rajendra Gupta SQL Server 2019 has a rich set of enhancements and new features. In particular, there are many new feature improvements in the database engine for better performance and query tuning. Read more »
Hexbin Scatterplot in Power BI Desktop November 9, 2018 by Rajendra Gupta We have explored useful visualizations in Power BI Desktop with my previous articles that covered: Read more »
Columnstore Index Enhancements – Index stats update in clone databases November 9, 2018 by Rajendra Gupta SQL Server was launched in 1993 on WinNT and it completed its 25-year anniversary recently. SQL Server has come a long way since its first release. At the same time, Microsoft announced a preview version of SQL Server 2019. SQL Server 2019 provides the ability to extend its support to big data, Apache Spark, Hadoop distributed file system (HDFS) and provides enhancements to database performance, security, new features, and enhancements to SQL Server on Linux. Read more »
Power BI desktop Mekko Charts November 6, 2018 by Rajendra Gupta In my last articles on Power BI Desktop (see the index at the bottom of the article), we have explored that Power BI has a rich set of visualizations. We can present data using various custom visuals available from Microsoft AppSource. These visuals are available free to download and use it as per our requirements. Read more »
Enhanced PolyBase SQL 2019 – External tables SQL Server, Catalog view and PushDown November 6, 2018 by Rajendra Gupta This article is part 4 of the series for SQL Server 2019 Enhanced PolyBase. Let quickly recap the previous articles. Read more »
Enhanced PolyBase SQL 2019 – External tables using t-SQL October 31, 2018 by Rajendra Gupta In this article on PolyBase, we will explore more use case scenarios for external tables using T-SQL. Read more »
SQL data classification – Add sensitivity classification in SQL Server 2019 October 31, 2018 by Rajendra Gupta SQL Server 2019 offers powerful new features to help in safeguarding your data and complying with various privacy regulations, which we’ll be covering in this article Read more »
SQL truncate enhancement: Silent Data truncation in SQL Server 2019 October 31, 2018 by Rajendra Gupta In this article, we’ll take a look into SQL truncate improvement in SQL Server 2019. Data inserts and updates are a normal and regular task for the developers and database administrators as well as from the application. The source of the data can be in multiple forms as if direct insert using T-SQL, stored procedures, functions, data import from flat files, SSIS packages etc. Read more »
Enhanced PolyBase SQL 2019 – External tables for Oracle DB October 24, 2018 by Rajendra Gupta In the previous article of the series, we took an overview of PolyBase in SQL Server 2017. We also learned about the Azure Data Studio and SQL Server 2019 preview extension to explore SQL Server 2019 features. Read more »
Enhanced PolyBase SQL 2019 – Installation and basic overview October 24, 2018 by Rajendra Gupta SQL Server 2019 is recently launched in the ignite 2018 event by Microsoft. We can get an overview of SQL 2019 preview version and learn how to install it on Windows environment by following up the article SQL Server 2019 overview and installation. Read more »
SQL Server 2019 – New DMF sys.dm_db_page_info October 22, 2018 by Rajendra Gupta Microsoft released preview of SQL Server 2019 recently in Ignite 2018. With every release of SQL Server is enriched with new dynamic management view and functions along with enhancements to existing features. In this article, we will view the newly introduced dynamic management function (DMF) sys.dm_db_page_info and explore the different scenarios around it. Read more »
SQL Server 2019 overview and installation October 15, 2018 by Rajendra Gupta On September 24th, 2018, Microsoft launched SQL Server 2019 preview version (SQL Server vNext 2.0) in the ignite 2018 event. As you know, SQL Server 2017 is still being adopted by the organizations, we are now ready with this preview version. Read more »
