DatabaseJournal.com Staff

By Scott Rosenberg, CEO, Miro Consulting, Inc. The arrival of Microsoft’s SQL Server 2012 in April was greeted with much fanfare, and more than a little concern. Many are concerned about SQL Server 2012’s impact on their budgets, virtualized environments and the new licensing model. Having a well-rounded overview of the changes and how to […]

In addition to Big Data, Microsoft introduced components for integration, analysis and better reporting in SQL Server 12. Along with new features that provide greater availability and improved query response, Microsoft claims SQL 2012 query execution is up to 100 times faster than previous versions. SQL Server 2012 also facilitates cloud deployments. The new system […]

Keesa Bond describes her technical interests as being those of an investigative Data Scientist. Throughout her career in academia, Keesa has found creative ways to use technology to make data more meaningful for those it should serve. She knows that the stories that data can provide are there, but realizes that data inaccuracies often […]

SAP is scaling up its database efforts, including the in-memory HANA and Sybase database technologies. During a press conference this week, SAP announced that the SAP Business Warehouse will now be powered by SAP HANA. Vishal Sikka, executive board member for Technology and Innovation at SAP said, “Business Warehouse on HANA is a non-disruptive, dramatic […]

By: Eric Farrar Today’s applications are big. With hundreds of thousands of users, many of whom are uploading content regularly, the size of the data store can grow massive in short order. Not surprisingly, for data architects, scale is a real concern. At companies with global internet reach, such as Google and Facebook, NoSQL—a new […]

by Robert D. Schneider Introduction The infrastructure that bolsters today’s IT environments must contend with more complexity than ever before, such as mixed workloads and virtualization, along with the unique benefits and demands presented by parallelized hardware. As usual, the burden of delivering a well-performing, scalable data processing environment falls on IT administrators and architects. […]

by Amit Satoor We are living in the age of exponential data volume growth where trillions of transactions, events or activities are generated through the use of online trading, online shopping and the use of mobile devices. The global economy is creating large volumes, as well as variety, of data at an increasingly faster pace. […]

>>Script Language and Platform: SQL Server Creating Excel using TSQ-L. Author: Rahul Vairagi PRINT ‘Begin CreateXLS script at ‘+RTRIM(CONVERT(varchar(24),GETDATE(),121))+’ ‘ PRINT ” GO SET NOCOUNT ON DECLARE @Conn int — ADO Connection object to create XLS , @hr int — OLE return value , @src varchar(255) — OLE Error Source , @desc varchar(255) — OLE […]

by Robert D. Schneider Introduction Three stark operational realities afflict any enterprise reliant on database technology to thrive in today’s highly dynamic, complex business landscape. First, supporting globalized activities means that there is no longer any “slack time” when maintenance can be performed without impacting users or customers. Secondly, largely in response to the demands […]

By Robert D. Schneider Thanks to the tremendous expansion of audio, video, images, XML documents, and other fresh data sources, modern applications must now contend with vastly larger amounts of information – much of which is semi-structured or even unstructured. This opens the door to new and inventive applications capable of extracting value from all […]

David Fitzjarrell has more than 20 years of administration experience with various releases of the Oracle DBMS. He has installed the Oracle software on many platforms, including UNIX, Windows and Linux, and monitored and tuned performance in those environments. He is knowledgeable in the traditional tools for performance tuning – the Oracle Wait Interface, Statspack, […]