Boost productivity with ‘Solution Summary’ cards
Solution Summary cards are the name I have given to simple 1-page documents we provide to developers to get up-to-speed on a particular solution. The primary use-case for these cards is to provide better on-boarding for new team members. An additional …
Implementing ETL Logging on Lakehouse using Delta Lake's Time Travel capability
The post Implementing ETL Logging on Lakehouse using Delta Lake's Time Travel capability appeared first on SQLServerCentral.
Working with T-SQL function AVG ()
This article will explain SQL Server average function, AVG(), and its use cases. Many times, we need to find the average value of numeric data stored in a column to address our distinct business requirements. SQL Server offers an aggregate function, AV …
Searching through a database via SQL
Imagine that while developing or testing a SQL Server database, you get an error message mentioning a database object, and you scratch your head, and mutter ‘by the bones of the saints, what is that?’. If it is a small database, then you ca …
[Video] Office Hours: Professional Development Questions
Most of the questions y’all post at https://pollgab.com/room/brento are technical ones, but there were a handful of interesting professional development and career ones in the queue, so I cherry-picked those for today’s episode: 00:00 Intro …
SQL Monitor: On-demand demo [Watch now]
The post SQL Monitor: On-demand demo [Watch now] appeared first on SQLServerCentral.
How to tell what SQL Server versions you are running
The post How to tell what SQL Server versions you are running appeared first on SQLServerCentral.
Is Remote Work the New Normal for DBAs?
An intriguing Office Hours question came in through my PollGab room. Anatoli asked, “Is remote work the new normal for DBAs? What are the pros / cons?” I happened to be teaching an online training class yesterday, so I asked my attendees wh …
Hybrid Cloud Monitoring
For years database server’s were hosted on either on-premises or colocation data centers. It was straightforward to walk down to the actual host where the server was located and see the blinking lights of the server. However, things started to ag …
Parameterizing Azure Policy and Ensuring Azure SQL AD Authentication
I wrote before about enforcing Azure SQL AD Authentication using Azure Policies in two different ways. First, only auditing if the Azure SQL is using AD Authentication or not. Later, automatically enabling the AD Authentication on Azure SQL Servers whe …
Now is the Right Time for the 2022 Brent Ozar Unlimited Scholarship Applications.
We normally do this in the fall, but given last week’s news, I bet you can understand why we’re doing this a little early, dear reader. You work at a charity or non-profit, helping them make a difference with data, fights for the rights of …
SQL Server Sample Databases
Northwind, Pubs, Aventureworks, AdventureworksDW, WideWordImporters, etc are important sample databases used in SQL Server. In this article, we will explain these databases and help you to find them, install them and understand them. Also, you will und …
SQL Database Snapshots for Reporting, Auditing and Data Recovery
The post SQL Database Snapshots for Reporting, Auditing and Data Recovery appeared first on SQLServerCentral.
I’m Coming Back to Israel for the Data.TLV Summit!
The Data.TLV Summit on September 15th is a big free conference on data engineering, business intelligence, data analysis, and … beer. I’m excited to announce that I’ll be back in Tel Aviv again for it, and this time I’m teaching …
Python Try Except Code Samples
The post Python Try Except Code Samples appeared first on SQLServerCentral.