Index Maintenance Madness
When we look at a new server, we check out their database maintenance jobs, making sure their server is in a safe place before we dig into their pain points. We verify if their backups and DBCC CHECKDB jobs can meet their RPO/RTO goals. We also check o …
First Responder Kit Release: Treating Object References Like Object Instances, Man
Object reference not set to an instance of an object. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1281 We’ve lowered the priority of Query Store being disabled. It’s just not as important as the …
Introducing the updated HTML comparison report in SQL Compare 13.1
In SQL Compare 13.1, Redgate have updated the interactive HTML comparison report type, providing simpler cleaner reports that focus on the differences between the compared databases. This blog post looks at the details of what’s new.
Keeping tables online during loading with schema swapping using SSIS
In this article, we discuss how schema swapping method can be used to keep tables online during the load process.
SQL SERVER – Msg 3743: The Database is Enabled for Database Mirroring. Database Mirroring Must be Removed Before you Drop the Database
One of my clients contacted me for quick assistance. They had Database Mirroring configured for a database. Due to some unknown issue their database mirroring went for a toss. Their end goal was to drop the database so that they can configure database …
Gartner Says Hire Programmers to Your Infrastructure and Ops Team
As traditional enterprises increasingly behave like platform companies, their IT and ops teams should change accordingly.
Savill's FAQs: How to Patch a Container Image
Three times a week, John Savill tackles your most pressing IT questions. Today, he explains patching Container Images, the size of Nano Server in Version 1709, and Project Honolulu Communications with servers.
SQL Server Missing Indexes Feature and Trace Flag 2392
Background Since the SQL Server 2005 release, SQL Server has had the default ability to collect metrics about what the query optimizer thinks are “missing” row store indexes, i.e. indexes that the query optimizer thinks would reduce the cos …
AWS Launches Cloud9 Integrated Developer Environment
Cloud9, which AWS acquired in 2016, is tightly integrated with a wide range of AWS services to allow users to write their code in the cloud.
Using Delivery Reports in Microsoft Exchange Server 2016
How to use the delivery report feature in Microsoft Exchange Server 2016.
Researchers Combat Gender and Racial Bias in Artificial Intelligence
Machine learning, image recognition and other AI tools have big blind spots that particularly effect women and minorities.
PASS SQL Saturday #687 Slovenia 2017 Sponsors Showcase
Please take a minute and check this brief introduction of our wonderful gold, silver, and bronze sponsors. Comtrade is a dynamic and well established technology group, with a 25-year track record of innovation and steady development of some of the worl …
A day in the life of a developer with SQL Prompt
There is a lot more to SQL Prompt than IntelliSense and code completion. Tony Davis takes a developer’s eye view of its features, as they slot into a typical day of database development work, covering Prompt’s snippets, Actions, custom code styling, sa …
Is This Database Being Used?
Can we delete this database, or is someone still using it?
SQL in the City Streamed – Virtual Event on December 13 2017
Just like everyone, I love free quality education. However, the biggest challenge we see in the technology world is that even though we have free education available, after a while the relevance of the education is limited. Technology field is continuo …