The Change Failure Rate
The number of times that you have a failure when deploying changes is a good metric to watch.
The number of times that you have a failure when deploying changes is a good metric to watch.
Learn how to use bit manipulation functions: BIT_COUNT, GET_BIT, and SET_BIT in SQL Server 2022's. Learn practical examples and common errors to simplify binary data management.
How can I accurately find which SQL Server Stored Procedures, Views or Functions are using a specific text string, which can be a table name or any string that is part of the code?
I just saw one of "those" questions. You know the ones: 'We're hitting an error with a stored procedure. What is the maximum number of parameters you can have?" <sigh> Look, I get it. Breaking the land speed record is cool. Getting the most people into a phone booth (look it up), also cool. Fastest, […]
With SQL Server on Linux becoming more popular, Steve asks if you think you need to know much about that OS.
This article shows how to insert data into a database, create embeddings, and then use this data to search the data with a natural language interface.
Imagine a candle that is lit and takes 1 hour to burn out. Now imagine one hundred candles. How many hours will it last? That depends. If they are lit simultaneously, it will take 1 hour. That is the basic idea of running in the background or asynchronously. Of course, the 100 candles can execute independently of one another, unlike if you try to run 100 processes on a computer with 2 cores. PowerShell has some ways to manage that, as PowerShell job – which we will see in this article – runspaces – needs to add programmable using .net.
In this next article in the Data Engineering with Fabric series, learn the different ways to develop schemas inside of Fabric.
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
By alevyinroc
It seems like no matter how long you work with a system beyond a...
By Steve Jones
I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...
Code for mssql 2008 DECLARE @CompanyID TINYINT DECLARE @MemNo decimal DECLARE @MemberFrom Integer DECLARE...
I have an execute task(has server list from a table) pointing to foraeachloop foreachloop...
In the ss below you can see that I have a table (dbo.clan.spouses) with...
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex] FILE = N'thirdone' , FILE = N'thirdtwo' , FILEGROUP = N'second' TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak' WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GOSee possible answers