(Derek Colley) As a database developer or DBA with a growing interest in data science, you have been tasked with creating a process to enable your organization to make predictions about their data using machine learning methods.
Community
How to resolve and avoid deadlocks in SQL Server databases
(Lindsay Moore) The first step in learning how to avoid deadlocks in SQL Server databases is preparedness. Knowing about deadlocks — in particular, what causes them — is the key to preventing them and resolving those that do occur, according to SQL Server experts.
Dipping into the Cookie Jar: T-SQL Tuesday #112
(Kenneth Fisher) This month our intrepid host for T-SQL Tuesday is Shane O’Neill (b/t). He’s asked us to talk about our cookies. No not the kind you eat (Double Stuff Oreos and Thin Mints are the best of course) or even the kind that web sites use to store information.
Announcing Db2 12 function level 504
(Paul McWilliams) We’re proud to announce Db2 12 function level 504!
Image Distortion Effects with SVG Filters
(Mary Lou) In our recent articles series on SVG Filter Effects, Sara has shown how powerful and versatile SVG filters can be. They allow for a plethora of unique effects.
Hibernate doReturningWork() method Example
(Yatin) In this tutorial, we will learn Hibernate 4 Returning Work interface and Session.doReturningWork() method for Jdbc.
SQL SERVER – Unable to Set Cloud Witness. Error: An Existing Connection Was Forcibly Closed by The Remote Host
(Pinal Dave) After finishing my lab and testing, I went to my client and they showed me error while setting up cloud witness. They showed me a different error then earlier.
Docker with Real Applications
(Peter Vogel) Here’s how to run a “real-world” application (consisting of an MVC application and a Web Service) in a networked set of Docker containers. And it’s just a couple of mouse clicks in Visual Studio to implement it.
Re-reading ASP.Net Core request bodies with EnableBuffering()
(Jeremy) In some scenarios there’s a need to read the request body multiple times. Some examples include
Top 10 Database Diagram Tools for MySQL
(Rob Gravelle) Your database schema acts as the blueprints for your database; its job is to represent the database structure, data types, and table constraints.