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 …
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 …
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.
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 …
Thank you, #sqlfamily, for donating to The Trevor Project.
A couple of weeks ago, we told you about how Andy Mallon’s LGBTQ Meetup was raising money for The Trevor Project, and how we’d match up to $5,000 of your donations. This weekend, you did it. You hit the $5,000 mark. I’m so proud of yo …
Merging a Conflict with SQL Source Control and Beyond Compare
This article describes a simple example of what it’s like to merge a conflict in SQL Source Control. You will need to have installed Beyond Compare, one of the tools which integrates with SQL Source Control to resolve conflicts.
Generate QR Code® barcodes in an SSRS report with the QRCoder library
QRCoder is an open source implementation of standards specification ISO/IEC 18004, which defines the requirements for two-dimensional QR Code symbols. It is a more complete implementation of the standard than the open source QRCode4CS library that was …
SQL SERVER – DBCC CHECKDB Waiting for PREEMPTIVE_OS_DEVICEIOCONTROL
As you might already know that I am a SQL Server Performance Tuning Expert who also acts as a “on-demand consultant” for many organizations across the world who have performance tuning or any other issue related to SQL Server. Once I was wo …
Calling all user group leaders! We want to present for you in 2019!
By the end of December, we at SQLskills will have presented remotely (and a few in-person) to more than 100 user groups and PASS virtual chapters around the world in 2018! We’d love to present remotely for your user group in 2019, anywh …
[Video] Office Hours 2018/10/17 (With Transcriptions)
This week, Brent, Erik, and Richie discuss small vendor apps, “Slow in the Application, Fast in SSMS?”, virtualization, licensing, msdb backup history issues, implicit transactions, how to convince your boss to allow you to use sp_blitz, an …