(Pinal Dave) Have you ever configured database mail using Gmail account? There are many articles on the internet describing the steps. In this blog, we would learn about fixing an error “The SMTP server requires a secure connection or the client was not authenticated” which you might see when databa
Other News
DBADM can maintain all database objects … but not really?
(Eddy Coppens) As many other I got challenged to set up a database architecture. Not only database objects related, describing the different environments was also asked and there was an urgent need for a decent security setup to support rollouts in general.
General availability: SQL Database auto-failover groups – and it looks awesome
(Denny Cherry) A really great feature in Azure SQL DB went GA today. That feature gives you and SQL DB the ability to automatically fail databases over to a Secondary replia, without having to configure your application to handle that failover. You point your application at a VIP and that VIP will a
How SQL DISTINCT and ORDER BY are Related
(lukaseder) One of the things that confuse SQL users all the time is how DISTINCT and ORDER BY are related in a SQL query.
Overriding Controller Authorization in ASP.NET MVC
(Peter Vogel) You have a Contoller class called Adminstration that only admins should use. There’s about a dozen Action methods in the Controller class and they all should only be accessed by users in the Admin or SuperAdmin roles.
Performance Myths: The query result cache
(Andy Mallon) I was recently doing a training session when a developer commented that it was OK to run an expensive query twice because on the second execution, SQL Server would use the “results cache” and be “practically free”.
7 Tips for Troubleshooting ASP.NET Core Startup Errors
(K. Scott Allen) “An unexpected error occurred” is the least informative error message of all error messages. It is as if cosmic rays have transformed your predictable computing machinery into a white noise generator.
Java Challengers #3: Polymorphism and inheritance
(Rafael Chinelato Del Nero) According to the legend Venkat Subramaniam, polymorphism is the most important concept in object-oriented programming. Polymorphism–or the ability of an object to execute specialized actions based on its type–is what makes Java code flexible.
JSON With JavaScript
(Naveen Arumugam) JSON stands for JavaScript Object Notation. It’s a lightweight data interchange format. It is a syntax for storing and exchanging data. It’s text written with javascript object notation. In this article, we will see some basics of JSON with JavaScript.
Power BI Introduction: Working with SQL Server data in Power BI Desktop — Part 5
(Robert Sheldon) Power BI Desktop provides a far more robust environment for developing business intelligence reports than the Power BI service. Power BI Desktop supports more data sources and offers more tools for transforming the data retrieved from those sources.