Tag: object

Feed: Planet PostgreSQL. Here is a series of articles that will focus on a new feature in version 11. During the development of this version, a feature caught my attention. It can be found in releases notes : https://www.postgresql.org/docs/11/static/release-11.html Allow heap-only-tuple (HOT) updates for expression indexes when the values of the expressions are unchanged (Konstantin Knizhnik) I admit that this is not very explicit and this feature requires some knowledge about how postgres works, that I will try to explain through several articles: How MVCC works and heap-only-tuples updates When postgres do not use heap-only-tuple updates and introduction to the ... Read More

Feed: Blog. Author: SQLWareWolf; In an effort to teach myself PowerBI, I thought that I could learn PowerBI while working with something that I know.  While in New York City, I was discussing this topic with the incomparable Patrick LeBlanc(b|t).  In the end, we decided that we would do a session together where he would show statistics and I would show PowerBI.  We were able to present this at Summit 2017.  I will review my experience at Summit 2017 in another blog. In this article, we are going to discuss how SQL Server uses statistics.  Differences between how 2016 and ... Read More

Feed: Blog. Author: Peter V.; The tempdb system database is a workspace used to hold temporary user objects, results created through queries and sorts, and other objects created by the SQL Server Database Engine. Because of the significant amount of data stored in tempdb, users can run out of disk space, which causes the entire server and all of its databases to become unresponsive. Resolve some of these issues by providing a monitoring solution that features a series of charts, views, and alerts specifically for tempdb. The tempdb system database, along with the master, model, and msdb databases, is provided by ... Read More

Feed: Blog. Author: Kim Brushaber; As 2018 quickly approaches, we have a good opportunity to look towards the future.  GDPR will go into effect in May and with it we should see some significant changes in how companies handle their data. GDPR will affect more than Europe Many companies think that GDPR is just a European Regulation. However, the regulation stretches to information collected on EU Members. As companies continue to stretch their arms into the global marketplace, the time to take GDPR seriously is now. GDPR states that if you collect any of this data on EU members you ... Read More

Feed: The Internet of Things on AWS – Official Blog. Author: Alex Oleynikov. BackgroundClearScale was founded in 2011, with a focus on delivering best-of-breed cloud systems integration, application development, and managed services. We are an AWS Premier Consulting Partner with competencies in Migration, DevOps, Marketing & Commerce, Big Data, and Mobile. Our experienced engineers, architects, and developers are all certified or accredited by AWS. We have a long track record of successful IoT projects and the proven ability to design and automate IoT platforms, build IoT applications and create infrastructure on which connected devices can easily and securely interact with ... Read More

Feed: The Internet of Things on AWS – Official Blog. Author: Michael Garcia. Connectivity is a key element to evaluate when designing IoT systems as it will weigh heavily on the performance, capabilities, autonomy of battery powered objects, and cost of the overall solution. There is no one network that fits all scenarios which is why AWS partners with many different network providers. By partnering, you can then choose the most relevant network to satisfy your business requirements. In this blog post, we’ll explore providing LPWAN connectivity to your objects using the Sigfox network. Pierre Coquentin (Sigfox – Software Architect) ... Read More

Feed: The Internet of Things on AWS – Official Blog. Author: John Renshaw. One of the biggest benefits of the Internet of Things (IoT) is the ability to get contextual insight from sensor data. Before you analyze sensor data, you may want to remove anomalies. Sometimes, though, you may want to analyze the anomalies or at least be notified of their presence.In this blog post, we will focus on detecting contextual anomalies. An example of a contextual anomaly is a temperature measurement that suddenly jumps from 50 to 70 degrees. The 70-degree measurement may not be unusual, but it is ... Read More

Feed: The Internet of Things on AWS – Official Blog. Author: Ryan Burke. The AWS IoT platform enables you to connect your devices and build scalable Internet of Things solutions with the breadth of Amazon Web Services.When shopping for a new tool, many developers want to be able to test-drive options before making a choice. When evaluating an IoT solution, it’s not practical to do so at scale with physical devices. Building a sensor simulator is the next best choice. With a sensor simulator built on top of AWS Lambda, you can elastically generate device sensors that report their state ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: William Vorhies. Summary:  This may be the golden age of deep learning but a lot can be learned by looking at where deep neural nets aren’t working yet.  This can be a guide to calming the hype.  It can also be a roadmap to future opportunities once these barriers are behind us. We are living in the golden age of deep learning.  This is quite literally the technology that launched 10,000 startups (to paraphrase Kevin Kelly’s prophetic prediction from 2014 “The business plans of the next 10,000 startups are easy to ... Read More

Feed: Big Data Made Simple - One source. Many perspectives.. Author: Baiju NT. Amazon Web Services (AWS) is currently the most widely used enterprise cloud data storage system, successfully competing against similar services from the likes of Microsoft and Google. In this article, we look at what AWS offers and outlines how enterprises can cost-effectively match their enterprise data and applications to the right AWS service. Not so long ago, the only option enterprises had for data storage was to purchase, set-up and manage ever increasing private storage server farms, but there were clear drawbacks to this scenario. First of ... Read More