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:
Reporting services are a feature that you can use starting from the Express edition, and it is a set of services that allow you to create and publish reports. I have written a series of articles about Reporting services (the first part is here). Users can view these reports on the URL within the internal… Read More »
In the previous two articles, I covered setting up database mail (gmail) and configuring Change Data Capture (CDC), which is the automatic tracking of changes to a table. So, it occurred to me, why not combine these topics and describe how to use automatic email to report changes to a specific table? This could come… Read More »
A database is a system of files and objects that are organized and linked within the database through keys. In SQL Server databases, you can find objects such as tables, views, functions, procedures, triggers, and more. Essentially, there are two ways to create a database. The first option is to create the database using the… Read More »
DBCC stands for database console commands, which are commands executed on a specific database. The DBCC command set allows you to perform various administrative operations or queries on databases through scripting, instead of using the graphical interface of Management Studio. To execute these commands, you typically need a high-level role (such as sysadmin, serveradmin, db_owner,… Read More »
SQL Developer is responsible for the development and management of application database structures, both from a database architecture perspective (tables, views, procedures, triggers) and in terms of security (access management, protection). SQL Developers most commonly work with these database platforms: SQL Server, MySQL, and Oracle. They are often mistakenly referred to as Database Administrators, but… Read More »
Microsoft.ace.oledb provider is not registered on the local machine is a quite common error message in data & analytics when we try to work with data in database without proper driver installed. When Does the ACE OLE DB Provider Error Occur and How to Resolve It? This error occurs when attempting to connect to an… Read More »
A data analyst is a professional who investigates data using data analysis tools to extract valuable information for management and business development. These individuals are capable of identifying patterns, dependencies, and trends in a large amount of data through a logical approach and technology (programming languages) that can positively influence management decisions and, consequently, business… Read More »
SQL Server offers 3 types of database recovery models: simple recovery model, full recovery model, and bulk-logged recovery model. The recovery model defines how SQL Server manages transactions and transaction logs and whether it stores or doesn’t store these data. Ultimately, this affects the options available for restoring data from backups. Each database can have… Read More »
A table without a primary key (clustered index) is referred to as a heap because it’s just a pile of unordered data. In contrast, a table with a clustered index is better structured into a balanced tree. The primary key itself is a clustered index and every table should have one. An optimized table or… Read More »
The Database Mail feature is only available in the SQL Server Standard edition and higher. In the SQL Server Express edition, unfortunately, it is not available. This feature is useful primarily if you want to send various messages from SQL Server to your email. Typically, this involves various checks, notifications, and alerts. Finally, this feature… Read More »