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 »
How to create a Word Cloud generator in Power BI Desktop October 11, 2018 by Rajendra Gupta In this article, we’ll look at how to create a Word cloud generator in Power BI Desktop, including importing data, customization and more. In my last article, Power BI Desktop Interactive chord diagrams, we learned about customized visualizations in Power BI Desktop. These visualizations are free to install and we can use them with our data set and customize charts as per our requirements. Read more »
Power BI Desktop Pulse Charts October 9, 2018 by Rajendra Gupta In my last article, Power BI Desktop Interactive chord diagrams, we underscored that Microsoft Power BI desktop has a rich set of customized visualization features. These visualizations can help to produce convert data to information in an efficient manner to an easy to understand format. We can freely download them from Microsoft AppSource Read more »
Power BI Desktop Interactive chord diagrams September 28, 2018 by Rajendra Gupta Power BI desktop helps to create interactive reports and dashboards from a high and complex volume of the data. The Power BI desktop is an integrated tool where we can get the data from different sources. Read more »
SQL Server Data Import using Azure Data Studio September 18, 2018 by Rajendra Gupta Azure Data Studio is a new GUI based tool that works on Windows, Mac OS and Linux operating systems. It connects to SQL Server, Azure database, and SQL DW. Read more »
How to create and configure the Tree Map Chart in SQL Server 2016 Reporting Services October 28, 2016 by Rajendra Gupta In the previous article, in this series, How to create and configure a Sunburst chart in SQL Server 2016 Reporting Services, we have explored new chart types in SQL Server 2016; the Sunburst chart and the Tree Map chart, that are used to display hierarchical data. The Sunburst chart is a way of presenting relational datasets together in a compact form. The Tree Map Chart is also a way of showing hierarchical data. In this article, we are going to show how to create a Tree Map chart and its comparison with the Sunburst chart. Read more »
How to create and configure a Sunburst chart in SQL Server 2016 Reporting Services October 12, 2016 by Rajendra Gupta Microsoft SQL Server 2016 introduces several significant new features, and enhances some existing ones in reporting services. We have summarised these new features in the previous article. We’ve also explored how to configure the SQL Server Mobile reports in my earlier article. Read more »
How to compare query execution plans in SQL Server 2016 September 15, 2016 by Rajendra Gupta SQL Server 2016 provides great enhancement capability features for troubleshooting purposes. Some of the important features are: Read more »
How to create and configure SQL Server mobile reports September 2, 2016 by Rajendra Gupta Microsoft has recently launched SQL Server 2016 with lots of new features like row level security, always encrypted, stretch database, PolyBase, R Services, hybrid cloud capabilities, Dynamic Data Masking, query store, etc. There is a rich set of business intelligence, security features, and high availability solutions. Read more »
