StarInix Corporation
august 2009 by andyh_ky
Database Compare 2.0 just made my day. A free schema diff tool.
Bookmarks
sql
schemadiff
diff
database
dba
tools
free
tool
freeware
compare
august 2009 by andyh_ky
Kimberly L. Tripp | GUIDs as PRIMARY KEYs and/or the clustering key
may 2009 by andyh_ky
PRO TIP: Rebuild your indexes!
Bookmarks
sqlserver
performance
guid
clustered
sql
indexes
sql.server
may 2009 by andyh_ky
Why NULL is special - The Fishbowl
february 2009 by andyh_ky
Good explanation of NULL in SQL
Bookmarks
sql
dba
february 2009 by andyh_ky
Kimberly L. Tripp: Improving *my* SQL skills through your questions! http://www.SQLskills.com/blogs/kimberly
april 2008 by andyh_ky
getting down and dirty with databases -- links marked "Inside the..." particularly good
Bookmarks
sqlserver
dba
sqlserver2005
work
resources
sql
april 2008 by andyh_ky
Ranking Functions (Transact-SQL)
april 2008 by andyh_ky
This is awesome, I had no idea T-SQL could do this.
Bookmarks
sqlserver
dba
sql
april 2008 by andyh_ky
Welcome to the Jungle (Redux): Rise and fall of DBAs: The tyranny of the ORM
march 2008 by andyh_ky
They've obviously never tried to access Twitter.
Bookmarks
database
development
orm
sql
dba
java
programming
march 2008 by andyh_ky
DB2 Database for Linux, UNIX, and Windows
march 2008 by andyh_ky
MERGE Statement notes
Bookmarks
db2
dba
sql
merge
march 2008 by andyh_ky
sp_change_users_login (Transact-SQL)
january 2008 by andyh_ky
This is a handy stored procedure dealing with Orphaned users.
Bookmarks
development
security
sqlserver
work
migration
login
sql
restore
tsql
january 2008 by andyh_ky
Linchi Shea : Ad Hoc vs. Parameterized
january 2008 by andyh_ky
On the Oracle database, by simply setting its cursor_sharing parameter to forced, the transaction throughput went up from ~1,200 per second to ~16,000 per second ... SQL Server 2005 has a similar database option called forced parameterization.
Bookmarks
performance
sql
sqlserver
january 2008 by andyh_ky
SQL Protocols : Troubleshoot Connectivity Issue with SQL Server Express 2005
january 2008 by andyh_ky
SS Express is turning into a headache.
Bookmarks
sql
support
dba
databases
sqlserver
troubleshooting
sqlserverexpress
microsoft
database
remote
january 2008 by andyh_ky
SQL Agent Date & Time
january 2008 by andyh_ky
Some useful functions in order to deal with SQL Server Job Agent's integer timestamps (one field YYYYMMDD and one field HHMMSS)
Bookmarks
sqlserver
dba
sql
time
january 2008 by andyh_ky
Tibor Karaszi's SQL Server pages
january 2008 by andyh_ky
There's no support at the TSQL level to keep generations of backups. For instance, you want to keep backups for 3 days. The functionality is available in Maintenance Plans (MP), but sometimes you want a higher degree of customization.
Bookmarks
sqlserver
dba
backup
sql
january 2008 by andyh_ky
DB2 Basics: Fun with Dates and Times
december 2007 by andyh_ky
What the hell ever happened to SELECT NOW() ? =)
Bookmarks
db2
documentation
datetime
sql
date
database
time
reference
ibm
december 2007 by andyh_ky
Identifying Long Running SQL Server Agent Jobs
november 2007 by andyh_ky
master.dbo.xp_sqlagent_enum_jobs rocks
Bookmarks
sql
dba
sqlserver
november 2007 by andyh_ky
MySQLForge :: View Snippet :: Split a Delimited String in SQL
november 2007 by andyh_ky
cool , useful function
Bookmarks
mysql
storedproc
string
split
sql
november 2007 by andyh_ky
related tags
accesskeys ⊕ acid ⊕ administration ⊕ adodb ⊕ ajax ⊕ algorithms ⊕ analytics ⊕ apache ⊕ api ⊕ articles ⊕ asp.net ⊕ awe ⊕ backup ⊕ blog ⊕ Bookmarks ⊕ bug ⊕ c# ⊕ cheatsheet ⊕ clustered ⊕ code ⊕ coding ⊕ commands ⊕ compare ⊕ comparison ⊕ compatibility ⊕ connection ⊕ crosstab ⊕ cte ⊕ dag ⊕ database ⊕ databases ⊕ datamodels ⊕ date ⊕ datetime ⊕ db ⊕ db2 ⊕ dba ⊕ dbazine ⊕ dbms ⊕ deadlock ⊕ design ⊕ development ⊕ diff ⊕ digraph ⊕ django ⊕ documentation ⊕ dts ⊕ dual ⊕ duplicate ⊕ emergency ⊕ errorhandling ⊕ examples ⊕ explain ⊕ faq ⊕ free ⊕ freeware ⊕ fulltext ⊕ ghetto ⊕ gis ⊕ google ⊕ graph ⊕ guid ⊕ guide ⊕ hardware ⊕ hierarchical ⊕ howto ⊕ http ⊕ ibm ⊕ indexes ⊕ indexing ⊕ injection ⊕ install ⊕ installation ⊕ isolation ⊕ java ⊕ javascript ⊕ join ⊕ joins ⊕ keyboard ⊕ learning ⊕ linked ⊕ links ⊕ linq ⊕ log ⊕ logging ⊕ login ⊕ magazine ⊕ maintenance ⊕ maps ⊕ memory ⊕ merge ⊕ microsoft ⊕ migrate ⊕ migration ⊕ mirroring ⊕ models ⊕ moss2007 ⊕ msdb ⊕ msdn ⊕ mssql ⊕ mysql ⊕ networking ⊕ news ⊕ odbc ⊕ online ⊕ opensource ⊕ optimization ⊕ oracle ⊕ orm ⊕ pagination ⊕ pdf ⊕ performance ⊕ php ⊕ pivot ⊕ plsql ⊕ podcast ⊕ postgis ⊕ postgres ⊕ postgresql ⊕ programming ⊕ python ⊕ queries ⊕ query ⊕ rails ⊕ rand ⊕ random ⊕ recovery ⊕ recursion ⊕ recursive ⊕ reference ⊕ remote ⊕ rename ⊕ reporting ⊕ reports ⊕ research ⊕ resources ⊕ restore ⊕ rules ⊕ samples ⊕ scalability ⊕ schemadiff ⊕ script ⊕ search ⊕ security ⊕ select ⊕ server ⊕ servers ⊕ sharepoint ⊕ sharepoint2007 ⊕ software ⊕ sourcecontrol ⊕ sp2 ⊕ split ⊕ sql ⊖ sql-injection ⊕ sql.server ⊕ sql2005 ⊕ sqlite ⊕ sqlserver ⊕ sqlserver2000 ⊕ sqlserver2005 ⊕ sqlserver2008 ⊕ sqlserverexpress ⊕ ssms ⊕ ssrs ⊕ stats ⊕ storage ⊕ storedproc ⊕ storedprocedure ⊕ storedprocedures ⊕ stress ⊕ string ⊕ support ⊕ sysadmin ⊕ table ⊕ tcpdump ⊕ tdd ⊕ testing ⊕ threading ⊕ time ⊕ tips ⊕ tool ⊕ tools ⊕ toread ⊕ transaction ⊕ transactions ⊕ transfer ⊕ tree ⊕ trigger ⊕ triggers ⊕ troubleshooting ⊕ tsql ⊕ tuning ⊕ tutorial ⊕ tutorials ⊕ twitter ⊕ upgrade ⊕ utl_http ⊕ version ⊕ versioncontrol ⊕ videos ⊕ vmware ⊕ web ⊕ webdev ⊕ webservices ⊕ windows ⊕ work ⊕ xml ⊕ xss ⊕ yahoo ⊕ yql ⊕Copy this bookmark: