Author Archives: dudidk

From time to time, we come across the need to transfer data from one SQL Server instance to another, we have several options to choose from and with this blog post, we will compare three common methods: backup and restore, Bulk Copy Program (BCP) Generated Import script and the Export & Import wizard. Backup andContinue reading “Data Transfer Between SQL Instances: Backup & Restore Vs BCP Vs Import Script”

Spoiler Microsoft.office.word –> mail merge The task Yesterday I received an interesting task.A team outside of ours had created a single column table within the TempDB database (AKA the redaction table) and our task is to DELETE the content from all tables from three major databases based on the id listed in the redaction table.Continue reading “A surprising tool to be used as a DBA”

Wail changing my site configuration from floating licenses to named users I came across two main issues. If the transition grace period has ended or if the floating license server is down then you cannot go into the Autodesk software in order to change the license type.The easiest way to work around this issue isContinue reading “Autodesk New License Method – Troubleshooting.”

As Autodesk has announced many times before it is in the process of changing all its clients from floating licenses via on-perm license server to named licensing via it’s cloud license server. Autodesk arguing that the change is beneficial for the client both technology vise and economically, to my opinion, we as users, are onContinue reading “Autodesk New License Method.”

Background: Few years back I was assigned the task to replicate our piping design software (Bentley AutoPLANT & AutoCAD Plant3D) Projects between our offices. The intention for this replication was, as explained to me by the Engineering CEO, is my engineer from office A will get sick I want the option that an engineer fromContinue reading “Replicating Piping Project between Offices.”

Current method (The Export & Import method): Currently, if we want all our users to work with the same tool palettes, we have to follow the following steps after every change we will do to the tool palette: From the computer that made the changes to the tool palette, Right Click the tool palette andContinue reading “How to share AutoCAD Tool Palette between Users via Local Network.”

Error: The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098, state: 15. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication isContinue reading “How to fix SPN error.”

Few days ago, wail a regular check I found that I have forgot to add permissions to my designers SQL group over the new AutoCAD PLANT3D project and databases and yet they are all working regularly. After some digging I found that when AutoCAD creates a new project it automatically grants control permissions to theContinue reading “AutoCAD PLANT3D SQL Permissions.”

Yesterday I had a strange issue, one of my users could access my SQL and some databases but I could not understand how. I can simply check the SQL security, users with access and groups with access but how can I get the user’s group and the groups for the groups ect’. So …. IContinue reading “Active Directory – Get all Groups for a User”

Method 1: Set initial size using the SQL Management Studio GUI. Restart the SQL Service New sizes should be set. Method 2: The best way to solve an issue is to avoid it. If we want to restart the SQL service and start it with switches then the correct way to do it will beContinue reading “HOW TO SHRINK TEMPDB?”