(Tapas Pal) The Azure Blob storage solution is used to store unstructured physical objects in Microsoft Cloud. It’s optimized for storing massive amounts of unstructured data, such as text or binary data which could be accessed by using HTTP and HTTPS protocols from anywhere an Internet connection i
Community
SQL SERVER – Results of Dynamic SQL Into A Variable
(Pinal Dave) The other day during Comprehensive Database Performance Health Check, I was asked if there is a way to store results of dynamic SQL into a variable. This is a very popular question and let us see the answer to this question in this blog post.
AI-Assisted Code Completion Suggestions Come to C++ via IntelliCode
(Nick Uhlenhuth) After reading and writing enough code, you begin to notice certain usage patterns. For example, if a stream is open, it will eventually be closed. More interestingly, if a string is used in the context of an if-statement, it will often be to check if the string is empty or if it has
Tracking Foreign Keys
(Jesper Krogh) The other day, I was reading a blog by Magnus Hagander about tracking foreign keys throughout a schema in PostgreSQL. I thought it was a good idea, so I decided to look at how you can track foreign key in MySQL.
Querying the amount of redo in Oracle Database
(Zahid Anwar) When a database starts to churn more redo then normal, it is handy to be able to extract the amount of redo over time, to be able to plot this in a graph.
Ranges with NULLs 04: Pack, Merge
(stewashton) In this post, I’m going to treat two closely related but distinct requirements:
Oracle LIKE predicate and cardinality estimations
(Franck Pachot) There are not many ways to access efficiently to table rows. Either you want lot of them, because your predicate is not very selective, and you read the whole table in the fastest you can do. This is Table Full Scan.
Simple ASP.NET CORE 2.2 app +Vue JS
(jicking) You got hired by WayKurat , a ficticios company that develops vue js/ ASP.NET Core apps.
Read Only Filegroups and Availability Groups
(Allan Hirt) A question came across my inbox this week which I decided to investigate: what happens if you have read only filegroups as part of your database, and you want to use Always On Availability Groups? Let’s find out.
Closest Match, Part 1
(Itzik Ben-Gan) Karen Ly, a Jr. Fixed Income Analyst at RBC, gave me a T-SQL challenge that involves finding the closest match, as opposed to finding an exact match.