December 04, 2015

DBA Skills for developers

In many smaller companies or departments, there is no dedicated DBA. In these cases, it falls on *someone* in the office to get to grips with the blackbox that is the database server, keep it running and dive in when the things go wrong. The objective of this article is to give non data-focused developers a quick roundup of useful information and knowledge that will enable them to both solve some routine issues that come up and also help prepare for some in advance. This is not intended to be a very indepth article, rather its a quick read over coffee break that should give give the reader some useful starting points. I would be delighted if any more experienced DBAs out there would like to comment and help expand the list.


Technology Will Translate Brain Signals into Actions for Brain Injury Patients

While this is a great achievement for the team, the people involved in making it possible consider it just one of the many milestones that they will cover in future. They wish to add more features into this system so there is literally no difference in how a normal person browses on the internet and how a quadriplegic patient will. The coming milestones for the team would be when they are able to add the drag and drop feature to this system. The team will also be working on the multi-touch capability of the system. As of the moment, BrainGate clinical facilities are the only places where this equipment is available. As more programs are introduced and awareness is spread about this system, it will go in every corner of the world.


How CloudFlare is accelerating the web with HTTP/2

The main focus of both SPDY and HTTP/2 is on performance, especially latency as perceived by the end-user while using a browser, with a secondary focus on network and server resource usage. One main benefit is the ability to use a single TCP connection from browsers to a website, or in the case of CloudFlare, a reverse proxy. As such, CloudFlare is in the perfect position to provide the benefits of HTTP/2 to all CloudFlare users by accelerating the web surfing experience between clients' browsers and CloudFlare, without the need to change anything on the origin server.


9 enterprise tech trends for 2016 and beyond

InfoWorld’s David Linthicum recently suggested it was time to retire the phase “cloud computing” and simply say “computing.” That’s how essential cloud has become -- and why for the past couple of years cloud has framed my annual attempt to identify the nine key enterprise tech trends going forward. In 2015, it became a lot clearer what cloud infrastructure in all its scalable, self-service glory will be best for: running applications composed of microservices outfitted with RESTful APIs. Most likely those services will run in containers, which give developers more control than ever in building, testing, and deploying applications. Containers in turn support devops, where ops leverages new automation, instrumentation, and monitoring -- and devs take new responsibility for applications in production.


Using data-driven insights for transformational outcomes

In this environment, it’s entirely possible for an agency to meet or exceed transactional performance metrics while experiencing breakdowns in the system—whether it’s food stamps ending up in the wrong hands, millions of Medicaid dollars channeled to one doctor at multiple addresses, or a child who is seriously injured despite multiple visits by a child welfare agency. And when human service systems experience their worst failures, where it matters the most, it often becomes obvious that traditional performance indicators do not guarantee meaningful, mission-critical outcomes for the people who rely on these services. But this all-too-common pattern is beginning to change, thanks to the rapid proliferation of new technologies and methods, and the introduction of more sophisticated data analytics.


Wearables will be life-changing… but no ingestibles, thanks

“When you look at what the IoT devices need, they’ve got to have some sort of processing, they need connectivity and a lot of security, and our entire portfolio is built around these things,” Goel says. Goel is particularly excited about wearables, pointing me to research that suggests three-quarters of our bodies could end up being connected by various forms of technology. Thus clothed we can better see what’s in front of us and what’s around the corner, understand our bodies, risks and opportunities. Already we see watches, wristbands, heart monitors, eyewear and more and Goel expects a mixture of approaches in different markets. And those different approaches will all require different features, connectivity and power characteristics hence the wide variety of IoT protocols and proposed standards from Zigbee, Thread, Bluetooth variants, WiFi, Z-Wave, WeMo and many more.


Workforce Management for Human Capital Management

Out of necessity, workforce management software is evolving as an integral part of systems for business units and for human resources. Importantly, advanced workforce management systems typically include analytics that help management understand workforce performance; in our previous workforce management research 61 percent of organizations said that analytics is important to workforce management. ... Furthermore, analytics can guide executives and managers to improve decision-making and rectify issues that could be leading to increased costs and be out of compliance with regulations. Many organizations, however, are not prepared to undertake these efforts; they still use an array of spreadsheets or tools that are not synchronized with real-time data from workforce management systems.


The SQL Server 2016 Query Store: Overview and Architecture

The Query Store is a feature that can help us to troubleshoot query performance, as well as capturing query execution information, such as the number of executions or the average duration of a query. The Query Store also captures every Execution Plan that has been generated for a specific query and you can then decide what Execution Plan you want SQL Server to use for that specific query. ... it is important to understand that the Query Store is a complete new feature inside SQL Server 2016, which is only available as a preview version at the time of writing these articles. This means that information inside the articles can change when SQL Server 2016 is officially released. Personally I don’t think this is very likely at the moment, seeing how the Query Store functionality remained stable during the various CTP versions, but I’m obliged to give a warning.


A Multi-Tenant (SaaS) Application With ASP.NET MVC and ASP.NET Boilerplate

Event Cloud is a free SaaS (multi-tenant) application. We can create a tenant which has it's own events, users, roles... There are some simple business rules applied while creating, canceling and registering to an event. ... Entities are parts of our domain layer and located under EventCloud.Core project. ASP.NET Boilerplate startup template comes with Tenant, User, Role... entities which are common for most applications. We can customize them based on our needs. Surely, we can add our application specific entities. ... Here, we handle these events and send email to related users as a notification (not implemented emailing actually to make the sample application simpler). An event handler should implement IEventHandler<event-type> interface. ABP automatically calls the handler when related events occur.


IT asset management strategy: License compliance and beyond

Discovery tools operate using one of two basic technologies: either agent-based or agentless. With agent-based discovery, software needs to be loaded on every one of the assets. The tool queries the agent, and the agent is going to talk back to the discovery tool. With agentless discovery, there's no agent on the individual component. [Instead, you have] profiles built into the discovery tool that I am looking for a match to. So it detects that this box exists. And it then compares what it sees in the box to the profile list. And when it finds a match, it reports that as a particular asset. That's an Exchange server, that's a file server, that's a straight file server and that's on SQL Server. And then, you as the customer can add profiles over time, so that the tool finds more and more things on its own.



Quote for the day:


"Innovation is not about saying yes to everything. It's about saying NO to all but the most crucial features." -- Steve Jobs,