(Daniel Calbimonte) Sometimes we have a T-SQL process that we need to run that takes some time to run or we want to run it during idle time on the server. We could create a SQL Agent job manually, but is there any simple way to create a scheduled job?
Author: SSWUG Research
The power of MySQL’s GROUP_CONCAT
(Michael Rikmas) In the very early days of Percona Vadim wrote very nice post about GROUP_CONCAT.
Storing and Retrieving Image From SQL Server Database in WPF
(Kiran Kumar Talikoti) In this article we will see how to store an image into a database and retrieve the image from the database. In this article I will show how to store an image into a database in the form of an array of bytes and retrieve the array of bytes stored as an image from the database.
Aspect-oriented Programming and Code Contracts in ASP.NET MVC
(Dino Esposito) There are some aspects to application programming, such as logging, tracing, profiling, authentication and authorization that cut across the business objects. These are difficult to deal with in an object-oriented paradigm without resorting to code-injection, code-duplication or int
UI Practicalities: Determining the User’s Intent
(Peter Vogel) Last month, I discussed creating a Windows Form that allowed Schedule Managers (SMs) to manage work orders, with each work order consisting of multiple services.
SharePoint: News Translations in a Team Site
(Ellen van Aken) Another example of how some thinking and experience with SharePoint can solve those all-too-common business problems!
Doubly-Linked Lists and LinkedList
(Richard Carr) A linked list is a data structure that holds a sequence of values. In a doubly-linked list, each item in the collection includes a pointer to the previous and next elements. This allows insertions and deletions to be performed quickly and efficiently.
Caching The Rows Returned By An MDX Query
(Chris Webb) Here’s another tip for those of you struggling with the performance of SSRS reports that run on top of an Analysis Services Multidimensional cube. Quite often, SSRS reports require quite complex set expressions to be used on the rows axis of an MDX query, and one of the weaknesses of SS
sp_SrvPermissions & sp_DBPermissions V3.0
(Kenneth Fisher) These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data sets.
Arrays: Sort, Find Lowest, Highest, Most Frequent Elements & Reverse Order
(Ged Mead) Although I turn to generic collections more and more these days, there’s still a place for the trusty old array at times, so I thought I’d just look at a few things you can do with arrays.