Why is it called BDUF [Humor]
It dawned on me why it is called BDUF.
It is the sound you hear when the pile of design specs lands on your table.
BDUF!!!
Archive for Programming
Disadvantage with having code in Database
I suddenly realized one big disadvantage about having code in the database (stored procedures etc) - Restoring
Restoring a database disrupts the versioning. Code and data are not versioned together. Database structure and code are usually tied together.
Say i have a procedure i want to modify.
I edit the SP,
update it in the database
run it.
I find an [...]
Some good links on SCM - software configuration management
Henrik Kniberg has written some very interesting things on agile version control. He has some links to other interesting sources as well. Go there, read it!
From Perforce I found this writing about High level best practices in SCM.
Is SCM the acronym for:
Software Configuration Management
Source Code Management
Both searches on Google seems to to point in the [...]
Regex for SQL
Found a regex for getting SQL-code here.
“(/\*[^\*/]*\*/)|(\r\n\s*)|\t|\s{2,}”
Making groups unique - fixing a duplicate key problem in SQL
I ran into a problem where updating a key column caused duplicate key errors. The table in question had several columns that formed the Primary Key. One of those columns was userd for a serial number making groups of keys unique.
Example
Group
GroupSerial
Apple
1
Apple
1
Pear
1
Pear
1
Here we see that each row is not unique.
So how can we fix this?
First [...]
Generate SQL-code with line breaks from metadata
I’m updating a system with lots of tables and i wanted to perform the same operation on more than 20 of the tables. Writing all those update statements by hand is errorprone and using copy-paste is equally worse.
I wanted to write good code with linebreaks, logmessages and comments. What to do?
Code-generation to the rescue!
1 [...]
Powershell-script to find files not having specified text
I had the need to find files “not containing” a certain text.
I scanned the web and found all and nothing. A few dedicated search tools and editors (some payware and some free).
Since i use powershell a lot in my work i wanted to use that environment. Finding a file based on a certain text [...]
Tags
ASP.NET MVC bduf codegeneration colourcoding filesearch googlesearch humor power powersehll Powershell scm software source code management sprocs SQL sqlcode SqlServer sqltools sqlutilities SSIS stored procedures sybase testpost tips utilities version controlPages
Recent Posts
- Good tips on VB6 string handling
- Why is it called BDUF [Humor]
- Disadvantage with having code in Database
- Powershell tips - Filter files modified the last n days
- Some good links on SCM - software configuration management
Categories
Mats Codemix
- Test WLW with plugins
- ASP.NET MVC Gotcha in AccountControllerTest using october theme
- Searching with google
- Calling 7-Zip from powershell
- Powershell v2 CTP3 - profiles
- SQL-formatter
- Testing geshi
- SSIS - Deployment utility problem - cannot copy configfile
- Problems connecting to SSIS in SQL Management Studio
- SSIS - Editing DTSX-project with lots of connections = slow
Recent Comments
- matsgf on Powershell-script to find files not having specified text
- Vincent THAVONEKHAM on Powershell-script to find files not having specified text
- Vincent THAVONEKHAM on Powershell-script to find files not having specified text
- Powershell: compress files using 7-Zip « Nathan on Calling 7-Zip from powershell
- Myself on About stored procedures
Meta
Mats Codemix på kuff
- An error has occurred; the feed is probably down. Try again later.