Register
Login
    #ClustrMaps       Minimize  

Locations of visitors to this page

Locations of visitors to this page

             
    #MCP       Minimize  

             
...
...
    FAQs       Minimize  

When I first started this website a couple of years back, most content was entered in the form of a Blog -- which was a good solution for entering things as they happened.

Unfortunately, Blogs are not the easiest mechanism to find information within. Search is ok -- but not great.

In that end, I've assembled a FAQ below, to write summary notes into, and sometimes refer back to longer blog posts that I've written in the past.

 

Note:
Over XMas 2010 I implemented a new FAQ Module: I had to rush a bit getting the data out of the old FAQs and into this new Ajax based solution, and things shifted in transit, and some formatting issues/ajax timeouts have shown up....with my work schedule, I suspect it will take most of 2011 Q1 to get them all ironed out.

In the meantime, you'll have to bear with taking the chaff with the wheat....

When I first started this website a couple of years back, most content was entered in the form of a Blog -- which was a good solution for entering things as they happened.

Unfortunately, Blogs are not the easiest mechanism to find information within. Search is ok -- but not great.

In that end, I've assembled a FAQ below, to write summary notes into, and sometimes refer back to longer blog posts that I've written in the past.

 

Note:
Over XMas 2010 I implemented a new FAQ Module: I had to rush a bit getting the data out of the old FAQs and into this new Ajax based solution, and things shifted in transit, and some formatting issues/ajax timeouts have shown up....with my work schedule, I suspect it will take most of 2011 Q1 to get them all ironed out.

In the meantime, you'll have to bear with taking the chaff with the wheat....

             
Blogs are very useful - but sometimes hard as heck to pinpoint something that is used over and over again.
Hence this FAQ which I fill with information that needs to be refered often.

