tag:blogger.com,1999:blog-6678093514755187865Mon, 09 Sep 2024 07:38:07 +0000UbuntuwindowsAptitudeLinuxAptJavascriptKeePassXMicrosoft SQL ServerMicrosoft WindowsPPAPublic KeyRSASQL ServerSynapticVisual StudioinstallmicrosoftrubyupdateupgradeBest PracticesBrowserCheck inConfigConsoleCrockfordDACFxDB2Data FlowData-Tier ApplicationData-Tier Applications FrameworkDatabaseEncryptionEscapeFailedFiddlerFirefoxFull ScreenHTTPSIBMIDEISOInstallationMan-in-the-middleMeta-modelMetadataNSSNetwork Security ServicesNetworkingPDFParserRESTRollbackSQLSQL Server Integration ServicesSSISSSLSource ControlStrutsT-SQLTFSTeam Foundation ServerTerminal Server ClientToBooleanTokenizeUSBVisual Studio Database ProjectWeb BrowserWindows 7Windows 8Windows Installationbashbinariesboolean logicbuild processcheck-incheckinclassicdashdb2starteclipseerrorformhandlesjuice startup errorlnopen filepackagepodcastspodcatcherprocessroll backroll-backruby gemssearchshstyleIdsymbolic linktfvisual studio 2010vs 2010vs2010Things I learn in my day-to-day work as a software engineer and in my geeky activities in general.http://sepitfalls.blogspot.com/noreply@blogger.com (Unknown)Blogger65125tag:blogger.com,1999:blog-6678093514755187865.post-1033578596372533927Thu, 28 Apr 2016 03:52:00 +00002016-04-27T21:53:12.458-06:00RESTI have seen the term REST  (Representational State Transfer) all over for years. And I finally have to learn enough to us it.  It turns out I had no idea what it is. Previously, in my ignorance, REST implied a web service that packages data in JSON format (see json.org). I have begun to add some valid information to my vortex of REST ignorance. REST is an architecture style. REST http://sepitfalls.blogspot.com/2016/04/what-heck-is-rest-restful-web-service.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-6678093514755187865.post-3860797448957471932Tue, 12 Aug 2014 18:10:00 +00002014-08-12T12:10:23.589-06:00I'm writing a little .NET application that watches for an event in a SQL server in one domain and starts an SQL Server Agent job on a SQL Server in another domain.  Here is how I determined if the job were already running: exec dbo.sp_help_job @job_name = 'TheJobName', @job_aspect = 'JOB', @execution_status = 1 If this returns any rows, the named job is running.http://sepitfalls.blogspot.com/2014/08/is-my-sql-server-agent-job-already.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-6678093514755187865.post-538902910212244543Fri, 27 Sep 2013 14:50:00 +00002013-09-27T08:52:57.768-06:00Microsoft SQL ServerParserSQLT-SQLTokenizehttp://www.sqlservercentral.com/blogs/dave_ballantynes_blog/2012/03/13/parsing-t-sql-the-easy-way/ Ran accross this example of using the SQL-Server parser to tokenize a T-SQL script, statement, what-have-you. At my company, we have some very specific SQL Formatting Standards.  And we have not found a code formatter that can do the job.  We've just come up with a VS2012 Add-on that http://sepitfalls.blogspot.com/2013/09/tokenizing-t-sql.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-6678093514755187865.post-5124691683259169875Mon, 09 Sep 2013 16:47:00 +00002013-09-09T10:48:21.526-06:00DACFxData-Tier ApplicationData-Tier Applications FrameworkmicrosoftMicrosoft SQL ServerMicrosoft WindowswindowsWindows 7I've identified two ways to identify the version of DACFx installed on a windows machine.  I've tested this under Windows 7.  If you try it on other platforms, please let me know so I can note success or failure here. Method One: Uninstall Programs Go to Uninstall Programs on the control panel. Search for Data-Tier See the version number. Method Two: Windows Registry Value Runhttp://sepitfalls.blogspot.com/2013/09/data-tier-application-framework-dacfx.htmlnoreply@blogger.com (Unknown)0Saint Johns, FL, USA30.0803521 -81.575147599999984.5583175999999987 -122.88374159999998 55.6023866 -40.26655359999998tag:blogger.com,1999:blog-6678093514755187865.post-6265036703325138696Thu, 30 May 2013 15:49:00 +00002013-05-30T09:52:01.274-06:00InstallationISOMicrosoft WindowsUSBWindows 8Windows InstallationI have an ISO file for windows 8.  Just realized I don't have DVD.  Turns out.  I don't need one.  Microsoft provides a tool that takes the contents of the iso file and creates and copies then to a USB device that can be used to install Windows.  Be warned, it formats the USB device.  That means anything on that device is lost. http://www.microsoftstore.com/store/http://sepitfalls.blogspot.com/2013/05/creating-windows-installer-on-usb-drive.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-6678093514755187865.post-7478293650491006046Mon, 08 Oct 2012 21:42:00 +00002012-10-08T15:42:20.923-06:00Check incheck-incheckinmicrosoftroll backroll-backRollbackSource ControlTeam Foundation ServertfTFSVisual Studiovisual studio 2010vs 2010vs2010Working in Visual Studio 2010 today, I was in the middle of creating a shelveset when I goofed and pressed Check In. Agh! Oh no! I discovered that Team Foundation (tf) has a rollback command.  So I used  >  tf rollback ...  from the command line. Then, I found the setting in Visual Studio to propmt on check-in. Menu: Tools > Options Options dialog: Source Control &http://sepitfalls.blogspot.com/2012/10/team-foundation-oops-i-shouldnt-have.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-6678093514755187865.post-6570129775536612793Mon, 08 Oct 2012 21:24:00 +00002012-10-08T15:24:32.664-06:00Best PracticesDatabaseMeta-modelVisual StudioVisual Studio Database Project Initial Thought on VS Database Projects NOTE: I wrote this up as notes on my first experience with database projects in Visual Studio 2010. It contains my notes and thoughts. As 'Noob-notes', nothing here is guaranteed to be correct, insightful, or interesting :) Meta-model It looks to me like VS 2010 creates a meta model of the a database from the source files and compares on that. It maps http://sepitfalls.blogspot.com/2012/10/vs-studio-2010-database-projects.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-6678093514755187865.post-4696463506054784466Wed, 07 Mar 2012 19:41:00 +00002012-03-07T12:41:41.665-07:00Data FlowMetadataSQL ServerSQL Server Integration ServicesSSISRecently I've begun to work with SQL Server Integration Services (SSIS) to extract data and load it into a data warehouse.  I discovered a seemingly absurd statement in an existing package. IF 1=2 SELECT CAST(NULL AS...), CAST(NULL AS ...) ... This was the very first statement in a long complicated SQL script that eventually...way down at the end of the file...after hundreds of lines...http://sepitfalls.blogspot.com/2012/03/providing-metadata-to-ssis-dataflows.htmlnoreply@blogger.com (Unknown)010996 S River Front Pkwy, South Jordan, UT 84095, USA40.554651230555272 -111.9144201278686540.553143230555271 -111.91688762786865 40.556159230555274 -111.91195262786866tag:blogger.com,1999:blog-6678093514755187865.post-8512945146965772285Wed, 07 Mar 2012 19:18:00 +00002012-03-07T12:18:27.683-07:00BrowserEncryptionFiddlerFirefoxHTTPSMan-in-the-middleNetwork Security ServicesNetworkingNSSSSLWeb BrowserIn a conversation with co-workers recently I realized that I didn't have a clear, correct view of how HTTP over SSL (HTTPS) works.  So, having done some reading today, I want to record some things about HTTPS. My main question was, where on the computer is the encryption/decryption happening? Does it happen somewhere in the windows networking stack (maybe somewhere in its TCP/IP http://sepitfalls.blogspot.com/2012/03/clearing-up-my-ssl-noob-questions.htmlnoreply@blogger.com (Unknown)0River Front Pkwy, South Jordan, UT 84095, USA40.552776331471 -111.9154071807861340.549760331471 -111.92034268078613 40.555792331471004 -111.91047168078613tag:blogger.com,1999:blog-6678093514755187865.post-8768819525991051798Thu, 05 Jan 2012 17:59:00 +00002012-01-05T10:59:18.197-07:00SQL ServerHere is a snippet shared by a co-worker for finding out what processes are eating cpu resources on SQL Server. exec admin.dbo.usp_serverblocks @orderby = 'secprocessortime'http://sepitfalls.blogspot.com/2012/01/find-out-what-is-causing-cpu-use-in-sql.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-6678093514755187865.post-4076103016539342467Wed, 21 Dec 2011 19:35:00 +00002011-12-21T12:35:13.336-07:00boolean logicCrockfordJavascriptToBooleanDevelopers familiar with c-languages may assume that Javascript's || and && operators produce boolean results.  But that isn't necessarily true. What they really do is return one of the two operands. Truthy-ness (and falsy-ness) An expression is "truthy" if it isn't "falsy".  The "falsy" values are false (the boolean literal value) "" (the empty string) undefined null NaNhttp://sepitfalls.blogspot.com/2011/12/in-javascript-and-dont-evaluate-to.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-6678093514755187865.post-8538336756019389025Thu, 08 Dec 2011 17:33:00 +00002011-12-08T10:33:51.730-07:00JavascriptIn short you don't know if you are changing a property of an object in the with or an implied global variable.  See Crockford's full post.http://sepitfalls.blogspot.com/2011/12/javascript-with-operator-is-bad.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-6678093514755187865.post-4778382490197419729Thu, 08 Dec 2011 17:32:00 +00002011-12-08T10:32:40.387-07:00VirtualBox/USB - Community Ubuntu Documentation I had to add myself to the vboxusers group and then vbox could connect to usb devices. I was able to let other programs access usb without starting the program as root too. So I still need to understand how the group and the bus permissions are linked. But I'm glad to be able to share USB devices with my Virtual Machine.http://sepitfalls.blogspot.com/2011/12/virtualboxusb-community-ubuntu.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-6678093514755187865.post-5400969318277507123Thu, 24 Mar 2011 19:49:00 +00002011-06-02T11:05:17.018-06:00Turns out you can get current thread using Thread.currentThread()With that thread you can call getStackTrace(). This allows you to get the current class and method name from stackTrace[0] (stackTrace being the result of getStackTrace()).You, of course, have to be in a context where this code executes on the same thread.Thanks to Ryan Sukale.My Code Fixes: Runtime Class and Method informationhttp://sepitfalls.blogspot.com/2011/03/my-code-fixes-runtime-class-and-method.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-6678093514755187865.post-7825393013717603079Thu, 24 Mar 2011 15:56:00 +00002011-03-24T09:56:05.668-06:00A new feature in Java 7. Try-with-resource blocks.Java 7: New Feature – automatically close Files and resources in try-catch-finally | Vineet Manohar's bloghttp://sepitfalls.blogspot.com/2011/03/java-7-new-feature-automatically-close.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-6678093514755187865.post-3804822318253447733Tue, 06 Apr 2010 15:20:00 +00002010-04-06T09:27:02.226-06:00FailedPDFUbuntuI've been using Ubuntu 9.04 for 9 months. I installed the Virtual PDF printer months ago. Apparently this morning I just used it for the first time. It failed to print.I looked in the ubuntu documentation. I'll quote the part of the article that referenced the problem.however, on the 9.04 machine I had to create the /home/your_user_name/PDF folder manually for each user on that machine to http://sepitfalls.blogspot.com/2010/04/ubuntu-904-pdf-printer-you-have-to.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-6678093514755187865.post-5425148565600068012Fri, 18 Dec 2009 16:20:00 +00002009-12-18T09:42:46.359-07:00classiceclipseIDEupdateIn eclipse galileo, go to window-->preferences.In the preferences dialog, search for Capabilities.In /General/Capabilities, check 'Classic Update'.Restart and the classic update and plug-in management is available.http://sepitfalls.blogspot.com/2009/12/enable-classic-eclipse-update.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-6678093514755187865.post-3795306481111895656Tue, 01 Dec 2009 18:32:00 +00002009-12-01T11:53:22.756-07:00I've been having a problem where a query sent through hibernate fails with the message: executeQuery method cannot be used for updateHere is an example of the log output. The hibernate actual hql and sql queries have been replaced with [...] in order not to expose my employer's database schema information.Hibernate: /* select [...] */ select [...]JDBCExceptionReporter:100 - SQL Error: -99999, http://sepitfalls.blogspot.com/2009/12/hibernates-user-sql-comments-feature.htmlnoreply@blogger.com (Unknown)1tag:blogger.com,1999:blog-6678093514755187865.post-5676602421062641295Wed, 25 Nov 2009 20:22:00 +00002009-11-25T13:29:01.398-07:00I've been struggling with a problem where an application I'm upgrading had problems inserting new records into a database using hibernate.App Server: IBM Websphere Application Server 6.1DB: IBM DB2 8.?JDBC Driver: Those packaged with IBM DB2Express v9.7I would get a message stating:org.hibernate.HibernateException: The database returned no natively generated identity valueWhen I changed my http://sepitfalls.blogspot.com/2009/11/db2-97-jdbc-driver-causes-problem-for.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-6678093514755187865.post-1461703272676524400Mon, 12 Oct 2009 22:02:00 +00002009-10-12T16:06:38.617-06:00ConfigDB2db2startIBMinstallThanks to bits.of.info for this tutorial on db2 install and config. Way better than trying to follow IBM's docs.http://sepitfalls.blogspot.com/2009/10/db2-install-and-config-tutorial.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-6678093514755187865.post-9197045619753978895Thu, 08 Oct 2009 22:45:00 +00002009-10-08T16:58:41.876-06:00bashdashlnshsymbolic linkUbuntuI've been trying to install IBM Websphere Application Server 6.1 on Ubuntu 9.04 AMD64. The installer kept failing. I found this post that clued me in that in Ubuntu /bin/sh is a symbolic link to /bin/dash (a faster, smaller shell apparently). The association of sh can be changed from dash to bash as follows:unlink /bin/shln -s /bin/sh bashafter doing this the installer worked just fine.Should http://sepitfalls.blogspot.com/2009/10/in-ubuntu-sh-is-dash-not-bash.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-6678093514755187865.post-400481867349267766Thu, 24 Sep 2009 15:52:00 +00002009-09-24T09:55:17.187-06:00AptitudeLinuxpackagesearchUbuntuupdateupgradeHere are some commands to use (usually with sudo):aptitude update -- update the package repoaptitude safe-upgradeaptitude full-upgradeaptitude search 'part of package name'aptitude show package-nameaptitude install package-namehttp://sepitfalls.blogspot.com/2009/09/aptitude-command-line-package-manager.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-6678093514755187865.post-2399591478653217382Thu, 24 Sep 2009 15:31:00 +00002009-09-24T09:42:57.304-06:00ConsoleLinuxUbuntuTurns out linux has several consoles going at once. From within my Gnome session I can press Ctrl-Alt-F1 and bring up console one. Gnome is running on console 7 so Ctrl-Alt-F7 brings me back into Gnome. Ctrl-Alt-F1 through Crtl-Alt-F7 work. Notice that Crtl-Alt-F1 takes you to TTY1 and Ctrl-Alt-F6 to TTY6. Having a full terminal to run from is handy when the session on TTY7 (Gnome) gets http://sepitfalls.blogspot.com/2009/09/switching-linux-consoles.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-6678093514755187865.post-5421420255980371215Thu, 24 Sep 2009 14:55:00 +00002009-09-24T09:30:46.431-06:00AptAptitudeKeePassXPPAPublic KeyRSASynapticUbuntuI use a program called KeePass on Windows to manage passwords. There is a project called KeePassX for Linux that will use the same password database file I use on windows. To install it on Ubuntu 9.04 AMD-64, I did the following:Add the source to Ubuntu (System > Administration > Software Sources)deb http://ppa.launchpad.net/keepassx/ppa/ubuntu jaunty maindeb-src http://ppa.launchpad.net/http://sepitfalls.blogspot.com/2009/09/adding-key-to-apt-so-ppa-packages-can.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-6678093514755187865.post-7584281324330519265Thu, 24 Sep 2009 14:55:00 +00002010-01-20T09:38:27.663-07:00AptAptitudeKeePassXPPAPublic KeyRSASynapticUbuntuWhen you add Third-Party Software Sources to Ubuntu, you will likely want to add those sources' shared keys to the apt so that when you update your packages a warning stating that some packages cannot be authenticated can be avoided. I get tired of it coming up. So, In my case I addeddeb http://ppa.launchpad.net/keepassx/ppa/ubuntu jaunty maindeb-src http://ppa.launchpad.net/keepassx/ppa/ubuntuhttp://sepitfalls.blogspot.com/2009/09/adding-key-to-apt-so-ppa-packages-can_24.htmlnoreply@blogger.com (Unknown)0