Clipmarks - ntziolis's sql 2005

8
POPS Command line reference for Windows, Sql Server, Linux ect..

by BitDrifter 8-4-2006

No Remarks

2
POPS CodeSmith 4.0 Public Beta Released

by travislaborde 10-19-2006

this awesome tool just keeps getting better.

1
POPS SQL Server 2005 List all IDENTITY columns

by Osolage 12-12-2007

When I upgraded one of my databases to MSSQL2K5 compatibility mode, I noticed that many of my insert statements on tables with identity columns started generating primary key violations. I realized that I needed to run DBCC CHECKIDENT on all of those tables to fix the problem. I found this script, which lists all of the tables, in a database, that have identity columns. Then a copy/paste and regex search/replace generated a script for me to run the DBCC CHECKIDENT for each table listed. After running the DBCC CHECKIDENT, the problem went away.

1
POPS .NET Tools for Oracle Connectivity

by grefly 10-26-2006

No Remarks

1
POPS You can use an external editor with sqlcmd

by Osolage 5-8-2007

I haven't really done much with SQL Server 2005. I'm getting myself in the situation where I must, though, as I am using it as the platform for capturing performance counter data. I let the database grow way out of pocket and am now suffering the consequences. I know back with SQL Server 2000 you could use the osql utility to run commands and scripts from the command line. Looks like you do the same thing using sqlcmd for SQL Server 2005. I'll probably be using this to execute a command file to shrink the transaciton log when it gets too big. I'll be using Performance Monitor's Alert feature to detect when the script needs to be run and have the action be to log a record in the application event log and to execute the script to truncate the log. The other alternative is to use SQL Server Agent to execute a cleanup script in a more meaningful manner. Consider my first suggestion a failsafe.

1
POPS MSDE unsupported on MS Vista

by elcid0603 2-13-2007

Is Microsoft planning to discontinue MSDE product and support? Or is it that presently due to the architecture differences MSDE isn't supported on MS Vista?

1
POPS NHibernate 1.2 released

by travislaborde 5-14-2007

I'm not an NHibernate user, but some people swear by it...

1
POPS Programmer Downloads, Tools, Resources, and 100 Cheat Sheets

by harvey007 8-27-2007

This article provides a list of downloads for free databases and languages. It also showcases some of the hottest programmer tools. Finally, there is a list of over 100 of the most popular programming cheat sheets.

1
POPS SQL Server 2008 - Finally a DATE datatype?

by travislaborde 8-31-2007

OMG this is my most wanted feature like EVER. It was promised but removed from SQL Server 2005. Will it really come this time? If so, I promise to convert all my apps to 2008 immediately upon release.

1
POPS CodeSmith 4.0 Released

by travislaborde 11-9-2006

No Remarks

1
POPS SQL Server 2005 equivalent to DBCC MEMUSAGE

by Osolage 5-31-2007

No Remarks

1
POPS Packt Publishing: ODP.NET Developer's Guide

by travislaborde 8-14-2007

No Remarks

1
POPS SQL Server 2005 Service Pack 2

by Osolage 4-11-2007

No Remarks