LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back   LinuxQuestions.org > Blogs
User Name
Password

Notices


Old

MSSQL Tricks & Hints

Posted 10-04-2012 at 03:51 PM by NullTerminator
Updated 11-16-2012 at 02: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 477 Comments 0 NullTerminator is offline
Old

Story: Justice Dept. to defend warrantless cell phone tracking

Posted 10-03-2012 at 04: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 9402 Comments 3 hydraMax is offline
Old

I am a networking idiot

Posted 10-01-2012 at 11:36 PM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 10-02-2012 at 10: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 573 Comments 0 rocket357 is offline
Old

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

Posted 09-30-2012 at 02:28 PM by the dsc (linux-related notes)
Updated 09-30-2012 at 02: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 751 Comments 0 the dsc is offline
Old

Royalty Free Sound Effects

Posted 09-28-2012 at 09: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 564 Comments 0 hydraMax is offline

  



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

Main Menu
Advertisement
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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration