SQL Server

Articles tagged with SQL Server.
visibility 15
thumb_up 0
access_time 2 months ago

In article Connect to SQL Server in Spark (PySpark) ,  I showed how to connect to SQL Server in PySpark. Data can be loaded via JDBC, ODBC and Python drivers. In this article, I will directly use JDBC driver to load data from SQL Server with Scala. Download Microsoft JDBC Driver for SQL ...

visibility 113
thumb_up 0
access_time 5 months ago

SQL Server has built-in function HASHBYTES that can be used to calculate hash values. The supported hash algorithms include MD2, MD4, MD5, SHA, SHA1, SHA2_256 and SHA2_512. The signature of this function is: HASHBYTES ( '<algorithm>', { @input | 'input' } ) ...

Azure SQL Database Automated Backup Strategy
visibility 689
thumb_up 0
access_time 10 months ago

When designing the architecture of Kontext platform, Azure SQL Database is chosen as the storage for relational data. TDE and other advanced security features are always enabled to protect the database. Backup plans are also employed to ensure I can always restore the database for as point of time ...

visibility 2078
thumb_up 0
access_time 10 months ago

In my previous article  Connect to SQL Server via JayDeBeApi in Python , I showed examples of using Python package jaydebeapi to connect to SQL Server via JDBC. The code was working properly. However after I reinstall Python 3.8.2 x64 version on Windows, I'm getting a new error ...

visibility 10009
thumb_up 1
access_time 11 months ago

In my previous article about  Connect to SQL Server in Spark (PySpark) , I mentioned the ways to read data from SQL Server databases as dataframe using JDBC. We can also use JDBC to write data from Spark dataframe to database tables. In the following sections, I'm going to show you how to ...

visibility 3482
thumb_up 0
access_time 11 months ago

Python JayDeBeApi module allows you to connect from Python to databases using Java JDBC drivers.

Spark Read from SQL Server Source using Windows/Kerberos Authentication
visibility 1464
thumb_up 0
access_time 12 months ago

In this article, I am going to show you how to use JDBC Kerberos authentication to connect to SQL Server sources in Spark (PySpark). I will use  Kerberos connection with principal names and password directly that requires  Microsoft JDBC Driver 6.2  or above. The sample code can run ...

visibility 5268
thumb_up 1
access_time 2 years ago

With Microsoft SQL Server JDBC driver, you can connect to the database through SQL Server Authentication or Kerberos Authentication. This post summarizes the configurations required for each authentication method with coding examples. *NTLM block in the following diagram represents pure Java ...

visibility 3011
thumb_up 0
access_time 2 years ago

In one of my previous post, I showed how to configure Apache Hive 3.0.0 in Windows 10. Apache Hive 3.0.0 Installation on Windows 10 Step by Step Guide I didn’t configure Hive metastore thus by default Hive will use embedded mode for metastore. The metadata is stored in Apache Derby database.

visibility 26830
thumb_up 4
access_time 2 years ago

Spark is an analytics engine for big data processing. There are various ways to connect to a database in Spark. This page summarizes some of common approaches to connect to SQL Server using Python as programming language. For each method, both Windows Authentication and SQL Server ...

Read more

Find more tags on tag cloud.

launch Tag cloud