Loading...

Follow SQL with Manoj on Feedspot

Continue with Google
Continue with Facebook
or

Valid

  The following JSON contains some attributes at root level, like ProductNum and unitCount. It also contains a Nested attribute with name “Properties”, which contains an array of Key-Value pairs. Now, what I want is to expand this JSON, and have all the attributes in form of columns, with additional columns for all the Keys […]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

    The adoption of public cloud computing services shows no signs of slowing down — Gartner predicted that the global public cloud services market will grow 17.3 percent in 2019 alone. A huge draw of the public cloud is the use of its low-cost storage services for cloud backup purposes. Businesses can securely back […]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

  Happy New Year 2019… from SQL with Manoj !!! As WordPress.com stats helper monkeys have stopped preparing annual report for any of their blogs, so I’ve prepared my own Annual Report for this year again.   –> Here are some Crunchy numbers from 2018 The Louvre Museum has 8.5 million visitors per year. This […]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

  HDFS or Hadoop Distributed File System is the distributed file system provided by the Hadoop Big Data platform. The primary objective of HDFS is to store data reliably even in the presence of node failures in the cluster. This is facilitated with the help of data replication across different racks in the cluster infrastructure. […]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

  1. Open RUN by pressing Windows + R keys, type powershell command and hit Enter.   2. Now on Powershell window first connect to the Azure VM that you want to remotely restart: [MyAzureVMName]: PS C:\Users\manojp\Documents>   3. Now try issuing the Restart command: Restart-Computer : Failed to restart the computer MyAzureVMName with the […]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

  Today on 24th September 2018 Microsoft announced the released of first CTP version of SQL Server vNext i.e. SQL Server 2019 CTP 2.0.   SQL Server 2016 & 2017 brought Machine Learning feature by adding R and Python support for Data Analytics and Scientists. And now SQL Server 2019 has added Big Data capabilities […]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

  Microsoft SQL Server is the most popular database management system, which provides flexibility to the database administrator to manage their database. It is a full-featured database and designed for use in corporate applications. But, many times, many users need to migrate their SQL Server database to the Azure SQL Database. Because Azure is an […]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

  Setup SQL Server on Linux: 1. Spinning up a new Linux VM on Microsoft Azure 2. Install and Configure SQL Server 2017 on Linux Azure VM 3. Connect SQL Server on Linux with SSMS from a Windows machine   Best Practices: Here are some of the best practices post installing SQL Server on Linux […]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

  You are running a Python script by using sp_execute_external_script SP but its throwing this error:   Msg 39023, Level 16, State 1, Procedure sp_execute_external_script, Line 1 [Batch Start Line 27] ‘sp_execute_external_script’ is disabled on this instance of SQL Server. Use sp_configure ‘external scripts enabled’ to enable it.   You can refer to my blog […]
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

  Microsoft is encouraging people/customers who are currently using Oracle, IBM Db2, Sybase, or Netezza database, to migrate to SQL Server 2017 for free (free license), get subsidized migration support services, hands-on labs, and instructor-led demos as part of this offer.     With SQL Server 2017 not only its available in Windows, but also […]
Read Full Article

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview