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,620 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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(14)

You rated this post out of 5. Change rating

2008-05-22 (first published: )

20,860 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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2008-05-19 (first published: )

6,609 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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(17)

You rated this post out of 5. Change rating

2008-03-31 (first published: )

30,087 reads

Blogs

Word to the wise: don’t turn on SQL vulnerability checks on a blog about SQL

By

Recently, in an attempt to thwart leechers (1990s kids will know), I added some...

Dazzling Stuff in Databricks (SQL) – Qualify

By

Once upon a time I had a series about some cool stuff in Snowflake:...

Advice I Like: Overnight Success

By

“Most overnight successes – in fact any significant successes – take at least 5...

Read the latest Blogs

Forums

Kantor Resmi BCA KCU MADIUN Telp&Wa .0821°8200°203

By layanan_Bca88

Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132.. Fungsi Layanan:...

Kantor BCA KCU BOROBUDUR Telp&Wa .0821°8200°233

By m4rt1n4

Call Cs 08218200233 Jl. Borobudur No.I, RT.03/RW.07, Mojolangu, Kec. Lowokwaru, Kota Malang, Jawa Timur...

Why Successful SQL Server Backups Are Not Enough

By Almighty

Comments posted to this topic are about the item Why Successful SQL Server Backups...

Visit the forum

Question of the Day

Adding Bits II

I have a table, dbo.bittest, where I am testing an application response. This has this structure:

CREATE TABLE [dbo].[BitTest]
(
[insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()),
[a] [bit] NULL
) ON [PRIMARY]
GO
My application runs this code:
INSERT dbo.BitTest
(
    insertdate,
    a
)
VALUES
(DEFAULT, true)
GO

See possible answers