The Complexity of Metrics
We need to monitor our servers, but individual metrics have more complexity than just setting simple limits for their readings.
The Database DevOps Transformation
Digital transformation is a buzzword that is often thrown about. But what isn’t discussed in depth, is how DevOps fits into the initiative and what the pitfalls are.
This on-demand session answers these questions and provides actionable takeaways from real-life database deployment automation projects.
You’ll also hear how the key trends in Database DevOps have influenced Flyway product development.
Nullable vs Non-Nullable Columns and Adding Not Null Without Downtime in PostgreSQL
In this article, we are going to talk about nullable and non-nullable columns specifically related to Postgres databases. While the reasons to use nullable or non-nullable columns may seem obvious at first, there are pitfalls associated with each decision that either affect development velocity, affect application performance, or cause downtime. Let's start with definitions. Nullable […]
The Senior Advantage
Being more senior in a role can be an advantage if you work at using your extra knowledge.
Extend your Power BI Reports with Analysis Services 2022 Data
This tip walks through the steps of how to combine data from SQL Server Analysis Services SSAS 2022 with other data using Power BI Desktop.
Testing Databases: What’s Required?
An overview of the challenges of database testing and test data management, reviewing the different types of database test that need to run during development work, what sort of test data they require, and how to manage all the required data sets, during development, in a way that allows rapid cycles of parallel testing.
The Data Fabric – Future of Data Management
This article provides an overview of Data Fabric and its components.
Ingesting Data from Google Drive to Azure Data Lake Gen2 using Azure Data Factory
Learn how to setup, configure and ingest data from Google Drive using Azure Data Factory in this step-by-step article.
Introducing the MySQL common table expression
As with many relational database management systems, MySQL provides a variety of methods for combining data in a data manipulation language (DML) statement. You can join multiple tables in a single query or add subqueries that pull data in from other tables.
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers