Let's say:
'(', '{', '[' are called "openers."
')', '}', ']' are called "closers."
Write an efficient function that tells us whether or not an input string's openers and closers are properly nested.
Examples:
"{ [ ] ( ) }" should return True
"{ [ ( ] ) }" should return False
"{ [ }" should return False
Solution
We iterate through our string, … Read More →
Le théorème de Bayes, ou de probabilité des causes, s'en dérive aussitôt en mettant à profit la symétrie de la règle de multiplication
P ( A | B ) = P ( B | A ) . … Read More →
https://brohrer.github.io/blog.html
I. End-to-end Machine Learning courses
II. How machine learning works
III. Using machine learning
IV. Using data
V. Statistics
VI. Professional Advice
VII. Artificial intelligence editorial
VIII. Becca, a robot brain project
Frequently asked questions
Contributing translations and adaptations
End-to-end Machine Learning courses
Hands-on, project-driven courses for machine learning students and data scientists, offered through Udemy.
Decision Trees: Build your own transit time predictor
… Read More →
pyfolio is a Python library for performance and risk analysis of financial portfolios developed by Quantopian Inc. It works well with the Zipline open source backtesting library.
At the core of pyfolio is a so-called tear sheet that consists of various individual plots that provide a comprehensive image of the performance of a trading algorithm. Here's … Read More →
DOTNET exposes several ways to achieve mutual exclusion in code such as Mutex, Lock, SynLock, Manual reset event or Thread wait etc. The same thing can be achieved even in SQL Server using application locks. It is achieved by using 2 system stored procs (sp_getapplock and sp_releaseapplock)
Permissions:
However to be able to call sp_getapplock a user … Read More →
LOCK_TIMEOUT is not only a session-level setting, it also needs to be set in a separate batch. But, it cannot be set via a variable. So, this can be accomplished by using Dynamic SQL in the "master" Stored Procedure. This will allow for setting LOCK_TIMEOUT and then executing whatever other Stored Procedure that should run … Read More →
Reinforcement Learning
Reinforcement Learning is a type of Machine Learning. It allows machines and software agents to automatically determine the ideal behavior within a specific context, in order to maximize its performance. Simple reward feedback is required for the agent to learn its behavior; this is known as the reinforcement signal.
There are many different algorithms that … Read More →
Reinforcement learning (RL) is a branch of machine learning that addresses problems where there is no explicit training data. Q-learning is an algorithm that can be used to solve some types of RL problems. In this article I demonstrate how Q-learning can solve a maze problem.
The best way to see where this article is headed … Read More →
The ideal flowchart maker
Build all kinds of different flowcharts with Lucidchart’s powerful features.
https://www.lucidchart.com/?noHomepageRedirect=true
Here are some SSIS interview questions that you can expect if you interview for the job of ETL Developer. I will be adding more questions and different small scenarios. Good luck with your SQL Server Integration Services interview.
For Video Answers for SSIS Interview Questions , Please check THIS playlist.
General
What is ETL? (Video Answer)
What is Business … Read More →
All Tips
Additional Optimizations for Type 2 Slowly Changing Dimensions in SQL Server Integration Services - Part 3
Backwards Compatibility in SQL Server Data Tools for Integration Services
Data Sampling in SQL Server Integration Services
Debugging Control Flow in SQL Server Integration Services - Part 1
Debugging Control Flow in SQL Server Integration Services – Part 2
Defining Workflow in SSIS … Read More →
Your Key Performance Indicators are the vehicle to tell the story of your organization’s strategic performance.
Learn how to develop your Key Performance Indicators to manage the performance of your strategic plan. Want more practical tips and insights on strategic planning?
Subscribe to our channel here - https://www.youtube.com/channel/UCc5c...
Download a FREE Complete Guide to Strategic Planning - http://onstrategyhq.com/complete-stra... … Read More →
Clustered and nonclustered indexes share many of the same internal structures, but they're fundamentally different in nature. Watch Microsoft Certified IT Professional Jon Seigel explain the similarities and differences of clustered and nonclustered indexes, using a real-world example to show how these structures work to improve the performance of SQL queries.
Blog post on primary key … Read More →
While the practice of Continuous Integration (CI) started with application code, you can apply the same principles to databases. Database CI is the process by which we build, test and deploy the database on commit of every database change, and report any errors. In this way, CI reduces your feedback loop such that changes that … Read More →
Learn how Azure SQL Data Warehouse combines massively parallel processing (MPP) with Azure storage to achieve high performance and scalability.
MPP architecture components
SQL Data Warehouse leverages a scale out architecture to distribute computational processing of data across multiple nodes. The unit of scale is an abstraction of compute power that is known as a data warehouse … Read More →
Resources
The page is dedicated to presentations, scripts, and other resources that are available for download.
Presentations:
SQL Server Audit - Evidence Never Lies - PowerPoint slide deck
SQL Saturday #692 - Atlanta, GA - Jul 15, 2017
SQL Saturday #610 - Richmond, VA - Mar 18, 2017
SQL Saturday #592 - Raleigh, NC - Mar 11, 2017
Policy Based Management - Beyond the Basics … Read More →
xp_dirtree has three parameters:
directory - This is the directory you pass when you call the stored procedure; for example 'D:\Backup'.
depth - This tells the stored procedure how many subfolder levels to display. The default of 0 will display all subfolders.
file - This will either display files as well as each folder. The default of 0 … Read More →
PIVOT Operator
UNPIVOT Operator
A collection of premium SSIS components to enable greater developer productivity and increase the power of SSIS.
The HTTP/Web Services components is a grouping of SSIS add-on components from the SSIS Productivity Pack which facilitate working with HTTP and SOAP or REST based web services within SSIS.
There are currently 6 SSIS components within this category:
HTTP Connection … Read More →