Truncate tables where Referential Integrity exists
This script can be useful in test and dev environments to quickly clear tables via the truncate command where referential integrity exists.
2024-05-02
62 reads
This script can be useful in test and dev environments to quickly clear tables via the truncate command where referential integrity exists.
2024-05-02
62 reads
Mistral 7B is the first foundation model from Mistral AI, supporting English text generation tasks with natural coding capabilities.
2024-04-03 (first published: 2024-03-21)
225 reads
Salesforce runs batch jobs in its server which takes resources and time and creates a burden on the overall server. Hence often times there is a need for a mechanism to call Salesforce system from external system. Calling salesforce from external system results in less burden on the salesforce server and faster processing. By leveraging […]
2024-03-21 (first published: 2024-03-19)
43 reads
Any user who has a backend in AWS can leverage python to query the database and generate insights on the data by leveraging bedrock and langchain library
2024-03-21
216 reads
In this script we will leverage the capabilities of Amazon Bedrock's Generative AI service to author SQL statements.
2024-02-03
282 reads
I created this stored procedure to be able to run SSRS subscriptions using T-SQL code instead of adding a component in the SSIS package with the subscription id. Let's say we have a set of report subscriptions named like this: ClientReport1, ClientReport2, ClientReport3. To run them using the stored procedure, all we need is this […]
2023-11-29 (first published: 2023-11-21)
648 reads
To move a table into a schema in T-SQL, you can use the ALTER SCHEMA statement along with the TRANSFER option. Here are the steps to do this: Assuming you have an existing schema named "NewSchema" and a table named "YourTable" that you want to move into this schema: Open SQL Server Management Studio or […]
2023-09-29 (first published: 2023-09-18)
1,216 reads
Csv files must frequently be joined. It would be fantastic if we could connect CSV files using the power of SQL. This script accomplishes that.
2023-09-18 (first published: 2023-08-28)
1,474 reads
Very often there is a need to create test data manually. This script will provide a mix of names that will make more sense rather than randomly generating meaningless names.
2023-09-11 (first published: 2023-08-24)
590 reads
This script creates an external table in Synapse.
2023-08-21 (first published: 2023-07-26)
780 reads
By HeyMo0sh
Test Data Management (TDM) is essential in software development to ensure your application runs...
By Rohit Garg
Introduction Full-Text Search in SQL Server is a feature that provides linguistic search capabilities...
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday. As a start,...
Greetings, I need to transform data returned in a query from several tables as...
Hi Replication and publisher configured on the same sql server 2022 version. Subscription to...
Hello, I am trying to firgure out how to merge duplicate indexes using a...
If I want to enable a trace flag for a specific query, how do I do it?
See possible answers