(Ryan Adams) This post has been sitting in the draft folder for way too long, March of last year to be precise. So although this is no longer new information, it has not been talked about all that much. I’m talking about the new feature in SQL Server 2012 that allows you to put TempDB on local sto
Author: SSWUG Research
Add an SQL query description to the SSMS tab name with the SQLComment add-in
(Sergey Vlasov) Many automatically opened SQL tabs in SQL Server Management Studio have names like SQLQuery1.sql, SQLQuery2.sql etc:
Technical: Microsoft – SQL Server – Analysis Services – Adding new dimension to an existing Cube, but ‘No go’
(Daniel Adeniji) Trying my best to get comfortable with Microsoft SQL Server Analysis Services; specifically Cube Browsing.
MDX Case Statement Examples for SQL Server Analysis Services
(Scott Murray) The Case statement exists in many programming languages and it is also available when writing MDX for SQL Server Analysis Services cubes. There are two types of Case statements that can be used in MDX; the simple case and the search case. In this tip we will cover how each of these
To Generate XML File from Datatable using LINQ
(puja11191) Using this simple code, you can generate XML files from database tables. XML files are very useful when it comes to transport data on the wire as they are platform independent. LINQ gives us a very simple way to generate XML files.
IBM PureApplication System backup and restore, Part 2: System backup
(Bobby Woolf and Tamiko W Brown) Part 2 in this series of articles that look at different aspects of backup and restore on IBM PureApplication System provides details for workload administrators on how to back up the workload catalog (patterns, and so on) and the data in applications running in the
Postgres 9.4 feature highlight: WITHIN GROUP and ordered-set aggregates
(Michael Paquier) PostgreSQL 9.4 is going to be shipped with a feature called ordered-set aggregates. This can be used with a new clause called WITHIN GROUP. All those things have been introduced by the following commit.
Too good for just an APAR Friday post; Set special registers using profiles
(Willie Favero) This is just so cool, it landed right in front of…. Wait, wrong story…
Using IBM Integration Bus In A .NET Environment – Working With Visual Studio
(Eric Berg) In my last post, I discussed some of the new features in IBM Integration Bus (IIB) that can help make life for the .NET developer easier. To add to those points, IIB embeds a Common Language Runtime (CLR) to invoke any .NET logic.
Why You Don’t Want to Code Validation in Before Commit
(Andrejus Baranovskis) You should know by now – there are many things possible in ADF, but it doesn’t mean every solution is right, even if it works. One example of such case – coding validation rules in beforeCommit method.