Category Archives: database

Use sys.dm_exec_sessions to disconnect SQL user connections

Posted on 01/03/2011 by Eric Fickes

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 — init vars DECLARE … Continue reading →

Posted in database, internets, microsoft, SQL, tsql | Leave a comment

TSQL : How to find all database tables ending with an UPPERCASE X

Posted on 12/08/2010 by Eric Fickes

1 2 3 4 5 6 7 8 9 10 — Give me all tables ending with an UPPERCASE X SELECT table_name, SUBSTRING( table_name, LEN(table_name), 1 ) as 'end' FROM INFORMATION_SCHEMA.TABLES — SELECT ascii('X') = 88 — SELECT ascii('x') = … Continue reading →

Posted in database, internets, SQL, tips and tricks, tsql | Leave a comment

Endless Mural wins FWA site of the day

Posted on 11/19/2010 by Eric Fickes

I’m ecstatic to announce the Endless Mural HTML5 project has won the prestigious FWA Site of the day award.  While this isn’t the first project I’ve worked on that has won the FWA, it is the first NON-Flash, HTML5 and … Continue reading →

Posted in .net, art, award, browser, C#, cool, database, development, fun, Internet Explorer, javascript, microsoft, SQL, Visual Studio | Tagged , , , , , , , , , , , , , | 3 Comments

Selecting random ids using TOP and a CTE

Posted on 09/29/2010 by Eric Fickes

While testing visualizations in a Flex application, I needed to do some underlying data cleanup in SQL Server.  One of my tasks was to manually update an entity table and set the status column to one of three possibilities.  Status … Continue reading →

Posted in database, SQL, tips and tricks, tsql | Tagged , , , , , , , | Leave a comment