Database Fundamentals #2: SQL Server Management Studio
The best way to learn any software is to start using it. There are a bunch of software tools in...
2017-06-12
1,105 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
T-SQL Tuesday #091 – Databases and DevOps
Implementing DevOps with databases presents a unique set of challenges. However, just because something might be hard doesn’t mean that...
2017-06-06
425 reads
Database Fundamentals #1: Install SQL Server
To get started with SQL Server, you need to install it. However, I’m not going to teach you how to...
2017-06-05
535 reads
Wanna Cry? Me too
I don’t doubt for a minute that on a certain level you’re sick to death of people talking about the Wanna Cry ransomware. However, bear with me, we need to go through it just a little more because it actually has some bearing on us as data professionals. OK, more than some bearing, it’s a […]
2017-06-05
195 reads
Technology Gender Gap By State
This is my first ever guest blog post. Take it away Hazel Garcia.
Though the gender gap narrows by the year,...
2017-06-02 (first published: 2017-05-22)
1,424 reads
General Notes on Security in Azure SQL Data Warehouse
I’m still learning about Azure SQL Data Warehouse (ADW, cause I’m lazy). ADW is a deceptively deep topic. Initially you...
2017-05-22 (first published: 2017-05-08)
1,176 reads
MySQL and Backups As A Service
With today’s announcement that MySQL is available as a Platform as a Service (PaaS) offering through Azure, a lot more...
2017-05-10
605 reads
Query Hash Values, Plan Guides and the Query Store
I was eating dinner with Hugo Kornelis and we started talking about query hash values. You know, like everyone does...
2017-05-08 (first published: 2017-04-24)
1,315 reads
Redgate Alexa Contest Winners!
A couple of weeks ago we had a small contest here to pick a skill for Alexa. The entries were...
2017-05-05
481 reads
Food On Your Table
I was asked, “Who here thinks that PASS helps people put food on the table?” To my shame, I initially...
2017-04-25
401 reads
Blogs
Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python
Most apps that call an LLM send every request to the same model. That...
Advice I Like: Responsibility
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
Forums
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Another Model, More Data Loss
Comments posted to this topic are about the item Another Model, More Data Loss
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers