Promising that developers can "save weeks of development effort," Microsoft today answered their request for database project support in Visual Studio to target Azure SQL Data Warehouse projects.
If someone tells you that LINQ doesn't support subqueries ... well, they're not wrong. But they're also not entirely correct, either. With LINQ you can meet many of the goals of SQL subqueries including the ability to build complex queries out of simpler ones.
A Visual Studio Code extension developed by a student is receiving a lot of buzz for its intention to serve as a "one-stop shop for data scientists."
The October release of Azure Data Studio includes preview support for SQL Server 2019 and more.
The Data Science Doctor explains how to use the reinforcement learning branch of machine learning with the Q-learning approach, providing code on how to solve a maze problem for an easy-to-understand example.
- By James McCaffrey
- 10/19/2018
If, in your "need for speed," you're looking to access and update your data as fast as possible, you can get to that goal by combining memory-optimized tables with compiled procs.
If screaming speed in data access is the most important thing in your life, SQL Server's durable in-memory, memory-optimized tables are your answer. They were good in SQL Server 2014 and they're even better in SQL Server 2016, 2017 and Azure.
You're not a DBA but you're responsible for managing your organization's SQL Server installation. Here are some tips on what you can do to speed up all your data access.
Microsoft introduced a preview of the latest edition of its flagship RDBMS, SQL Server 2019, highlighting new Big Data capabilities integrated into the core database engine.
If you want to speed up your SQL Server queries you need to know how your application and your users actually use your database.
Our resident data scientist provides a hands-on example on how to make a prediction that can be one of just two possible values, which requires a different set of techniques than classification problems where the value to predict can be one of three or more possible values.
- By James McCaffrey
- 08/30/2018
Microsoft this month updated its R Open programming language with multi-processor support highlighting new functionality.
Data scientist Dr. James McCaffrey provides code, screenshots and step-by-step instructions on how to perform regression using a deep neural network with the Keras code library.
- By James McCaffrey
- 07/23/2018
In less than a year, Microsoft will end support for SQL Server 2008, meaning no more updates and no more support of any kind, but perhaps more problems on the security and compliance fronts for organizations that don't migrate to newer options.
The Data Science Doctor provides a hands-on tutorial, complete with code samples, to explain one of the most common methods for image classification, deep neural network, used, for example, to identify a photograph of an animal as a "dog" or "cat" or "monkey."
- By James McCaffrey
- 06/25/2018