SQL Server Management Objects
In this column, I discuss how SMO can be used to examine a database’s objects and to perform a variety of administrative tasks.
2007-06-18
2,930 reads
Additional Articles
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
Bridging the Impedance Mismatch Between Business Intelligence and Serv
Business intelligence (BI) and service-oriented architecture (SOA) have conflicting principles and needs. This article will show you how to make peace between them.
2007-06-11
6,335 reads
Cut development time with SQL Server 2005's synonyms
A synonym is a new object to SQL Server 2005. It is a way to give an alias to an already existing object. For example, if you have a table named SalesHistoryFromArchiveF
2007-06-08
3,890 reads
How to Read Raw Files in SSIS
If you've ever used SQL Server 2005 Integration Services (SSIS), you will have come across raw files. Microsoft introduced them with SSIS as a mechanism for storing data on the local file system. The design of raw files enables data to be written very quickly but, unfortunately, to achieve this performance Microsoft has used a proprietary binary storage format.
2007-06-07
3,167 reads
Enforce Business Rules for All Your Data with Constraints
The only way to guarantee that your business rules are always enforced for all your data is by using constraints. Learn how to use them to enforce business rules in the database.
2007-06-05
3,215 reads
A Primer on Managing Data Bitemporally
In systems that require, for auditing purposes, advanced logging and reproducibility of reports between runs, a straightforward update, insert, or delete may be counter-productive. In such circumstances, a bitemporal model is necessary
2007-06-04
2,464 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Morowali Telp:Cs.08216977726
Whatsapp:08216977726 Jl. Trans Sulawesi, Keurea, Kec. Bahodopi, Kabupaten Morowali, Sulawesi Tengah 94974
BCA KCP Kertopaten Telpon. 083135766741
WhatsApp 083135766741 Jl. Pegirian No.114, RT.007/RW.10, Sidodadi, Kec. Simokerto, Surabaya, Jawa Timur 60145
BCA KCP Kas Palu Barat Telp:Cs.083831618816
Whatsapp:083831618816 Jl. Sungai Malei No.35, Ujuna, Kec. Palu Bar., Kota Palu, Sulawesi Tengah 94111
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers