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
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers