Category: SQL Tips

Ebooks and video at HUGE discounts at Packt Publishing Packt Publishing publishes technical manuals for all software developers are having a huge $5.00 sale for ebooks and videos. Developer skills platform that supports software professionals in learning the skills they need to stay relevant in their field. From web development to data science, Packt delivers practical content on what's important in the tech world, helping developers solve today's - and tomorrow's challenges. With every eBook and every video $5 there's never been a better time to learn something new or dive deeper into what's important to you. Some of the current sale items are: Mastering Swift 2 Getting Started with Lazarus IDE Mastering Ubuntu Server Ubuntu Server Cookbook SQL Server 2016 Reporting Services Cookbook The library is huge and software…

Eurekalog debugs your deployed application.   Eurekalog has consistently proven that they assist developers in debugging deployed applications.  No kidding, Eurekalog will send back a detailed report to the developer informing them exactly where the bug occurred and what exactly happened.  Baron Software has implemented in all of their applications the Eurekalog method and recommend to all Delphi developers to implement it as well. Eurekalog Features Features that should convince you to purchase the Eurekalog applcation: Detailed bug report about each exception, leak or hang; Bug report includes call stack with unit names, class names, routine names, and line numbers; Extensive run-time and environment information is logged into bug report; RAW dump and disassembly information; Easy integration, no need to write code; No additional files needed (no DLLs, no .map files,…

  SQL Stored Procedures to get folder and files There may be a time when you will need to get the file name contents from a folder for the purpose of using the information in your stored procedure.  The one undocumented stored procedure on Microsoft SQL Server 2016 is master.sys.xp_dirtree that you can use. In your stored procedure, we will go ahead and create a temporary table that will store the files with their correct extension.  The first thing we want to do is check whether the temporary table was left over and remove it.  Usually when you close out a session temporary tables will be destroyed but it is fine to check and do house cleaning in  your stored procedure. IF OBJECT_ID('tempdb..#FilesListing') IS NOT NULL DROP TABLE #FilesListing; The…