SQLServerCentral Editorial

The September Energy Update

I think you'll be happy to know that there are interesting people out there. One of my neighbors, maybe a couple miles away, has a windmill that I've watched run regularly as I drove my daughter to school all last year. I finally grabbed their address one day and wrote them a letter, not wanting to just walk up to their door with a list of questions. I waited patiently for a couple weeks and finally got an email.


153 reads

SQLServerCentral Editorial

Free Training

I heard on Thursday a couple weeks ago that someone who had received a free admission to the PASS conference had cancelled and wasn't able to attend. It was last minute and that pretty much ruled out any chance to have a contest, so I called a friend in Denver who's a DBA and doesn't get much of a budget for training. I offered him the admission and he said he'd let me know Friday.

5 (6)


1,435 reads

SQLServerCentral Editorial

Billy-yons and Billy-yons of Records

There was an article last week with a great title: The Mother of All Genealogy Databases, and so I had to take a look at it. It talks about some of the large databases on the Internet that are collection public records and linking them together to help people find out about their individual and family histories. The largest site so far, Ancestry.com, supposedly has 5 billion records.


215 reads

SQLServerCentral Editorial

Three Months

That's what we were estimating the rewrite of this site would take. After all, to me it's a pretty simple site, a few content sections, some date specific stuff, scheduling, a few admin tools, not that much, right?

4 (1)


140 reads

SQLServerCentral Editorial

Opening Day

Today is the opening day for the PASS conference here in Denver and it's kind of exciting. As many of you read this, I've hopefully gotten Simon Galbraith, owner of Red Gate software, and my boss, out here at the ranch shoveling manure. He's anxious to get on the ATV for a ride, so maybe I can work out a deal to reduce my workload 🙂

4 (1)


112 reads

SQLServerCentral Editorial

Unethical or Just Sneaky

One of the fundamental rules of a stable, controlled production system is that you apply updates singly, after they've been tested, and you document the change. This way you can ensure that if a problem occurs, you can do some backtracking to see what might have caused instability.

5 (4)


1,205 reads


Daily Coping 11 Aug 2022


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Using DBCC CLONEDATABASE to create a schema only copy of your database.


DBCC CLONEDATABASE is one of those features that I don’t use often but it’s...

VS Live Microsoft HQ Slides and Code


Thanks to everyone that attended my sessions today at VS Live. I have my...

Read the latest Blogs


SSIS Running From SQL Job Fails - Most Of The Time

By AMCiti

I have three SSIS packages created in Visual Studio 2019, going against a SQL...

Grand total of the sum of a field taking another field

By JeremyU

Hello everyone, I am trying to calculate the field called "Load weight". The calculation...


By adisql

Hi, Trying to Create a query that will execute on the current database and...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers