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
Scott Klein, CTO at Cloud and Devices, explains how enterprises can leverage the built-in intelligence features of SQL Server 2017 to ensure DevOps pays off.
The May update of Visual Studio Code has added documentation for using the popular MongoDB in Microsoft's lightweight, cross-platform code editor.
Our data science doctor provides a hands-on neural networking tutorial to explain how to get started with the popular Keras library, a high-level wrapper over TensorFlow.
- By James McCaffrey
- 05/15/2018
The data science doctor explains everything you need to know about clustering data, the process of grouping items so those in a group (cluster) are similar and items in different groups are dissimilar.
- By James McCaffrey
- 04/30/2018
With a host of improvements based on customer and SQL community feedback, the SQL Server 2016 Service Pack 2 was released by Microsoft.
The ability to use SQL with Entity Framework Core has always been a cool feature. There's a new feature in Entity Framework Core that opens the door for whole new set of SQL-related functionality.
The extension model introduced with Visual Studio Code and subsequently tracked by the Visual Studio IDE is proving so popular it has been applied to SQL Operations Studio, Microsoft's cross-platform, open source data management tool.