LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Blogs
User Name
Password

Notices

Old

MSSQL Tricks & Hints

Posted 10-04-2012 at 02:51 PM by NullTerminator
Updated 11-16-2012 at 01:40 PM by NullTerminator

Patching up leading zeroes
UPDATE TheTable
set FILE_NBR = replicate('0', 6-len(FILE_NBR) ) + FILE_NBR

Querying disk file sizes

use master

SELECT DB_NAME(DATABASE_ID) AS [DATABASE_NAME], name as FileName, Type_desc,
-- hmmmm 8k blocks?
CAST(( CAST(SIZE * 8 AS FLOAT) ) / 1024 AS VARCHAR) + ' MB' AS [SIZE],
CAST( (MAX_SIZE / 128) AS VARCHAR) + ' MB' AS [MAX_SIZE]
FROM SYS.MASTER_FILES

...
LQ Newbie
Posted in Uncategorized
Views 324 Comments 0 NullTerminator is offline
Old

Story: Justice Dept. to defend warrantless cell phone tracking

Posted 10-03-2012 at 03:34 AM by hydraMax (Bits and Pixels)

http://news.cnet.com/8301-13578_3-57...hone-tracking/

Hmmm... Giving the U.S. Justice department legal permission to track our movements, via our cellphone signal, 24 hours a day without even mentioning it to a judge... I'm not too sure about that one. Anyone else have doubts?
Member
Posted in Uncategorized
Views 5611 Comments 3 hydraMax is offline
Old

I am a networking idiot

Posted 10-01-2012 at 10:36 PM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 10-02-2012 at 09:22 AM by rocket357

So a while back I got my hands on a Cisco 2948 for my home network. Sure, it's only 10/100. Sure, it's an older model. Sure, it's EOL.

But damn it's sexy in my livingroom...48 ports of Cisco goodness. Port security! VLANS! So much more than my other "dumb" switches! Imagine the possibilities! I set off flipping knobs and tweaking everything as tight as I can. Months of restful sleep ensue, with my world protected by pf and a locked down switch.

Then...
Member
Posted in Uncategorized
Views 396 Comments 0 rocket357 is offline
Old

Pure-text de-truncator script, a work in progress

Posted 09-30-2012 at 01:28 PM by the dsc (linux-related notes)
Updated 09-30-2012 at 01:32 PM by the dsc
Tags epub, pdf, sed, truncated

Sometimes I want to quote some PDF on pure text, luckily enough it would have actual text rather than being an non-OCRed image, but often there's still the problem that the text on the PDF is truncated/formatted in a fake/dumb way, with actual "new lines" to break the page, which may not make the text completely unreadable when pasted in a text editor, but it's reasonably annoying, and may require quite some time to fix manually.

I'm trying to create a script or one-liner...
Member
Posted in Uncategorized
Views 520 Comments 0 the dsc is offline
Old

Royalty Free Sound Effects

Posted 09-28-2012 at 08:21 PM by hydraMax (Bits and Pixels)

http://soundbible.com/

Not my Web site... just thought it was a neat Web site, because most of the sFX are under a simple CC-BY license.
Member
Posted in Uncategorized
Views 438 Comments 0 hydraMax is offline

  



All times are GMT -5. The time now is 02:03 PM.

Main Menu
Advertisement

My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration