Tech
SQL Server, SSIS, ASP.NET, and other software notes
236 posts, 2003–2020.
2020
2019
2017
2016
2015
- Mister SQL | The other half of MS SQL
- Dumb Services – Accessing a website when there isn’t an webservice API
- Using Twitter more effectively as a software developer
2014
- REST Levels above 4
- C# Basics– Classes and basic behavior
- Computer Operating System, Explain it like I’m Five
- DC Agile Software Management Book Club
- Writing code for technical interviews, my opinions so far
- Javascript Intellisense, Pretending to Compile JS
- Launching WinForms apps from a console
2013
2012
- So you want to run powershell scripts without admin rights
- Reading System.Diagnostics from the Mono sources
- Compiler Error 128
- Getting WCF to talk ordinary HTTP to a browser
- Production Trace
- Cross Database Support
- Sites I am migrating
- Customizations I used with Elmah
2011
- Opinionated Trace
- Rude and Passive Aggressive SQL Error Messages
- Custom Exception Antipatterns
- It’s not engineering. It’s school yard psychology
- Mobile Development and ASP.NET Websites
- Mercurial and .hgignore
- The standard advice on new opensource projects
- Validation Application Block Post Mortem
- Picking .NET tools when you want to collaborate
- SQL Compact and MS-Access
2010
- The Thin Website
- MaxiVista and Visual Studio 2010 and my computers
- A build server for home
- Stop! In the name of code!
2009
- ASP.NET MAF plugable website working
- You think you’re doing tier architecture or business objects, but its just super pipelines and ziggurats.
- Troubleshooting “Service ‘Astoria’ implements multiple ServiceContract types, and no endpoints are defined in the configuration file.”
- SQL Express on Windows Home Server
- Kinds of Anonymity
- The Anonymous Web
- WHS Accomplishments
- WHS: What I use it for
- WCF + .NET 2.0
- The sorry state of application security audit logging
- Security auditing/logging. It’s not the same as the others
- Not using SqlRedgate is industrial sabotage
- The best SQL Stored Procedure Header EVAR
- Webservices and WCF- eatting one’s own dogfood
- When to and when not to use #Region in C# and VB.NET
- Brave new world of Web Services
- How to Overengineer the Reference Table/Code Table
- FISMA Secure
- Sql Compact, it appears to be ready for use
- Datagrid and Gridview, just don’t cut it anymore.
- log4net weirdness
2008
- The given columnMapping does not match up with any column in the source or destination
- Developers think other developers are retarded
- Looking at HttpBrowserCapabilies
- Whitelisting and Blacklisting by user-agent headers
- Sign the Pledge! Sign the Petition! Down with #region!
- try/finally without catch
- Commenting Code
- Unit Test Checklist for .NET business objects
- Virtuozzo Software Compatibility List, my personal version
- Catch/Rethrow
- Moving back to Lunarpages from Webhost4life
- Medium Trust for 1.1 ASP.NET applications
- Automated Testing Using WebClient and HTML Agility Pack
- Built in Exceptions you should use
- Adword Quality
- Walking with PowerShell
- Where to put the Connection String in Sharepoint
- What is a stp file?
- Using the DataSourceWebPart in Sharepoint
- DataViewWebPart, Part II
- SSAS Tips
- SSAS Tips
- Failure to upgrade Reporting Services 2005 to SP2
- Stsadm for hard core users- Installing Templates with Powershell
- Why there is a shortage of SharePoint Developers
- URL Rewriting and DotNetKicks Open Source Version
- Utilities I can’t work without
- Recommended to-do list for Classfieds Starter Kit
- Strange but true
- Source contol on XML base programming languages
- Talend Studio solved for me an ETL problem
- Business Intelligence, Small, Medium and Venti
- Hit by a Php Root Kit: ro8kbsmag.txt
- Live blogging Talend Studio
- Installing Subversion, short edition
- Pervasive Integration Architect Forensics
- Product(s) Review: SQLite Maestro
- Pervasive Integration Architect: Dealing with workspaces
- Observations: Pervasive Integration Architect Process and Map Designer
- SQLite and ASP.NET Providers
- Evaluating a Sofware Development (SDLC) Process
- Embedded databases for speed and simplicity
- Notes: SQLite for ASP.NET
- Review: Talend Open Studio
- Notes: Pervasive Data Integrator Repositories
- Named SQL 200 Instances
- ETL Anti-pattern: Checking for more than one problem at a time
- Learing about ASP.NET output caching
- License Mixing from a CDDL standpoint
- Pervasive Data Integrator: Title pending…
- Review: Pervasive Data Integration
- How hard is it to make SQL Express easy?
- Evolution of an Idea
2007
- MCTS Exam Review Books
- ASP.NET Skills
- Webcast Notes: Top 5 Challenges Faced by Software Development Teams
- SSIS: Transfer Database Task
- SSIS: Dog Pile!
- SSIS: Avoiding setting the data down
- SSIS: Ragged Right good, Fixed Width bad
- DTS and SSIS: Time to find alternatives
- SSIS Tip: Fixing Columns Width with Derived Column Transformation
- Got Apple Software on your Machine?
- Website Navigation: Google is my user interface
- Installing Oracle Drivers: A Heuristic Approach
- Visual Studio 2005: Installation Woes
- Blowery Compression and MaintainScrollPositionOnPostback Errors
- Portable XAMPP: Potential Uses
- Notes: Hosting Multiple ASP.NET Applications in one place
- Mod_aspdotnet: Some investigations
- Who are you and who do you know?
- Replacing the water cooler
- Outsourcing Identification
- Using Random in ASP.NET
- Hosting PowerShell in ASP.NET
- Registering the PowerShell MSAccess Provider
- Google Pack
- Google Ad Words
- Google Checkout
- Terminate with extreme prejudice: WinCinemaMgr.exe
- OpenID Adventures
- SQL Style vs AzMan Style rights granting
- OpenId vs CardSpace Smackdown
- AzMan Biz Rules
- Group, Role, Task, Operation Design—Some Theory
- Top 10 Reasons Why You Should Use AzMan
- More Notes on AzMan- An inconvenient interface
- Creative Use of Role Base Authorization in Degenerate Cases
- ASP.NET DropDownList and Unexpected Data
- Overview of Code Generation in the .NET World
- Geek Charity– Donate Bandwidth and CPU Cycles
- The Great ASP.NET Lunarpages Experiment
- Vista Temptations
- MSDTC Considered Harmful
- MS Access as a Linked Server
- SMO vs TSQL vs Batch vs .NET vs VBS
- Why I ripped MS Ajax 1.0 out of my app
- The Search for FAST Souce Control
- Visual Studio Team Server Impressions
- Getting the Most from your iPod
- When to use an Object Database (Or ASP.NET Personalization)
- Parental Controls
2006
- Things that would improve my love hate relationship with SSIS
- Can you do Cascading Dropdowns In FormView?
- Email Bankruptcy
- IE 6.0 Is leaving the building
- SQL Server as an Application Server
- Overclocking Pentium 840 D
- Setting a database to Read Only
- Actually trying to use MS-Words HTML editing is not a good idea
- Building a computer, Part II
- Updating a bazillion rows in SQL
- Computer Books
- Why SQL SMO is so damn exciting
- SQL 2000 Read Only Databases
- My New Dual Core
- Kitchen Computer
- Life Hacking: Shopping
- Finding the Answer: Researching Tech Questions
- The SQL 2000 Post System Crash DBCC Script
- Documenting Anything
- Graphics Cards
- SSIS Packages and Shared Configurations
- UI Options For SSIS
- SSIS Trick
- Soft Reset for the Ipod
- Enterprise Library from Patterns & Practices
- Whee, recovering a crashed SQL Server
- Thinking about Logging, Trace, Configuration, Error Handling
- A1 Visual1 Studio1 Blog1 Entry1
- SSIS’s ‘Fast Load’, ‘INSERT BULK’ and Bcp
- Implementing a ‘Separate’ Staging Area for a Data Warehouse
- Installation: So you think I got time to burn…
- Component Designer in Visual 2005 kind of broke
- ASP.NET Lessons Learned
- Debugging ASP Classic with Visual Studio 2005
- Visual Studio for non-Visual Studio Languages
- Books online is giving me a head ache.
- Visual Studio Database Projects
- SSMS Review
- Front Page Extentions: What are they?
- Random learning links for VSS
- If the code snippet manager is hidden…
- JScript.NET + SMO
- SQL DBA Check List- Draft
- Red Gate SQL Tools
2004
- Working with Php Dates
- LunarPages
- The joy of deploying Servlets
- Wish list
- VB6/Visual Studio Irritation #5673
- #!#@$!@ XM Radio, !$!@$ Car Radios
- Unions vs Outter Joins
- Things DTS needs
- Why I need a photo cell phone
- Can’t someone create this product?
- Stupid VB Control Tricks
2003
- Tungsten T3- Usage Update
- Cooking with my Palm Tungsten T3
- Tungsten T3
- Droping tables in T-SQL
- TSQL programming with MS-Access
- Visual Programming
- PDAs and the like
- W3 Standards
- XSL Pains
- SQL Server & XML Forms
- More Thoughts on Using XML
- XML Things I’ve learned
- Using Jbuilder to Make a Swing GUI
- Getting MS Explorer to Swing
- Beating my head against CVS
- How to send a file to a printer using batch
- Converting phpNuke to MS SQL Server
- Can SQL be run in reverse?