Basic Git for DBAs: Getting Started with Git
Learn the basics of Git in this article if you've never used this version control system before. We will cover setting up a repo, adding files, changing them, and getting your history.
Stairway to Advanced T-SQL Level 11: Using Logical Operators
SQL Server supports a number of different logical operators. These operators can be used for testing Boolean conditions that return true, false and unknown in your T-SQL code. Logical operators are useful for defining constraints to limit the rows be processed when selecting or updating data. This chapter will provide an overview of the logical […]
Using T-SQL over PoSh
When do you choose to use one tool or language over another. Steve discussed T-SQL vs. PowerShell.
CASE STUDY: The hybrid monitoring needs of a fast-growing global business
With ambitious expansion plans, PointsBet needed an expansive overview of its server estate, whether on Azure or on-premises, anywhere around the world. Find out how SQL Monitor rose to the challenge.
How to get length of Text, NText and Image columns in SQL Server
There is sometimes a need to figure out the maximum space that is being used by a particular column in your database. You would initially think that the LEN() function would allow you to do this, but this function does not work on Text, NText or Image data types, so how do you figure out the length of a value in a column that has one of these data types?
A Third Space
We used to work in offices, now we work at home. Do we need a third space? Steve does.
Incremental Data loading through ADF using Change Tracking
Learn how you can use Change Tracking to incrementally load data with Azure Data Factory
SQL Server Graph Tables – Cross Database Surprises
Louis Davidson explains how to get around an interesting issue when doing cross-database queries involving graph database tables.
Webinar | Kick start your DevOps Initiative
Without someone on your team experienced at putting DevOps into practice, it can be difficult to know how to get started. Join Microsoft Data Platform MVP, and AWS Community Builder Grant Fritchey to discover his top tips on how to kick start DevOps in your organization.
Constant Azure Improvement
This week I noticed a number of changes in the Azure platform from their change feed. Actually, every week has a crazy number of changes across the entire platform, but this week a number of these were related to data and databases. That isn't always the case, but I saw some interesting items. We have […]
Blogs
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat kantor BCA KCU WISMA ASIA Telp:0818751777
WhatsApp:0818-751-777 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu Sel., Kec....
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers