This article will explain why and how you can easily move tables to new schemas if the need arisees.
tl;dr The title says it all. Prologue One of the keys to my personal learning is that, very early in my database career, I taught myself how to make lot’s of rows of Random Constrained Data in a comparatively short time. With the help of a few good folks over time, the method has been […]
In this article, we look at a sample use case of how you can create SQLCMD batch files that can be interactive and reused in different SQL Server environments.
SQL Server provides lots of information about various aspects of server and database objects and this data is referred to as metadata. Understanding what is available and how to use this metadata can greatly enhance and streamline how you can work with SQL Server.
Learn how to replace text in SQL Server strings using the REPLACE and TRANSLATE functions and how these could be used for data manipulation.
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 need for performance tuning your SQL Server workloads has never been more critical. As workloads are moved into cloud services, their efficiency has a direct impact on the recurring bills. A workload that consumes more resources than necessary costs more to host in the cloud and affects the bottom line for your organization.