LL – Laxmi Lal Menaria Blog!

Tag: Database

  • SQL Managemnet Studio (SSMS)- Retrieve Unsaved Scripts

    While working with SQL Server Management Studio (SSMS), we can have crash issues. This causes loss of our scripts / queries / query windows data. Sometimes we get “Not responding” error message and restarted again after automatically closed. We can’t stop this. This will be frustrating to re-write all statements again. So, there are some…

  • How to read DBF to Datatable

    [csharp] OleDbConnection oConn = new OleDbConnection(@”Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Temp;Extended Properties=dBase III”); OleDbCommand command = new OleDbCommand(“SELECT * FROM Test.DBF”, oConn); oConn.Open(); DataTable dt = new DataTable(); dt.Load(command.ExecuteReader()); oConn.Close(); [/csharp]

  • ORA-28001: The password has expired

    The password life of the applications as well as operating systems are limited. To enabling more security we are getting some alert in daily life that we need to chage our passwords regularly on fixed inerval. If we don’t change before the applications limitation, it will expired. The other day when I was opening SQL…

  • SQL SERVER – Installation Failure Database engine services failed.

    Sometimes when we install SQL Server or Add any new SQL Server Instance on Windows Machine, we can see the database errors listed below. To resolve these errors we are trying to repair existing installation or do something else. If nothing happens then we are trying to install it completely from control panel, but it…

  • How to Re-index Bibliographic Records in Koha

    Sometimes after entering Bibliographic (Books) data to Koha, they are not visible in the search. Due to this issue we need to rebuild the Koha index using command: sudo koha-rebuild-zebra -f -v instancename    

  • How to Backup Microsoft SQL Server (MSSQL) Databases

    –1. Variable declaration DECLARE @path VARCHAR(500) DECLARE @name VARCHAR(500) DECLARE @filename VARCHAR(256) — 2. Setting the backup path SET @path = ‘X:\MSSQLDB\Backup\’ DECLARE db_cursor CURSOR FOR SELECT name FROM master.dbo.sysdatabases WHERE name NOT IN (‘master’,’model’,’msdb’,’tempdb’) — ignore system databases –3. Initializing cursor operations OPEN db_cursor FETCH NEXT FROM db_cursor INTO @name WHILE @@FETCH_STATUS = 0…

  • How to speed up database and table listing in Management Studio

    In SQL Management Studio, select the “Databases” node in the Object Explorer. Then, click View –> Object Explorer Details. Right click on one of the column headers and uncheck all of the columns besides “Name”. These columns are slowing down the process of expanding the database list.

  • How to get list of all always encrypted columns in SQL Server

    We do have “Always encrypted” feature in SQL 2016 and later versions, from this feature we can encrypt the column data instead of encrypting whole database.  Sensitive data like credit card numbers, SSN. We need to prepare a list of encrypted columns at some where to track for future. Without tracking anywhere in the documents…

  • How to export schema of MYSQL Database?

    If you need schema of your MYSQL database for backup or any copy database to another server, then you must need schema with or without data. GUI tools like SQLYog, WebYog or PHPmyAdmin will best example for that. But if you need any command or utility then MYSQLDUMP has most important role. For using mysqldump…