A Fine Slice Of SQL Server
Our requirement is to record unsuccessful login attempts i.e. failed logins for security and compliance reasons. The database estate includes SQL Servers, Azure SQL Databases, and Azure SQL Managed Instances. How can I configure auditing for failed logins for each of these database environments?
Read on for the answer in SQL Server, Azure SQL Database, and Azure SQL Managed Instance.
Leave a CommentAndy Brownsword tries and tries again:
Retries are a useful part of resilient pipelines. However, retries aren’t created equal, so I want to dive into recent changes to pipeline activity retries and the benefits they bring.
Read on to learn more about new capabilities such as introducing built-in exponential back-off and specific retry conditions.
Leave a CommentStephanie Bruno breaks out the green visor:
Your nonprofit is ready to escape spreadsheet chaos and move into Power BI. Then you open the licensing page. Pro? Premium Per User? Fabric capacity? F2, F64, F-what?! If you’re a nonprofit trying to make every dollar count, figuring out what to buy can feel like reading a spellbook in a language you don’t speak. We get this question a lot, so here’s our plain-language guide.
Prices below are in USD and current as of October 2026. Microsoft changes licensing pretty often, so always double-check the official nonprofit offers page before you buy.
Read on for several tips on how to get the most out of Power BI if you do work for a non-profit organization.
Leave a CommentLouis Davidson works with three amigos:
To get the total, there are a few ways, which I will demonstrate in the next sections on the aggregation functions,
ROLLUP,CUBE, and thenGROUPING SETS. Grouping sets are the most flexible, in that they let you do what the other two can do, but with more control. But knowing the others is important because it is how most ad hoc queries will be written.
It’s uncommon that I use GROUPING SETS() in my code, but every time I do, I’m thankful that it exists.
James Serra offers up some alternatives:
If you are migrating a data warehouse, there is a question worth asking before you start: should you recreate the existing solution on the new platform, or use the move to make it better? This applies whether you are moving from an on-premises Netezza system to Microsoft Fabric or from Azure Synapse Analytics to Fabric. My preference is to modernize during the migration when the business case and timeline support it. Even a conservative migration takes substantial work, so it is worth considering which additional improvements would make that investment more valuable for years to come.
Click through for pros and cons on four approaches, as well as James’s recommendations.
Leave a Comment