(Kenneth Fisher) In my general quest to figure out the T-SQL to do common GUI tasks I did some browsing through BOL to find out how to detach a database. Dropping a database is easy enough.
Author: SSWUG Research
Meaningful Use and the Semantic Web
(Angela Guess) Jennifer Bresnick of EHR Intelligence recently wrote, “No one can reasonably deny that EHR adoption and meaningful use participation have been a struggle.
White spaces and Map Views
(Abhinav Agarwal) When working with Map Views, you can choose to collapse the map formats panel on the left.
Creating RESTful API’s with the APEX Listener
(Roel Hartman) In REST you model the resources, not the actions. So you define a GET /apex/oow13/hr/employees instead of a GET /apex/oow13/GetAllEmployees.
Restoring a SQL Server Database – A Practical Example
(satnam singh) Performing a Database Restore is a part of a DBA’s daily life. A DBA may need to perform a Restore due to various reasons such as recovery, refreshing a database for testing purpose etc.
Optimizing SQL Server Spatial Queries with Bounding Box
(Dmitri Korotkevitch) SQL Server supports two data types to store spatial information – geometry and geography. Geometry supports planar, or Euclidean, flat-earth data. Geography supports ellipsoidal round-earth surface.
Enabling crash-safe slaves with MySQL 5.6
(Stephane Combaudon) Being able to configure slaves to be crash-safe is one of the major improvements of MySQL 5.6 with regards to replication. However we noticed confusion on how to enable this feature correctly, so let’s clarify how it should be done.
Web Page Banner with Slides – JQuery
(Shashank Srivastava) Any website comes up to be more specific if its header comprises of an elaborative banner. The more it is sectioned into attractive and self explanatory sections, the more it is helpful in explaining the website to its visitor. The banner I intend to develop in this article con
Another DB2 11 gem you may not have noticed
(Willie Favero) Today we are going to focus on what DB2 11 has done to/for RUNSTATS…
TechTip: Six New Things You May Not Know About Java EE 7
(Joe Cropper) Java EE 7 was released in June 2013, and it represents the latest major release of the Java EE platform, which has certainly come a long way since the early days of J2EE. Java EE’s focus has always been on simplifying server-side enterprise applications, allowing developers to focus on