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,534 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,726 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,565 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,059 reads

Blogs

Using a Local Large Language Model (LLM): Interacting with Local LLMs Using PowerShell

By

As AI continues to evolve, many of us are looking for ways to leverage...

Monday Monitor Tips: Finding the Hostname for Queries

By

I was chatting with a customer recently and they wanted to know which host...

Can AI Read Execution Plans?

By

Yeah, yeah, second AI post in a row. I promise not to make a...

Read the latest Blogs

Forums

Size of DB on physical disk doesn't match Disk Usage by Table report

By water490

Hi everyone I am looking at the size of my db on disk (ie...

Getting the TEXTSIZE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting the TEXTSIZE

The Return to the Office Debate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Return to the Office...

Visit the forum

Question of the Day

Getting the TEXTSIZE

How can I check what value I used for TEXTSIZE? I ran this code:

SET TEXTSIZE 8096
But then deleted the code and couldn't remember. Is there a way to check this?

See possible answers