Miscellaneous

Technical Article

J2EE and SQL Server: Making a JDBC Connection

  • Article

Using a SQL Server back end with a Java application server may sound like an unnatural proposition but there's no need to bow to such arbitrary limitations. In this article you'll get step-by-step instructions on making a JDBC connection between the four most popular Java application servers and Microsoft SQL Server.

2007-03-14

2,136 reads

Technical Article

Returning a Comma Delimited string

  • Script

One of the small quirks of SQL is that it can add each row to a variable.In the most common case, this is used to generate a comma delimited list.The script shows how to do this wiht a scalar function, so that multiple rows are returned.The script shows calculating the column sum the hard way […]

You rated this post out of 5. Change rating

2007-03-26 (first published: )

590 reads

Technical Article

Using SMS 2003 SQL Views to Create Custom Reports

  • Article

Microsoft Systems Management Server (SMS) 2003 Reporting uses Microsoft SQL Server views to provide access to data from the tables in the SMS site SQL database and to offer an efficient reporting option. The SMS site SQL database contains a large collection of information about the network, computers, users, user groups, and many other components of the computing environment. This database also contains objects that represent SMS items such as advertisements, packages, queries, reports, and status messages.

2007-03-08

1,706 reads

Technical Article

Maintenance Plan Cleanup Proc

  • Script

If you use 2 different maintenance plans (one for full-recovery databases and one for simple-mode databases) this proc can help keep the databases in the right plan. You can schedule this as a job and if anyone changes the recovery mode of a database or adds/removes a database, this proc will ensure that the changes […]

You rated this post out of 5. Change rating

2007-04-06 (first published: )

1,620 reads

Technical Article

List of RTA numbers based on the lucky number you

  • Script

Using this procedure you can get the list of 4 digit number and the sum of those 4 digits is equal to your given input number. its helpful when you choose your RTA (Regional Transportation Authority) Vehicle number.Input For this procedure: Single Digit Number (May be your luck number)Output From this procedure: it gives the […]

You rated this post out of 5. Change rating

2007-04-04 (first published: )

123 reads

SQLServerCentral Article

Running a Query Using a Text File for Input

  • Article

When automating administrative actions for SQL Server, there are a number of ways to handle the workflow. Longtime SQL Server DBA Roy Carlson brings us a technique for using a text file as input to the standard SQL Server tools.

4.5 (2)

You rated this post out of 5. Change rating

2008-01-14 (first published: )

21,244 reads

Blogs

Come See Me at the PASS Data Community Summit

By

I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...

SQL Clone at Scale with Striped Backups

By

I had a customer recently reach out to ask if SQL Clone would work...

How to Set Up SQL Server 2025, Ollama and NGINX in Docker Without the Headaches

By

Ollama SQL FastStart kit just works out of the box. It makes it easy...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Holistic Approaches to Overcoming Erectile Dysfunction

By marksmith9698

Erectile dysfunction (ED) affects millions of men and arises from a combination of physical,...

Managing unused indexes

By JasonO

While doing some housekeeping activity on several old but large production databases, I come...

Visit the forum

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