16
NOV
Blog author
Databases Database technologies, like MS SQL Server, PostgreSQL, MySQL, No SQL, Graph Db's, etc.
10
AUG
SQL Server Database Export/Import operation in MS Azure
The beauty of Azure is that it has multiple ways to do the same thing. Imagine the scenario; you need to copy the database between subscriptions. Considering the SQL Server Import/Export procedure, you can do that either from the UI or use command line tools (like SQLPackage). The way it works with Azure UI, you go to the SQL Server database you want to export, and you have an option available (
13
MAY
Hadoop
In a nutshell, Hadoop is an open-source project of the Apache Software Foundation that can be installed on a set of standard machines, so that these machines can communicate and work together to store and process large datasets. Hadoop has become very successful in recent years thanks to its ability to effectively crunch big data. It allows companies to store all of their data in one system and
21
JAN
JOIN operator for dummies
Данная статья будет полезна новичкам и поможет в освоении оператора JOIN и в этом примере он будет рассмотрен в контексте языка T-SQL. Для визуализации работы запросов были также использованы диаграммы Венна, которые, как я надеюсь помогут вникнуть в смысл JOIN-ов. Для начала работы над примерами - предположим, что у нас есть 2 таблицы ('Таблица_1' слева и 'Таблица_2' справа), давайте заполним их
20
JAN