Welcome to CedarLogic, LLC - Shawn Cicoria Sign in | Join | Help

Shawn Cicoria - CedarLogic

Perspectives and Observations on Technology

News





  • Unity08.com

Browse by Tags

All Tags » SQL   (RSS)
Learning LINQ - No excuses
There are really a whole bunch of great resources out there that help the community get up & running with LINQ. Personally, with all the additional providers that I've seen ( Qak Leaf List ) - several of which I see great use for - LINQ to SharePoint Read More...
Extract DDL and Data - SQL Server Database Publishing Wizard
Here's a tool that completely slipped by me.  I've been using ApexSQL for generation of SQL scripts for creating schema and data. Turns out, during the Visual Studio 2008 installation I see "SQL Publishing Wizard" pop up on the list. This Read More...
Query SQL (or any LINQ Provider) Using LINQPad...
Here's a cool tool that provides an interactive LINQ environment that you can use to develop queries against LINQ sources (SQL, Objects, XML, etc.). If you're working with LINQ and need an environment that supports both expression and language statements Read More...
How to get a list of SQL Procedures, Functions, Views that have recently change?
Today, I needed a quick view of what objects in a SQL DB had changed. The following get's me that in a nice list: SELECT [name], [type], create_date, modify_date FROM sys.objects WHERE [type] in ('P', 'FN', 'V') order by Modify_Date desc Read More...
Google's entry into "SmartClient" - offline client ability
So, I was looking at Google Reader and noticed a link in the upper right - Offline (new).. What's that? Turns out, Google has a project called "Gears" that provides Javascript hooks that will interface with a few locally running services: Cache, DB, and Read More...
UN Website Hacked using simple SQL Injection
This is what happens when you skimp on resources for projects, take shortcuts, and frankly, hire amateurs. So many times I've shown up on projects and client sites, take a quick look at the code, then see how vulnerable a site is with injection attacks. Read More...
LINQ an aid to FoxPro (dBase, Clipper...) folks...
I didn't really think of the connection until I read this post from the Oak Leaf folks... http://oakleafblog.blogspot.com/2007/04/linq-featured-in-redmond-developer-news.html dBase, then Clipper (from Nantucket) was my first development environment on Read More...
LINQ for NHibernate...
Here, in the continued foray into LINQ and the 3.5 (Orca's) release, is an implementation of LINQ over NHibernate. http://ayende.com/Blog/archive/2007/03/16/Linq-for-NHibernate.aspx Oren Eini provides a starting point, if not a great example of how LINQ Read More...
LINQ is seemingly more powerful than simple ORM
It seems the LINQ guys have done a great job of optimization inside of the LINQ namespace (System.Linq). http://blogs.msdn.com/jomo_fisher/archive/2007/03/28/fast-switching-with-linq.aspx If you take a look at this post, then subsequent comments and a Read More...
Accessing Application Configuration Settings from SQL CLR
http://www.cicoria.com/cs1/blogs/cedarlogic/archive/2006/04/22/204.aspx Read More...
Article on SQL .NET CLR - Application Configuration Settings Posted to SqlJunkies.com
An article I wrote a couple weeks back has been posted to www.Sqljunkies.com Accessing Application Configuration Settings from SQL CLR Recently, one of my peers asked a question regarding the ability of SQL CLR classes to read configuration data from Read More...
Microsoft Exception MessageBox - Nice little gem
If you're developing WinForm applications, generally at some point in the project you develop an Exception Dialog box that provides a user friendly interface for error messages. Usually, it's a generic box that displays parts of the exception stack and Read More...
Accessing Application Configuration Settings from SQL CLR
Recently, one of my peers asked a question regarding the ability of SQL CLR classes to read configuration data from an Application Configuration file. After doing some quick Google searches on the topic, I came up with a couple of links that indicated Read More...
Bunch of New SQL Server 2005 Downloads including SP1
The first SP for SQL 2005 is here along with a bunch of add-on tools mostly focused on the express version. So, for those IT folks that state “I never install any MSFT product until the first SP is out” – well it’s out. Time to Read More...
Browser Based AJAX SQL Designer
WWW SQL Designer . Very cool Web based SQL Designer that leverages AJAX for the UI. Very impressive tool that is helping make me an even bigger believer in what AJAX can do for web based UI. Read More...
More Posts Next page »