Armed with a schema comparison engine and an object-level directory of the source for every recent version of the database, you'll be able to remove a lot of the uncertainty around merging database changes back into development.
2023-05-12
Many businesses are hesitant to adopt cloud technology due to security, cost, and complexity concerns. This can make it challenging for organizations to sell the benefits, leading to missed opportunities. Learn about different techniques to help sell cloud technology in your organization.
2023-05-12
This article explains different methods to move a SQL database into a new directory of Ubuntu Linux. This article covers the following topics. How to install SQL Server 2022 on Ubuntu Linux. How to add a new drive in Linux. Attach the StackOverflow database using the database. Install SQL Server 2022 on Ubuntu I have […]
2023-05-10
1,978 reads
I often perform code reviews and thought it would be fun to frame this exercise: a completely fictitious stored procedure hits my desk, I’ll reject it of course, and enumerate the reasons why.
2023-05-10
In 2023, connect, share & learn with like-minded peers, speakers, and industry leaders during the full week of data celebrations. Summit happens in person, from November 14th to 17th in Seattle. Check out the blog post to learn more.
2023-05-10
The tip, Views in SQL Server, explored the purpose of views, creating views examples, and benefits of views. A view is a virtual table that references the actual database tables stored in the database. What if someone changes the underlying table structure, such as renaming the column, adding a new column, or dropping the table? What is the impact of changing schema on views? How can we stop any schema changes if the view references the schema?
2023-05-08
Redgate’s new DevOps test data management tool, Redgate Clone, provisions production-like data in seconds for SQL Server, PostgreSQL, MySQL and Oracle databases.
2023-05-08
This article will cover exporting data from a PostgreSQL table to a CSV file, both from the command line and pgAdmin. We will also look at importing data from a CSV file.
2023-05-05
1,802 reads
This SQL cheat sheet contains a series of scripts to help address common situations that might be brought to a Microsoft SQL Server DBA. Each has a proper explanation as to what it does and how it works.
2023-05-05
This article outlines the syntax of the three and four dot references that usually denote external database references, demonstrates how to find them either from a live database or by using a text search of a script, and explains some of the complicating factors that can lead to 'false positives'.
2023-05-05
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
By Kevin3NF
Parts 1, 2 and 3 got you to the (SQL) engine room. Now we...
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Comments posted to this topic are about the item Vector Datatype Dimensions
Immediate need for a hands-on SQL Server DBA. This is a greenfield opportunity to...
The new vector datatype in SQL Server 2025 requires a number dimension parameter. What is the maximum number of dimensions supported?
See possible answers