SqlCredit - Part 2: Creating the Database, Tables, CRUD Procedures
Continuing with this series on building a database system
2007-06-13
3,926 reads
Continuing with this series on building a database system
2007-06-13
3,926 reads
This ActiveX Script runs in DTS Designer and will clean up all unused connection objects. This allows you to rename connections at will by selecting "New Connection" and typing a new name. It also allows you to copy and paste connections then rename them. Then you can cleanup leftover connections when development is complete.
2007-06-12 (first published: 2005-01-05)
463 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
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
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
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
This was just an answer in a forum in September, but I keep getting requests for the script. So I am sharing it here for anyone that could be interested: Problem: large amount of registered servers, multiple DBA's needing updated registration info, DBA workstations added or rebuilt, many servers added at once. In cases like […]
2007-06-05 (first published: 2005-01-26)
895 reads
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
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
COALESCE() accepts a series of values and a value to use in the event that all items in the list are null; then, it returns the first not-null value. This tip describes two creative uses of the COALESCE() function in SQL Server.
2007-06-01
5,777 reads
We’re working through the major refresh of my Certified Kubernetes Administrator series at Pluralsight! The...
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
Comments posted to this topic are about the item Reporting Services Editions
Comments posted to this topic are about the item Exporting and Importing Registered Servers...
Hi All, I need a sanity check, and hoping someone here can provide it.......
In which editions of SQL Server 2022 can you run Reporting Services?
See possible answers