A series of arguments with developers who insist that fuzzy searches or spell-checking be done within the application rather then a relational database inspired Phil Factor to show how it is done. When the database must find relevant material from search terms entered by users, the database must learn to expect, and deal with, both expected and unexpected.
The path to becoming a data scientist isn't simple or easy, but it might be for you.
Microsoft announced the availability of SQL Server Analysis Services (SSAS) on Azure late last year. Siddharth Mehta walks through how to quickly set up a tabular data model in SSAS Azure.
This article demonstrates using React and the CData API Server to build dynamic Web pages using SQL Server data.
Have you ever given up on your brainchild? If yes, how did you deal with it?
Grant Fritchey on the lessons all DBAs can learn from the recent Public Relations disaster for United Airlines.
The Redgate Foundry team have been researching data masking, and have found that generally speaking there's six common approaches. In this blog post, Toby Smyth runs through all six.
It takes a creative mind to come up with new ideas. So how do you do it?
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Comments posted to this topic are about the item TempDB Facts I
Comments posted to this topic are about the item Have you done a Mid...
Can I set Accelerated Database Recovery on tempdb?
See possible answers