Of all the valuable attributes of a DBA, from passion to humility to practicality, perhaps one of the most important attributes may turn out to be the most seemingly nebulous: foresight. According to Free Dictionary, foresight is the "perception of the significance and nature of events before they have occurred". Foresight does not come naturally to most people, as the […]
Why has Microsoft added new capabilities in SQL Server to connect to other types of data sources? Read on to learn more.
This tip will teach you when and how you can use CASE in T-SQL statements with several code examples to give you a better understanding.
You’ve submitted thousands of bug reports and feature requests at feedback.azure.com. Brent Ozar goes through what you’ve voted as the top 10 requests right now.
Being prepared for a disaster might mean having a way to collect data when something occurs.
Azure Logic Apps can be used to automate steps like sending approval emails. Elie Bou Issa explains automating Azure DevOps with Logic Apps.
Take the 2021 State of Database Monitoring survey and tell us about how you monitor your databases, instances and servers. By taking the survey, you’ll contribute to (and get early access to) the leading industry-wide report on database monitoring, and be entered to a prize draw for a $500 Amazon gift card.
Being able to audit the actions others take on your systems is important to Steve, especially when working in the cloud.
Introduction Every DML transaction reads the data before it makes any changes. Not only during a SELECT query, but when you run any DML statement, insert, update, or delete, SQL Server first fetches a bunch of pages into the buffer pool locating the desired rows and changes them while synchronously writing to the transaction log […]
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Comments posted to this topic are about the item Working Better Under Pressure
Comments posted to this topic are about the item Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers