Microsoft introduced Azure SQL Data Warehouse, a new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just few minutes. In this article, Arshad Ali discusses the different types of tables you can create in SQL Data Warehouse, how they impact performance and the best practices around them.
Steve Jones looks at SQL Server on Linux and how this may differ from what most of us have worked with in the past.
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.
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Jl. Raya Pluit Utara. 85 Blok E Kav. No. 11, RT.4/RW.5, Pluit, Kecamatan Penjaringan,...
BCA KCP Tebet Timur Telpon/WA:08137887595.Jl. Tebet Timur Dalam Raya Blok GG No. 97, Tebet...
Jl. Raya Kelapa Hibrida, Ruko, Jl. Gading Riviera Raya No.10 Blok PF 21, Daerah...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers