(Robert Sheldon) The job of retrieving data from Excel, and importing it into SQL Server hasn’t the same appeal or glamour as, for example, performing heroics with ill-performing queries. This could be why one hesitates before asking questions about how to do it.
Other News
SQL Injection, XML Injection, and LDAP Injection – CompTIA Security+ SY0-401: 3.5
(Professor Messer) Database security can sometimes be circumvented by poorly designed software. In this video, you’ll learn how SQL injection, XML injection, and LDAP injection can get data from the most secure databases.
OS Watcher Paging Example
(Bobby Durrett) I have an example of paging in some Exadata OS Watcher log files. We got an error in the alert log about a high load but reviewing AWR reports it did not seem like we had an unusual number of active sessions.
30 SQL Developer Tips in 30 Days, Day 4: Statement Execution
(Jeff Smith) A few quick things to remember:
RAC Database Backups
(Hemant K Chitale) In a RAC environment, the database backups can be executed from any one node or distributed across multiple nodes of the cluster.
pureScale ‘lite’ – just ‘rite’ for many customers!
(Iqbal Goralwalla) I recently wrote about the new Shadow tables feature in the DB2 10.5 “Cancun Release” and how it is so relevant to customers I have been working with who need to report directly on their transactional DB2 systems (http://bit.ly/shadow_tables).
Drag Drop Elements in ASP.NET MVC 5 using HTML 5, Web API and jQuery
(Mahesh Sabnis) HTML 5 can be used in ASP.NET MVC 5 applications to create some rich user experiences. This article shows how to use HTML 5 Native support for Drag-Drop in an ASP.NET MVC application. We also use Web API to pull data and jQuery to make Ajax calls.
I’m Your Big Data Problem: Integrate THIS!
(Rachel Bland) Let’s take a look at my profile. Gen X-er. Young kid, busy job, work-life integrated. I will not answer your online surveys, I won’t even answer the phone unless I know who it is because if you really knew me you’d send a text. I don’t listen to voice mail – too disruptive.
Build Context-Aware Apps with iBeacons
(Greg Shackles) One of the most powerful things about mobile apps is their ability to provide a customized experience for the user based on where the user is at any given moment — right here, right now.
Frozen SharePoint PSConfig Upgrade with SQL Server AlwaysOn
(Samuel Betts) If you have a SharePoint farm that uses SQL Server AlwaysOn and your upgrade is just never finishing, this article might be for you.