A Self-Serve System to Refresh Databases (Part 3)
This is the wrap up of this series on a system for developers to restore production database in test. It gets pretty detailed on the web setup side.
Overview of Azure Cosmos DB
Cosmos DB is Microsoft’s highly scalable, NoSQL database platform running in Azure. It supports four API models, including Key-Value pair and Documents. Pushpa Sekhara provides an overview of Cosmos DB, including some best practices to improve performance.
Microsoft and Minecraft and Training Kids
Today we have a guest editorial from Andy Warren, looking at learning.
Types of SQL Server Temporary Tables
In this series of tips we will look at different ways using temporary data in SQL Server along with examples. In this first part we will cover some reasons for doing this and different types of temporary data stores.
Where Do You End Up as a DBA?
Steve Jones talks about careers, and where you might take your career over time.
Importing Data into Azure SQL Database
Data imports represent some of the more commonly performed database management tasks. Learn about a number of traditional SQL Server data import techniques that you can leverage when importing data into Azure SQL Database.
Communicate Smarter Not More
After installing Microsoft Teams, Steve has a bit of communication overload.
Join DBAle’s data privacy competition!
Got a favorite story of unusual, unique, or inspired attempts at data privacy. We'd love to hear them on DBAle's data privacy contest. Share your story for the chance to win a box of beer and the glory of getting your name on DBAle
Using the FILTER Function in DAX
In the previous article of this series, Andy Brown of Wise Owl Training explained how to use the oh-so-important CALCULATE function in DAX to make changes to the default filter context within a formula. This article shows how you can use the FILTER function to do something similar and explains the differences between the two approaches.
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
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
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