SQL Server Education (by the geeks, for the geeks)
This article first appeared in the SQLServerGeeks Magazine. Author: Ben Weissman Subscribe to get your copy. You may have heard of Kubernetes – in my opinion the future platform for any …
Deploying SQL Server on Kubernetes – in Less than 10 lines by Ben Weissman Read MoreThis article first appeared in the SQLServerGeeks Magazine. Author: Amit Bansal Subscribe to get your copy. In this article, we will see how SQL Server optimises Tempdb logging for faster CRUD …
Faster INSERTs in Tempdb – Optimized/Minimal Tempdb by Amit Bansal Read MoreThis article first appeared in the SQLServerGeeks Magazine. Author: Erland Sommarskog Subscribe to get your copy. My tip this month is mainly a tip on style, but if you follow …
A Tip on Writing UNION by Erland Sommarskog Read MoreThis article first appeared in the SQLServerGeeks Magazine. Author: Martin Catherall Subscribe to get your copy. It was a huge honour to be asked to write a piece for DataPlatformGeeks – …
SQL Server and JSON by Martin Catherall Read MoreThis article first appeared in the SQLServerGeeks Magazine. Author: Amit Khandelwal Subscribe to get your copy. You’ve been a SQL Server DBA for many years, and now you have a project …
Frequently Asked Questions for SQL Server on Linux/Containers by Amit Khandelwal Read MoreThis article first appeared in the SQLServerGeeks Magazine. Author: Satya Ramesh Subscribe to get your copy. In this article, we will see a few scripts that help us to find CPU …
Investigate CPU Usage In SQL Server by Satya Ramesh Read MoreThis article first appeared in the SQLServerGeeks Magazine. Author: Prince Rastogi Subscribe to get your copy. Data Security is one of the major important area of any business now days. We …
Data Discovery and Classification by Prince Rastogi Read MoreThis article first appeared in the SQLServerGeeks Magazine. Author: Erland Sommarskog Subscribe to get your copy. Consider this query SELECT * FROM tbl WHERE col LIKE ‘%alter%’ The table has some …
A Tip to Optimise LIKE Searches by Erland Sommarskog Read MoreThis article first appeared in the SQLServerGeeks Magazine. Author: Ben Miller Subscribe to get your copy. Initial Thoughts Working as a DBA you are most often faced with multiple instances and …
Using PowerShell as a DBA by Ben Miller Read MoreThis article first appeared in the SQLServerGeeks Magazine. Author: Parikshit Savjani Subscribe to get your copy. The year 2021 has started as an eventful year and continuous to be challenging times …
Azure Database for MySQL Flexible Server – a fully managed service running community version by Parikshit Savjani Read More