(Robert Sheldon) Microsoft has released the first public Community Technology Preview (CTP) of SQL Server 2014. Not surprisingly, the CTP introduces many of the new features that will be available in the final product.
Author: SSWUG Research
SQLCMD – Database Backup and Restore – Automation – Quickest and Simplest method
(Prashanth Jayaram) In today’s world we rely more on third party tools to do a Backup and Restore of databases. Most of us still use SQL Native method to do a Database Backup and Restoration.
SQL Server – Get SQL Server Service Account using T-SQL
(Vishal Gajjar) SQL Server service account information is stored in Windows Registry database. You can get this information from Services Console or SQL Server Configuration Manager.
Scalar Subqueries in Oracle SQL WHERE clauses (and a little bit of Exadata stuff too)
(Tanel Poder) My previous post was about Oracle 12c SQL Scalar Subquery transformations. Actually I need to clarify its scope a bit: the previous post was about scalar subqueries inside a SELECT projection list only (meaning that for populating a field in the query resultset, a subquery gets execute
Regular Expressions Basics: (8) Repetitions, (Part 1)
(Ged Mead) From what I’ve covered so far, you might think that if you wanted to find a match for six consecutive digits, you would use something like:
Managing your InfoSphere Streams cluster with IBM Platform Computing
(Mike Branson) Today, the challenge for many organizations is extracting value from the imposing volumes of data available to them. Tackling the big data challenge can fundamentally improve how an organization does business and makes decisions. But managing your big data infrastructure doesn’t have
Offline Capture
(Dermot O’Neill) Sometimes its not possible to directly connect over JDBC to a database your want to migrate to Oracle.
Read XML file with LINQ to XML
(Nikolay Zahariev) The xml file I will use for the example is as follows:
SQL Server 2012 Analysis Services (SSAS) DMVs
(Scott Murray) What are the SQL Server Analysis Services (SSAS) 2012 DMV’s and how can they be used?
SQL Server T-SQL Tips & Tricks
(Arash M. Dehghani) Today everyone is talking about NoSQ, but SQL is still an essential language that every programers should know enough about it as same as JavaScript and XML. MS SQL Server is a SQL engine that enables programmer to forward all data-related processes and worries to it, and just in