Articles

Pseudo web service using xmlHTTP

This article delves into the mysterious xmlHTTP object and the supporting ASP code. I've got to tell you that I really love using this object. Basically what I like about it is that through xmlHTTP you can expose some or all methods of any ActiveX class to the client-side user. What this means is you are giving the user the capability of calling your back-end Active X controls. And the best part of it all is that the entire communication process takes place behind the scenes!

2001-08-14

7,421 reads

Save Your Packages Locally

DBAs often ask how to transfer DTS packages and move them between servers. They also want a version control system that is more robust than that provided in msdb. Steve Jones looks at one of the features of the DTS designer that solves both of these problems.

4 (1)

2001-08-09

5,898 reads

Some Comments about our Discussion Area

Sometimes as hard as you look you just can't find the answer or idea you're looking for - that's when a good discussion forum comes in handy! Read this article for some tips and tricks on using our discussion forums successfully. Then when you have time, browse our current discussions and see if they work.

2001-08-07

2,290 reads

Monitoring blocking on a Server

This article will demonstrate how to monitor active spids, blocked by spids,cpu,I/O,cmds and app name being issued in a real time fashion by using the cmd shell calling a T-SQL script and a resource kit utility.

2001-08-07

49 reads

Blogs

New Power BI Report Design Pre-Con in 2020

By

I’m excited to announce that I will be offering a full-day pre-con about Power...

Resetting an Azure SQL Database Admin Password

By

This is likely something that most people know, but it was a bit confusing...

Read the latest Blogs

Forums

Query runs for days when upgrading to 2017

By askcoffman

We upgraded our datawarehouse sql server from 110 to 140, RTM - CU17. In...

Connections during AG Failover

By J-M.L

Hello everyone, I am playing with Availability Groups for the first time (a bit...

How to grant CREATE TABLE but deny DROP TABLE?

By webrunner

Hello experts, We have an application that creates new lookup tables on the fly....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers