This article examines some basic database design principles that help ensure your queries can execute more quickly.
The post How to Improve Database Design to Speed Up SQL Queries appeared first on SQLServerCentral.

Sometimes people say to avoid the snowflake schema and stick to a clean star schema. Why is that? Is something wrong with creating a snowflake schema?
The post Star Schema vs Snowflake Schema Considerations appeared first on SQLServerCentral.

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.
The post Understanding how to Successfully Sell the Cloud appeared first on SQLServerCentral.

Learn a number of methods to view or programmatically get the SQL Server instance startup time.
The post How to Find the SQL Server Instance Startup Time appeared first on SQLServerCentral.

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.
The post Database Branching and Merging without the Tears appeared first on SQLServerCentral.

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 […]
The post How to Create a SQL Database on a New Drive in Ubuntu appeared first on SQLServerCentral.

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.
The post PASS Data Community Summit registrations are open! appeared first on SQLServerCentral.

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.
The post Find 40 Problems in this SQL Server Stored Procedure appeared first on SQLServerCentral.