The 3rd edition of the ebook SQL Server Execution Plans
From Redgate website you can download (for free) the ebook SQL Server Execution Plans written by Grant Fritchey and technically reviewed by Hugo Kornelis.This ebook can not be miss in your digital library!Enjoy!
SQL Server Diagnostic Information Queries for October 2018
This month, I have just made some minor improvements to most of the query sets. I have a T-SQL script that you can use to check whether your instance of SQL Server has been patched to mitigate against the Spectre/Meltdown CPU vulnerability. This works …
Batch Mode For Row Store: What Does It Help With?
SQL Server 2019 Introduces something pretty cool: the ability for row store indexes to be processed in batch mode. Batch mode is, of course, the preferred processing realm of column store indexes. If you’re still in the dark about column store, y …
Generate HTML Formatted Email of SQL Server Database Consistency Check Errors
In this tip we look at to create a SQL Server DBCC CHECKDB errors email formatted in an HTML table. This will report any errors for all of your databases on the server.
Basic Administration Tasks – Level 5 of the Stairway to for Azure SQL Database
In this next level, learn how to accomplish a few simple administration tasks that may help you manage your Azure SQL Database.
Free eBook: SQL Server Backup and Restore
In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSM …
SQL SERVER – How to Get List of SQL Server Instances Installed on a Machine Via T-SQL?
Earlier last year, I had posted a very interesting blog post which still today gets quite a lots of interest is SQL SERVER – How to Get List of SQL Server Instances Installed on a Machine?. In the recent Comprehensive Database Performance Health …
How to See Execution Plans in Azure Data Studio
Azure Data Studio is Microsoft’s cross-platform tool for T-SQL developers. It’s still relatively young, so it has some missing areas of functionality. When you run DMV queries to look at query plans, they show up as XML, which isn’t v …
You probably didn’t go to a training class this year. Again.
“Can someone just give me a tl;dr?” The year is drawing to a close, and you didn’t go to a training class. Again. Your skills aren’t keeping up. You keep bookmarking blog posts about new database stuff, interesting scripts you w …
Posting SQL Server notifications to Slack
Learn how you can post notifications from SQL Server directly to a Slack channel.
Scheduling SQL Server Tasks on Linux
In this tip we look at how to schedule SQL Server tasks on Linux servers using Cron.
Highlighting Personally Identifiable Information (PII) across SQL Server instances and databases
With the recent regulatory pressures such as GDPR, being able to know what type of data we are holding onto within our business became a bigger challenge. At Redgate, we have been exploring ways to make this easier for our heavy SQL Server users and el …
SQL SERVER – How to DROP Multiple Tables Using Single DROP Statement?
In my earlier post, SQL SERVER – How to DELETE Multiple Table Together Via SQL Server Management Studio (SSMS)? I showed you how to DROP Statement multiple tables together using a wizard in SQL Server Management Studio (SSMS). Lots of develo …
New class: Immersion Event on Azure SQL Database, Azure VMs, and Azure Managed Instance
Tim’s been working closely with the development team on Azure Managed Instance, presented with them at Ignite recently, and has been presenting internally at Microsoft field offices to their clients, as well as working with our own clients extens …
Announcing The Team Membership
You have a team of database developers and DBAs – SQL Server professionals who want dedicated help. You want a predictable bill that includes training, mentoring, consulting meetings, and career growth. In The Team Membership, you get: Live …