Full-Text Search in SQL Server and Azure SQL Database lets users and applications run full-text queries against character-based data in SQL Server tables. Installing Full-Text Search SQL Server Full-Text Search feature is an optional competent of the Database Engine and doesn’t get installed by default.While installing SQL Server you have to select the Full-Text Search […]
I recently upgraded one of my SQL Server 2014 instance to SQL Server 2017 and applied CU5. Very recently I installed Full Text Feature and instance is enabled for Full Text. Database is enabled for Full Text. Now when I am trying to create Full-Text Index from SSMS on one of my table , Full-Text Index […]
In this article we will go over on how to Read Azure blob Storage Data from SQL Server (SSMS) Setup Azure Storage account Grant permission to access the Storage container. Connect to Azure Storage from SSMS ( Storage Account and Account Key Required). Install Polybase feature on the server.(If do not exists) PolyBase Connectivity Configuration. […]
This article talks about how to install SQL Server 2017 polybase post upgrading from SQL Server 2014 and troubleshooting polybase installation rule failures. For more details and limitations go to https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-installation Polybase is introduced in SQL Server 2016.So, post upgrading you have to install polybase as a fresh feature installation to an existing upgraded SQL Server […]
Error : SSMS DTS Wizard throw error The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data) TITLE: SQL Server Import and Export Wizard —————————— The operation could not be completed. —————————— ADDITIONAL INFORMATION: The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data) The error is due to SSMS calling […]
While trying to import data from an excel file we encountered error related to OLDEDB provider (Microsoft.ACE.OLEDB.12.0 & Microsoft.ACE.OLEDB.15.0) Error encountered on Microsoft SQL Server 2017 (RTM-CU5) (KB4092643) – 14.0.3023.8 (X64) Edition : Developer Edition OLE DB provider “Microsoft.ACE.OLEDB.15.0” for linked server “(null)” returned message “Could not find installable ISAM.”. Msg 7303, Level 16, […]
We recently ran into below issue trying to change the SQL Server Service Account. SQL Server Service was running under local service account and the instance is configured for force encryption with certificate. Issue : Unable to load user-specified certificate [Cert Hash(sha1) “XXXXXXXXXXXXXXXXXXX”]. The server will not accept a connection. You should verify that the certificate […]
Very recently one of my client argued on the effect ALTER TABLE ADD or ALTER TABLE DROP column has on an existing table having millions of records. AFAIK, the add column and drop column do not have a significant impact as the changes made are matadata changes. Still, to prove the point , here is […]
Identifying logins that have no passwords SELECT name FROM sys.sql_logins WHERE PWDCOMPARE(”, password_hash) = 1 ;
Reading mongod log file in command prompt. Navigate to the log file location and type {TYPE log-file-name} type 1.log If the log file is quite big and you want to read the log file in batches use pipe operator with more tag type 1.log | more
To check replication status, mongodb has rs.status() inbuilt function. abc:PRIMARY> rs.status function () { return db._adminCommand(“replSetGetStatus”); } rs.status ouput If secondary is synced and wasn’t created with slaveDelayoption then optime and optimeDate of secondary should be equal or close (if there are current operations) to those of primary. In that case stateStr should be equal […]
Stopped the mongod service manually and tried to start the service again which failed to start. Looked into the error log to see what caused the service to fail. Attached below is the error recorded in the error log, which was quite confusing and got me thinking how come permission where removed. [root@lx1 /]# cd /var/log/mongodb [root@lx1 mongodb]# […]
select * from sys.databases where is_master_key_encrypted_by_server=1 select * from sys.certificates select * from sys.dm_database_encryption_keys where encryption_state=3 SELECT * FROM sys.symmetric_keys SELECT * FROM sys.asymmetric_keys
Continuation from http://sqlcontent.com/index.php/category/sql-server-encryption/ Asymmetric Keys Encrypt by Password do not require to have master key in the database. The following example creates an asymmetric key named _rsa_customer_accmaster_key by using the RSA_2048 algorithm, and protects the private key with a password. USE RSASecData GO CREATE ASYMMETRIC KEY _rsa_customer_accmaster_key WITH ALGORITHM = RSA_2048 ENCRYPTION BY PASSWORD = ‘G%$D@3@f5-34+!DF’; GO […]