(Julie Smith) This is a MONSTER long post. The main point of this post was to give you guys some T-SQL code which can be used against the information schema view of a SQL Server table destination to spit out a complex SSIS Expression. While that was the point of the post, I felt like I also needed t
Author: SSWUG Research
C# via Java: Arrays
(Simon Cooper) The one primitive type that hasn’t been covered is the array. An array contains a fixed number of items, and each item is a value of the array’s element type. The array elements are individually indexed starting from zero.
ASP.NET Identity with the Entity Framework
(K. Scott Allen) In a previous post (Core Identity), we saw how the .Core identity assembly provides interfaces for describing the data access needs of a membership and identity system. Core also provides a UserManager class with the domain logic for identity management.
Reflecting ref and out Parameter Information
(Richard Carr) Methods and their parameters can be examined using reflection to obtain detailed information about their use. When reflecting method parameters, it may be necessary to determine if they are reference or output parameters.
Aggregating By Local Groups In Power Query
(Chris Webb) When looking through the Power Query library reference I noticed that the Table.Group() function has a very useful option to aggregate data using what it calls local groups. Rather than explain what this does, let me show you…
Loading Scripts with jQuery
(David Walsh) JavaScript loaders are incredibly powerful and useful utilities. I’ve even covered a few of them on this blog, like curljs and LABjs, and have used RequireJS and the Dojo loader on personal projects. They’re super powerful but can be overkill in some cases.
Oracle SQL Developer 4 and the Oracle Client
(Jeff Smith) You don’t need to have an Oracle Client installed on your machine to use Oracle SQL Developer. Everything you need to connect to Oracle Database is provided by the JDBC driver included with the download. So you can be up and running in usually less than 5 minutes.
ALTER Operations Restricted in DB2 11
(Troy Coleman) DB2 11 introduces new restrictions that limit the types of ALTER operations that can be conducted on an object.
IBM Cognos BI 10.2.1 Reporting on IMS
(Richard Tran, Sachchidanand Singh, Poonam Chitale and Tushar Patil) The IBM IMS database stores data using a hierarchical model which is quite different from the relational databases like IBM DB2. A typical IMS database stores the data using blocks called as segments & each segment can contains sev
It’s Obvious. It’s in the Data.
(Bill Cole) You’ve had that experience, right? Somebody says that the answer is in the data so you look harder and all you see is stuff. There’s not a pattern within a grenade blast of this data. Maybe if you had a bit more time you’d find it. Or maybe having the data in the right format would m