Bilal Ahmed

Bilal Ahmed

Bilal Ahmed is the CTO & Vice President of Engineering at Sonasoft. Bilal has over 10 years of experience in the development and integration of systems and database applications. Bilal has extensive experience with Oracle and SQL databases and has managed over hundred production and development servers across USA, Canada, UK and Australia. Bilal can be reached at bilala@sonasoft.com



Kiran Kumar



Kiran Kumar is the Database Administrator and Sonasafe Technical Architect. Kiran has over 8 years of experience in administering hundreds of high-end Microsoft SQL and Oracle Database Servers. Kiran is an expert in Database Backup/Recovery, Stand-by, Failover Clusters and performance trouble shooting.



Vas Srinivasan



Vas Srinivasan is the Vice President of Marketing at Sonasoft. Vas has over 16 years of experience in Technology, Manufacturing and Research. Vas can be reached at vass@sonasoft.com


SQLServerCentral Article

SQL Server Redundancy for SMBs

Building a highly fault tolerant and available SQL Server is expensive and difficult. This brings about unique challenges for small businesses who often lack the resources of large enterprises. Bilal Ahmed and Shivan Bindal discuss the various ways of building redundancy and the challenges of each.

3.5 (2)

You rated this post out of 5. Change rating

2006-02-21

5,980 reads

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.

4 (2)

You rated this post out of 5. Change rating

2004-06-29

19,335 reads

Blogs

Troubleshooting TempDB Log Full Errors When SSMS Won’t Connect

By

Have you ever received the dreaded error from SQL Server that the TempDB log...

Accelerating AI with Confidence: Why Microsoft Purview is Key to Responsible Innovation

By

Artificial intelligence is no longer a distant concept. It is here, embedded in the...

The Mystery of SQL Server 2025’s New Tricks – Scooby Dooing Episode 5

By

Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail...

Read the latest Blogs

Forums

Bottlenecks on SQL Server performance

By runarlan

We have a BI-application that connects to input tables on a SQL Server 2022...

Is there some good routines for updating SQL Server database objects with GitHub

By Rod at work

At work we've been getting better at writing what's known as GitHub Actions (workflows,...

The Tightly Linked View

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Tightly Linked View

Visit the forum

Question of the Day

The Tightly Linked View

I try to run this code on SQL Server 2022. All the objects exist in the database.

CREATE OR ALTER VIEW OrderShipping
AS
SELECT cl.CityNameID,
       cl.CityName,
       o.OrderID,
       o.Customer,
       o.OrderDate,
       o.CustomerID,
       o.cityId
 FROM dbo.CityList AS cl
 INNER JOIN dbo.[Order] AS o ON o.cityId = cl.CityNameID
GO
CREATE OR ALTER FUNCTION GetShipCityForOrder
(
    @OrderID INT
)
RETURNS VARCHAR(50)
WITH SCHEMABINDING
AS
BEGIN
    DECLARE @city VARCHAR(50);
    SELECT @city = os.CityName
    FROM dbo.OrderShipping AS os
    WHERE os.OrderID = @OrderID;
    RETURN @city;
END;
go
What is the result?

See possible answers