Power BI Anomaly Detection
The post Power BI Anomaly Detection appeared first on SQLServerCentral.
Redgate Tool Tips
The post Redgate Tool Tips appeared first on SQLServerCentral.
Pop Quiz: What Do These Things Cost Today?
Price check on Aisle 2021. My main consulting job is a 2-day SQL Critical Care® where I help turn around slow SQL Servers. Companies come to me because they’re not sure if it’s a hardware problem, a database configuration issue, bad app …
Moving from application automation to true DevOps by including the database
The post Moving from application automation to true DevOps by including the database appeared first on SQLServerCentral.
Restoring Master on a Windows 2019 / SQL Server 2019 Cluster
It doesn’t happen often you have to recover systems databases in SQL Server. Most articles cover restoring a master database on a local instance, if you’re lucky for a named instance, but most do not cover a clustered instance. As with ever …
Five facts about the SQL Server Model Database
The post Five facts about the SQL Server Model Database appeared first on SQLServerCentral.
PowerShell editors and environments part 2
The post PowerShell editors and environments part 2 appeared first on SQLServerCentral.
Never, Ever, Ever Start T-SQL Comments with Two Dashes
There are two ways you can write comments in T-SQL:–By starting a line with two dashes, or /* By framing it on both sides like this */ Never, ever use two dashes. Never. The problem is that monitoring tools and diagnostic management views often d …
3 steps to get started with Database DevOps
The post 3 steps to get started with Database DevOps appeared first on SQLServerCentral.
Reading Stored Procedure Output Parameters in Azure Data Factory
To facilitate native SQL code we have stored procedure support in Azure Data Factory (ADF). When we work with stored procedures, mostly we use input parameters, however, a stored procedure can also have output parameters. In this case, we need to deal …
Cherry-picking Migrations using Flyway
The post Cherry-picking Migrations using Flyway appeared first on SQLServerCentral.
Query Audit data in Azure SQL Database using Kusto Query Language (KQL)
The post Query Audit data in Azure SQL Database using Kusto Query Language (KQL) appeared first on SQLServerCentral.
Automating Migrations for Multiple Databases using Flyway
The post Automating Migrations for Multiple Databases using Flyway appeared first on SQLServerCentral.
Exploring Four Simple Time Series Forecasting Methods with R Examples
The post Exploring Four Simple Time Series Forecasting Methods with R Examples appeared first on SQLServerCentral.
SQL Server Security – Fixed server and database roles
Managing Security for SQL Server is extremely important. As a DBA or security administrator, you need to provide access for logins and database users to resources within SQL Server. SQL Server has both server and database resources where access might n …