Basit Aalishan Masood-Al-Farooq

Basit Farooq is a Lead Database Administrator, Trainer and Technical Author. He has more than a decade of IT experience in development, technical training and database administration on Microsoft SQL Server platforms. Basit has authored numerous SQL Server technical articles, and developed and implemented many successful database infrastructure, data warehouse and business intelligence projects. He holds a master's degree in computer science from London Metropolitan University, and industry standard certifications from Microsoft, Sun, Cisco, Brainbench, Prosoft and APM, including MCITP Database Administrator 2008, MCITP Database Administrator 2005, MCDBA SQL Server 2000 and MCTS .NET Framework 2.0 Web Applications.

All authors

Why you may or may not consider using Database Snapshots!

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

Microsoft introduced database snapshots with SQL Server 2005. A database snapshot is a static, read-only copy of a source database...

2011-12-17

8,252 reads

Get drive & mount points space information in SQL Server 2005 by using CLR Stored Procedure?

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

As we know xp_fixeddrives can only be use to retrieve normal fixed drives space information. It cannot be used to retrieve information...

2011-12-16

2,048 reads

My first blog post!

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

I’ve started my own SQL blog. Hopefully I’ll write some interesting SQL blog posts here soon.

2011-12-16

535 reads

All authors

Blogs

How to Connect to SQL Server When Nothing Else Works – DAC

By gbargsley

It's 2 AM. Your phone is going off. Users can't connect to the application,...

Get a Range of Sequence Values: #SQLNewBlogger

By Steve Jones

I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...

The Agent Era: When “How do I…?” Replaces “Where do I click?”

By Arun Sirpal

After a year away getting to grips with AI and its application across the...

Read the latest Blogs

Visit the forum

Question of the Day

Creating a JSON Document II

I want to create a JSON document that contains data from this table:

TeamID TeamNameCity         YearEstablished
1      Cowboys  Dallas       1960
2      Eagles   Philadelphia 1933
3      Packers  Green Bay    1919
4      Chiefs   Kansas City  1960

If I run this code, what document(s) is/are returned?

SELECT json_objectagg( n.city : n.TeamName)
FROM dbo.NFLTeams;

See possible answers