Introduction Azure Storage is the service for storing different types of data. A storage account is created first. The storage account provides a unique namespace for different types of Azure storage data accessible from anywhere in the world over HTTP or HTTPS. Data in the Azure storage account is durable and highly available, secure, and […]
Are hackathons a good way to get a project started? It's not clear to Steve that open ended events are good.
The cloud migration tools and processes that will help you move a database to the cloud, from planning, implementation and validation through to extending existing development and deployment processes to the new cloud platform.
In this article we look at how to identify if SQL Server databases are not being used and a process to take these unused databases offline.
I've just finished up teaching at an in-person event, the first in fifteen months. It was the SQL Server and Azure SQL Conference (formerly known as SQLIntersection). The event organizers did a great job making it into a hybrid event, where we presented both in-person and virtually, so that people could choose if they wanted […]
Discover how to integrate features of Visual Studio and the SSIS Catalog for an efficient development and deployment environment.
The only way to derive meaning from the massive amounts of data collected today is to develop innovative high-performing, high-capacity storage solutions. In this book, Robert Sheldon explains the many types of storage currently available and what's on the way.
In this blog, David Yard at Kingston Technology shares his favorite SQL Monitor features and how they’re helping him to make sure their large SQL Server estate performs at its best.
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
If you’ve been watching AI roll through the data community and thinking, “this seems...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Comments posted to this topic are about the item Spending Time in the Office
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