SQL Server FILESTREAM Database backup overview January 16, 2019 by Rajendra Gupta The SQL Server FILESTREAM feature in SQL Server allows storing the large documents files directly into the file systems. In my previous articles, we explored the concepts of FILESTREAM feature in SQL Server. We also learned the folder structures, metadata information and the process of garbage collection. In this article, we are going to learn about the backup and restores in SQL Server. Read more »
Managing data with SQL Server FILESTREAM tables January 14, 2019 by Rajendra Gupta SQL Server FILESTREAM allows storing the Varbinary (Max) objects in the file system instead of placing them inside the database. In the previous article – FILESTREAM in SQL Server, we took an overview of the FILESTREAM feature in SQL Server and process to enable this feature in SQL Server Instance. Read more »
FILESTREAM in SQL Server January 11, 2019 by Rajendra Gupta This article will discuss SQL Server FILESTREAM including installation, configuration, enabling and general considerations.
Change default database file and backup paths in SQL Server on Linux January 10, 2019 by Rajendra Gupta In a previous article, we explored the process to change default SQL dump file location in SQL Server. In this article, we will view the process to change the default database files and backup locations in SQL Server on Linux. Read more »
Improvements of Scalar User-defined function performance in SQL Server 2019 January 4, 2019 by Rajendra Gupta In SQL Server, we normally use user-defined functions to write SQL queries. A UDF accepts parameters and returns the result as an output. We can use these UDFs in programming code and it allows writing up queries fast. We can modify a UDF independently of any other programming code.
Power BI Desktop Q&A data interaction examples January 3, 2019 by Rajendra Gupta The Q&A feature in Power BI desktop provides a way to move towards Artificial Intelligence. In my previous article, we learned about the prominent Q&A in Power BI Desktop feature. We can get the desired result from Power BI Desktop by asking a question in Natural language. It converts the result set in tabular, chart format based on the requirement. It also helps users to build the question with its intelligence. It is one of the most incredible features of Power BI.
Uninstalling SQL Server on Ubuntu December 31, 2018 by Rajendra Gupta We learned to install SQL Server 2019 installation on Ubuntu without a Docker Container in one of my previous articles, but we might also get a request to uninstall SQL Server running on Ubuntu as well. Both the installation and the uninstallation of SQL Server is different in Linux than of Windows OS. In windows, we can remove or uninstall any program using the add or remove programs feature. In Ubuntu, We need to run the commands in order to uninstall the programs. However, before performing uninstallation, we need to take care of the below point. Read more »
SQL Server Profiler in Azure Data Studio December 28, 2018 by Rajendra Gupta In this article, we will explore SQL Server Profiler in Azure Data Studio in detail including download and installation, execution plans, coding T-SQL and more. Read more »
Monitoring Disk Space on Linux – Helpful Commands for SQL Server DBAs December 25, 2018 by Rajendra Gupta In this article, we will explore the different Linux commands related to the disk space. ‘ls’ command ‘df’ command ‘du’ command
Changing SQL Dump file locations in SQL Server on Linux December 24, 2018 by Rajendra Gupta In this article, we will talk about SQL Dump files and the process to change the dump directory in Linux SQL Server.
Ask a Question feature in Power BI Desktop December 21, 2018 by Rajendra Gupta In this article, we are going to learn how to use Power BI Desktop Q&A functionality to enable users to ask the question from the data set and easily get the results without any configuration or write complex codes.
Renaming a SQL Server instance on Ubuntu Linux December 20, 2018 by Rajendra Gupta In my previous articles, we installed the SQL Server 2019 CTP 2.1 on Ubuntu Linux. You can follow the below articles to prepare the SQL instance on Linux.
Flow Map Chart in Power BI Desktop December 19, 2018 by Rajendra Gupta In this article, we will explore the Flow Map chart in Power BI Desktop. Power BI is helpful to visualize the data through various form of the inbuilt and the custom charts. We have explored few such important charts in previous articles. Below is the list of articles for reference
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 »
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.
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
