SQLServerCentral Article

SQL Server Express

SQL Server Express 2005 is a new product that has been released (in Beta) as a followon to the MSDE product. A number of new features as well as complementary products for all of the .NET development tools are now available. Read on for a quick summary of what this new product line is all about.

SQLServerCentral Article

Backup Scenarios for successful SQL Server Restores and Recovery

SQL Server has a great backup and recovery architecture, but you have to know how to properly configure and use the server to ensure that you will not be seeking new employment anytime soon. A few of the Sonasoft team have written this short piece on strategies for setting up your backup jobs to ensure recovery in the event of a disaster. Welcome new authors Bilal Ahmed, Kiran Kumar, and Vas Srinivasan.

SQLServerCentral Article

Save Yourself - Recovering from an XP Disaster

How many of you dig into Windows XP extensively? Working with hardware and the OS isn't something that many DBAs deal with these days. Most companies have an admin to work on servers, hardware, workstations, etc. But sometimes you need to help yourself out. Steve Jones had to work to get his laptop back after an XP disaster. Read on and hopefully this will help you one day recover your system.

Blogs

Understanding Lakehouse Permissions in Microsoft Fabric

By

Understanding how permissions work in Microsoft Fabric can be essential for anyone managing access...

The Cost of Not Having a DBA

By

Does skipping a DBA save money? Wait until your system grinds to a halt,...

Who are you? Building an identity map.

By

I admit that until I read the article, Who are you as a Leader?,...

Read the latest Blogs

Forums

Union where it matches against only one shared column

By ldanks

Hi folks I have two tables, both with a NAME, START and END fields...

How to update using data from three tables?

By mjdemaris

I am in the process of migrating from MySQL to SQL Server. I have...

Select Returning Blank Rows

By JP789

I have the following select statement --#1 Select supplier, s.refnum, desc from supplier as...

Visit the forum

Question of the Day

Replacing a NULL II

What is returned from this code in SQL Server 2022?

DECLARE
  @value INT = NULL
, @value2 VARCHAR(20) = NULL;
SELECT COALESCE (@value, @value2, 100.5) AS Result;
GO

See possible answers