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
906 reads
Blog Posts
SQL Crossword : T-SQL Keywords : June 2017
I did a SQL crossword last month (not my first one either) and it was pretty popular so I asked...
2017-07-07 (first published: 2017-06-28)
2,433 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
457 reads
Database Fundamentals #4: Create a Database
SQL Server provides multiple ways to perform most functions. In order to maximize your understanding of how SQL Server works...
2017-07-06 (first published: 2017-06-26)
2,000 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
329 reads
Keep VMware snapshot growth from wrecking your day
VM snapshots are one of the best virtualization features ever. But…have you ever had a VMware vSphere or Hyper-V snapshot...
2017-07-06 (first published: 2017-06-26)
1,411 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
758 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,034 reads
SQL Server 2017
Top String FunctionsMachine Learning – Python IntegrationResumable Index Operations
Happy Learning!!
2017-07-06
455 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
55 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers