Category Archives: Programming

Phil Factor @ SimpleTalk: Statistics in SQL: Pearson’s Correlation

Statistics in SQL: Pearson’s Correlation The series so far: Statistics in SQL: Pearson’s Correlation Statistics in SQL: Kendall’s Tau Rank Correlation Statistics in SQL: Simple Linear Regressions Statistics in SQL: The Kruskal–Wallis Test

Posted in Business Intelligence, SQL Server, System/DB Administration | Leave a comment

Log files and Fail-friendly code

Oh my goodness. Thoughts for the day… Log file-based troubleshooting of deployed applications in limited-access environments has to be one of the most frustrating processes of application development. Magic numbers are EVIL. Lack of default cases is EVIL. Long strands … Continue reading

Posted in C#, Musings, Programming | Leave a comment

Database unit testing resources

Not strictly a linkdump, but a list of resources for database unit testing. tSQLt, SQLunit, DBunit, dbForge

Posted in Linkdump, Programming, SQL Server, System/DB Administration | Leave a comment

DAX formatter

http://www.daxformatter.com by Marco Russo and Alberto Ferrari  

Posted in Business Intelligence, Linkdump | Leave a comment

SQL Server: time zone adjustment that accounts for Daylight Saving Time changes

This pulls the calendar for Daylight Saving Time from the server. DECLARE @time_in DATETIME SET @time_in = GETDATE() — SET @time_in = ‘2016/10/15 09:20:00 pm’ DECLARE @timezone_adjustment INT SET @timezone_adjustment=DATEDIFF(hh,GETUTCDATE(),GETDATE()) DECLARE @time_string NVARCHAR(60) –Convert from stored UTC datetime to local. … Continue reading

Posted in Programming, SQL Server | Leave a comment

C# SystemColors class

I set the design-time background color of by-default-invisible controls to a vibrant Pale Green as an indication to the designer/developer/myself that this control won’t be visible unless made so. When working with the by-default-invisible controls, I typically change the .BackColor … Continue reading

Posted in C#, Programming | Leave a comment

Linkdump: Screen/web scraping

http://www.dotnetperls.com/scraping-html http://www.dotnetperls.com/webclient https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=c%23+to+scrape+website http://stackoverflow.com/questions/3357170/beautifulsoup-and-asp-net-c  

Posted in Linkdump, Programming | Leave a comment

Linkdump: Getting SharePoint document lists

Get items from SharePoint List using PowerShell script https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=sharepoint%20powershell%20get%20list http://mosshowto.blogspot.com/2008/06/get-sharepoint-list-splist-internal.html https://social.msdn.microsoft.com/Forums/office/en-US/e3225ad4-75e6-4d78-b0ee-1b8e566778fc/reading-sharepoint-list-using-c?forum=sharepointdevelopmentlegacy http://www.sharepointsecurity.com/sharepoint/sharepoint-development/what-are-the-biggest-sharepoint-api-mistakes/   https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=c%23%202008%20get%20sharepoint%20list http://sharepoint.stackexchange.com/questions/50301/how-to-insert-data-into-managed-metadata-field-of-any-document-set-using-powersh/145279#145279 http://sharepoint.stackexchange.com/questions/67959/listing-all-the-documents-in-sharepoint-server-using-c http://sharepoint.stackexchange.com/search?q=c%23+get+document+list http://stackoverflow.com/questions/25718303/how-to-get-sharepoint-list-using-c-sharp http://sharepoint.stackexchange.com/questions/8862/sharepoint-2010-code-get-list-items-of-list-in-other-site-collection https://msdn.microsoft.com/en-us/library/office/microsoft.sharepoint.splist(v=office.14).aspx https://msdn.microsoft.com/en-us/library/office/ms456030(v=office.14).aspx https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=c%23%20sharepoint%202010%20get%20list%20items https://msdn.microsoft.com/en-us/library/office/websvclists.lists(v=office.14).aspx https://msdn.microsoft.com/en-us/library/office/websvclists.lists_members(v=office.14).aspx https://msdn.microsoft.com/en-us/library/office/websvclists.lists(v=office.14).aspx https://msdn.microsoft.com/en-us/library/office/websvclists(v=office.14).aspx https://msdn.microsoft.com/en-us/library/office/websvclists.lists(v=office.14).aspx https://msdn.microsoft.com/en-us/library/office/ee705814(v=office.14).aspx https://msdn.microsoft.com/en-us/library/1534a5f4-1d83-45b4-9714-3a1995677d85 https://code.msdn.microsoft.com/sharepoint-2013-get-items-d48150ae

Posted in Linkdump, Programming | Leave a comment

Linkdump: Working with (Tcl) Expect on Windows

http://expectonwindows.blogspot.com/ https://en.wikipedia.org/wiki/Expect http://expect.sourceforge.net/ http://stackoverflow.com/questions/19460420/running-expect-script-on-windows http://www.admin-magazine.com/Articles/Automating-with-Expect-Scripts http://docs.activestate.com/activetcl/8.4/expect4win/expect.html#exp_close http://docs.activestate.com/activetcl/8.4/expect4win/expect.html#exp_spawn http://tcl.activestate.com/man/tcl8.4/TclCmd/contents.htm?_ga=1.17009081.1244592451.1459347583 http://docs.activestate.com/activetcl/8.4/expect4win/expect.html http://docs.activestate.com/activetcl/8.4/expect4win/ex_usage.html#e4w_commands http://wiki.tcl.tk/3548 Expect script: start telnet, run commands, close telnet http://stackoverflow.com/questions/11250564/how-to-automate-telnet-session-using-expect?lq=1 http://stackoverflow.com/questions/11250564/how-to-automate-telnet-session-using-expect  

Posted in Linkdump, Programming, System/DB Administration | Leave a comment

Save a null value to a GUID field using C# SqlParameter

sCommand.Parameters.Add(“@employee_id”, SqlDbType.UniqueIdentifier).Value = (processEmployee_id == String.Empty ? System.Data.SqlTypes.SqlGuid.Null : new Guid(processEmployee_id));   http://stackoverflow.com/questions/23556173/how-to-insert-a-null-value-to-guid-column-in-table-using-c  

Posted in C#, Programming, SQL Server | Leave a comment