[Video] Office Hours: Morning in Mexico Edition
Got SQL Server questions? Post ’em at https://pollgab.com/room/brento and upvote the questions you’d like to see me discuss. Here’s what we covered this morning: 00:00 Introductions 00:45 SQL Simian: Everybody loves free advice, but w …
Prevent Accidental Resource Deletion Using Locks in Azure Data Factory
Introduction While working in Azure Data Factory a user can delete a resource unknowingly. We can implement Azure Locks to prevent this accidental resource deletion. You can create your own custom roles to give users read-only access to the Azure Data …
The basic T-SQL SELECT statement
The post The basic T-SQL SELECT statement appeared first on SQLServerCentral.
Summit 2022 Call for Speakers Now Open
The post Summit 2022 Call for Speakers Now Open appeared first on SQLServerCentral.
Announcing Quest Database Training Days 2022
Wanna learn for free? On April 13, I’m doing a session called My Cloud Database Costs are Too High. You’ve moved to the cloud, and now management is asking questions about your monthly bills. They’ve asked you to cut costs. Now what? …
New Lower Prices on My Mastering Class Recordings and End-of-Year Live Class Season Pass
If you’ve been watching my Instagram feed or any of my recent Office Hours videos, you’ve noticed that I’ve moved down to Cabo San Lucas, Mexico. I’m absolutely loving it, having a great time watching whales, sitting on the …
DBAs and DevOps: A match made in heaven?
The post DBAs and DevOps: A match made in heaven? appeared first on SQLServerCentral.
What’s new in SQL Monitor? Tagging and Current Activity Page (minor release v12.1)
The post What’s new in SQL Monitor? Tagging and Current Activity Page (minor release v12.1) appeared first on SQLServerCentral.
Query History and Server Reports in Azure Data Studio
Introduction Query history and server reports are two popular extensions in Azure Data Studio. In this article, we will cover these extensions. Firstly, the Query History extension allows having the history of the queries executed. Secondly, the Server …
Populate a SQL Server column with a sequential number not using an identity
The post Populate a SQL Server column with a sequential number not using an identity appeared first on SQLServerCentral.
Exploring Knowledge Center in Azure Synapse Analytics
Introduction Azure Synapse Analytics is an enterprise analytics service that brings together popular data warehouse technologies and big data systems together. It provides SQL for enterprise data warehousing, Spark technologies for big data, Data explo …
SQL Prompt ALT S Magic
The post SQL Prompt ALT S Magic appeared first on SQLServerCentral.
SQLBits 2022 Day 1 Keynote
Conferences are back, baby! I’m in London for SQLBits 2022, the biggest Microsoft data conference in Europe. This year’s theme is classic video games, and it’s been really cool to see the 8-bit logos and games all over the ExCel Cente …
The Curious Case of… random failing log shipping restores
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …
[Video] Office Hours: Cabo Home Studio Edition
Got questions about SQL Server? Post them at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. This episode was the first live one I shot in my home studio in Cabo: Here’s what we covered: 00:00 Introductions 0 …