Using SQL Server as a Source with for an Excel Application
I am presenting an MS Excel VBA project which automates the display of SQL Server data tables.
Artificially Intelligent - Text Sentiment Analysis
One of the truisms of the modern data-driven world is that the velocity and volume of data keeps increasing. We’re seeing more data generated each day than ever before in human history. And nowhere is this rapid growth more evident than in the world of social media, where users generate content at a scale previously unimaginable.
The Value of Data
Data can be valuable, and there's a new book that compares the value of data today to that of oil in the previous century. Steve Jones has a few thoughts on why we should consider this to be the case.
Calculating Employee Attrition with DAX – Part 2
In part 1, we described the requirements for calculating attrition and also demonstrated one method that doesn’t rely on writing DAX code at all. In the second part of this tip, we introduce alternative methods of creating a calculation in DAX to calculate the number of employees that have left the company.
Covering Indexes: Not Just for SELECT but also for UPDATE statements
Covering indexes help UPDATE performance also
Does the Tone matter?
Does the tone of communication matters to you that much that it affects your work in some way?
Calculating Employee Attrition Rate with DAX – Part 1
In many businesses, the HR department needs reports on the employee attrition. This is the number of people that leave the company (depending on the reason they leave; the terminology can also be dismissals or turnover). Suppose you have a table with your employee data, where you also store a possible termination date. How do you calculate the number of people who have left the company using the DAX query language?
Auto assign Column Data Types for Flat file Source Import
A tip to auto detect data types for flat file sources in SSIS. Never manually enter them ever again!
How do you deal with disappointment?
Disappointment is hard, but you get to choose how you react to it.
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