(Peter Vogel) If you’re using the Windows Forms DataGridView and loading data into columns by pulling that data out of properties on objects, you should know that there’s an easier way. Just create a List of your objects and use that List to set the DataGridView’s DataSource property.
Author: SSWUG Research
Rethinking Compression
(Tom Rieger) The preponderance of big data and the capability to effectively collect, organize, and synthesize key data into information for analysis and query has managed to bring unprecedented challenges on existing relational database management systems.
Embed a PowerPoint Presentation into a SharePoint 2013 Page
(Chris Clark) Office Web Apps (as part of SharePoint 2013) allow SharePoint users to view and edit Office documents (Word, PowerPoint, Excel etc.) from within the browser.
SQL 101 – Group by ROLLUP
(Scott Wesley) One of the reasons I called renamed this blog grassroots-oracle was to occasionally illustrate some simple examples of functionality not everyone is aware of – or are maybe too scared to give it a go (or research).
Creating Cascading DropDownLists using ASP.NET MVC 4 and jQuery
(Bipin Joshi) Sometimes you need to display DropDownLists in your ASP.NET MVC views such that values in one DropDownList are dependent on the value selected in another DropDownList. The most common example of such a functionality is countries and states DropDownLists where based on a selected countr
An Approach to SQL Server Index Tuning
(Susan Van Eyck) Well-constructed indexes can greatly improve read performance in SQL server, but they can be costly to maintain. There’s the obvious cost of additional time for your periodic index maintenance (rebuilds, reorganization and updating statistics) and the cost of additional storage, but
What’s New in Entity Framework 6.0 RC1
(Pravinkumar Dabade) In this article, we will talk about some of the new features introduced in Entity Framework 6.0 RC1.
Why Your Business Needs To Get Going With Linked Data
(Jennifer Zaino) Any data-driven industry – and these days, that’s almost all of them – knows the challenges around bringing together data from many systems and from across many years to make use of it. There’s too much focus on making copies and transforming information, rather than getting value o
Q&A From ‘5 Ways to Improve Performance through Indexing’
(Jason Strate) A few weeks back spoke at a Pragmatic Works Training on the T’s on indexing that was titled 5 Ways to Improve Performance through Indexing. The abstract for the sessions is:
What’s new in 12c: Adaptive joins part 2
(Maria Colgan) In our earlier post on adaptive joins we explained how this new 12c functionality works and said we would follow up this post with a real-world demo.