SQL Server Severity Alerts: How to Set Up Proactive Error Notifications – SQLYARD Leave a Comment / Articles, Scripts / By SQLYARD SQL Server Severity Alerts: How to Set Up Proactive Error Notifications By SQLYARD · SQLYARD.com · Updated June 2026 · Estimated read: 18–22 min SQL Server 2005 and later · All editions Most […]
SQL Server Severity Alerts: How to Set Up Proactive Error Notifications Read More »
Microsoft Team Foundation Server (TFS) is a centralized server that allows developers to collaborate on software projects. TFS provides source control, work item tracking, and build management capabilities. It also includes a number of features that make it easier for developers to work together, such as team chat and collaboration tools. TFS is a popular
Microsoft Team Foundation Server Read More »
Microsoft GitHub is a web-based hosting service for software development projects that use the Git revision control system. It is owned by Microsoft, who acquired the company in 2018. GitHub offers both free and paid plans for private and public repositories. The platform has become increasingly popular in recent years, with over 40 million users
Microsoft Azure Cosmo Database is a cloud-based, globally distributed database service. It is Microsoft’s flagship database offering and is the successor to Azure SQL Database. It offers all the benefits of a relational database, including transaction support, scalability, security, and high availability. Microsoft Azure Cosmo Database also has some unique features that make it well
Microsoft Azure Cosmo Database Read More »
Microsoft Azure is Microsoft’s cloud computing platform. It is a comprehensive set of cloud services that developers and IT professionals can use to build, deploy, and manage applications through Microsoft-managed data centers. Azure provides both platforms as a service (PaaS) and infrastructure as a service (IaaS) services and supports many different programming languages, tools, and
Microsoft SQL Server Column Store Indexes are a type of index designed to improve query performance in data warehouses. In a traditional data warehouse, each row of data is stored in its own page. With column store indexes, data is stored in columns instead of pages. This allows the database to reduce the amount of
Microsoft SQL Server Column Store Indexes and Indexes Read More »
The Microsoft SQL Server error log is a critical component of the server that can help you troubleshoot and resolve problems. The error log contains information about what the server was doing when the error occurred, and it can be extremely helpful in troubleshooting. However, the error log can also be very large and unwieldy,
The Microsoft SQL Server error log Read More »
If a user is deleted from the Active Directory Domain that was used to authenticate them to SQL Server, then they become an orphan user in the SQL Server Database. So how can this be prevented? There are a few ways you can go about it. The first way is to use a group instead
What are Microsoft SQL Server Database orphan users? Read More »
SQL Server Data Classification: Discovery, Labeling, and Audit Integration | SQLYARD Leave a Comment / Articles, Security / By SQLYARD SQL Server Data Classification: Discovery, Labeling, and Audit Integration By SQLYARD · SQLYARD.com · Updated June 2026 · Estimated read: 10–13 min SQL Server 2012+ • SQL Server 2022 • SSMS 17.5+ SQL Server Data
SQL Server Data Classification: Discovery, Labeling, and Audit Integration Read More »
SQL Server Reporting Services: The Complete DBA Guide | SQLYARD Leave a Comment / Articles, Operations / By SQLYARD SQL Server Reporting Services: The Complete DBA Guide By SQLYARD · SQLYARD.com · Updated June 2026 · Estimated read: 16–20 min SQL Server 2016–2022 SSRS Native Mode SSRS roadmap change: SQL Server 2025. SSRS 2022 is
SQL Server Reporting Services: The Complete DBA Guide Read More »
SQL Server Agent: The Complete DBA Guide to Architecture, Configuration, and Automation | SQLYARD Leave a Comment / Articles, Operations / By SQLYARD SQL Server Agent: The Complete DBA Guide to Architecture, Configuration, and Automation By SQLYARD · SQLYARD.com · Updated June 2026 · Estimated read: 14–18 min SQL Server 2019 SQL Server 2022 SQL
SQL Server Agent: The Complete DBA Guide to Architecture, Configuration, and Automation Read More »
SQL Server Dynamic Data Masking: The Complete DBA Guide | SQLYARD Leave a Comment / Articles, Security / By SQLYARD SQL Server Dynamic Data Masking: The Complete DBA Guide By SQLYARD · SQLYARD.com · Updated June 2026 · Estimated read: 12–15 min SQL Server 2016+ SQL Server 2022 Azure SQL Dynamic Data Masking (DDM) is
SQL Server Dynamic Data Masking: The Complete DBA Guide Read More »
It is a high availability and disaster recovery solution that provides continuous data access. In order to achieve this, it employs a number of technologies including failover clustering, database mirroring, and log shipping. One of the benefits of using Microsoft SQL Server ALWAYS ON is that it can help to prevent data loss in the
What is Microsoft SQL Server ALWAYS ON? Read More »
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 »
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 »
