Liberating the DBA from SQL Authentication with AD Groups
It's 15 years after the beginning of the century. Time to eliminate the security exposure of SQL logins, and implement integrated security. Active Directory Groups make this easy for the DBA.
Install and Configure SQL Server 2017 Availability Groups on Linux - Part 3
In this tip, Edwin Sarmiento looks at how to create the Always On Availability Group with a listener name when using SQL Server on Linux.
Adaptive Query Processing – Batch Mode Memory Grant Feedback
Explore Batch Mode Memory Grant Feedback that was introduced in SQL Server 2017
Historical Stock Prices and Volumes from Python to a CSV File
Python is a versatile language that is gaining more popularity as it is used for data analysis and data science. In this article, Rick Dobson demonstrates how to download stock market data and store it into CSV files for later import into a database system.
Azure DWH part 25: Auditing and threat detection
In this new article, we will show how to audit the Data Warehouse Activities.
Lowering the Noise
We are busy as administrators, and it can be very useful to ensure our systems avoid adding to our workload.
Network Issue or THREADPOOL waits?
Tara Kizer talks identifying THREADPOOL waits and what you can do about them.
Critical SQL Server Patches for Meltdown and Spectre
Everyone needs to learn about these hardware bugs and apply patches as soon as possible.
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
BCA KCU PANAKKUKANG Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Boulevard No.5 Blok F5, Masale, Kec. Panakkukang, Kota Makassar, Sulawesi...
BCA KCU MAKASSAR Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Ahmad Yani No.31, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan...
BCA KCU AMBON Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Sultan Hairun No.24, Kel Honipopu, Kec. Sirimau, Kota Ambon, Maluku...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers