SQL Server management, tutorials, scripts, coding, programming and tips for database administrators

MS SQL

Microsoft SQL Server: Current Identify Column Value in a Table 04/11/2019

Learn how to find the current identify column value in your Microsoft SQL Server tables.

Compressed Microsoft SQL Server Backups by Default 04/08/2019

Learn how to create default database compression for your SQL Server databases.

Configuring Azure SQL Databases Using Azure Resource Manager Templates 03/27/2019

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.

Creating CRUD Stored Procedures in SQL 03/13/2019

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.

Shrinking SQL Server Backup Files and Speeding Up Backups 03/08/2019

With backup compression you can speed up our backups, while making your backups smaller.

When Will My SQL Server Online Resumable Index Rebuild or Create Operation Complete? 03/05/2019

Using Azure Resource Manager Templates To Provision Azure SQL Databases 02/21/2019

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.

New Truncation Error Message in SQL Server 2019 02/07/2019

A new error message in SQL Server 2019 will make your life much easier!? Learn more...

Getting Approximate Count in Microsoft SQL Server 02/04/2019

Sometimes performance is more important than exact accuracy. Learn how to get an approximate count in SQL Server with better performance.

Top 10 Databases for 2019 01/31/2019

A look at ten top databases fighting for mind-share in 2019.

Overview of Azure SQL Database Performance Monitoring 01/08/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.

Customizing the Default Azure Data Studio Dashboards 01/03/2019

Explore the Azure Data Studio dashboards and see how to customize one of these dashboards to include a new widget.

New Preview of SQL Server Management Studio Available for Download 12/06/2018

On September 24^th Microsoft released the first Community Technical Preview for SQL Server 2019, which was CTP2.0. At the same time Microsoft pushed out a new preview for SQL Server Management Studio (SSMS) known as version 18. Now is the time to download this new preview!

SQL Server 2019 Community Technical Preview (CTP) 2.1 is Available Now 12/03/2018

Microsoft announced the release or CTP 2.1 for SQL Server 2019. This is the second CTP released for SQL Server 2019, and it has lots of new exciting features, like " UDF inlining". Read on to find out more!

Overview of Azure SQL Database Information Protection 11/01/2018

Information protection becomes one of the dominant factors that drive modern database design and implementation. This becomes particularly evident when operating in a cloud computing environment, with Azure SQL Database serving as one of the prime examples of this trend. Microsoft delivers relevant features by leveraging several different security-related Azure services. In this article, we will provide an overview of this functionality.