(Jack Vamvas) Question: I’d like to use SERVERPROPERTY(‘productversion’) for purposes of reporting on current sql server level. I’m using the SERVERPROPERTY(‘productversion’) funcion, but am struggling with how to split the parts of the details, to make it easier for reporting.

(Daniel Farina) You’re asked to run a project that uses SQL Server as the database engine in your production environment with the least cost as possible. You know there are different editions of SQL Server, but how do you choose the right edition to make sure you have the needed features and keep th

(Denny Cherry) Normally large companies invest in Business Continuity (BC) sites, hardware, and people to keep companies up and running in the event of a disaster.

(Itzik Ben-Gan) Last month I covered a Special Islands challenge. The task was to identify periods of activity for each service ID, tolerating a gap of up to an input number of seconds (@allowedgap).

(Don Castelino) While working with SQL Server, one of the common issue application teams encounter is timeouts. In this article, we are covering approach to troubleshoot SQL Command/Query timeouts, data collection and data analysis steps to isolate further.

(Eduardo Pivaral) Sometimes you must perform DML processes (insert, update, delete or combinations of these) on large SQL Server tables. If your database has a high concurrency these types of processes can lead to blocking or filling up the transaction log, even if you run these processes outside of

(Daniel) As you may now you can view the kubelet logs from an AKS node for troubleshooting purposes. The guidance provided in the Microsoft documentation lets spin you up a container in the AKS cluster which you then use to jump on the node via an SSH connection.

(Kenneth Fisher) tl;dr; VIEW DEFINITION Every now and again you’ll have a user that needs to be able to see what permissions other users have. Not change them, just look at them.

(Thomas LaRock) The internet provides everyone the ability to access data at any time, for any need. Unfortunately, it does not help guarantee that the data is valid, or clean.

(John L. Viescas) Learning how to retrieve information from or manipulate information in a database is commonly a perplexing exercise.