sql-server
26 items tagged with "sql-server"
Articles
Regular Expression Replace (REGEXP_REPLACE) in SQL Server
Execute Azure SQL Statements Periodically via Azure Automation
Call SQL Server Stored Procedure in Python
Spark (PySpark) - 从SQL Server数据库中读取数据
How to Create User for Azure SQL Database
Spark Scala: Load Data from SQL Server
Calculate MD5 , SHA256, SHA512 in SQL Server
Azure SQL Database Automated Backup Strategy
AttributeError: type object 'java.sql.Types' has no attribute '__javaclass__'
Save DataFrame to SQL Databases via JDBC in PySpark
Connect to SQL Server via JayDeBeApi in Python
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
Extract Values from JSON String Column in SQL Server
JSON is commonly used in modern applications for data storage and transfers. Pretty much all programming languages provide APIs to parse JSON.
Calculate time difference in T-SQL / SQL Server
JDBC Integrated Security, NTLM and Kerberos Authentication for SQL Server
Configure a SQL Server Database as Remote Hive Metastore
Connect to SQL Server in Spark (PySpark)
Load Data into HDFS from SQL Server via Sqoop
Connecting Apache Zeppelin to your SQL Server
Querying Teradata and SQL Server - Tutorial 2 Filtering and Sorting
Querying Teradata and SQL Server - Tutorial 1: The SELECT Statement
使用SQL Server 自带功能简化SQL
SQL Server 行列互相转换、合并
在数据库查询中，我们经常需要将数据库中的行与列互相转换；本文将对这些转换进总结，以供参考。
SQL Server 附加没有日志文件ldf的数据库mdf的方法
Diagrams
Python Libraries to Connect to SQL Server
There are several different ways to connect to SQL Server in Python: JDBC (py4j), for example, JayDeBeApi ODBC (pyodbc) FreeTDS (pymssql)
Static and Dynamic Data Masking
Static data masking will replace sensitive data at rest and this operation is usually irreversible. This is usually used to build data warehouse or data mart for analytical purposes where sensitive data is not required; it is also used to generate DEV and TEST environments using production data. Dynamic data masking will replace sensitive data in transition. The original data stored in the database will not be altered. When users issue query to retrieve the data, dynamic data masking process or engine will mask the data based on settings and users' access or roles. References Dynamic data masking (Azure SQL Database)