How do you use OSQL or SqlCmd to sign in to SQL Server from the command line?If I've dropped a DB which used to be my default Db, and I can no longer login, can I solve it?What are Delegates, and how do I use them?What are "Automatic Properties"?What are Automatic Object and Collection Initializers?What are Extension Methods?What are Implictly Typed local variables (the var keyword)?What are Anonymous Types?What are Anonymous Methods?What are lambda expressions?Best Practice: Default to sealed classes, and only remove that when you start to add the virtual keyword to methods.Use the Non Virtual Inferace Pattern.What is a Software Developer?What is an Application Programmer?What is a Systems Analyst?What is a Systems Software Analyst?What is a Software Analyst?What are the namespaces that have to be defined at the top of the XAML files?What's the format for Margin, Padding, etc.?What do I need to know about Properties, and the new Dependency Properties?How do I bind the value of a DependencyProperty to something else?How do I add a ToolBox Icon to a custom control?Regarding ASP.NET: So -- again -- what are the designer attributes for custom controls???How do I reference usercontrols in other the same assembly (or others?)What options do I have for Bindind in WPF XAML?What's the relationship between DependencyObject, UIElement, and FrameworkElement?How do I work with Styles?How do I use Styles with controls?How do you define a Resource Brush or GradientBrush?What's up with GridUnitType.Star (*) notation, and how do I size columns based on Percentage (%) anyway?How do I apply Transformations to an object?Is there anything in XAML similar to HTML Textos?How do we give tooltips to things? And can we customize them?How do I trap the right click?What's the DataGrid, where do I get it, how do I use it?Can I write my own custom MarkupExtensions?How do I do Triggers in Silverlight?How do I add a ToolBox Icon to a Custom Control?How do I expose .NET methods to JScript?How do I add Line returns toa TextBlock?How do I trap double clicks?What should I know about the object param'sWindowless property?Where's the DropShadow, OuterGlow, Bevel and Blur effects (ie BitmapEffects)?No {Binding ElementName=...} ?!?!3D?What's the difference between IEnumerable, ICollection, IList, and IDictionary?How to I use the XmlSerializer?What's different about DataBinding?How do I work with ObjectDataProvider?What's the relationship between DependencyObject, Visual, UIElement, FrameworkElement, Control, etc.?In SL1.1 there was no CompositionTarget.Rendering...what about SL2.0?Where can I learn about the Visual State Manager?How do I use the StackPanel so that the last element fills up all the remaining space, rather than them all bunching up on one side?Where is the WrapPanel?Any ideas on how to work with WCF?Unsorted links:What's the difference between IsSubClassOf() and IsAssignableFrom() ?What is a Business Object (sometimes called a Domain Object)?What's the difference between a Layer and a Tier?How should I design my application Layers?What is a Data Transfer Object (DTO), and how does it relate to a Business Object?Do Icreate theIDbParameters in the Business Logic Layer or the Data Access Layer?Is it ok for DAL methods to return an IDataReader orIDataRecord?What is a Value Object (VO)?What is a POCO object?Is there a way to instantiate a single DataRow?What is a Data Access Component?Is there a good tutorial on using Typed DataSets?Are DataTables serializable?Are there strong arguments against using DataSets/DataTables for returning data from DAL to BLL, rather than DTOs?How do I use the BinaryFormatter or SoapFormatter?What WCF bindings does Silverlight support? Can I use WSHttpBinding?What does aSilverlight clientServicesReference.ClientConfig file look like?Where can I learn more about cross domain restrictions?How to I get Sessions to work for WCF?How can I add a custom header to every WCF operation?Where can I find a MenuItem to get started?When using WCF, how do I use the same Business Objects (BO) on both the Server and Client?How do I create a Templated Control?Is there a good Control LifeCycle chart?How do I set the Z-Index?What about a LicenseManager?Using NInject...How do I use SqlCmd to log on?How do I list the *mounted* databases?How do I mount and unmount databases?How do I switch databases?What are the default system databases and what are they for?How do I list the tables in a database?How do I create a new table?How do I do a quick backup?How do I do a backup when RecoverMode=Simple?How do I do a backup when RecoveryMode=Full?How do I restore a database?How do I load *.sql scripts?Should I initialize variables on declaration, or in the constructor? (Answer: On Definition)What is RendezVous Model and Asynchronous Programming Model (APM)?What is Windows Network Load Balancing (NLB) and how do I set it up on Windows Server 2008?What isa quick summary of the"Active Record" Pattern?What is a quick summary of the "Application Controller" Pattern?What is a quick summary of the "Associate Table Mapping" Pattern?What is a quick summary of the "Class Table Inheritance" Pattern?What is a quick summary of the "Client Session State" Pattern?What is a quick summary of the "Coarse-Grained Lock" Pattern?What is a quick summary of the "Concrete Table Inheritance" Pattern?What is a quick summary of the "Data Mapper" Pattern?What is a quick summary of the "Data Transfer Object" Pattern?What is a quick summary of the "Database Session State" Pattern?What is a quick summary of the "Dependent Mapping" Pattern?What is a quick summary of the "Domain Model" Pattern?What is a quick summary of the "Embedded Value" Pattern?What is a quick summary of the "Foreign Key Mapping" Pattern?What is a quick summary of the "Front Controller" Pattern?What is a quick summary of the "Gateway" Pattern?What is a quick summary of the "Identify Field" Pattern?What is a quick summary of the "Identity Map" Pattern?What is a quick summary of the "Implicit Lock" Pattern?What is a quick summary of the "Inheritance Mappers" Pattern?What is a quick summary of the "Layer Supertype" Pattern?What is a quick summary of the "Lazy Load" Pattern?What is a quick summary of the "Mapper" Pattern?What is a quick summary of the "Metadata Mapping" Pattern?What is a quick summary of the "Model View Controller (MVC)" Pattern?What is a quick summary of the "Money" Pattern?What is a quick summary of the "Optimistic Offline Lock" Pattern?What is a quick summary of the "Page Controller" Pattern?What is a quick summary of the "Pessimistic Offline Lock" Pattern?What is a quick summary of the "Plugin" Pattern?What is a quick summary of the "Query Object" Pattern?What is a quick summary of the "Record Set" Pattern?What is a quick summary of the "Registry" Pattern?What is a quick summary of the "Remote Facade" Pattern?What is a quick summary of the "Row Data Gateway" Pattern?What is a quick summary of the "Separated Interface" Pattern?What is a quick summary of the "Serialized LOB" Pattern?What is a quick summary of the "Server Session State" Pattern?What is a quick summary of the "Service Layer" Pattern?What is a quick summary of the "Service Stub" Pattern?What is a quick summary of the "Single Table Inheritance" Pattern?What is a quick summary of the "Special Case" Pattern?What is a quick summary of the "Table Data Gateway" Pattern?What is a quick summary of the "Table Module" Pattern?What is a quick summary of the "Template View" Pattern?What is a quick summary of the "Transaction Script" Pattern?What is a quick summary of the "Transform View" Pattern?What is a quick summary of the "Two Step View" Pattern?What is a quick summary of the "Unit of Work" Pattern?What is a quick summary of the "Value Object" Pattern?What is a quick summary of the "Model-View-Presenter (MCP)" Pattern?What does a ConnectionString to SqlServer Compact look like?How do I use LINQ o SQL with an SDF database?Can I use LINQ to SQL on a SDF database, running on Compact Framework?Can a SQL Server Express 2008 database be a merge replication Publisher, rather than just a Subscriber?Can I use the |DataDirectory| Macro in connection strings?Is there a way to add a right-click on *.sdf, or something, to make *.dbml file?Where does the |DataDirectory| macro (in connection strings) expand to?How do I make an install package for a CF project?Regarding Linq2SQL: How can I log the output of what LINQ to SQL is doing?Regarding Linq2SQL: How do I handle mapping Enums to an database, without LINQ to SQL converting it to an Int datatype?Regarding Linq2SQL: Should I use vars for custom query results, and if so how do Ireturn anon types beyond the method they were created in?What is a callback?What is the Rule of Three?What is the "You Ain't Gonna Need It (YAGNI)" Principle?What is MoSCoW?Where can I find general SQL optimization tips?Misc KnowledgeDid I miss it -- or is there a way to create Relationships between tables, using Visual Studio's tools?Can I use Visual Studio 2008 to create a LINQ to SQL *.dbml file to work with a Sql Server Compact (*.sdf) file?What is the DRY principal?What is the Model-View-ModelView pattern?What is the Observer Pattern?What exactly is a Unique Key, and what's its relationship to a Primary Key?Regarding Linq2SQL: Are the generated Entities the Business Objects?Regarding Linq2SQL: Linq To SQL relies on Lazy Loading unless I specify otherwise...how do I prefetch attached tables?Regarding WCF: Is there a way to check whether a Client Endpoint has been configured in the config file?Error Msg: Could not find a base address that matches scheme net.tcp for the endpoint with binding MetadataExchangeTcpBinding. Registered base address schemes are . Error Msg: The contract name 'IMetadataExchange' could not be found in the list of contracts implemented by the service xxx. Add a ServiceMetadataBehavior to the configuration file or to the ServiceHost directly to enable support for this contract.Error Msg: This collection already contains an address with scheme net.tcp. There can be at most one address per scheme in this collection. Regarding LLBLGen Pro: How do I get the count of records in a table?Regarding LLBLGen Pro: How do I get the count of records in a table that match a criteria?Where can I find a comprehensive list of good coding standards?How can I get the DataForm control to dynamically return custom controls for each entry field?How do I use the new SaveFileDialog introduced in Silverlight 3?How do I use Silverlight 3's methods to check whether I have network connectivity?How can I leverage Silverlight 3's events to be notified as to when I have network connectivity?Why cannot I not seethe Design View in Visual Studio 2008 SP1? It used to be there...How can I find my position in the MouseLeave event (it always comes back with useless data)?How do I trap double clicks?How do I trap right-clicks?Regarding XML/XSLT: How do you use an OR statement in a condition?How do I merge two Matrices?How do I extract the Angle back out from a Transform Matrix?How do I create a Rotation matrix by hand?How do I popup a Modal (or NonModal) ChildWindow?What's up with GridUnitType.Star (*) notation, and how do I size columns based on Percentage (%) anyway?How do I apply Transformations to an object?Where can I find out info about the various built-in Panel controls (Canvas, Grid, etc.)?How do I get grid lines in a Grid?What are the Build Action options, and which one should I use?How do I use Resource (*.resx) Files and Localize them?How do I know the size of the layout Slot I've been allocated?How do I find a parent element?Can I shrink the size of XAP files?Where can I find out more about Matrices?Can I work with Zip Files?How do I download new assemblies and load them?Serving XAP's from a Production Server...what do I do?How do I bind the value of a DependencyProperty to something else?How do I do IDE Designers?Should i ever use Console.WriteLine?How do I add outputto the Console from apps that only have Trace/Debug statements?What's the Default tracelistener?How do I set up a TextTraceListener to write debug/trace messages to a file?What about Asserts? Can they be logged to ?Regardinig Globalization/Localization: How to I globalise / localise an application?Regardinig Globalization/Localization: What are the common codes to string.Format a Currency, a DateTime, float,etc?How do I add PerformanceCounters to an app?Regarding Threading: How do I work with threading?How do I find child elements?How do I round a matrix (so that the numbers are comparable, for example)?How do you extract the matrix from a transformation, when you don't know whether the transformation was a MatrixTransformation, group, or other?How do you multiply two matrices?How do you get the Inverse of a matrix in SL20?Is there a DataTemplateSelector in Silverlight?Is there a workaround to the BeginAnimation that is missing in Silverlight (at least in 2.0)?How do I ensure that custom templated ListBox elements stretch the full width of the control?How do I use Styles with controls?How do I define a GradientBrush as a Resource?What's the format for Margin, Padding, etc.?How do I recurisevely search for a Resource in an anscestor ResourceDictionary?Can one trigger animations from declarative code only?What are MergedDictionaries -- and how do you use them?How do I find what controls are at a certain position (ie, under the cursor)?How do you get back from the selected Item -- which is a UI element -- back to the actual data that it was created from?LINK:How do I find an element within a template?Any naming conventions that I have stick to?What's NamingScope?LINKLINKLINKLINK: Local ConnectivityWhere can I find out the very basics of writting Storyboards declaratively in XAML?How do I define a Storyboard and animations, via code?Where can I see how the Ease functions work?How can I combine the value of two TraceSwitches (eg, take the highest of one created for App, and another for the assembly?)How do I setup an EventLog trace listener?Can I send debug and trace statements to different files/listeners?What are a list of common Listeners I could define?How do I define a Console TraceListener?What about tracing to a db?Where can I find a rolling textfile listener?What's the order in which Blend creates the Transforms? (ie, what exactly is at "(TransformGroup.Children)[3]"?What are the namespaces that need to be at the top of an XAML page?What the heck is that bracket notationt that Blend spits out?How do I get Bold, Italic, Underline, etc. in a TextBlock?How do I enter line breaks in a TextBlock?I've forgotten....howis it thatone turns on textwrapping in a TextBlock?What's the syntax for working with ColorAnimation on FrameworkElement Fillsfrom XAML Storyboards?Help! Setting Properties after an animation doesn't seem to do anything....!!!Regarding WCF: What does [DataMember(Order=1)] actually do (and how does it work)?Regarding WCF: For DataMembers/DataContracts, how can I with against interfaces rather than concrete instances?ListBox SelectionChanged returns the Data item was bound to...how do I get a handle on the ListBoxItem itself?How do I createa snapshot of a control?What's the control hierarchy within a ListBoxItem -- and how do I get to my Element within it?Trying to run a SVCfrom within IIS, but gettingHTTP Error 404.3 - Not FoundI'm having trouble databinding to a UIElement's transform values... what's the Dot/PropertyPath syntax needed?Where can I find official documentation on the Dot/PropertyPath syntax used in Storyboards and binding? Seems a bit buried....I know nothing about Databinding...where's a good place to start?How do I detecting duplicate instances of a running Silverlight application?Where can I find out about the DataForm...and should I use it?Where can I find fonts to embed?How do I ensure CPU is not maxed out with Animations?Animations and shadows...LINK: Forcing Validation on all controls in form, all at once...How do I bind to an Enum?How do I bind to something via code?LINKHow do I add Scrolling to a control?How do I find the highest level element (ie the first control loaded in the Silverlight player)?How do I transformcoordinates from one UI element to another?What's involved with the Validation Framework that was introduced in SL3?How do I force validation on a UI Element? Like in a Submit button?How can I use the BasedOn attribute to make a Style derive from a previous Style?How do I style ALL the buttons at once?What's the Interface I have to implement on a ViewModel to make it automaticall editable with the DataForm?How do I keep DataField labels all the same width?Why can't I find the BindableAttribute that was alluded to in some videos and tutorials?How do I change the visibility of the Edit, Cancel,Commit, etc. buttons?LINKLINK:LINKSLINKSLINKSLINKSMISC LINKSHow can I work with Notifications?Where can I find out more about the ICommand architecture added in V4?LINKSLINKSLINKS: Duplex Polling How do I showa right-click context menu?Where can I get a Ribbon control for free?How do I implement the new SL4 drag/drop functionality?LINK: Farseer introHow do I make a templated control enherit from ListBox, but providea default custom Panel other than VirtualizingStackPanel?Where can I find out what the original theme of a ListBox is?Where can I find the original Templates?How do I get access to the ItemHost Panel that is within the ListBox, selector, ListControl?What's a good clientside db to use?How do I draw a line to fill a cell, without specifying X1,Y1, X2,Y2?How do I create a new Table cloned from another?Regarding WCF: What will [ServiceContract(Name="...")] affect?Regarding WCF: What are some Versioning Best Practices?How can I recover or change the SA password?When cut/pasting from Design to Blend, I get "The clipboard text coun not be pasted. The name 'Viewbox' does not exist in the namespace 'http://schemas.microsoft.com/client/2007'" What is going on?!How do I convert a Shape/Geometry to a Motion Path in Blend?When i use Subtract one shape from another, I don't always get the same result?What do I have to add to the AppManifest.xml to prepare a program to work Out of Browser?There's no Scissor tool in Blend...how can I cut away stuff I don't want from a Shape?What Attributes are available to make my control's properties integrate well with Blend?How do I work with Design-Time Sizing in Blend?How do I generate a running total?How do I work with in memorytable variables?How do I create Temp Tables?How do I work with Transactions in TSQL?How do I work with TRY, CATCH and RAISEERROR() for Error Handling?How do I setup and use SQL Server 2005's Database Mail?How do I use IF / ELSE, ISNULL, or CASE, WHEN, THEN, END, or GOTO for branching?How do I work with Dates (@@LANGUAGE, @@DATEFORMAT, @@DATEFIRST, GETDATE(), GETUTCDATE(), CONVERT(), YEAR(),MONTH(),DAY(),DATEPART(), DATEADD(), DATEDIFF(), etc) ?How do I use NEWID()/NEWSEQUENTIALID() to generate IDs, @@ROWCOUNT to get the number of rows affected, @@IDENTITY/@@SCOPE_IDENTITY to return the last generated ID, or use ROW_NUMBER to control the returned rows?How do I use DECLARE, SET, and DALLOCATE with custom variables?How do I use LEFT, RIGHT, SUBSTRING, LTRIM, RTRIM, LEN, DATALENGTH, UPPER,LOWER, REPLACE, etc on Strings?How do I work with Cursors?Why use the NOCOUNT in every transaction?Getting a SQL Server RowCount Without doing a Table ScanHow do I work with numbers in TSQL?How do I use the FOR XML options?How do I page data, using the ROW_NUMBER?To compile the *.ps files (the pixel shader scripts), where do I find the FXC file?Are there any tools (Intellisense, etc.) to make working with HLSL easier?Is there an easy way to hook up the compilation of the *.ps files from within Visual Studio, rather than dropping to the command line?Where can I find some PixelShaders to get started?Can ICommand's be attached to anything else than Buttons?What's so special about ICommand? Why should I use them, rather than use EventHandlers?For compatibility purposes, what are the built in Commands in WPF?Writting ICommand classes can get tedious: any way of writting them faster?Where do I start learning the HLSL language necessary to make PixelShaders?What's the syntax for the Uri of embedded resources? Component something?Why is the variable passed to the main function in the pixel shader script not called pixel, or point -- why is it a uv?What do i have to do to prepare an applicaiton for OOB installation?Regarding Linq2SQL: What are Dynamic queries, and how do I use them?How do I pass an array of variables as a parameter?How do I compare against a passed in argumentthat could be null?How exactly does class enheritence work?I'm thinking of automatically tracing using Reflection -- what do I need?What is SOLID?How should I design a Repository?What's good advice when checking passed args?Not about DB's, but related -- how do I round up, for showing page numbers?Regarding Networks: Network computers are inaccessible...Regarding Networks: How can I clear the Username/password cache?Regarding Visual Studio: How do I use Post-Build events & XCOPY to copy a project build to another directory?Regarding Visual Studio: What's a good way to manage snippets?Regarding I/O: How do I work with Isolated Storage?How do I count the number of distinct items in a table?Regarding Linq: I unfortunately don't use LINQ enough to remember the bits and pieces...Regarding Linq: How do I use the GroupBy?Regarding Linq: What are Dynamic Queries, and how do I use them?What's a God Class?Regarding MVC: What's a ViewPage made up of?Regarding MVC: What's the convention of Folders in an MVC project?Regarding MVC: What are the HtmlHelper methods I can use in the View?Regarding MVC: What's a Controller’s ActionInvoker responsible for?Regarding MVC: What are ActionResults and is there a list of them?Regarding MVC: What exactly goes into the various parts of the MVC, and good practices?Regarding MVC: What are the most common attributes I can use to decorate Action Methods?Regarding MVC: What's the default Routing?Regarding MVC: What's the request lifecycle?Regarding MVC: Binding is cute, but how the heck do I make it secure?!?Regarding MVC: How do I use Google CDN to load JQuery and JQueryUI?What about Continuous Integration?Damn! Have to work with an older version of Visual Studio....Where can I find tools to convert solution and projects?What should our team use for Unit Testing?Regarding Resharper: Where can I find a Resharper CheatSheet?How do I generate Documentation of the code?What about static code analysis with FxCop or Gendarme or other?Where do I start? [Answer: SOLID]After SOLID what's the next step? [Answer:TDD]What do I use for comparing schemas and data? [Answer: SQL Data Compare]Should I push team members to get certification?After SOLID and TDD, where's a good place to learn Patterns?What's a good solution for UML? [Answer: Enterprise Architect]What can I use to manage Multiple Remote Desktop Connections.What about cheatsheets?What about inter team communication?What about document sharing (ie CMS)?Regarding HTTP: What are the traditional port numbers I have to remember?Regarding HTTP: What's an actual request look like?Regarding HTTP: What are the Verbs that are used?Regarding HTTP: What are the status codes I can get back after a request?Regarding HTTP: What are the most common mime types?What are some of the !DOCTYPE options?How do Idefine inline CSSor import externalCSS files?Where can I find a quick reference table of common 2.1 CSS?Regarding XHTML: What are the various DOCTYPEs?What about some reference links on CSS?Where can I find a list of resources to learn/stay up to date on CSS?How would I go about setting up a high availability load distributed website?Regarding JScript/Javascript: What are some good links to get started?What's a good Partition Manager for dealing with everything?Regarding Networks: Anylinks to software that eases managing various workstations?Regarding Networks: Where can I get a list of what each group has rights to??!Regarding Visual Studio: if I turn on Warn as Error, how do I getVS to ignore uncommented autogenerated WCF proxy / EF4 code?What about Version Control?Regarding ATLAS: How could one use the AutoComplete Extender with a Webservice?Regarding raw AJAX: Does Safari support XMLHttpRequest?Regarding raw AJAX: Does Firefox support XmlHttpRequest? Regarding Configuration: How do I turn on debugging and/or tracing?Regarding ASP.NET: What are the ASP.NET special folders?Regarding HTML5: Links to tools to check browserHTML5 abilities?Regarding ASP.NET: What are some links to consider?Regarding ASP.NET: Where can I learn about Session specifically?Regarding ASP.NET: Where can I find out more about the Request PipeLine?Regarding ASP.NET: Where can I find out more about the Control LifeCycle?Regarding ASP.NET: I've written several ASP.NET based posts/articles that you may find useful...Important Tips to know before embarking on using SqlServer CE...What are some Schema Dump and Diff Tools I could try?What are some CLR extensions I could try?What are some Backup solutions I could try?Are there any Webbased SQL Server Managers I could look at?Where's a great source of TSQL examples? (http://bit.ly/dnRLuO)LINKS: Where should I go for tips? (http://bit.ly/9BF2Zp)What are the various flavours of SQL? [DDL, DML, DCL]LINKS: What are some alternates to SSMS?LINKS:What's an example of SQL Server Express Connection String?What's the ASP.NET PipeLine look like?Regarding ASP.NET: What's the ASP.NET Control LifeCycle look like?Regarding ASP.NET: What are the Page Directives (the @...)?Regarding MVC: 101: A quick note as to what MVC is compared to ASP.NET classicRegarding ASP.NET: LINKS:Regarding MVC: LINKSRegarding XML/XSLT: LINKSHow do I launch and pass vars to a workflow?Why or why did they choose VB as the language of choice?!Regarding ASP.NET: How do I use ObjectDataSource when binding to objects that have sub objects? Regarding ASP.NET: An ObjectDataSource/GridView Adapter for Business Entity Collections so that it can do sorting/filteringRegarding ASP.NET: What's with System.ComponentModel.DataObjectAttribute?Regarding ASP.NET: When should i use the SqlDataAdapter?Regarding ASP.NET: Got an example of using a Control for the parameter of an ObjectDataSource?Regarding ASP.NET: Where can I find a good article on ObjectDataSource?Regarding ASP.NET: General stuffRegarding ASP.NET: Links Regarding ASP.NET: The pros and cons of typed datasets versus ORM objects:How can I check whetheran SP exists or not ?Can I combine an INSERT and an UPDATE in the same SP?How do I launch a Stored Proc?What's a DELETE SP looked like?How do I setup and use Log4Net?The service certificate is not provided for target 'http://localhost:17069/Service1.svc'. Specify a service certificate in ClientCredentials.What options do I have with demonstrating current dev work with a client?I've been tasked to setup a lost cost/free bug tracking solution...any suggestions?System.Security.Cryptography.CryptographicException: The system cannot find the file specified.System.Security.Cryptography.CryptographicException: Keyset does not existRegarding DNN: Set cache time to 20minutes for all Text/HTML panels.Regarding DNN: Update cache time to 0 for all FAQsRegarding DNN: Get the post with the most commentsRegarding DNN: Update Existing FAQsRegarding Linq: LINKSRegarding Configuration: What are some tips for using the configSource attribute?Regarding Configuration: How does one turn off and on custom error messages in a web site?Regarding Configuration: Can configSource values be merged?Regarding Configuration: LINKSRegarding Visual Studio: What about using static Code Analyis with FxCop?Regarding Visual Studio: What should I do to ensure good documention of code?Regarding Resharper: LINKSHow do I use nUnit to write unit tests?How do I create a test fixture with MSTest?What problems could I run into by using MSTest, rather than NUnit?What test typescan one create with Visual Studio Team Edition for Software Testers (Answer: Unit, Web, Load, Generic, Manual, Ordered)Where can I find a chart comparing the various way of creating test fixtures?How do I run MSTest's without installing VStudio?Where can I find a comparison between the various frameworks (NUnit, NbUnit, xUnit, MSTest, etc?)Regarding TFS: Whre can I get a Hosted TFS solution?How do I get the constraints on a Table or it's columns?Where do I find the SQL Server Business Intelligence Development Stadio needed to get started with SSIS?How do I use the SQL Server Import and Export Wizard to Export to Excel (or other)?Regarding ASP.NET: How do I create a new ASPNET DB? (http://bit.ly/fLHDvx)Where can I find descriptions of the various Control Flow Service Tasks?What are some common ConnectionStrings?Where can I find a list of Operators and Functions I can use in Equations?Where can I find a good tutorial on SSIS?Windows Installer: Where can I find info on how to make a Web Project Installer?Windows Installer: Where can I find a tutorial on how make a Visual Studio Installer?Windows Installer: How i can use a Windows Installer project to read the Registry?Windows Installer: Error: I’m trying to install a project on .NET 3.5, but it keeps asking for .NET 4.0!?!?!Windows Installer: What about dev/uat/production config files?!Windows Installer: IMPORTANT: Microsoft is retiring Installer Projects after VS 2010 -- in favour of InstallShield... (A BAD MOVE!)General: Where can I find a feature grid comparing Windows Installer, WiX, InstallShield LE?So...if start on this slippery slope...what's the feduciary damage going to be?!?General: LINKS to different packagers on the market (with some notes).InstallShield LE: And if I go down this slippery slope...what's the damage (money wise)?!?LINKSLINKS: ProductsDoes WMI need full trust?Why install SSL?WiX: Where can I find a list of the Predefined FolderNames (eg: ProgramFilesFolder)?Tip: How do I launch an MSI with Administrator rights?WiX: What are the list of UI Dialogs Sets I can use?WiX: Where can I find a full list of project reference variables (eg: $(var.MyProj.TargetPath)?LINKS: Where can I find a set of examples for common WiX configurations?WiX: Whatpredefined UI Dialogs Sets are available right off the bat ()?WiX: When debugging WiX Projects, how do I generate a log when running the MSI?Where can I find a list of the variables defined by Wix UtilExtensions?Wix: Formatted Fields: How do I refer to Environment Variables in FORMATed fields?WiX: Component: How Do I create Registry Keys?WiX: Component: How do I make a shortcut to uninstall the application?Regarding WiX: Component: How do I create a shortut in the Start/Program Menu Structure?WiX: Component: How do I create a Shortut to the app in the Startup folder?Wix: Formatted Fields: What's the syntax forwith FORMATTED fields?WiX: Component: How do I install/refresh a Windows Service?WiX: What are the Schema Namespaces I can hook up to make WiX have more options?Regarding WiX: How can I use PreProcessor statements to change build depending on env vars?WiX: Component: How do I create a shortcut to a webpage?WiX: How do I create pre-Launch Conditions?WiX: Component: How do I use XmlConfig to update an attribute?How do I specify a custom RTF License File?WiX: Element: ProductRegarding TFS: How can I hook in a better Diff/Merge Viewer?LINKS: Custom DialogsWiX: Component: SqlDatabaseHow do I use heat.exe to harvest the output of a website?LINKSHow can I handle UI cross threading issues (when InvokeRequired=true) elegantly?What are some common Run Cmds (eg:MsTSC,INETMgr,EventVwr.msc, FireWall.cml, MsConfig, MsInfo32)?How can IDENT_CURRENT use 'VS100COMNTOOLS' to my advantage?What's a good partition manager?Regarding I/O: How do I send Email?Regarding I/O: How do I read/write to files?What's the default SQL Server Name? (answer: MSSQLSERVER)What's the default location for the databases?Can one change the name of an Instance (eg: SQLSERVER to MSSQLSERVER)?Is there ever a good reason to install a NamedInstance without first installing a Default Instance? (Answer: No)Have a Named Instance, don't have a Default Instance, don't want to ReInstall...anything I can do to use '.' and get back to work already?What exactly doesthe |DataDirectory| macro expand to?How do I list all tables?Regarding I/O: What do I need to know about Encoding/Decoding?Regarding Processes: ow do I work with Process class to list Processes, or find one by name?Regarding Processes: How do I use Process to start a command (equivalent of ShellExec/ShellExecute)?What's a quick recap on how to work with Images and Bitmaps?Regarding I/O: How do I use Compression Streams (GZipStream / DeflateStream)?Regarding I/O: How do I work with BufferedStream?Regarding I/O: What's the hierarchy of Streams (how does StringReader relate to TextReader, or BinaryReader, etc.)?LINK: Everything you need to know about AppPool Identities (http://bit.ly/fvplea)Regarding Networks: Where can I find SysPrep to clonea hard drive with all the stuff I want, ready to vm, etc.?Regarding Resharper: It complains about "Page_Load" -- wants it to be renamed as "PageLoad"...Regarding WCF: How do I serialize Collection propertieswithout having to make them get/set (only get)?Regarding Windows Server: How can I configure SMTP Service to use GMail?Regarding Windows Server: How can I configure Windows Server SMTP touse Gmail?Looking for a solution to "The type 'XXX', provided as the Service attribute value in the ServiceHost directive could not be found." ?Visual Studio's Tool to "Add Service Reference..."is refusing to generate the code client proxy to a Service...what could I be doing wrong?Regarding Resources: Is there an effective way to create string resources without them getting fragmented as the project progresses?How do I define a primary key on multiple columns?How do I use Code Contracts?How can I use IIS's APPCMD to manage just about everything of a server?Regarding WCF: How do I work with KnownType and ServiceKnownType to deserialize base classes?Some Links of interestLinksMore linksmore linksLinksMore linksWhat are some links for generating a GUID?LINKS: Learning C#LINKSLinks: Tools for Sql Server ExpressHow do I list all users?How do I list all databases?How do I execute an imported *.sql script file?How do I select from one table, minus those found in another table?How do I check for the existence of a user table?Regarding DNN: How do I reset a Password?Regarding Validation: Can I use Extension Methods for Guarding arguments?How do I use Advanced Query Syntax (AQS) to use Windows Search Effectively?Regarding Resources: How do I manually compile *.resx files into *.resource files?I'm getting: System.ServiceModel.Security.MessageSecurityException: Cannot find a token authenticator for the 'System.IdentityModel.Tokens.X509SecurityToken' token type. Tokens of that type cannot be accepted according to current security settings.How do I work with IIS Logging?Regarding Xml/Xslt: How do I use Xslt to transform Xml and keep it indented / pretty printed?Visual Studio 2010 won't let me downgrade my Test from .NET 4.0 back to 3.5!!! LINKS: Error Messages and general trouble shooting.Trouble shootingHow do I add XmlTools to Notepad++Regarding Networks: What do I need to know about Remote Access?Every SP that doesn't need row count should begin with SET NOCOUNT ON;The WITH NOLOCK hints is a red herring (no matter what others think).Avoid writing SP's per table (InsertTask, UpdateTask, etc.) Think Units of Work instead.Fiddler doesn't trace local ASP.NET traffic!Links to .NET ExamplesRegarding MSTest: I'm having trouble getting TestDriven.net to play nice with my MSTest tests...Regarding WCF: Fiddler is not Listening to WCF calls made from within an ASP.NET application?!Regarded CodedUI Tests: What's an alternative to using Microsoft' UI Testing framework?What are some suggested software tools to install on dev machines?Make the following changes to your PATH environment var.Regarding SpecFlow: How do I get SpecFlow to use MSTest rather than NUnit tests?Regarded CodedUI Tests: Do I have to decorate Coded UI Tests with anything special?TestRegarding SpecFlow: How do I write a good Spec?How do I pass data around?What's a good checklist of design considerations?How do I navigate around in a Windows Phone App?What's a good Sanity CheckList (things to look for before letting the code out the door)?CheckList: Configuration SettingsHow do I use Advanced Query Syntax to find things in my computer?Regarding Subversion (SVN): How do I set up an exclude filter?Word's Bullet's drive me nuts...what to do about them?!?What's goes into a DDDD application?How do I create a Role?Regarding Configuration: Where do I find the the MetaBase.xml?Regarding Configuration: How can I rename a virtual app? Can't seem to do it from within INETMGR...???Regarding Configuration: What's to know about the IIS metabase.xml file?Regarding Sparx Enterprise Architect (EA): Any pointers for working with it?How do I export a sql script for a database?Where can I find out about SQL Server security -- such as GRANT, REVOKE, etc?How do I create a new ROle, add members to it, and grant roles to an Stored Proc?What's the syntax for GRANT ing permission to stored procs?Regarding Pex/Moles: How do I Mole up an IIdentity for an ASP.NET page?Regarded MSTest: How do I create a Unit Test Coverage report, using Visual Studio?Is there an online resource to I translate colors from HEX to decimal?Regarding Pex/Moles: Can one write Unit Tests in .NET 3.5 that uses Moles?Regarding Pex/Moles: What's that \0 business that Pex does?Regarding Microsoft Word: How do I configure it to be productive, quickly?Regarding Pex/Moles: How do I substitute a method? Eg, replace DateTime.Now?Regarding SpecFlow: How can I have two Steps with the same attribute?What are the bare bone parts of using NinjectWhere can I quickly get up to speed on Unity?How do I configure Ninject from an xml config file, rather than code?What do I need to know to get Ninject to work in MVC?What do I need to know to get Ninject to work in an ASP.NET context?What IoC frameworks should I know about?Ninject keeps on mentioning how fast it is...are there any specs?How would I go about using Ninject in asp.net?Regarding NuGet: how do I refresh the packages if not checked in?Regarding NuGet: How do use redownload packages if I haven't checked them in to Source Control?Regarding NuGet: What's the website of the guy behind NuGet? Regarding NuGet: How do I create a Package?Regarding NuGet: How do I create a NuGet package?Regarding CSS: How can I color the background of a checkbox or radio button? How do I use JQuery to check/uncheck a checkbox?Regarding JQuery: How do I check/add/remove attributes using JQuery?How do I check/add/remove css attributes and classes, using JQuery?How do I hide/show things using JQuery?How do I clear a form using JQuery?Regarding JQuery: What is the page event I have to wait for?Regarding JQuery: What's the syntax for Selectors?Some links on JQuery?How can I work with cookies in jQuery?HOw do I load data asynchonously, using JQuery?Regarding MVC: How does "return View()" automagically know which View to return?Regarding AD: If I add a User to a Group, when will it be apparent/available?Regarding AD: Where can I find out about SID's, ACL, etc?In Mercurial (Hg), how do I install an Extension?Regarding EF4: how can I get it to create Self Tracking entities in .NET 3.5?Regarding EF4: How do I generate a Db from the Model?Regarding EF4: How do I choose between POCO, and Self Tracking Entities?Regarding Security: How do I get a list of the AD groups a WindowsIdentity belongs to?Regarding WCF: How do I host an WCF Service endpoint, using SSL to protect it?Mercurial (HG), why am I'm getting "abort: repository default-push not found!" when I hg push?Regarding Subversion (SVN): What are the pros and cons between using Subversion (SVN) and Mercurial (HG)?Mercurial (HG), what's a good starting point for a .hgignore?Regarding Subversion (SVN): What's a good repository folder stategy that can handle externals with grace?With Mercurial (HG), how do I add an empty folder?In Mercurial (Hg), how do I do operatations on subrepositories, from the parent repository?With Mercurial (HG), what's the difference between pull and update?With Mercurial (HG), all this writting of usernames and passwords in .hgsub and .hgrc is freaking me out (security wise)...With Mercurial (HG), what's up with having both a default, and default-push path in .hgrc ? With Mercurial (HG), where can I find a quick intro to Mercurial?With Mercurial (HG), can I check out just a partial repo (like in Subversion/SVN?)With Mercurial (HG), how do I work with subrepositories?With Mercurial (HG), where do I start (what do I download first, etc)?Regarding EF4: How do I deal with Enums? And is a fix coming any time soon?Regarding WCF: If I wanted to check what Cert was sent over the wire in a WS-Security BinarySecurityToken as a bas464 string, how would I go about it?Regarding Xml/Xslt: how do I use XPath using wildcards for the namespaces?Regarding WMI: What do I need to know?Regarding Security: What's a quick summary of Symmetrical Encryption Algorithms?Regarding Security: How do I generate a Hash?Regarding Subversion (SVN): What's a good project structure to consider when laying out repositories?Regarding WCF: OATH Links...Regarding WCF: LinksRegarding WCF: How do I work with ServiceKnownType?Regarding WCF: How can I send large messages (eg:large byte arrays)over the wire?Regarding WCF: How do I use SvcTraceViewer to figure out what's going on?Regarding WCF: What are some versioning best practices?Regarding WCF: How can I host in IIS a *.svc page that doesn't use CodeBehind, but instead uses a class defined ina referencedassembly?Regarding WCF: Is there a Rolling WCF svclog TraceListener?Regarding Certificates: is there a real easy way to set up a dev station to create a CA + server + client certs?Regarding WCF: How do I enable MEX through SSL?Regarding Certificates: How do I use netsh to register a cert against a port?Regarding Certificates: where can I find out the location of the private key?Regarding WCF: Should I be using Web Services Extensions (WSE) 3.0 in order to create X509SecurityToken?Regarding WCF: How do I set a client's X509Cert?Regarding WCF: What should I be using for certificateValidationMode?Regarding Certificates: I've received a certificate created in a different environment (using Java tools)...what type is it (ie, whaty'a a cert.p12?)Regarding Certificates: how do I generate a Certificate Signing Request (CSR) on Windows?Regarding Certificates: , how do I use MakeCert to create a friendly name?Regarding Macros: LINKS...Regarding EF4: LINKSRegarding EF4: How can I get Syntax Highlighting of T4 templates?Regarding EF4: Where can i find a great walkthrough on working with POCO entities?Regarding EF4: How can I edit the T4 template to suppress errors?Regarding EF4: How do I work with DTO's?Regarding Reflection: I'm thinking of automatically tracing themethodand class ...what do I need?Regarding Console Output: Links...Regarding Test: Xml Roundtip?Regarding WebDeploy: after installing, how do I check that the service is running and listening? Regarding WebDeploy: how do I run an Xml Document Transformation (XDT) transformation on a web.config from the command line?Regarding WebDeploy: what's an XDT example for an app setting value?Regarding WebDeploy: what's an example of a connection string XDT look like?Regarding WebDeploy: how do I manually update the *.csproj of older websites to use XDT?Regarding WebDeploy: what's the namespace for creating XDT files?Regarding WebDeploy: where can I find a means to do an XDT transformation outside of VisualStudio, on any file?Regarding WebDeploy: After installing, how do I turn on the necessary services?Regarding WebDeploy: LinksRegarding WebDeploy: prior to installation, how do I ensure needed IIS roles are installed?Regarding TraceListeners: Why is the output of the VB based FileLogTraceListener different than the TextWriterTraceListener? Regarding TraceListeners: Can I remove the source filename from the output?Regarding ActiveDirectory/AD: What's the *.msc I need in order to add/remove users/groups, etc?How do I get a Log4Net library compatible for .NET 3.5Regard SQL: How do I get a list of the roles associated to a Stored Proc?Regard SQL: How do i retrieve the sql of a stored Proc?Regarding SQL: What's a good way of delivering SQL to a client -- and getting a log of how the install process went?Regarding TFS: Is there a Keyboard Shortcut for View/Other Windows/Source Control?Regarding IHttpHandlers: How do I create a IHttpHandler to render POX to a client?Regarding WebServices: How do I create an *.asmx to render data back to a the client?Regarding JScript: What's the equivalent to string.Format in Jscript/Javascript?Regarding WCF Binding: what's the difference betwen webHttpBinding, basicHttpBinding, wsHttpBinding?Regarding WCF Binding: for a REST enabled SVC, can I use any other binding than webHttpBinding?Where's a good source of info on creating WCF Rest services in .NET 4?Regarding JSON: where can I find a listing of the differences between the two JSON serializers included in .NET (JavaScriptSerializer and DataContractJsonSerializer)?Regarding REST: how do enable them over TLS/SSL?Regarding REST: Worth knowing...Regarding WCF/REST: How do I raise an exception that the JQuery client can use?Regarding WCF Rest: how do I get rid of the *.svc extension?Regarding WCF: How do I enable MEX for a TCP connection or other?
 
Copyright 2007 by Sky Sigal