Vasant Raj

  • Interests: Learning new things, Playing Table Tennis and watching English Premier League...

SQLServerCentral Article

Adding Custom Code To Reporting Services

Reporting Services has been greatly enhanced in SQL Server 2005 and become an integral tool in many SQL Server installations. Longtime autor Raj Vasant brings us an example of how you can enhance your reports with custom coded DLLs called from within the reporting engine.

4.9 (10)

You rated this post out of 5. Change rating

2008-01-15 (first published: )

21,579 reads

SQLServerCentral Article

Document Your Database

Computer professionals are constantly complaining about the documentation for the software they use. And are notorious for not documenting their own code very well. Longtime author Raj Vasant brings us a short article with some suggestions on how to go about documenting your databases.

1.61 (18)

You rated this post out of 5. Change rating

2008-01-02 (first published: )

13,816 reads

SQLServerCentral Article

Source Control in SQL Server

One of the most requested features from SQL Server developers is the integration of source control with T-SQL code. SQL Server Management Studio brings some integration with Visual Source Safe and longtime SQL Server author Raj Vasant explains it to us.

2.14 (7)

You rated this post out of 5. Change rating

2007-11-30 (first published: )

14,148 reads

SQLServerCentral Article

Querying System Tables

It is not recommended, but there is quite a bit of valuable information stored in the SQL Server 2000 system tables. Raj Vasant brings us a look at some of the information that you can get by directly querying the system tables and explains what is stored in a number of them, including gathering information about computed columns.

3.6 (5)

You rated this post out of 5. Change rating

2007-10-02 (first published: )

39,651 reads

SQLServerCentral Article

Using OpenXML

SQL Server 2000 added XML support awhile back, though it was limited in what is offered and can be a little confusing. SQL Server 2005 will add many more features and functions, but in the meantime, if you are looking to add some XML support to your 2000 server, new author Raj Vasant brings us some basics on using OpenXML.

4.5 (2)

You rated this post out of 5. Change rating

2007-10-02 (first published: )

42,236 reads

Blogs

Elevate Your Data Leadership: A Unique Intensive Learning Experience

By

I’ve collaborated with two industry experts to design a transformative course for data leaders:...

A New Word:Maugry

By

maugry – adj. afraid that you’ve been mentally deranged all your life and everybody...

Friday Flyway Tips–Capture the Filegroup for Tables

By

A customer asked recently why Flyway doesn’t detect the filegroup for some changes. I...

Read the latest Blogs

Forums

ssas memory issues even after switching over to table level refreshes

By stan

Hi, we just moved to 2019 std from 2016 std.   We comingle the engine,...

Using R and Python with SQL Server 2022 not possible

By kunigunde.kurzweil

I want to use R and Python with SQL Server 2022, but I get...

is process add available in standard ssas

By stan

Hi, i cant tell from these 2 articles if incremental processing is available in...

Visit the forum

Question of the Day

Daylight Saving Time

I have a Sql Server 2022 instance setup with '(UTC-05:00) Eastern Time (US & Canada)' as timezone and a PostgreSQL 16 cluster setup with 'America/New_York' as timezone; both of them have -05:00 as UTC offset. Given that in New York, in 2024 Daylight Saving Time will begin on Sunday, March 10, at 2 AM, what happens if I execute the following statements in their own environment? Sql Server:

select dateadd(HOUR, 1, cast('20240310 01:00:00-05:00' as datetimeoffset(0)));
PostgreSQL:
select date_add('20240310 01:00:00-05:00'::timestamptz, '1 hour'::interval);

See possible answers