Administration

SQLServerCentral Article

Disaster In The Real World - #2

  • Article

Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.

4.75 (4)

You rated this post out of 5. Change rating

2012-12-14 (first published: )

10,681 reads

SQLServerCentral Article

Using the Copy Database Wizard

  • Article

In a follow up article to Rahul's article on 'Copying Databases from Server to Server' Andy looks at another option, the Copy Database Wizard introduced in SQL 2000. Easy to use, but like most wizards it has a couple gotchas you need to know about. Good article for beginners and pro's alike!

4.5 (2)

You rated this post out of 5. Change rating

2002-07-18

11,292 reads

SQLServerCentral Article

The Case for SQL Logins - Part 1

  • Article

Andy says Windows Authentication "is bad". What? That's not what Microsoft says! Heck, that's not even what we say! Everyone knows NT authentication is the way to go. Then again, when was the last time Andy wrote an article that wasn't worth reading?! Read the article, rate it and add a comment - and automatically be entered in a drawing for a copy of SQL Server 2000 Performance Tuning donated by Microsoft Press.

2 (1)

You rated this post out of 5. Change rating

2002-06-25

12,651 reads

SQLServerCentral Article

Creating your own sp_MSforeach stored procedure

  • Article

This article shows you one of the most time saving stored procedure built into SQL Server and then shows you how you can modify it to affect additional objects like triggers. For example, after this article and the code in the article, you'll be able to disable every trigger in your system in one line of code.

5 (1)

You rated this post out of 5. Change rating

2002-06-17

16,452 reads

SQLServerCentral Article

Maintenance Plans - Backups and Removing Old Files

  • Article

Andy has written several good articles for us on maintenance plans - including some stuff that makes us a little more likely to use them! This week he talks about how and when old backups are removed by maintenance plans. A page turner! Well, it's only one page, but you know what we mean!

You rated this post out of 5. Change rating

2002-06-10

7,594 reads

SQLServerCentral Article

Maintenance Plans - Behind the Scenes

  • Article

Andy did "Under the Covers" last week, what the heck will it be next week? Read this article to see how maintenance plans update statistics, rebuild indexes, and remove free space from your databases. Add your comments to the article, maybe even a suggestion or two for better titles!

5 (1)

You rated this post out of 5. Change rating

2002-05-27

10,423 reads

Blogs

India-US Tariff War: Is the Indian IT Sector at Risk?

By

How U.S.-India Tariff Disputes Could Ripple Through the Indian IT Sector Although the newly...

Save BIG on Microsoft Azure Certification – Up to 100% Off!

By

🌟 Why Microsoft Azure Certifications Are Beneficial for Your Career 🗓️ How to Schedule...

Modifying a Trigger to Capture More Info: #SQLNewBlogger

By

I had someone ask me about using triggers to detect changes in their tables....

Read the latest Blogs

Forums

One big server with multiple instances, or multiple smaller servers...

By jasona.work

We're currently on SQL 2019 and will likely be looking to migrate to a...

Transitioning AlwaysOn Availability Group to Synchronous Commit Mode

By abdalah.mehdoini

Hello, I have a SQL Server with an AlwaysOn configuration consisting of three replicas...

CDC & Azure Managed Instances - Performance degredation

By Ant-Green

Anyone got any good advice for performance tuning CDC on a Managed Instance? We...

Visit the forum

Question of the Day

The Trigger Updated Column(s)

In a trigger, I can use UPDATE() or UPDATED_COLUMNS() to determine which columns were changed. For these functions, which one accepts a column name as a parameter?

See possible answers