Changing the Paradigm of Work
AI is changing work, sometimes for the better, sometimes not. Steve continues to examine and evaluate how GenAI systems might be used in today's world and asks if there is work that might help you.
Stairway to Transaction Log Management in SQL Server, Level 3: Transaction Logs, Backup and Recovery
This article discusses the different types of backup and recovery models and gives the essential facts that will guide you to being able to achieve a recovery of a database to a point in time.
How to Load a Date Dimension in Microsoft Fabric using Macros in dbt?
With the popular data transformation tool dbt (data build tool), we have a bunch of interesting features at our disposal to write SQL more efficiently. One of those features is macros, which we’ll introduce in this article
How to Forecast Data in Power BI
Learn how you can use Power BI to forecase the future trends of data.
More Linux than Windows
Microsoft announced that Linux runs on more machines in Azure than Windows. Steve isn't surprised and thinks that Linux use will continue to grow.
Top 5 Power BI Common Pitfalls
What are some of the most common mistakes when working with Power BI? For example, when a junior colleague starts on a Power BI project for the first time, what are the pitfalls you try to warn them about? What advice would you give them?
Analyzing Tempdb Spills and Usage Across Recursive Queries
This article examines how tempdb is affected by recursive queries, using a few different methods.
Developer Time is More Valuable Than Ever
Today, Kendra Little talks about how DevOps adoption affects developer productivity and time.
Introduction to GitHub Actions Part 2: GitHub-hosted runners
In this article, you’ll learn about the many options for using a GitHub-hosted runner, including Docker.
Does Version Control Scare You
Steve finds a lot of people don't use version control and don't want to learn how to use it.
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