SqlCredit - Part 5: Adding Card, Vendor, and Purchase, Plus Much Refac
As I built out the last pieces of the original table set (Card, Vendor, and Purchase), I found a number of pieces that needed to be fixed in the design.
2007-06-19
1,737 reads
As I built out the last pieces of the original table set (Card, Vendor, and Purchase), I found a number of pieces that needed to be fixed in the design.
2007-06-19
1,737 reads
In this month’s installment, we will add security to the existing code and add new unit tests to prove that security.
2007-06-15
2,657 reads
In this month’s installment, we will discuss updates based on feedback from part 2 as well as introduce automated unit testing.
2007-06-14
2,494 reads
Continuing with this series on building a database system
2007-06-13
3,926 reads
The purpose of the SqlCredit series is to demonstrate the database design and development portion of a development project. We will build a complete, functioning, tested credit card database to illustrate the complete software development lifecycle.
2007-06-12
3,306 reads
Continuing with his series on XML in SQL Server 2005, Jacob Sebastian brings us a number of examples on how to work with XML in different situations with SQL Server 2005.
2007-06-06
21,537 reads
This simple script is useful if you have a lot of scripts owned by developers, and you want to re-assign them all in one go to SA or any other login. Note the section which produces a rollback if you have any problems after the re-assign
2007-09-27 (first published: 2007-06-01)
2,380 reads
Learn how to upload multiple XML files to an SQL Server 2005 database XML data type column.
2007-05-29
3,285 reads
I saw a script on here that outputs commands to the messages pane in Query Analyser. When run, these scripts output row counts for all your tables. This script does the same thing, but in one step.Tested on SQL Server 2000.
2007-09-25 (first published: 2007-05-24)
758 reads
This script was created for an Oracle to SQL 2005 migration. It creates a table, and then populates it with the record counts for each table in a given schema. (You will need to replace the xxxx text with your schema name for it to work). I prefer populating a table with this data, then […]
2007-09-24 (first published: 2007-05-24)
1,020 reads
I’m excited to announce my brand-new SQL Server 2025 Unleashed live online training on...
In my previous post, I showed you how to build a snapshot backup catalog...
By Steve Jones
Train employees well enough that they could get another job but treat them well...
Comments posted to this topic are about the item Create an HTML Report on...
Hello, Our old server is on its last legs, and I'm transitioning to a...
Comments posted to this topic are about the item Docker Advice for SQL Server...
In SQL Server 2022, how many backup files can I have in a striped backup?
See possible answers