Microsoft SQL Server is a popular database system used by many businesses. As with any database, it is important to take steps to secure the data stored in SQL Server. There are a number of best practices that can help to improve security, including using strong passwords, encrypting data, and creating backups. Using strong passwords […]
Microsoft SQL Server Security Read More »
It is a component that provides messaging and queuing capabilities for databases. Service Broker helps to build asynchronous, decoupled applications in which independent components communicate with each other by sending and receiving messages. This communication is facilitated by a queue, which stores messages until they are processed by the intended recipient. Service Broker provides a
What is Microsoft SQL Service Broker? Read More »
It is a cloud-based data integration service that allows you to create data-driven workflows to orchestrate and automate data movement and data transformation.With Data Factory, you can use the Azure portal to visually design and monitor your data pipelines.It also provides the following benefits: Microsoft SQL AZURE Data Factory provides a flexible platform that helps
Microsoft AZURE Data Factory Read More »
Microsoft SQL Azure Data Lake is a cloud-based data storage and processing service that is part of the Azure cloud platform. It is designed to handle large amounts of data quickly and efficiently and can be used for a variety of tasks such as data warehousing, analytics, and machine learning. SQL Azure Data Lake is
Microsoft SQL Azure Data Lake Read More »
SQL Server Analysis Services: The Complete DBA Guide | SQLYARD Leave a Comment / Articles, Cloud and Azure / By SQLYARD SQL Server Analysis Services: The Complete DBA Guide By SQLYARD · SQLYARD.com · Updated June 2026 · Estimated read: 14–18 min SQL Server 2019 SQL Server 2022 SQL Server 2025 SQL Server Analysis Services
SQL Server Analysis Services: The Complete DBA Guide Read More »
Microsoft’s Powershell is a versatile tool that can be used for a wide range of tasks, from simple administration to complex automation. One of the most powerful features of Powershell is its ability to work with SQL Server. With just a few commands, Powershell can help you manage your databases, automate backups, and even troubleshoot
Microsoft’s Powershell Read More »
It is a cloud-based relational database service that is based on the latest edition of the Microsoft SQL Server Database Engine. It is also known as Azure SQL Database. It offers all the benefits of a managed relational cloud database, including high availability, security, scalability, and performance. Additionally, it offers patching and updating for the
What is a Microsoft Azure database? Read More »
Microsoft SQL Server data virtualization with PolyBase enables you to access data stored in Hadoop Distributed File System (HDFS) or Azure blob storage without moving or copying the data. With PolyBase, you can query and join data from Microsoft SQL Server and Hadoop by using the Microsoft SQL Server Transact-SQL language. You can also use
Microsoft SQL Server data virtualization with PolyBase Read More »
SSIS Catalog Object parameter information script The first query is filtered out for information and the second query is a select * gets you all and you can change to your needs USE SSISDB SELECT pr.name AS [ProjectName], pr.description AS [ProjectDescription], pr.last_deployed_time AS [ProjectLastValidated], pr.validation_status AS [ProjectValidationStatus], op.object_name AS [PackageName], op.design_default_value AS [DefaultConnectionString],pr.deployed_by_nameFROM [internal].[object_parameters] opINNER
SSIS Catalog Object parameter information script Read More »
Steps to rename a database ( Few ways to do this, this is how I achieve this) Step 1 get the logical and physical name SELECT file_id, name as [logical_file_name], physical_nameFROM sys.database_files Step 2–Disconnect all existing sessions.USE [master];GOALTER DATABASE SET SINGLE_USER WITH ROLLBACK IMMEDIATEGO –Change database into OFFLINE mode.ALTER DATABASE SET OFFLINE –Step 3–Log in
Steps to rename a database in SQL Server Read More »
USE [msdb]GO/*Create a trigger to send a notification on a status change */SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO Create TRIGGER [dbo].[sqlagentjobstatuschange]ON [dbo].[sysjobs]FOR UPDATE AS SET NOCOUNT ON; –** Declare variablesDECLARE @username VARCHAR(50),@hostName VARCHAR(50),@jobName VARCHAR(100),@newEnabled INT,@oldEnabled INT,@jobCreated INT,@bodyText VARCHAR(200),@subjectText VARCHAR(200),@servername VARCHAR(50),@profileName VARCHAR(50) = ‘Add Profile’,@recipients VARCHAR(500) = ‘Add email Address’ –** Set Variables SELECT @username = SYSTEM_USERSELECT
Create a trigger on SQL Agent job status change. Read More »
select * FROM [SSISDB].[internal].[packages] — Get Project ID and Name DELETE from [SSISDB].[internal].[packages] where project_id=and name like ‘%name.dtsx%’ — Change the Name you want to delete
SSIS Catalog-How to remove a single SSIS package without redeploying the entire project. Read More »
Get-WmiObject Win32_logicaldisk -ComputerName ADD Your Server Name ` | Format-Table DeviceID, ` @{Name=”Drive Size(GB)”;Expression={[decimal](“{0:N0}” -f($_.size/1gb))}}, ` @{Name=”Drive Free Space(GB)”;Expression={[decimal](“{0:N0}” -f($_.freespace/1gb))}}, ` @{Name=”Drive Free pct”;Expression={“{0,6:P0}” -f(($_.freespace/1gb) / ($_.size/1gb))}} ` -AutoSize
Get drive letter (Device ID), Drive size, drive free space and drive free space % Read More »
The SQL Server (DAC) was created if you are having critical performance issues. The (DAC) can help you research the issue. The (DAC) connects to a separate port by default 1434. The (DAC) port is assigned dynamically by the SQL Server at startup. The SQL Server Browser service also needs to be started. Once the
What is SQL Server Dedicated Admin Connection also known as the (DAC) Read More »
SQL server has become one of the most powerful database tools to use in the industry. Many of its functions are exceptional in terms of protecting your data, including the SQL Server Transaction Log backups, truncating, and shrink operations. This article looks at this operation, providing some examples to further explain the processes. To get
How SQL Server Transaction Log Backup, Truncate and Shrink Functions Operate Read More »
Use this script to change the database owner to sa. This script will generate the syntax for each database not having sa as the owner. 1 to many depending on your environment. TSQL to review what the database owner is of each database select db.name as [Database Name],sp.name [SQL Login Name] from sys.databases db left
We can use this script to get the current drive space on the server. By default this takes the current server name, you can also set the server name as well. By default, xp_cmdshell is turned off. We will enable this and run the script then turn it back off. sp_configure ‘show advanced options’, 1goReconfigure
Check Drive Space with T-SQL and PowerShell Read More »
SQL Server Morning Health Check: The Complete Daily DBA Checklist – SQLYARD Leave a Comment / Articles, Operations, Scripts and Tools / By SQLYARD SQL Server Morning Health Check: The Complete Daily DBA Checklist By SQLYARD · SQLYARD.com · Updated August 2026 · Estimated read: 18–22 min SQL Server 2016 and Later · All Editions
SQL Server Morning Health Check: The Complete Daily DBA Checklist Read More »
