Articles

Technical Article

SQL Server 2000 Report Pack for Financial Reporting

The SQL Server 2000 Report Pack for Financial Reporting is a set of six Microsoft SQL Server 2000 Reporting Services reports that work with a sample financial database called FinSampleDB.

With the Report Pack, you have the choice of using the sample reports either as-is or as templates for designing new reports using the SQL Server Reporting Services Report Designer.

2004-10-11

1,924 reads

Technical Article

SQL Server 2000 Report Pack for Microsoft Exchange

The SQL Server 2000 Report Pack for Microsoft Exchange is a set of 13 Microsoft SQL Server 2000 Reporting Services reports that work with a Microsoft Exchange sample reporting database.

With the Report Pack, you have the choice of using the sample reports either as-is or as templates for designing new reports using the SQL Server Reporting Services Report Designer.

2004-10-08

1,858 reads

SQLServerCentral Article

Review: Typhon III from NGSSoftware

Every shop with any sort of IT organization should be scanning for vulnerabilities and issues with their systems and SQL Server is no exception. Security software vendor has a tool that can scan and report on all your SQL Servers is an easy to use product called Typhon III. Our security expert Brian Kelley takes a look at this product.

You rated this post out of 5. Change rating

2004-10-07

13,922 reads

SQLServerCentral Article

Analysis About Analysis Services

SQL Server is an amazing business intelligence platforum, including many tools that other vendors force you to buy separately. New Author Ramunas Balukonis is working with this platform and has built a system that helps him perform analysis on just what his Analysis Server is doing.

(2)

You rated this post out of 5. Change rating

2004-10-06

9,978 reads

Technical Article

Optimized ADO.NET

This article contains guidelines compiled by examining the .NET implementations of shipping .NET applications and analyzing the common performance mistakes that we found. The guidelines discuss selecting .NET objects and methods, designing .NET applications, retrieving data, and updating data.

2004-10-06

3,043 reads

Technical Article

SQL Server 2000 Report Pack for Microsoft CRM

The SQL Server 2000 Report Pack for Microsoft CRM is a set of six Microsoft SQL Server 2000 Reporting Services reports that work with the Microsoft CRM 1.2 sample database.

With the Report Pack, you have the choice of using the sample reports either as-is or as templates for designing new reports using the SQL Server Reporting Services Report Designer.

2004-10-05

1,758 reads

SQLServerCentral Article

Exchange from SQL Server

SQL Server allows data access from many sources, probably any that you could want. Some, however, are easier than others. Have you ever tried to update information in Exchange from SQL Server? Not that easy, but new author Steve Boriotti has written code as well as a short article on how you can make this happen.

You rated this post out of 5. Change rating

2004-10-04

12,982 reads

Blogs

Prime Day Recommendations

By

It’s Prime Day. A few of my recommendations, since I want to do some...

Fabric for Operational Reporting & SQL Endpoint Trap

By

With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...

Crawl, Walk, Run with Agentic Development of Power BI Assets

By

If you’ve been watching AI roll through the data community and thinking, “this seems...

Read the latest Blogs

Forums

SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About

By Terry Jago

Comments posted to this topic are about the item SQL Art, Part 4: Happy...

Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments

By Massimo Preitano

Comments posted to this topic are about the item Concurrency and Baseline Control: Level...

Spending Time in the Office

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Spending Time in the Office

Visit the forum

Question of the Day

Multiple Values Inserted

I have this code on SQL Server 2022. What happens when it runs all at once?

DROP TABLE IF EXISTS dbo.Commission
GO
CREATE TABLE dbo.Commission
(id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY
, salesperson VARCHAR(20)
, commission VARCHAR(20)
)
GO
INSERT dbo.Commission
( salesperson, commission)
VALUES
( 'Brian', 12 ),
( 'Brian', 'None' )
GO
 

See possible answers