(Robert Sheldon) There are more than ten useful command-line applications that are either associated with, or are distributed with, SQL Server. Some, like BCP are used often, whereas others like LogDumper, almost never. However, they all have their uses and several become important as part of script
Author: SSWUG Research
Introduction to Bootstrap: A Tool for Building Responsive, Mobile-First Projects
(Bipin Joshi) With the increasing popularity of mobile devices, web developers are required to think about their website design for mobile devices from the beginning of a development project. Developing web applications targeting multiple devices can be challenging.
New Technote on expanded RBA/LRSN and new Redbook for DB2 11
(Willie Favero) It’s Monday and this week is already off to a good start. Today a Technote (FAQ) covering the DB2 expanded RBA and LRSN and a Redbook that discusses transaction monitoring and tuning in DB2 11 were announced.
Automating DataPump Export
(Michael Dinh) What’s the most elaborate thing you have done with DataPump?
SQL Server Analysis Services Discretization
(Scott Murray) Discretization is a neat tool for assisting SSAS developers especially when dealing with dimension attributes which have a large number of members. Discretization is a derivative of discrete, and basically means creating a discrete set of values based on a continuous group of values.
Tiny XML Serializer for C++
(Lothar Perr) I was looking for a lightweight and easy to use XML Serialization library for C++.
Postgres 9.4 feature highlight: LSN datatype
(Michael Paquier) In PostgreSQL terminology, an LSN (Log Sequence Number) is a 64-bit integer used to determine a position in WAL (Write ahead log), used to preserve data integrity. Internally in code, it is managed as XLogRecPtr, a simple 64-bit integer.
Windows Azure Gets .NET Upgrades
(Keith Ward) Windows Azure has gotten a ton of upgrades in its latest release, including a bagful of goodies for .NET Framework developers, especially in the area of Mobile Services.
SQL SERVER – Listing Primary Key of Table with Stored Procedure sp_pkeys
(Pinal Dave) Here is a follow up blog post of my earlier blog post on very similar subject Listing Foreign Key Relationships of Table with Stored Procedure sp_fkeys. In previous blog post we listed foreign keys and now we will list the primary key of the table with the help of Stored Procedure sp_fk
ORA-04098
(Andrew Reid) I noticed this recently on an Oracle 11.1.0.6.0 database.