Translate

Wednesday, December 12, 2018

8 top Artificial Intelligence and Analytics Trends for 2019

Artificial intelligence will deliver approximately $2 trillion worth of business value worldwide over the next year through the use of advanced computing algorithms that identify and optimize business insights that humans cannot spot. Companies that fail to adopt AI will lose out. Some industries may even be wiped out.

As identified main trends are,

AI and Analytics Merger
Decision Automation
Digital Twins
Edge Computing
Mixed Reality
Blockchain Boom
Cloud Maturity
Full-Stack Engineers

Read more at https://www.information-management.com/opinion/8-top-artificial-intelligence-and-analytics-trends-for-2019 

Saturday, November 17, 2018

SQL Server Temporal Tables Overview

For many applications, it's a common requirement to get details about data modifications that have occurred in a SQL Server table. Tables can have multiple updates and deletes for different reasons, and there may be a need to keep the different versions of records. Prior to SQL Server 2016 you would have to use triggers to keep track of data changes in tables, but now we can use the built-in temporal table feature that was first released in SQL Server 2016.

Read more at https://www.mssqltips.com/sqlservertip/5781/sql-server-temporal-tables-overview/

Tuesday, November 13, 2018

DevOps and Databases

A robust DevOps environment requires having continuous integration for every component of the system. But far too often, the database is omitted from the equation, leading to problems from fragile production releases and inefficient development practices to simply making it harder to on board new programmers.
In this article, it is discussed the unique aspects of databases, both relational and NoSQL, in a successful continuous integration environment.

Tuesday, October 30, 2018

Script to Create and Update Missing SQL Server ColumnStore Indexes

SQL Server columnstore indexes are helpful when it comes to retrieving large volumes of data.  However, there are instances where columns are added to the table after the columnstore index was created. This means the new columns are missing in the columnstore index. Also, there can be cases where new tables are added and a columnstore index was not created.  In this tip we will look at how we can identify these cases and create scripts to create the index.

https://www.mssqltips.com/sqlservertip/5742/script-to-create-and-update-missing-sql-server-columnstore-indexes 


Sunday, October 21, 2018

Free eBooks from Microsoft Press

Free Microsoft eBooks are available in PDFEPUB and Mobi for Kindle formats.
Find more training eBooks & books at The Microsoft Press Store.

Download from https://mva.microsoft.com/ebooks

Monday, January 22, 2018