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
Miscellaneous
SqlCredit - Part 4: Schema and Procedure Security
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
SqlCredit - Part 3: Schema/Proc Updates and Automated Unit Testing
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
SqlCredit - Part 2: Creating the Database, Tables, CRUD Procedures
Continuing with this series on building a database system
2007-06-13
3,926 reads
Part 1: Introduction, Business Problem, and Initial Design
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
XML Workshop II - Reading values from XML variables
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
Change DTS package owner
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
Upload multiple XML files to an XML data type column
Learn how to upload multiple XML files to an SQL Server 2005 database XML data type column.
2007-05-29
3,285 reads
Row counts for all tables in a database
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
Record Count for Tables
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
Blogs
SQL Server 2025 Unleashed Live Training – A New Era Begins
I’m excited to announce my brand-new SQL Server 2025 Unleashed live online training on...
Build a Snapshot Backup Catalog in Pure Storage - The SQL Server 2022 Edition
In my previous post, I showed you how to build a snapshot backup catalog...
Advice I Like: Training Employees
By Steve Jones
Train employees well enough that they could get another job but treat them well...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Connecting to SQL express 2019 server
Hello, Our old server is on its last legs, and I'm transitioning to a...
Docker Advice for SQL Server in Production
Comments posted to this topic are about the item Docker Advice for SQL Server...
Question of the Day
Striped Backup File Limits
In SQL Server 2022, how many backup files can I have in a striped backup?
See possible answers