Managing Fabric Lakehouse objects with the new CLI: Data Engineering with Fabric
In this next article, we are going to explore how to install, configure and use the command line to manage a couple different Fabric Lakehouse’s.
Purging Data from a Large Table in SQL Server
Purging data from a table is a common database maintenance task to prevent it from growing too large or to stay in compliance with data retention. When dealing with small amounts of data, this can be accomplished by a simple delete with no issues; however, with larger tables, this task can be problematic. Deleting records requires a lock that can block other processes from writing or even reading the data (depending on your isolation level). In this article I will share a technique I have used to work with some very large tables.
Helping Students with a Data Professional Career
Steve has advice for students looking to become data professionals.
DMV Comparison for SQL Server 2019 vs Azure SQL Database
What DMVs were added to Azure SQL Databases, and which DMVs are missing from Azure SQL Databases but still exist on SQL Server 2019 or other versions?
Deleting a Database
Who among us hasn't deleted a production data file? Steve hopes most of us have not.
Sentiment Analysis & Key Phrase Detection
Learn how you can conduct a sentiment analysis on data loaded into an Excel spreadsheet.
Power BI Mistakes to Avoid – Part 2
What advice would you give to someone new to Power BI? What are common Power BI mistakes to avoid? In this article, we will discuss several Power BI mistakes to avoid to help you navigate this powerful tool effectively.
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.
Blogs
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...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
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