Introduction Microsoft released SQL Server on Linux, starting from SQL Server 2017. SQL Server 2019 (15.x) has the same underlying database engine on all supported platforms, including Linux. Therefore, many existing features and capabilities operate the same way on Linux. Platform File System Red Hat Enterprise Linux 7.3, 7.4, 7.5, 7.6, or 8 Server XFS […]
2020-06-01
2,385 reads
In the third article of this series, Sanil Mhatre demonstrates how to perform a sentiment analysis using R including generating a word cloud, word associations, sentiment scores, and emotion classification.
2020-06-01
2020-06-01
In the part 18, we created a Cube based on the Azure Data Warehouse. In this new chapter, we will work with the cube, create backups and show some tips to restore.
2020-05-29 (first published: 2017-10-23)
3,079 reads
My favorite new things are that sp_BlitzIndex @Mode = 2 now makes it even easier to do disconnected index tuning just purely inside a spreadsheet, and sp_BlitzCache runs faster on big servers.
2020-05-29
The Sequence object is a way of auto generating a numerical value in some order automatically. This object can be used as a default for a table column, and this articles shows how this can be implemented.
2020-05-28
13,002 reads
Is your organization—and your data team—ready to embrace an AI-augmented future?
2020-05-28
How many different database applications exist? Many people can name the most common ones such as MySQL, Microsoft SQL Server, and Oracle. Most good DBAs and programmers could likely rattle off a dozen different databases is you asked them to.
2020-05-27
Learn how to ensure your PolyBase objects are accessible from all nodes in an Availability Group.
2020-05-26
3,819 reads
For any Business Intelligence solution to be useful for analytical and decision-making purposes, it is imperative that the underlying data quality is good so, that reports generated are reliable to make business decisions. This article from Imran Quadri Syed walks the through steps involved to implement a successful Data Quality Monitoring framework that would validate incoming data against predefined data quality rules and capture data quality metrics.
2020-05-26
1,004 reads
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Comments posted to this topic are about the item Working Better Under Pressure
Comments posted to this topic are about the item Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers