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.
SQL Server Graph Databases – Part 4: Working with Hierarchical Data in a Graph Database
The Graph Database feature, new with SQL Server 2017, can be used to represent hierarchies. In this article of the series, Robert Sheldon demonstrates how to represent hierarchies in data with complex relationships.
Strange Filtered Index Problem
What I thought was a strange filtered index problem but turned out to be a DB settings problem
Create Azure VMs with PowerShell Part 1
Azure virtual machines are created for many reasons, even just to have an environment to quickly test something out. In this article, Robert Cain demonstrates the first few steps in automating the process with PowerShell. He shows how to gather information needed and set up a resource group, storage and networking needed for the VM.
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
Alamat Bank BCA KCU MENARA BCA Telp:0817839777
Wa: +62 817-839-777 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1 Lt. 28, RT.1/RW.5,...
Alamat Bank BCA KCU THAMRIN Telp:0817839777
Wa: +62 817-839-777 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec....
cons for a dev machine in a different version of sql from our prod server
hi, im not a dba. For a couple of years our dev sql server...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers