On being a woman and a data professional
This is a list of links, in no particular order, that you should read in no particular order. But read all of the words at the end of these...
2023-04-24
156 reads
Find out how fast is your SQL database growing using the backup metadata from msdb
Sometimes I need to know how fast a database is growing, or which particular database is growing the most out of all the databases on a SQL instance. Now...
2023-05-03 (first published: 2023-04-24)
813 reads
Monitor SQL replication subscriptions synchronization status
In your current role if you are managing a SQL server replication setup, you are probably well aware that if any of the subscriber is not getting synchronized within...
2023-04-28 (first published: 2023-04-22)
380 reads
How to use the new dynamic format strings for measures in Power BI
The April 2023 release of Power BI desktop introduced a new preview feature called dynamic format strings for measures. This allows us to return values with different formats from...
2023-05-01 (first published: 2023-04-21)
754 reads
Get your Query History in Redshift
Because my Windows machine apparently decides to install updates over night (and thus reboot my machine), it has happened that I lost the query that I was writing for...
2023-04-28 (first published: 2023-04-20)
136 reads
New Job -> Week 5 -> Create Index Maintenance Scripts
This is part of a series of new job blog posts. You can find them all here. Week 5 goal: set up Ola index maintenance for all Azure SQL...
2023-04-18 (first published: 2023-04-17)
185 reads
Tales From The Field Weekly Wrap Up for the Week of 04-10-2023, Taylor Swift, & The Disney 10 Miler
Hello Dear Reader! Last week was a really busy week with an even busier weekend. We will get to the show recap's in a moment but first let's dive...
2023-04-17
17 reads
Flyway Desktop PoC–Adding a Shadow and Baseline Script
In the last post, I created a baseline marker for Flyway in each database. This set the version in the dev and QA databases to v1. However, I also...
2023-04-12
44 reads
I’ve Got 99 Problems But xp_cmdshell Ain’t One
xp_cmdshell is an extended SQL stored proc that allows users to run Windows command prompt commands from within SQL. Sound scary? It might, but is xp_cmdshell really a security...
2023-04-26 (first published: 2023-04-12)
591 reads
Reasons Why SQL Servers Don’t Get Configured to Industry Best Practices
Throughout my career, I’ve worked on a LOT of different SQL Servers. Many that were installed and configured by application administrators, developers, vendors, and data professionals. I’ve seen servers...
2023-04-11
24 reads
Blogs
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Forums
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...