This guide describes the locking and row versioning mechanisms the SQL Server Database Engine uses to ensure the physical integrity of each transaction and provides information on how applications can control transactions efficiently.
I am presenting an MS Excel VBA project which automates the display of SQL Server data tables.
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.
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.
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 help UPDATE performance also
Does the tone of communication matters to you that much that it affects your work in some way?
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?
A tip to auto detect data types for flat file sources in SSIS. Never manually enter them ever again!
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
By Steve Jones
“You don’t need more time because you already have all the time that you...
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Wa:082374977784 Jl. Tarum Barat Blk. E No.5, RT.4/RW.10, Wil. Kota, Kec. Duren Sawit, Kota...
Wa:082374977784 Jl. Sultan Hairun No.24, Kel Honipopu, Kec. Sirimau, Kota Ambon, Maluku 97124
Comments posted to this topic are about the item What Did Healthy Look Like?
How many types of DML triggers are there?
See possible answers