Browse by Tags

All Tags » SQL Server   (RSS)
Test Twitter Notifier from Live Writer
Trying out the Twitter Notifier using Live Writer.  Found in the Live Writer SDK for Technical Preview .  This should show up on my Twitter feed . Read More...
Posted 30 June 08 02:50 by ryanm1201 | 0 Comments   
Filed under , , , , , , , , , ,
Nuggets from Working with Large Lists White Paper
Other than the obvious benefit of learning the best methods for dealing with large lists, there are a couple related nuggets covered in the white paper titled Working with Large Lists in Office SharePoint Server 2007 (discovered from the SharePoint Product Read More...
Posted 26 July 07 08:21 by ryanm1201 | 1 Comments   
Filed under ,
Using a CTE for Heirarchical Query
A project I did a few years back was for a large company with thousands of employees. The project was essentially building a system to allow managers to evaluate employees and give them quarterly bonuses. We had to take raw data out of a PeopleSoft repository Read More...
Posted 06 January 05 02:11 by ryanm1201 | 0 Comments   
Filed under
MyGeneration Released
On another project at my current client the developers decided to use a code generation tool to help them save some time. They ended up using MyGeneration , which at the time was in beta, to read their SQL database and generate the DAL. I noticed the Read More...
Posted 05 January 05 05:27 by ryanm1201 | 0 Comments   
Filed under ,
SCHEMABINDING Option
I've never run into the situation where I was worried about a table being accidentally dropped (maybe I should have been?) as I usually let a good security model restrict that. But, accidents do happen. So, if I ever need to make sure a table isn't dropped Read More...
Posted 27 December 04 08:55 by ryanm1201 | 0 Comments   
Filed under
Conditional JOIN's
A co-worker asked me earlier today if there was a way to do a conditional join. Meaning he had two tables and he wanted to join to one or the other within his query, depending on the value of a variable. The two simplest ways to accomplish this are to Read More...
Posted 09 December 04 12:33 by ryanm1201 | 0 Comments   
Filed under