BI Robert Sheldon in BI SQL Server Machine Learning Services – Part 3: Plotting Data with Python One of the advantages of running Python from SQL Server is the ability to create graphics to assist in analysis... 02 January 2018 26 min read
BI Robert Sheldon in BI SQL Server Machine Learning Services – Part 2: Python Data Frames SQL Server Machine Learning Services provides the ability to run Python scripts directly against data in SQL Server. To do... 18 December 2017 28 min read
.NET Dino Esposito in .NET Adapting Images to Websites Creating web pages with images that look good on all devices and screen sizes is not an easy task. Dino... 14 December 2017 11 min read
.NET Pawel Lukasik in .NET Fixing Those Broken Windows: Dealing with Technical Debt Problems that are not addressed up front are harder and more expensive to fix later. This is true for just... 30 November 2017 11 min read
BI Robert Sheldon in BI SQL Server Machine Learning Services – Part 1: Python Basics Python is a very popular language used for many purposes including machine learning. SQL Server 2017 supports Python with its... 30 November 2017 20 min read
.NET Hubert Kuffel in .NET MSBuild: Targeting Your Needs The Microsoft Build Engine (MSBuild) works seamlessly within Visual Studio, but it can also be used to build software where... 17 November 2017 12 min read
.NET Dino Esposito in .NET ASP.NET Core Tag Helpers for Bootstrap The ASP.NET Core tag helpers improve on the HTML templated helpers in ASP.NET MVC 5. ASP.NET Core comes with some... 17 November 2017 13 min read
.NET Michal Kostrzewski in .NET Hacking Visual Studio Visual Studio, like any Integrated Development Environment, can host extensions for more specialist languages or development tasks. This sort of... 03 November 2017 8 min read
JavaScript Jakub Kaczmarek in JavaScript Developing a Google Chrome Extension using Angular 4 It may seem a tricky task to create a Chrome extension with TypeScript and Angular 4 but it turns out... 31 October 2017 14 min read
.NET Dino Esposito in .NET The Secrets of ASP.NET Core User Secrets Although configuration data kept in a user profile folder is reasonably secure for development work, all bets are off once... 31 October 2017 12 min read
.NET Edward Charbeneau in .NET Working with Angular and its Technology Stack in .NET Angular is a great way of creating single-page applications that are easily testable, and have Dependency Injection and Separation of... 19 October 2017 14 min read
.NET Dino Esposito in .NET Abstracting System Time in ASP.NET Applications When designing web applications, it is a good idea to be cautious about the way you handle the time of... 19 September 2017 11 min read
.NET Dennes Torres in .NET Managing the Password of the Application’s User How can you ensure that passwords conform to a policy, even if they are used for connecting applications to databases?... 06 September 2017 26 min read
.NET Mircea Oprea in .NET C++/CLI Wrapper: Bridge Unmanaged C++ and .NET Learn how to create a C++/CLI wrapper that bridges unmanaged C++ code and .NET managed applications. Covers ManagedObject base class,... 06 September 2017 14 min read
.NET Dan Turner in .NET Why is My Database Application so Slow? When your application is running slowly, the reflex action is to blame the database queries. It is certainly true that... 24 August 2017 14 min read
.NET Tom Fischer in .NET The Care and Feeding of Tuples in C# Tuples have many uses in languages like F# and Python; they underlie relational theory. The .NET support for tuples seems... 23 August 2017 10 min read
T-SQL Programming Hitendra Patel in T-SQL Programming The Power of Python and SQL Server 2017 Python is new to SQL Server 2017. It is intended primarily to allow the use of Python-based machine-learning within SQL... 04 August 2017 14 min read
.NET Dennes Torres in .NET SQL Server Query Hints in Entity Framework: DbCommandInterceptor Guide Add SQL Server query hints to Entity Framework using a DbCommandInterceptor. Covers OPTION RECOMPILE, table hints (UPDLOCK, HOLDLOCK), and why... 01 August 2017 29 min read
.NET Dennes Torres in .NET Encrypting connection strings in web.config Encrypting web.config elements is a good security feature. Web.Config elements can include passwords and important keys that we need to... 01 August 2017 2 min read
T-SQL Programming Darko Martinović in T-SQL Programming SQLCLR Email in SQL Server: Build a Custom sp_send_dbmail Alternative Build a SQLCLR stored procedure for sending email from SQL Server without sp_send_dbmail. Covers .NET SMTP integration, custom email profiles,... 17 July 2017 36 min read
