Development

SQLServerCentral Article

A Report to Display and Edit User 'Rights'

  • Article

Reporting Services is quickly becoming one of the most popular parts of SQL Server and new author Jonathan Spink brings us an interesting use of this subsystem. He explains how Reporting Services can do more than just display data; it can also provide an easy interactive way to make changes without the overhead of a complete .NET application.

(1)

You rated this post out of 5. Change rating

2006-08-09

6,919 reads

Technical Article

Creating a Basic SSAS Cube

  • Article

In this video demonstration, you'll quickly learn how to create a basic cube using the Cube Wizard upon a data warehouse. Brian walks through the entire process in this 10 minute video to get you started with creating a browsing a cube. Free registration required.

2006-07-12

1,597 reads

SQLServerCentral Article

Data Driven Subscriptions

  • Article

Reporting Services is a great subsystem for SQL Server that fulfills quite a few needs. However just like SQL Server, there are some features that are limited to the Enterprise Editions, something that not every user can afford to implement. New author Jason Selburg brings us a way to implement subscriptions to reports using Standard edition.

(6)

You rated this post out of 5. Change rating

2006-06-01

25,661 reads

Technical Article

Load 1TB in less than 1 hour

  • Article

This project was done using SQL Server 2005 Enterprise Edition (with SP1 beta) using the BULK INSERT command with 60 parallel input files, each of approximately 16.67 GB. The best time I got was 50 minutes. Hewlett Packard was kind enough to loan me some time one night on the machine they use to do the TPC-H tests. It is an Itanium2 Superdome with 64 1.6GHZ 9M (Madison) CPUs. For the insert tests the system was equipped with 256GB of RAM. The HP SAN configuration is rated at 14GB per second throughput.

2006-05-30

2,290 reads

Blogs

SQL Server Journey Part 2: Modern Era (2017 – 2026) – AI/Cloud First

By

Following up on my Part 1 baseline, the journey from 2017 onward changed how...

Google Moves Up Post-Quantum Cryptography Timeline

By

In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...

The Book of Redgate: No Politics

By

In today’s world, this might mean something different, but in 2010, we had this...

Read the latest Blogs

Forums

Dancing Robot Goes Rogue

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Dancing Robot Goes Rogue

advice as i migrate my winscp based ssis pkg to our prod server

By stan

Hi , i installed winscp on my pc, added it to GAC thru vs...

Identities and Sequences II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Identities and Sequences II

Visit the forum

Question of the Day

Identities and Sequences II

In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?

See possible answers