Availability databases hosted on SQL Server Always On Availability Groups (AG) can be connected using a unique Virtual Network Name (VNN), called the Availability Group Listener. When an Availability Group is enabled, clients can connect to databases in both primary and secondary replicas without explicitly specifying the SQL Server instance name. You don’t even need […]
Whether you work as a Data Engineer or a Data Scientist, a Jupyter Notebook is a helpful tool. One of the projects I was working required a comparison of two parquet files. This is mainly a schema comparison, not a data comparison. Though the two .parquet were created from two different sources, the outcome should […]
Learn how to properly configure input date formats for Power BI reports for any type of browser so users always get the results they expect.
Redgate is giving you the chance to win your choice of DevOps books and Redgate goodies in their latest competition. To enter, visit the Redgate Forums and answer the question: ‘How is SQL Change Automation helping you?’
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.
By Steve Jones
ochisia – n. the fear that the role you once occupied in someone’s life...
This is a quick blog post, mainly so I have the code available if...
Praise whatever deity you believe in, because it’s finally here, a tenant switcher for...
Looking for a reliable and exciting betting platform? TigerExch is your answer! With top-tier...
Looking to up your betting game? TigerExch 247 has everything you need for top-notch...
When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?
See possible answers