A union of curiosity and data science

Knowledgebase and brain dump of a database engineer

Archive

RSS.Net (8)

Date Title Comments Rating
2017-01-11 Predict stock prices with SQL Server Analysis Services Mining Models 0 5
2016-09-07 Microsoft Cognitive Services Playground - Computer Vision VS2015 1 5
2016-09-06 Facebook Insights API : Single Ad Performance Results 0 None
2016-08-04 C# Dictionary from Key Value Pair String (URL) 0 None
2016-07-20 SQL Server 2012 CLR Function - Google Web Services : Address Distance Matrix API 0 None
2016-07-18 Process XML to DataTable Function 0 None
2015-08-15 Write Image to Browser as Base64 String 0 None
2012-01-26 C# Grab image from web and put it in a SQL Server Table. 0 None

RSSGeneral (1)

Date Title Comments Rating
2010-11-29 Toys 0 None

RSSLync (1)

Date Title Comments Rating
2011-11-01 Lyncin Log 9 None

RSSMachine Learning (1)

Date Title Comments Rating
2017-01-11 Predict stock prices with SQL Server Analysis Services Mining Models 0 5

RSSMS Cognitive Services (1)

Date Title Comments Rating
2016-09-07 Microsoft Cognitive Services Playground - Computer Vision VS2015 1 5

RSSPredictive Analytics (1)

Date Title Comments Rating
2017-01-11 Predict stock prices with SQL Server Analysis Services Mining Models 0 5

RSSPython (4)

Date Title Comments Rating
2016-08-22 Python 3 Connection to SQL Server with PYPY 0 None
2016-08-15 Open non valid utf_8 character text file with python. (not unicode but non decodable bytes) 0 None
2016-07-26 Preparing Visual Studio 2015 For Python Development 0 None
2016-07-25 Setting Up Eclipse for Python Development 0 None

RSSRedshift (1)

Date Title Comments Rating
2017-05-18 EC2 and Redshift - Set Password File - use Bash / PSQL / Select without interactive password 0 5

RSSSQL Server (3)

Date Title Comments Rating
2015-03-06 Generate MD5 hash string with T-SQL - Hashbytes 0 None
2013-01-17 SQL SERVER MSSMS Error "Saving Changes is not Permitted." 0 None
2012-01-26 C# Grab image from web and put it in a SQL Server Table. 0 None

RSSSQL Server - Admin (13)

Date Title Comments Rating
2011-08-25 Server Setup Basics - Considerations and Good Practices 0 None
2011-02-17 Estimated query completion time 0 None
2011-02-10 A slow query log for SQL Server 0 None
2011-02-10 Useful Profiler T-SQL functions 0 None
2011-02-08 Defrag me please........ 0 None
2011-02-08 Database defragmentation at x%. SQL 2k5 and 2K8 0 None
2011-02-08 Database defragmentation at x%. SQL 2k 0 None
2011-01-31 Report your database table sizes. (2k, 2k5, 2k8) 0 None
2011-01-05 What the? How much memory is SQL Server using? 0 None
2011-01-03 Disk Space Monitoring Procedure without OLE Automation Procedures 0 None
2010-12-14 Shrink Transaction Logs 0 None
2010-12-01 SQL 2K5 Suspect Mode Database (EMERGENCY MODE) 0 None
2010-09-09 Fixing Orphaned SQL Server Users. SQL 2k, 2k5 0 None

RSSSQL Server - CLR (2)

Date Title Comments Rating
2016-07-20 SQL Server 2012 CLR Function - Google Web Services : Address Distance Matrix API 0 None
2013-11-21 Create SQL Server CLR Function (Date Time Conversion) UTC to PDST 1 None

RSSSQL Server - Collation (1)

Date Title Comments Rating
2011-01-19 Collation Basics 浚 0 None

RSSSQL Server - Perf. Tuning (1)

Date Title Comments Rating
2011-01-06 Lock Pages In Memory 0 None

RSSSQL Server - Replication (2)

Date Title Comments Rating
2011-09-28 Change SQL Server 2005 Replication Agent Profiles 0 None
2011-02-02 Cannot alter table for replicated article after dropping article from all publications. (SQL2K5) 2 None

RSSSQL Server - SSAS (4)

Date Title Comments Rating
2017-01-11 Predict stock prices with SQL Server Analysis Services Mining Models 0 5
2014-10-07 Order MDX query alphabetically - Member_Caption 0 None
2014-07-08 Format SSAS Dates from '1900-01-01 00:00:00.000' to '01/01/1900' 0 None
2013-01-10 MDX Query Examples - Item Lag, Lead and Tail 0 None

RSSSQL Server - SSRS (2)

Date Title Comments Rating
2014-07-16 SQL Jobs for SSRS Subscriptions are made with a GUID as the name . Find the actual report. 0 None
2012-09-17 SSRS 2012 Chrome Incompatibility 0 None

RSSSQL Server - T-SQL (11)

Date Title Comments Rating
2015-10-26 Query for finding command text within a sql server job 0 None
2015-03-06 Generate MD5 hash string with T-SQL - Hashbytes 0 None
2015-01-26 Visual Studio SSIS Temp Tables in Data Sources. 0 None
2014-03-13 Create UPC Check Digit Function 0 None
2013-10-02 T-SQL Word Count Function 0 None
2012-10-05 Excel Floor Function in SQL Server 0 None
2012-03-27 Random Number Per Queried Row SQL Server 2005 0 None
2011-06-02 Cross apply and a quick date split function 0 None
2011-01-10 SQL Server Cursor Example 0 None
2010-12-14 Shrink Transaction Logs 0 None
2010-12-13 TSQL Query Default Database Path for SQL Server 0 None

RSSSSAS Mining Models (1)

Date Title Comments Rating
2017-01-11 Predict stock prices with SQL Server Analysis Services Mining Models 0 5

RSSVisual Studio (1)

Date Title Comments Rating
2016-07-26 Preparing Visual Studio 2015 For Python Development 0 None

Uncategorized (12)

Date Title Comments Rating
2018-05-09 Note on GDPR - General Data Protection Regulation Summary 0 None
2018-05-08 Magento 2 API Product Get 0 None
2018-01-05 Google Translate API - Wav file speech recognition with python3 0 None
2016-09-05 C# Query Facebook Insights API 0 None
2016-01-21 C# Get file names in directory (loop through directory and get filenames) 0 None
2014-02-26 sp_blocked - procedure for viewing locks and blocks 0 None
2013-11-11 C# Loop through sql server database recordset with SqlClient 0 None
2013-07-17 SQL Server: Store localized versions of strings with language specific full text search 0 None
2013-01-01 Save a Freelancer from Freelancer.com to a Lightbox / Wishlist - Chrome Extension for Freelancer.com 0 None
2012-12-14 Use a select statement to create a list within a varchar variable 0 None
2012-10-28 Linked Servers : SQL Server 0 None
2012-06-06 Modify Drop Down List (Combo Box) Size / Item Count in Sharepoint 2012 Performance Point 0 None

Total

61 posts
13 comments
5 raters