SQL Server Education (by the geeks, for the geeks)
This 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 MoreThis article first appeared in the SQLServerGeeks Magazine. Author: Steve Jones Subscribe to get your copy. One of the things that I have often seen developers ignore in building applications is …
A Few tricks for testing security by Steve Jones Read MoreThis article first appeared in the SQLServerGeeks Magazine. Author: Tomaž Kaštrun Subscribe to get your copy. OPENJSON was introduced in SQL Server 2016 and is a table-valued function that parses JSON …
SQL Server OPENJSON for selecting and comparing values by Tomaž Kaštrun Read MoreThis article first appeared in the SQLServerGeeks Magazine. Author: Edward Pollack Subscribe to get your copy. Data performance challenges are a universal part of application development. No technology, platform, or development …
Good Database Architecture is the Best Optimization by Edward Pollack Read More