Enhancing SQL Server Searches with Elasticsearch and Python
Learn how to get started with Elasticsearch with data in your SQL Server database.
Learn how to get started with Elasticsearch with data in your SQL Server database.
Steve has a few thoughts on how AIs change the role of databases.
Create an SQL Server backup for an Azure Managed Instance that you can download and restore on another SQL Server instance.
In Azure SQL Database serverless edition, we get an upgrade to our configuration.
Freshly minted MCM Wayne Sheffield fills a log shipping crack that could otherwise cause you to re-initialize your log shipping.
The executives at CrowdStrike testify before the US Congress, noting their software development process needs work.
Companies of all sizes and across industries are struggling to cope with an explosion of data never before seen in the short history of computing. As applications reach new levels of sophistication and become deeply interconnected, these companies find themselves increasingly overworked, overheated, and at their wits’ end, desperately trying to squeeze just a bit more performance and availability out of their aging database architectures.
You heard it here first, PASS Data Community Summit will return to Seattle next year! Save the date, as PASS Summit will take place in person at Summit, Seattle Convention Center, from November 17-21, 2025!
How simple should software development be? Steve notes it can be simple, but not too simple.
In this first level of the Stairway to Synapse Analytics, we learn how to set up a new workspace and add data files.
By Patrick
SQL Server Audit is an efficient way to track and log events that occur...
I presented at SQL Saturday Pittshburgh this past weekend about populating your data warehouse...
By Steve Jones
A customer was asking recently about the RPO for their estate, and I showed...
hi, we just decided to change over to a tab delimited format in a...
Hi everyone, I have a table as below, I would like to strip out...
From this link - https://stackoverflow.com/questions/22005698/how-to-find-all-the-dependencies-of-a-table-in-sql-server I can find all the child dependencies starting from my...
CREATE TABLE t0 ( id INT PRIMARY KEY , field1 VARCHAR(1000) , field2 VARCHAR(MAX)); INSERT INTO t0 SELECT gs.value , REPLICATE ('X', 1000) , REPLICATE ('Y', 1000) FROM generate_series(1, 10, 1) gs; GO
select STRING_AGG(field1, ';') within group (order by id) from t0;
select STRING_AGG(field2, ';') within group (order by id) from t0;