SQL Server management, tutorials, scripts, coding, programming and tips for database administrators
Learn how to remove gaps in Identity values in SQL Server caused by Identity Cache.
Have you deleted a bunch of rows from a table that has an identity column value and now thins aren't working quite right? If so, read on...
Cosmos DB delivers a wide range of advantages over traditional SQL and NoSQL-based data stores, including support for multiple consistency levels, latency and throughput guarantees, policy-based geo-fencing, automatic scaling, and multi-master replication model. However, it is a significant departure from the traditional database management and development approach that most database administrators are familiar with. Discover the offerings that you can use at no cost to gain hands-on experience with Cosmos DB.
Data imports represent some of the more commonly performed database management tasks. Learn about a number of traditional SQL Server data import techniques that you can leverage when importing data into Azure SQL Database.
Learn how to find the current identity column value in your Microsoft SQL Server tables.
Learn how to create default database compression for your SQL Server databases.
Template-based provisioning simplifies deployment and promotes principles of DevOps and Infrastructure as Code, making it the recommended method for implementing cloud-based services. However, its benefits extend beyond initial implementation, since you can apply it to configuring and maintaining existing Azure SQL Database instances. In this article, you explore an example of this approach.
Back to the basics: learn how to Create, Read, Update and Delete operations are pivotal for any database application. Plus, you’ll see how to use Stored Procedures to manipulate data on the database side instead of on the application side.
With backup compression you can speed up our backups, while making your backups smaller.
Azure provides a number of different methods that can be used in order to implement and configure its resources. Each of the methods differs to some extent in regard to functionality and intended use cases.
A new error message in SQL Server 2019 will make your life much easier!? Learn more...
Sometimes performance is more important than exact accuracy. Learn how to get an approximate count in SQL Server with better performance.
A look at ten top databases fighting for mind-share in 2019.
Transitioning to the Platform-as-a-Service model typically implies relinquishing certain degree of control over your computing environment. One of the primary concerns related to this transition is diminished level of transparency providing insights into performance of cloud-resident workloads. Fortunately, with Azure SQL Database, you have a wide range of options that address this concern, allowing you to identify and remediate overwhelming majority of performance-related issues.
MS SQL Archives