Browse by Tags
All Tags »
SQL (
RSS)
During hierarchy changes, MDS provides some basic rules for validating hierarchy members against some logic that is defined in the model within the MDS interface or through the Services interface. Behind the scenes, MDS is generating all sorts of...
I run my development server by boot to VHD (Windows Server 2008 R2 x64). In that instance, I also have an attached VHD (I attach via script at boot up time using Task Scheduler). That VHD I have my SQL instances installed. So, the other day...
There have been many times that I’ve been handed a SQL instance that doesn’t allow me to do much with it even though the IT Admin for the machine have indicated they’ve done the install and your AD account is part of the Local Admin group. By default...
Cloud services that is. Windows Azure, .NET Services, Live Services…. If you looking for the spoon fed variety of information, a bunch of HOWTO vides have been released – see below. These are small little “nuggets” – like those MSDN Nuggets out...
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...
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...
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...
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
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...
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...
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...
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...
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...
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...
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...
More Posts
Next page »