Static Data Masking in SSMS 18
December 6, 2018In 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.
Search Results for: azure
Row Mode Memory Grant Feedback in SQL Server 2019
December 6, 2018In 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.
The STRING_SPLIT function in SQL Server
December 3, 2018This article will cover the STRING_SPLIT function in SQL Server including an overview and detailed usage examples.
SQL Server 2019 on Linux with Ubuntu
November 29, 2018In 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, 2018In 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.
How to Programmatically Pass Credentials in an Embedded Power BI Report
November 20, 2018In the article, How to embed a Power BI Report Server report into an ASP.Net web application, we looked at available options for embedding a Power BI Report Server report into an ASP.NET web application. Since the publication of the article, I have received several questions relating to how one goes about programmatically passing credentials […]
CDS for apps in the [POWER WORLD]
November 19, 2018Executive Summary CDS for Apps VS Power Query – is there a difference? If so, what is that difference? Are they mutually exclusive or complement each other? Later I briefly outline Common Data Services for Analytics no, Power BI Datapools no again, actually Power BI Data Flows. It is difficult to keep up with the […]
Columnstore Index Enhancements – data compression, estimates and savings
November 14, 2018Data 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.
SQL Execution Plan enhancements in SSMS 18.0
November 13, 2018This article will provide an overview of the SSMS 18.0 with particular focus on improvements to the SQL execution plan feature. To work with Microsoft SQL Server Database Engine, you need to have an environment to edit, debug and deploy scripts written in different languages such as T-SQL, DAX, MDX, XML and JSON. In addition, […]
The new SQL Server 2019 function Approx_Count_Distinct
November 9, 2018SQL 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.
How to secure Reporting Services with Group Managed Service Accounts (GMSA)
November 7, 2018In this article, we will explore the functionality to secure reporting Services with Group Managed Service accounts ( GMSA)
Enhanced PolyBase SQL 2019 – External tables SQL Server, Catalog view and PushDown
November 6, 2018This article is part 4 of the series for SQL Server 2019 Enhanced PolyBase. Let quickly recap the previous articles.
Enhanced PolyBase SQL 2019 – External tables using t-SQL
October 31, 2018In this article on PolyBase, we will explore more use case scenarios for external tables using T-SQL.
Enhanced PolyBase SQL 2019 – External tables for Oracle DB
October 24, 2018In 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.
Enhanced PolyBase SQL 2019 – Installation and basic overview
October 24, 2018SQL 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.
Forecast SQL backup size
October 23, 2018This article will cover the process of analyzing and predicting/forecasting the size of a SQL backup as a means to better handle/manage retention of backups. One of the main database management tenets is “Do not lose your data”. According to this; a database administrator incurs huge responsibilities to protect data. Under these circumstances, taking database […]
SQL Server 2019 overview and installation
October 15, 2018On 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.
Power BI Desktop Interactive chord diagrams
September 28, 2018Power 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.
Deploy SQL Server with Cluster Shared Volumes – part 2
September 19, 2018In the other article in this series: Deploy SQL Server for failover clustering with Cluster Shared Volumes – part 1 we have seen what a cluster shared volume is and what are the advantages and other considerations to keep in mind when deploying CSVs for SQL Server workloads. In this article, I will walk though […]
Text Analytics with Microsoft Flow
September 19, 2018Twitter is a very popular social media platform which generates millions of tweets a day. These tweets include very valuable data for marketers or social media analyzers because they can analyze these tweets with specific algorithms and find out the sense of social media users.
SQL Server database backup tools
September 18, 2018This collection of content presents an overview of top SQL Server database backup tools, with product page links for each of the tools and screenshots if available. If you noticed a tool we missed, please let us know in the comments below.
Top 50 PowerShell bloggers of 2018
August 31, 2018We made a collection of the most popular PowerShell bloggers, including a link to each individual blog. The ranking is based on Alexa global score. If your blog is on this list, you can display the ‘Top blogger’ badge on your blog. Please see the bottom of the page for the instructions on how to […]
How to integrate Power BI data alerts into Slack
August 31, 2018There is a growing trend among professionals and entire companies to move away from email as a primary means of communication and are even adopting alternative technologies. One of the most popular of these is Slack. Slack is a new kind of messaging and communication platform between colleagues, team or community members that allows them […]
Understanding automatic tuning in SQL Server 2017
August 22, 2018Monitoring databases for optimal query performance, creating and maintaining required indexes, and dropping rarely-used, unused or expensive indexes is a common database administration task. As administrators, we’ve all wished, at some point, that these tasks were simpler to handle.
Top SQL Server LinkedIn groups
August 16, 2018Here you can find 60+ LinkedIn groups ordered by a number of members in it and with short description from the group’s profile page.