(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
(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.
(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
(lukaseder) One of the things that confuse SQL users all the time is how DISTINCT and ORDER BY are related in a SQL query.
(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.
(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”.
(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.
(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.
(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.