Azure DWH part 19: Backup and Restore SSAS
In the part 18, we created a Cube based on the Azure Data Warehouse. In this new chapter, we will work with the cube, create backups and show some tips to restore.
Crack that Encrypted Data
Ransomware is becoming an issue. Steve Jones notes DBAs need to be ready to deal with these issues.
Updated First Responder Kit and Consultant Toolkit for May 2020
My favorite new things are that sp_BlitzIndex @Mode = 2 now makes it even easier to do disconnected index tuning just purely inside a spreadsheet, and sp_BlitzCache runs faster on big servers.
The Basics of Using a Sequence as a Table Default
The Sequence object is a way of auto generating a numerical value in some order automatically. This object can be used as a default for a table column, and this articles shows how this can be implemented.
The Challenges of Working Under Quarantine
It's been nearly two months since the Redgate Software offices closed. I am not normally in the office, but I did cancel a trip that I normally would have taken to touch base with a number of teams. That's a minor change for me, but a still a change. It's much less than the disruption that […]
Rewiring Your Culture for an AI-Augmented Future with Intelligent DataOps
Is your organization—and your data team—ready to embrace an AI-augmented future?
Jumping Air Gaps
There are all sorts of viruses, worms, and malware out in the world, and some of us have had to deal with them at different points in our career. SQL Slammer was particularly memorable for me, but there were plenty of non data related virus issues I've had to work on at various employers. To […]
Monitoring - Level 6 of the Stairway to SQL Server on Linux
In this level of the Stairway to Linux, learn how to use the TIG stack to monitor your SQL Server instance on Linux.
How Many Databases Can You Name?
How many different database applications exist? Many people can name the most common ones such as MySQL, Microsoft SQL Server, and Oracle. Most good DBAs and programmers could likely rattle off a dozen different databases is you asked them to.
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
A Fun Computer Quote
Comments posted to this topic are about the item A Fun Computer Quote
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers