Jon Reade

How to Schedule a SQL Server Database Creation Script

Scripting out your SQL Server 2000 objects is useful in any number of ways. You can save off the scripts for version control, generate the scripts needed to migrate to new hardware or a new environment, or just package up your application for deployment. Jon Reade brings us a look at the SCPTXFR utility, which can prove very valuable in managing your scripts.

4 (5)

2006-10-13 (first published: )

38,108 reads

Selecting a Web Host for your SQL Server Driven Website Part 2

Many of us have SQL Servers at work that we learn on, test with work, etc. But getting your own SQL Server for a website can be a tricky thing. Especially on a budget. Or maybe your company wants to have their website hosted. Before you spend any hard earned money, read part 2 of this two part series by Jon Reade on what to look for when setting up a SQL Server hosting company.

2005-04-20

5,278 reads

Selecting a Web Host for your SQL Server Driven Website Part 1

Many of us have SQL Servers at work that we learn on, test with work, etc. But getting your own SQL Server for a website can be a tricky thing. Especially on a budget. Or maybe your company wants to have their website hosted. Before you spend any hard earned money, read this two part series by Jon Reade on what to look for when setting up a SQL Server hosting company.

2005-04-19

6,119 reads

SQL Server 2005 DBCC Command Quick Reference

The next version of SQL Server due in 2005 will bring about many changes in how it works, with .NET, the CLR integration, Integration Services, and much more. Many of us are looking to get a jump on the product and see where these changes might affect our scripts and environments. Jon Reade has started the work in decoding the new DBCC commands, which ones work and which don't. Since there's a limited amount of documentation for the Beta product, read about his detective work and send him off an

3.64 (11)

2004-12-16

33,723 reads

Blogs

Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …)

By

Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...

ANSI_WARNINGS = OFF can break update statements with some SQL features

By

Working on a SQL 2017 database where an external, non-Microsoft application has direct access...

Bring Your Own Key to Azure SQL Database Managed Instance TDE

By

Last year Azure SQL Database Managed Instance saw the introduction of bring your own...

Read the latest Blogs

Forums

Transactions/Second

By SteveOC

Hello.Does anybody have a way to identify what transactions ran in an interval (i.e....

How to update status with conflict data where chemical temp table have same chem

By ahmed_elbarbary.2010

How to update status with conflict data where chemical temp table have same chemical...

Blob to ADF to Stored proecure

By SQL_Surfer

I'm reading file from BLOB through ADF and I would like to pass the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers