MS SQL Server is the software created by Microsoft. It includes a database engine and a number of features that help with database development, maintenance, and various activities such as reporting or master data management.
These features include SQL Server Integration Services, Reporting Services, Analysis Services, and other components such as Master Data Management or Data Quality Services.
Don’t miss out from category:
The previous article focused on installing dbt in the Mage.ai environment or independently, followed by the initialization of a project named mage_dbt – Dbt Installation (pip/conda) and project initialization. So, we have the mage-ai environment installed, into which we have installed dbt-sqlserver. We then tested that we can see the established file structure of the… Read More »
I have been using the KingswaySoft tool for automating ETL data flows for many years and decided to write an article about this tool. KingswaySoft brings a low-code revolution to data integration through SQL Server Integration Services (SSIS). Don’t worry, it’s not a startup, it’s a vendor that has been in the market for many… Read More »
In this short article I will introduce the possibility to run a sql script outside of SQL management studio using SQL server command line utility (sqlcmd for short). This utility allows you to work with SQL server using the command line. The use are obvious and include working with SQL from different applications. How to… Read More »
I recently purchased a new Macbook Air with Apple Silicon M1 CPU architecture (ARM). From the first time everything was fine – super experience when unboxing, everything tuned to the smallest detail, huge performance, battery lasts 8 hours on a single charge without losing performance when unplugged. But… As a Business intelligence developer and financial… Read More »
Table Indexes are a fundamental pillar of optimizing SQL queries in a database. They significantly speed up read operations. Unfortunately, over time, indexes get fragmented, and the order of indexes deteriorates. Index fragmentation occurs because records are gradually inserted or deleted from a table, and indexes are not optimized afterward. This means that individual index… Read More »
A temporary table with a hash (#) or double hash (##) is a temporary table stored in the system database tempdb. This table exists only for the duration of the user session ID that created it. There are two types of temporary tables: Local Temporary Table A local temporary table is accessible only within the… Read More »
A data warehouse is a centralized repository where company-wide data is consolidated and stored in a format that enables clear, accurate, and user-friendly reporting in tools such as Excel, Power BI, or other analytical platforms. At some point in every company’s lifecycle, you inevitably realize that you are operating too many business systems and facing… Read More »
Resource Governor is one of the SQL Server enterprise features that are not available in any other edition. If you are interested in various limitations across editions, I have summarized them in the article SQL Server Installation – Planning, HW and SW Requirements. If you are experiencing performance problems and have tried various optimization and… Read More »
It is possible to connect to many data sources using Power Query (more in this article) and SQL Server database is one of them. This article will tell you how to set connection to SQL Server table directly from Excel in few simple steps. Guide to Data Import and Connecting to SQL Server from Excel… Read More »
As SQL Server administrators, we might want to know what is happening on the server during the day and if any unwanted incidents are occurring. This is where Alerts come into play. If an event occurs that is monitored by a defined alert, a notification will be sent via email to the operator who can… Read More »