Just a Day in the Office
Stuff about applications and databases
Menu Close
  • Home
  • Vertica Kit
  • About Me
  • Dilbert

Month: June 2012

0

CROSS APPLY for function execution

Posted on June 28, 2012 by Norbert Krupa

The APPLY operator is similar to the JOIN operator, however it specifically allows you to use table functions with parameters to join the results. table1 column —— a1 a2 a3 a4 a5 Using the query below, CROSS APPLY will join… Continue Reading →

SQL Server, T-SQL
0

Clearing voicemail icon on Samsung Galaxy S3

Posted on June 27, 2012 by Norbert Krupa

I recently purchased the Samsung Galaxy SIII from T-Mobile and was unable to clear the icon from the notifications bar. I have my voicemail managed by Google Voice so I first disabled forwarding under Phone > Call Settings > Call… Continue Reading →

Galaxy S3, Google Voice, Samsung, T-Mobile
0

Calculate percent change between 2 rows in SQL Server using CTE

Posted on June 20, 2012 by Norbert Krupa

A common table expression (CTE) is used in this example to create a temporary result set with a sequential number that allows us to do the arithmetic required to calculate percent change.

common table expressions, function, percent change, SQL Server
0

Select columns for a table in SQL Server

Posted on June 18, 2012 by Norbert Krupa

To select the columns in a specified table in SQL Server, use this code: SELECT c.name FROM sys.columns c, sys.tables t WHERE t.name = ‘table_name’ AND c.object_id = t.object_id

SQL Server
0

EPSON WorkForce Pro GT-S50 Document Scanner

Posted on June 17, 2012 by Norbert Krupa

I recently purchased the EPSON WorkForce Pro GT-S50 Document Scanner on Amazon for $329.98. I was also considering the Fujitsu ScanSnap S1500, and settled with the GT-S50 after reading positive reviews. The most common issue I read with the ScanSnap… Continue Reading →

Document Scanner, Epson, GT-S50, PDF
0

Unique primary key across multiple applications

Posted on June 11, 2012 by Norbert Krupa

Very interesting read on how Instagram solved a problem with having a single unique ID across multiple applications. Sharding & IDs at Instagram

PostgreSQL
0

Decimal data type precision on SQL Server

Posted on June 5, 2012 by Norbert Krupa

The MSDN article on decimal and numeric data types explains that precision in the decimal data type is the: …total number of decimal digits that can be stored, both to the left and to the right of the decimal point.… Continue Reading →

SQL Server

Connect

Official Seal

Official Seal

Recent Posts

  • Installing Gitblit on CentOS
  • Windows Authentication for SQL Server Connection
  • Canceling FreedomPop Premier Service
  • Bootable Windows 8 USB Drive
  • Resolving javaw.exe is not recognized With Squirrel SQL Client

Resources

  • Large collection of free Microsoft eBooks
  • Succint data structures
  • Guide to forms based website authentication
  • EXPLAIN Extended
  • Fundamental differences between hashing and encryption algorithms

SQL Server

  • COUNT(*) vs. COUNT(1) vs. COUNT(pk)
  • Best way to remove time from datetime
  • Understanding how SQL Server Executes a Query
  • T-SQL: COALESCE vs. ISNULL vs. IS NULL OR
  • Precise or fuzzy matching with CONTAINSTABLE
  • 13 things you should know about statistics and the query optimizer
  • NULL Comparison Search Conditions
  • SQL grouping ranges
  • Stored procedure template using TRY CATCH
  • NOEXPAND hint to use indexed views
  • SQL Performance
  • Why sum of nothing is null

Links

  • When the nerds go marching in
  • Twitter fights government subpoena
  • Are databases and programming at odds?
  • Netherlands first country in Europe with net neutrality
  • MySQL at Facebook: What is the query plan for a running query?
  • How I became a Password Cracker
  • Code is not physical property
  • W3Schools Intervention
  • Prey project
  • Junior DBA Interview Questions
  • USB chargers, Apple is not the best

News

  • Does your job create real value?
  • Google goes back to the future with SQL F1 database
  • Man's $600,000 Facebook Disaster Is A Warning For All Small Businesses

Humor

  • Exploits of a mom
  • What a crappy evening in 1998 looked like
  • Google Fiber vs. Broadband
  • Programming skill vs blood alcohol concentration
  • FunnyJunk tries to sue The Oatmeal
  • Maslow's hierarchy of needs

Archives

  • February 2016 (2)
  • July 2014 (1)
  • December 2013 (1)
  • November 2013 (1)
  • September 2013 (3)
  • August 2013 (1)
  • July 2013 (2)
  • June 2013 (1)
  • May 2013 (1)
  • March 2013 (1)
  • January 2013 (1)
  • August 2012 (4)
  • July 2012 (4)
  • June 2012 (7)
  • May 2012 (3)
  • April 2012 (6)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Tags

7-Zip Active Directory Apple bulk insert centos cURL Date Efficiency Excel FreedomPop function gitblit Java MacBook Msg 207 Msg 2714 Msg 7314 MySQL mysqli openrowset Oracle Parsing PDO PHP PHPExcel PostgreSQL RSS SharePoint shell SQL sql-case sql-coalesce sql-isnull SQL Server squirrel stored procedure String T-SQL Talend temporary tables usb VirtualBox Virtual Machine Windows XML
© 2025 Just a Day in the Office. All rights reserved.
Hiero by aThemes