Learn how to effectively attach and detach databases in SQL Server, exploring the differences between these methods and traditional backup and restore procedures. Streamline your database management tasks with clear, step-by-step instructions.
2024-12-30
663 reads
This tip's objective is to present and describe several T-SQL examples for creating, using, and analyzing GUIDs and assessing their uniqueness.
2024-12-30
In the modern world, the companies are not solely dependent on a specific database server platform. There are many database platforms available that are adequate to handle moderate workload and client requirements of high availability and disaster recovery. MySQL is one of those database platforms which provides a lot of features and high performance. Just […]
2024-12-27
788 reads
A 16-year old SQL Server bug that means 'forced plans' have the query plan hash in place of the expected query hash. Includes an explanation and discussion of the term 'morally equivalent plan'.
2024-12-27
For my new mission, I set out to convert a list of files from Excel to comma-separated values (CSV). We upload the original Excel files to a Data Lake in Fabric. We then need to convert a specific worksheet and move the CSV files to a different folder in Data Lake.
2024-12-25
This article shows how to attach an MDF with or without a log file.
2024-12-23
3,017 reads
Over the past years, the tool dbt – short for data build tool – has become quite popular in the data engineering world for handling such an ELT process. dbt takes on the role of the “T”, meaning it’s responsible for transforming the data in a certain data store.
2024-12-23
How to create a connection for StreamLit and Snowflake to upload data for visualization
2024-12-20
1,873 reads
How we handle data warehousing updates to dimension tables is crucial and this article covers Slowly Changing Dimensions versus overwriting tables.
2024-12-20
Find your personal ROI in under 1 minute. And see how many working days you and your team could save in coding time with SQL Prompt!
2024-12-20
By Steve Jones
As we close out the year, I decided to drop this post here and...
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
I spend my days working on and managing SQL Server instances—working days at least,...
Hello, I currently have an instance of SQL Server 2019 Developer installed on my...
Comments posted to this topic are about the item How to Attach and Detach...
Comments posted to this topic are about the item What is Terraform?
What is Terraform (from Hashicorp) used for in technology?
See possible answers