Your Biggest Data Model Complaints
Today Steve asks which data model issues are most annoying to you.
SQL Server Backup or Restore using Network Share with SSMS
In this article, we look at how to create a SQL backup to network share or restore a backup from a network share.
Why Not Use AI?
Steve re-posts a question from someone else, asking why you wouldn't want to use an AI.
Why use Tally Tables in the Fabric Warehouse? Data Engineering in Fabric
This next article in the Data Engineering with Fabric series showcases how tally tables can help load data in a Fabric warehouse.
Engineering a Lakehouse with Azure Databricks with Spark Dataframes
How can we get familiar with Azure Databricks with Spark Dataframes?
How to use the Azure Emulator to create blob containers, queues and tables
Learn how to emulate Azure storage for files, blogs, and queues.
What If You Need to Index a Lot of Duplicate Data?
Let’s get a little nerdy and look at database internals.
Triggers
Triggers. Who doesn’t like a good, lively debate about triggers? With the extreme cold that we’ve experienced this past week in the northeastern U.S., I feel like a little heated debate wouldn’t be a bad way to forget about the cold. But alas, I’m not here to talk about database triggers. Sorry, we’ll have to […]
Configuring Maintenance Plans in SQL Server
See a walkthrough of setting up a maintenance plan in SQL Server.
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers