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
334 reads
Blog Posts
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,417 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
770 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
SQL Server 2017
Top String FunctionsMachine Learning – Python IntegrationResumable Index Operations
Happy Learning!!
2017-07-06
457 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
59 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
461 reads
Balanced Power Saving T-SQL script
We can easily spend tens of thousands of dollars on core licences for SQL Server, and then we go and...
2017-07-05
186 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
Geo Location of Twitter messages in Power BI
[2017-June-25] There are several custom solutions that make Twitter messages analysis possible in Power BI. And with a recent addition of...
2017-07-05 (first published: 2017-06-25)
2,089 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers