Search

Tutorials, tips&tricks, snippets..

#KISS: KEEP IT SIMPLE, STUPID!

Enable/disable foreign keys check

When you do some stuff on your database, it can be useful disable, for a while, the foreign keys check. Here how to do it:
Continue reading “Enable/disable foreign keys check”

Advertisements

How to Fix the Error “Could not find the Database Engine startup handle” in SQL Server 2016, 2014, or 2008

Just go here to solve this problem.

Find duplicate records with a query in Access

Duplicate data often creeps in when multiple users add data to the database at the same time or if the database wasn’t designed to check for duplicates. Duplicate data can be either multiple tables containing the same data or two records containing just some fields (columns) with similar data. Here’s how you can locate duplicate records for a desktop database.

To find duplicate records:

  1. On the Create tab, click Query Wizard.
  2. In the New Query dialog, click Find Duplicates Query Wizard > OK.
  3. In the list of tables, select the table you want to use and click Next.
  4. Select the fields that you want to match and click Next.
  5. In the list of available fields, select the field or fields that contain the data that you want to update and click Next.
  6. Accept the suggested query name or enter a name, and click Finish to run the query.

CopyDatabaseWizard version error

This morning I found this annoying message in Event Viewer of my machine where I have a SQL Instance:

Activation context generation failed for “c:\program files (x86)\microsoft sql server\120\Tools\Binn\managementstudio\CopyDatabaseWizard.exe”.Error in manifest or policy file “c:\program files (x86)\microsoft sql server\120\Tools\Binn\managementstudio\CopyDatabaseWizard.exe” on line 8. The value “1.0” of attribute “version” in element “assemblyIdentity” is invalid.

A quick solution is:

Continue reading “CopyDatabaseWizard version error”

What is the difference between Public, Private and Protected?

We always see the Access Modifiers in our code, but do we really know them?

Continue reading “What is the difference between Public, Private and Protected?”

Only numbers in a WPF textbox with regular expressions

Managing the input in your project is very important. In this post, you can see how create a numeric field in WPF, using the regular expressions.

Continue reading “Only numbers in a WPF textbox with regular expressions”

Prevent Copy, Cut and Paste in a XAML Textbox

How can you prevent at least one of copy, cut and/or paste actions in a WPF project? Here how prevent these events in a textbox.

Continue reading “Prevent Copy, Cut and Paste in a XAML Textbox”

Extension Methods #5: check if object has a method

We have a lot of confortable methods ready to use in our .NET objects and this is wonderful: just think for example the method .toString()! How much do we use it? But, sometimes, these methods aren’t enough and we need to create others on our own.

Continue reading “Extension Methods #5: check if object has a method”

Extension Methods #4: check if object has a property

We have a lot of confortable methods ready to use in our .NET objects and this is wonderful: just think for example the method .toString()! How much do we use it? But, sometimes, these methods aren’t enough and we need to create others on our own.

Continue reading “Extension Methods #4: check if object has a property”

Powered by WordPress.com.

Up ↑