Geeks With Blogs

Lance's TextBox » About Me » My Resume »Twitter SQL There are 11 entries for the tag SQL
ADO.NET Entity Framework – Code First Development Pattern
Here’s a quick start introduction to the ADO.NET Entity Framework Code First Development Pattern. For a more complete (but still intro) walkthrough, check out ScottGu’s blog. At the time of this writing, you’ll need the EF 4.1 Release Candidate. After EF 4.1 is released you’ll no doubt be able to find it on the ADO.NET team blog. 1. Create a new empty ASP.NET MVC2 Web Application, add a reference to System.Data.Entity. If using the EF4.1 RC - add a reference to the EntityFramework dll that comes ......

Posted On Thursday, April 14, 2011 3:42 AM

Dynamic Configuration of Log4Net
I needed to dynamically configure log4net – outside of the web.config file. Here is my solution: 1. All that configuration of log4net in web.config? Forget it. 2. Create a separate log4net.config file (name it whatever you want), with the usual configuration content in it defining whatever appenders you want. For example if you want a rolling file log: <log4net> <appender name="RollingLogFileAppender" type="log4net.Appender.Roll... <param name="File" value="C:\\Temp\\mylog.txt" ......

Posted On Friday, August 13, 2010 7:18 PM

SQL - Get all columns for distinct email address
Wow. I was trying to create a SQL query in which I could retrieve all the information from a table, but with only 1 result per distinct email address. You can't do this with distinct, since distinct works on all the columns. Here's what I ended up with, after a little help from the bytes.com forums. SELECT TIME, NAME, EMAIL, COMPANY, TARGET, TITLE, PHONE, LEARN FROM RSSBUS_DOWNLOADS AS y1 WHERE (TIME IN (SELECT (SELECT TOP (1) TIME FROM RSSBUS_DOWNLOADS AS y2 WHERE (EMAIL = emails.EMAIL)) AS TIME ......

Posted On Friday, February 26, 2010 3:59 PM

10 DIY SharePoint Web Parts #3
This post is the third in a series of postings, containing examples of SharePoint WebParts that anybody can build all by themselves. To read all posts in this series, or to get started with the RSSBus WebPart, go here. #3 – Custom SQL Queries This web part will perform a custom SQL query, and allow you to display them however you like. Unlike previous examples, this one won’t be just cut and paste, since you’ll have to provide your own SQL connection string and query, and make replacements inside ......

Posted On Tuesday, July 14, 2009 9:30 AM

10 DIY SharePoint Web Parts
10 DIY SharePoint Web Parts 10 DIY SharePoint Web Parts is a series of postings containing examples of SharePoint WebParts that anybody can build all by themselves. These examples will require the use of the highly acclaimed RSSBus SharePoint WebPart. The RSSBus SharePoint Web Part isn’t like most others – it cannot be called a uni-tasker. It is the most exciting thing I’ve had the pleasure to work with in quite a while... its just a thing of beauty. What does it do? It lets you expose data to SharePoint ......

Posted On Monday, June 29, 2009 3:44 AM

SharePoint Admins – You Dont Want to Miss This
The RSSBus SharePoint Web Part might just be the most exciting thing I’ve had the pleasure to work with in quite a while. RSSBus is an amazingly powerful product, but the RSSBus SharePoint Web Part…its just a thing of beauty. What the web part does: it lets you expose data from just about anywhere inside SharePoint. The simplest example is to show an RSS feed like Google News or Yahoo News. I tweeted about that last week. I put together two more simple examples. One is using my Twitter Search RSS ......

Posted On Friday, February 6, 2009 5:04 PM

How to Execute SQL PowerShell Commands Anywhere
SQL Server 2008 PowerShell Cmdlets + /n software PowerShell Server v2 = Execute SQL Queries Anywhere. If you don’t already have the SQL cmdlets for PowerShell, you’ll need to download and install SQL Server 2008. A warning for those of you running on x64 machines - you’ll have to export the SQL Server keys in HKEY_LOCAL_MACHINE\SOFTWARE... (there should be 2 in PowerShellSnapIns and 1 in ShellIds) and reimport them to Wow6432Node. If you don’t already have /n software’s PowerShell ......

Posted On Monday, December 22, 2008 3:13 PM

SQL Server to Excel
With RSSBus, right out of the box you can run a SQL query on an Excel sheet using the excelQuery operation. If you create a little RSSBus script, you can also perform queries on SQL Server, Access, or other database sources and pipe the results into Excel: <!--hard-code some inputs to sqlQuery: --><rsb:set item="myinput" attr="query" value="SELECT TOP 20 * FROM Customers" /><rsb:set item="myinput" attr="conn" value="Data Source=localhost\\SQLEXPRES... Catalog=Northwind;" /> ......

Posted On Tuesday, August 7, 2007 4:47 PM

RSSBus as a mashup tool
Raymond Yee wants to know how well RSSBus works as a mashup tool. While its true that RSSBus offers a lot of connectors that make it easy to mashup data coming from sources like Flickr, Amazon, and pre-existing RSS feeds - its also important to know that RSSBus is not only valuable as a mashup creation tool. One of its biggest uses is on the flip side of the coin - helping sources expose data in the first place. Without companies like Flickr and Amazon exposing their data in structured formats like ......

Posted On Friday, May 25, 2007 10:00 AM

Slicing and Dicing web data
Yesterday Jon Udell wrote about slicing and dicing, and then rewiring the web. Reusing websites as data sources is great - and Yahoo Pipes provides several such "sources" in Yahoo Search, Yahoo Local, Flickr, Google Base, and the basic URL Fetch. All these are great and provide interconnectivity and the ability to slice and dice certain parts of the web. But why stop there? The beauty of this annotating, slicing, and dicing, is in the reusability of this data - not just for reading blogs - but for ......

Posted On Tuesday, February 13, 2007 11:55 AM

Activemodules.com
I run an old DotNetNuke 2.11 website that uses the NTForums module from Active Modules, Inc. NTForums is actually outdated and the current product has be rebranded as Active Forums. Active Forums supports DNN 3.1, 3.2, 3.3, 4.0, and 4.3. The only reason I haven't installed the upgrade yet is that I keep having trouble with the DNN upgrade itself (not the module upgrade). Last night I had some trouble with a sql injection (fun times!). Luckily, the injected script was basically harmless, just annoying. ......

Posted On Wednesday, September 13, 2006 5:45 PM

Copyright © Lance Robinson | Powered by: GeeksWithBlogs.net