Jacob Sebastian

SQLServerCentral Article

Web Data Adminstrator

Accessing your SQL Server without Enterprise Manager or Management Studio can be a difficult task without a custom application. Especially if you are not in the office. Jacob Sebastian brings us an open source application that can make this much easier for DBAs.

You rated this post out of 5. Change rating

2008-05-27 (first published: )

7,456 reads

SQLServerCentral Article

XML Workshop I - Generating XML output using FOR XML with AUTO and RAW

Quickly becoming the SQL Server XML expert, Jacob Sebastion brings us a great new article that expands upon his very popular series on XML in SQL Server. This time he examines the FOR XML PATH option, which provides additional formatting capabilities.

4.21 (14)

You rated this post out of 5. Change rating

2008-05-22 (first published: )

20,656 reads

SQLServerCentral Article

Tracking Database Schema Changes with DbPro

Tracking changes to your development environments is important to ensure that your deployments to production go smoothly. Jacob Sebastion brings us a look at how well the Visual Studio Team System Edition for Database Professionals can help you with this task.

4.5 (2)

You rated this post out of 5. Change rating

2008-05-19 (first published: )

6,530 reads

SQLServerCentral Article

Writing Faster T-SQL

How many times have you wished that your queries performed better? Performance Tuning is a bit of an art, but learning about new techniques and which things work help grow your knowledge. Jacob Sebastian brings us the first part of a series on writing better performing queries.

4.41 (17)

You rated this post out of 5. Change rating

2008-03-31 (first published: )

30,051 reads


THAT Conference 2024 in Wisconsin Dells


I’m headed back to Wisconsin Dells next week for THAT! Conference 2024. This is...

7 Best Online Advanced SQL Training Courses to Learn in 2024


The world runs on data, and SQL is the key to unlocking its secrets....

Calling a REST Endpoint from Azure SQL DB


External REST endpoint invocation in Azure SQL DB went GA in August 2023. Whereas...

Read the latest Blogs


Issues adding and updating a column

By richardmgreen1

Hi all   I'm hoping someone will able to say "you're an idiot because....."...

Deadlocks with UPDATE statements using serializable transaction isolation level

By zoggling

We are seeing frequent deadlocks occurring due to a particular stored procedure that is...

Use Polybase with ODBC to create external table

By blom0344

I'm trying to use the installed Polybase service on an  SQL 2019 server to...

Visit the forum

Question of the Day

The Last DBCC Date

How can I easily get the last DBCC CheckDB date from T-SQL in SQL Server 2022?

See possible answers