SQL Server database business continuity, including high availability and disaster recovery, is not an easy topic to engineer for. The business must work with the IT teams to define service-level agreements, statistically significant scenarios to plan for, and then decide on a budget.
2020-06-03
Useful free and paid utilities and tools for Microsoft SQL Server - complete list of 275 Utilities
2020-06-02 (first published: 2020-05-26)
39,186 reads
PowerShell scripts are the tool of choice for many admins, but how do you make them easy for others to use? In this article, Greg Moore shows how to add professional looking help to your scripts that work just like the help in cmdlets.
2020-06-02
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,401 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,094 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,241 reads
Is your organization—and your data team—ready to embrace an AI-augmented future?
2020-05-28
I am excited to host T-SQL Tuesday for the first time. I want to...
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Telp/WA 62 8218200203 Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta...
Telp/WA 62 8218200233 Jl. Wolter Monginsidi No.54, RT.2/RW.4, Petogogan, Kec. Kby. Baru, Kota Jakarta...
Telp/WA 62 8218200174 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101, Wil, Kec....
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers