My favorite Open Source tools for Dot Net are NHibernate, NUnit and Log4Net. There are others I use. But these three seem to always be in nearly every application I write. What’s funny is that there are a lot of tools similar to these three. In fact, Microsoft has copied all three of them in one fashion or another. Entity […]

The USA has a reality game show called Survivor that has been going on for a few years. The point of the game is to take a number of people from different walks of life, strand them in an isolated location with nothing but themselves to provide food and shelter. Frequently they players had to vote someone to send out […]

From Wikipedia, http://en.wikipedia.org/wiki/Coopetition Coopetition occurs when companies interact with partial congruence of interests. They cooperate with each other to reach a higher value creation if compared to the value created without interaction, and struggle to achieve competitive advantage. Often coopetition takes place when companies that are in the same market work together in the exploration of knowledge and research of […]

The Multi-Tennant capability of Oracle 12c has been available for some time now. This technology is really cool, and to my knowledge, not available in any other SQL database engine. At a high level, how this works is you create a Container database in Oracle 12c. Once the container is created you can add separate database instances of the same […]

John shares with us a few queries he uses, and would like to pass on to our readers. John writes: Concerning your scripts for creating a comma separated list from a single field: This is what I do to perform the same functionality. It is a bit more robust I think since I am also formatting the data a bit, […]

Let me start out by saying I came across the following syntax while reading a forum on building dynamic SQL. I can’t find the address right now; but I would like to share the syntax letting you know it is not unique to me. I love SQL that uses a variable to build something based on a set of data […]

Most Information Technology professionals agree that you use the best tools to get the job done. Sometimes the tools you need are already believable from open source or commercial packages. Many times you can deploy a pre-developed package implementing it with your own configuration. For example, Sales Force is a popular CRM package you can purchase; or you could use […]

This is one of my favorite topics when it comes to writing SQL Queries because it utilizes my favorite data dimension, time. A rolling window is a virtual window of time from a specific starting point. You can have a rolling window of years, quarters, months, days, hours, minutes, seconds. You get the point. So, in order to have a […]

There is an incredible, and growing, amount of data available to you through the SSWUG site. Sometimes you may find it difficult to find content you know exists. I thought I would share a couple tips that helped me find some content for a reader today. First enter your search terms in the “Search SSWUG ORG” text box on the […]

Ed Writes: In a different slant on cross-database operations, we are looking for the best ways to split a database into two where some of the stored procedures use tables from both databases and there is the need for referential integrity with tables in the other database. The reason we would do this? To split the application configuration away from […]