/* prepare the statement resource */ $stmt=mssql_init("your_stored_procedure", $conn); /* now bind the parameters to it */ mssql_bind($stmt, "@id", $id, SQLINT4, FALSE); mssql_bind($stmt, "@name", $name, SQLVARCHAR, FALSE); mssql_bind($stmt, "@email", $email, SQLVARCHAR, FALSE); /* now execute the procedure */ $result = mssql_execute($stmt); Another Example $conn = mssql_connect($db_host,$db_user,$db_password);if ($conn===false){ echo ‘Cannot connect.’; exit; } if (mssql_select_db("YourDatabase",$conn) === false) …
Category: ব্লগ । Blog
ব্লগ । Blog
Sep 15
Important Basic Concepts: Statistics for Big Data
Important Basic Concepts: Statistics for Big Data Graphical : Exploratory Data Analysis (EDA) methods? First of all, EDA is about exploring the data and understanding if the data will be good for the experiment and study. Graphs and plots can easily show the data patterns. The raw data can be difficult to understand for patterns …
Sep 15
Questions Answered by Exploratory Data Analysis (EDA)
Questions Answered by Exploratory Data Analysis (EDA) What are the key properties of a Dataset (Center, Spread, Skew, probability distribution, correlation, outliers) 1. What is the center of the data (mean, median, mode) 2. How much spread is there in the data? (Variance, Standard deviation, Quartiles, Interquartile Range (IQR), Example: IQR = Q3 – Q1) …
Sep 15
Best Practices in Data Preparation
Best Practices in Data Preparation 1. Check data formats (Image, CSV, PC, Mac, mainframe, text, structured, unstructured) 2. Verify data types (numbers, text, floats, currencies, nominal, ordinal, interval, range) 3. Graph your Data (Scatter, Histogram, bar, line) 4. Verify the data (data accuracy, data makes sense) 5. Identify outliers ( Examples: very large or very …
Sep 15
Machine Learning and Security Basics
Machine Learning and Security Basics Objective: Define/describe key concepts on what Machine Learning can do for Security and how First of all, what are security threats? Malware, Worm, Trojan, Spyware, Adware, Ransomware, Rootkit, Backdoor, Bot, Botnet, Exploit, Scanning (port scanning), Sniffing (silently observe and record), Keylogger, Spam, Login Attack, Account Take Over, Phising (masquerading), Spear …
Sep 14
Hacking Basics: Short Overview: A Short Breadth
Hacking Basics: Short Overview: A Short Breadth Audience: Ethical Hackers, Wanna be security researchers, interested to know the basics of Security Objective: Identify the key hacking concepts. Just the names primarily. key Topics: Password Cracking, Keyloggers, Trojans, Viruses, Worms, Rootkits, Social Engineering, Privilege Escalation, Denial of service attack, Botnet, Alternate data streams, Steganography, Covering tracks. …
Sep 13
Where to get Malware Samples and Labels?
Where to get Malware Samples and Labels? This information is intended for Security and Malware researchers. Virus Total: https://www.virustotal.com/gui/ Malware-traffic-analysis-net: http://malware-traffic-analysis.net/ Virus Share : https://virusshare.com/ VX Haven: https://vxer.org Kaggle, Microsoft Virus/Malware database: https://www.kaggle.com/c/microsoft-malware-prediction/data Reference: Clarence C, and David F.
Sep 12
Visualization of Multivariate Charts
Dataset Types Tables, Networks, Spatial https://www.cs.ubc.ca/~tmm/talks/minicourse14/vad16nasa.pdf Attribute Types Categorical, Ordered, Quantitative Multivariate Charts Scatter Plot, Heat Map, Bubble Chart, Parallel Coordinates, Radar Plot Scatter Plot https://en.wikipedia.org/wiki/Scatter_plot Scatter Plot : Details: Patterns https://mste.illinois.edu/courses/ci330ms/youtsey/scatterinfo.html Scatter Plot and Trend Line https://www.mathsisfun.com/data/scatter-xy-plots.html Scatterplot Details https://www150.statcan.gc.ca/n1/edu/power-pouvoir/ch9/scatter-nuages/5214827-eng.htm GRAPHICS: COMBINING TWOWAY SCATTERPLOTS | STATA LEARNING MODULES https://stats.idre.ucla.edu/stata/modules/graph8/twoway-scatter-combine/ Multiple overlaid scatterplots https://www.stata.com/support/faqs/graphics/gph/graphdocs/multiple-overlaid-scatterplots/index.html Visualization …
Sep 10
PERCEPTION and Data Visualization: Concepts, Examples, Code, Projects
PERCEPTION Data Visualization for Human Perception "Data visualization is the graphical display of abstract information for two purposes: sense-making (also called data analysis) and communication. … In other words, to visualize data effectively, we must follow design principles that are derived from an understanding of human perception." https://www.interaction-design.org/literature/book/the-encyclopedia-of-human-computer-interaction-2nd-ed/data-visualization-for-human-perception The Role of Visual Perception in Data …
Sep 10
Text Visualization: Concepts, Examples, Code (Python, R, Matlab), Example Projects
Text Visualization Data Visualization Of President Obama’s Inauguration Speech https://blog.capitalogix.com/public/2009/01/data-visualization-of-president-obamas-inauguration-speech.html Text Visualization Course at Washington University https://courses.cs.washington.edu/courses/cse512/16sp/lectures/CSE512-Text.pdf Why Visualize Text? https://www.teachervision.com/reading-comprehension/visualizing You can visualize text to find key concepts in a speech. Obama’s Speech: https://www.nytimes.com/2009/09/10/us/politics/10obama.text.html Example: Speech/Article Visualizations https://economix.blogs.nytimes.com/2009/09/09/obama-in-09-vs-clinton-in-93/?mtrref=undefined&gwh=EA5A091DC9E658A2DCC9513805FEAC3F&gwt=pay&assetType=REGIWALL 1993 Speech: Bill Clinton https://economix.blogs.nytimes.com/2009/09/09/bill-clinton-on-health-care-1993/ 1993 vs 2009. https://economix.blogs.nytimes.com/2009/09/09/obama-in-09-vs-clinton-in-93/ Wordtree https://www.jasondavies.com/wordtree/?source=8bd3e76f64f2d614410435434e2fb1fd&prefix Text Visualization Overview https://courses.cs.washington.edu/courses/cse512/16sp/lectures/CSE512-Text.pdf Introduction …
