Running dbatools commands with VS Code tasks
I’ve started to look at the excellent dbatools.io to automate some of the checks that I routinely perform on my...
2017-07-07
907 reads
Friday Reading 2017-07-07
Final Lions Test tomorrow! The win last week sets up a thrilling series decider, if they win they’ll be the...
2017-07-07
800 reads
Mongodb – How to Iteratively Access Data Across all Databases and Collections
With some applications, there may be a need to pull data from other database instances, or from other databases within...
2017-07-06
764 reads
SQL Server 2017
Top String FunctionsMachine Learning – Python IntegrationResumable Index Operations
Happy Learning!!
2017-07-06
457 reads
Power BI Custom Visuals Class (Module 58 – Drilldown Choropleth)
In this module you will learn how to use the Drilldown Choropleth Custom Visual. The Drilldown Choropleth is a map...
2017-07-06
1,037 reads
Becoming an MVP
“Climb the mountain to see the world, not be seen by the world.” – from Tim Ford.
This past July 1 was...
2017-07-06
458 reads
Gratitude
I want to take a moment to thank a few people for being amazing.
First up, Thomas LaRock is wrapping up...
2017-07-06
331 reads
Writing Dynamic and Random Tests Cases for Pester
I have written a module SQLDiagAPI for consuming the SQL Server Diagnostics API with PowerShell. I blogged about how I...
2017-07-06
459 reads
Upgrade Your SQL Server CASE Statements With IIF and CHOOSE
SQL Server 2012 introduced IIF and CHOOSE functions and I completely missed they even existed until recently. They make some...
2017-07-06
57 reads
Book Review: VMware vSphere 6.5 Host Resources Deep Dive
If you are actively managing VMware environments with workloads that have high performance needs (such as all of the virtualized...
2017-07-05
497 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers