James Travis

PASS Summit 2004 - Another Look

Our longtime member and author, James Travis went with the SQLServerCentral.com crew to the 2004 PASS Summit in Orlando last month. For those of you that don't recognize the name, he goes by Antares686 in the forums and has been generous enough to post over 6,000 times, giving lots of his time and knowledge to helping others. He jotted down a few notes on the conference for those of you that weren't there and are considering going next year.

2004-10-14

3,467 reads

Hidden Dangers!

How many of you register a server in Enterprise Manager? Now how many of you click the "save password" box? Probably most of you. Are you aware of the security risks associated with this? James Travis looks at one of potential problems here and other security issues relating to SQL-DMO.

2004-05-04

7,570 reads

UDF to get first date or trim time for Datepart.

Not long ago I was in a forum discussion when someone presented another way to get the date with time value of midnight by doing similar to thisDATEADD(dd,DATEDIFF(dd,0,@DATE),0)Which I find is much cleaner than any other option I have seen or tried myself. Seeing this I realized there are many other dates that can be […]

4 (1)

2003-05-02

445 reads

Remove old DTS Package versions

This Procedure is what I use to clean out all the old DTS package version on my server periodically. You just place it in the msdb database and run it as you need to.Note: Although I have never had an issue with it, I do suggest backup msdb database beforehand, just in case you wack […]

5 (1)

2002-11-30

288 reads

Blogs

Power BI Monthly Digest – September 2020

By

In this month’s Power BI Digest Matt and I will again guide you through...

[MSSQLTips] Visual Studio 2019 Configuration for the Production DBA

By

Happy Tuesday everyone… Today I am honored to have my first article published on...

Daily Coping 22 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

SCOM/SCCM alert when Always On High Availability dashboard is green

By webrunner

Hello experts, Does anyone know why SCOM (or is it SCCM?) would send the...

Restart SQL server from CMD

By SQLAddict01

We have a issue in SQL Server 2017 (RTM-CU21) with SSISDB when a server...

Replication issue

By premkuttan

my table is getting replicated from server 1 to server 2. I got a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers