In this article, we are going to learn how we can manage the FILSTREAM filegroup of SQL Database. I am going to cover the following topics.
Read more »
Server management
How to download and install SQL Server 2016 express edition
December 2, 2021In this article, you are going to learn about SQL Server 2016 express download and installation process. The SQL Server 2016 express edition is a free version of SQL Server that offers limited features. The express edition of SQL Server can be used in any of the following scenarios:
Read more »
Using SQL Server to query data from Amazon Athena
November 5, 2021In this article, we are going to use SQL Server to query data that resides in Amazon S3 buckets with the help of Amazon Athena. SQL Server is one of the most popular relational database management systems developed by Microsoft. SQL Server can be installed on-premises or on popular cloud services like Azure or AWS. For the purpose of this demonstration, we are going to use SQL Server that has been installed on-premises. Also, as a pre-requisite for this tutorial, we would need to have an AWS account valid and some knowledge about Amazon Athena.
Read more »
Installing Oracle 19c on Windows Server 2019
October 13, 2021In this article, we understand the step-by-step installation process of Oracle 19c on Windows Server 2019. The minimum hardware requirement to install an Oracle database server is following:
Read more »
SQL Connection Strings tips
September 24, 2021This article intends to give some useful tips on usage details of the SQL connection strings.
Read more »
Configure ODBC drivers for MySQL
August 5, 2020In this article, I am going to explain ODBC drivers. We will go through the process to set up the ODBC driver for MySQL and use it to create an SSRS report. First, let me talk about ODBC drivers.
Read more »
How to configure an iSCSI initiator on Windows Server 2016
July 7, 2020In this article, I am going to explain how we can configure the iSCSI initiator and use it to connect to the iSCSI virtual disk on the target server.
Read more »
Installing and configuring a iSCSI Target Server on Windows Server 2016
June 30, 2020In this article, I am going to explain how we can install and configure the iSCSI Target Server Role on Windows Server 2016. iSCSI stands for Internet Small Computer System Interface and iSCSI Target Server allows you to boot multiple computers from a single operating system (OS) image.
Read more »
How to use SQL Server Configuration Manager
February 12, 2020SQL Server configuration manager is a tool provided by Microsoft SQL Server. When we install SQL Server, it is installed automatically. It is used for the following purposes.
Read more »
Move a SQL database using the detach and attach method
January 29, 2020This article explores the process of moving a SQL database using the detach and attach method.
Read more »
Different methods to identify the SQL Server version number
December 11, 2019In this article, I am going to show different methods to identify the SQL Server version number and its edition. Also, I have included the list of known SQL Server version numbers, Service Packs (SP), and Cumulative Updates (CU of MS SQL Server 2019, 2017). I have not included the hotfixes and CUs of SQL Server 2008 R2 and earlier versions.
Read more »
How to find the SQL Server version
October 8, 2019In this article, we will explore how to find the SQL Server version details with various methods.
Read more »
Overview of SQL Server Aliases
October 7, 2019This article gives an overview of SQL Server Alias and its usage for connecting with SQL Server.
Read more »
Recover a lost SA password
September 20, 2019In this article, we will review how to recover SA password by starting SQL Server in single user mode when you forget “sa” credentials or lose the access to the instances due to the following reasons:
Read more »
Overview of SQL Server Startup Parameters for the SQL Database Engine Service
July 24, 2019In the SQL world, it is an important activity to perform SQL Server installation for a database administrator. Have you ever noticed ‘SQL Server Startup Parameters’ for the SQL Service? You might not have noticed them, but these parameters are beneficial for DBAs.
Read more »
Overview of Service Principal Name and Kerberos authentication in SQL Server
July 18, 2019This article gives an overview of Service Principal Name (SPN) for using the Kerberos authentication in SQL Server connections. We use the Kerberos authentication to authenticate windows users securely for providing access to SQL Server.
Read more »
Inventory and document your SQL Server estate using PowerShell
January 14, 2019Data growth has raised the stakes in the market increasing the size of SQL Server estates that DBAs are expected to manage. Because of this, fast and efficient configuration management can be very helpful. To this end, let’s delve into this article to generate a SQL Server inventory using PowerShell.
Six methods to automatically Discover SQL Server instances
December 12, 2018DBAs 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.
A concrete example of migration between an Oracle Database and SQL Server using Microsoft Data Migration Assistant
April 12, 2018Introduction
Intended audience
This document is intended for application developers and database administrators who plan to migrate an Oracle Database to Microsoft SQL Server.
Context
In the previous article, we saw how to install and prepare to migrate one or more Oracle Schema(s) and their objects to SQL Server. Now it’s time to go through the migration process…
Read more »
Migrating an Oracle Database to SQL Server with Microsoft Data Migration Assistant – Installation Process and Short Overview
March 27, 2018Intended audience
This document is intended for application developers and database administrators who plan to migrate an Oracle Database to Microsoft SQL Server.
Context
Nowadays, most IT professionals are aware that Oracle Database is a very good database solution, but it’s not inexpensive, to say the least. If you want to partition a table in Oracle, it’s an option that you must pay for, which is the same for advanced security options like Database Encryption or Dynamic Data Masking. In contrast, SQL Server comes with these options out of the box when you use the Enterprise Edition.
Read more »
Microsoft SQL Server Migration Assistant (SSMA) v7.1 for Oracle
December 12, 2016Introduction
SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies and automates database migration processes (assessment analysis, necessary conversions, data migration and tests) from Microsoft Access, MySQL, Oracle, Sybase and DB2 to SQL Server, Azure SQL DB and SQL Server vNext (at the time I’m writing this article, SQL Server vNext stills in CTP1 version, so being a technical preview version it should not be used for production migrations).
Read more »
Link a SQL Server to an Oracle database
August 15, 2016There are some cases in the wild where we want to get back data from an external database without additional coding in an application and just write a T-SQL query that will do all the job for us. That’s why Microsoft provides the « linked server » feature.
Read more »