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:
In applications or complex enterprise information architectures, there is often a need to handle historical records and track changes in values for various reasons. Most of the time, it’s for security purposes; we need to monitor who is making changes and be able to correct errors, whether they are from users or database administrators. Another… Read More »
From time to time, it’s important to examine the database objects in terms of table size (number of rows and storage) to avoid some performance issues on server. How to Check Table Sizes in a SQL Database If there are not many objects in the database, you can perform the check directly in the properties… Read More »
In SQL Server, there is a system table that stores all possible error states and their severity levels. Error severity ranges from 0 to 25 and defines the seriousness of an error. All sql server error messages that you may encounter are stored in the sys.messages table. USE MASTER SELECT * FROM SYS.MESSAGES WHERE language_id… Read More »
xp_cmdshell is a very powerful procedure that allows you to execute commands via the command-line (cmd) in SQL Server. With cmdshell, you can perform various operations on a Windows server through the SQL platform, such as copying files, creating, deleting, running bcp for data import and export, and more. However, there are significant security risks… Read More »
SQL Server Agent is a tool integrated into SQL Server that is primarily used for automating and scheduling tasks. Through SQL Agent, you can create Jobs and schedule individual tasks within those Jobs, such as executing scripts, running SSIS packages, using PowerShell, and much more. However, SQL Server Agent is only available in the Standard… Read More »
SQL Server 2017 was released in October 2017. Many users were still getting accustomed to all the features in SQL 2016, but Microsoft quickly brought in another set of features that are sure to please. Microsoft representatives and user feedback confirm that SQL Server 2017 represents a significant step in development compared to, for example,… Read More »
Are you navigating the IT environment and would like to land your dream job or enhance your personal knowledge portfolio? Bet on the latest certifications from Microsoft. We will focus on the MCSA: SQL 2016 certification. If you have no idea what it is and why this certification should interest you, then you’re in the… Read More »
In the previous article (see Index Fragmentation), I described how to detect index fragmentation using a script that utilizes system tables. According to Microsoft’s recommendations, we should reorganize (REORGANIZE) indexes with fragmentation between 5 – 30% and rebuild (REBUILD) indexes with fragmentation above 30%. We will use the script from the previous article and create… Read More »
Running more than 1 procedure at a time may not be as simple a task as it seems, especially if individual procedures have dependencies between them – meaning that a set of procedures relies on the execution of other procedures. So, how can we achieve parallelism when running sql server queries? Let’s recap the options… Read More »
SQL Server offers several backup methods. These backup types can be combined to create various backup strategies for SQL Server. Types of Backups in SQL Server Full Database Backup This is the classic method of performing a full backup, where all objects (including system objects) are included in the backup. Transactions (changes) that occur during… Read More »