Different ways to Convert a SQL INT Value into a String Value
The post Different ways to Convert a SQL INT Value into a String Value appeared first on SQLServerCentral.
Monitoring Azure Blob Storage
Introduction In this article, we will learn how to monitor Azure Blob Storage. Azure monitoring provides powerful reporting and analytics insights. It helps you understand how your Azure Storage account performs by providing meaningful insights, alerts …
Here’s What I’m Teaching at the 2022 PASS Summit.
The lineup for the PASS Data Community Summit is out, and in addition to my pre-conference workshop on Mastering Parameter Sniffing, I’m also teaching two sessions: Everything You Know About Parallelism Is Wrong. Just because you see parallelism …
[Video] Office Hours Speed Round
In ten minutes, let’s cover as many questions as possible from https://pollgab.com/room/brento: Here’s what we raced through: 00:00 Introductions 00:17 dbacat: We’ve been fighting an AG issue for a while. Sometimes during failover, on …
Who’s Hiring in the Database Community? July 2022 Edition
Is your company hiring for a database position as of July 2022? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must inclu …
Why a leading bank with over 1,400 databases chose to think again about Redgate SQL Monitor
The post Why a leading bank with over 1,400 databases chose to think again about Redgate SQL Monitor appeared first on SQLServerCentral.
Columnstore Indexes are Finally Sorted in SQL Server 2022.
There’s a widespread misconception that SQL Server’s columnstore indexes are like an index on every column. I debunk that myth in the first 30 minutes of my Fundamentals of Columnstore class, where I explain that a better way to think of th …
What’s new in T-SQL in SQL Server 2022
There are many new features in SQL Server 2022. In relation to T-SQL querying, there are a few as well and they usually are left for last in face of many other new optimization features. Sample scenario These samples are built on the AdventureWorksDW20 …
How to Import and Export Connections from SQL Server Management Studio
The post How to Import and Export Connections from SQL Server Management Studio appeared first on SQLServerCentral.
Accelerating Digital Transformation: The role of DevOps and Data
The post Accelerating Digital Transformation: The role of DevOps and Data appeared first on SQLServerCentral.
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 …