In a previous tip we saw how easy it was to link to SQL Server tables from Microsoft Access. As is the case with all systems, how does Access manage the changes? What happens when you modify the structure of the underlying SQL Server table? What happens to the SQL Server table if you delete the linked table in Access? We will look at each of these situations in this tip.
2008-05-14
3,960 reads
2008-05-13
8,466 reads
Encrypting data is the easy part of dealing with encryption and databases. Steve Jones talks about some of the other, more difficult, issues you must handle.
2008-05-13
41 reads
Encrypting data is the easy part of dealing with encryption and databases. Steve Jones talks about some of the other, more difficult, issues you must handle.
2008-05-13
35 reads
Encrypting data is the easy part of dealing with encryption and databases. Steve Jones talks about some of the other, more difficult, issues you must handle.
2008-05-13
39 reads
This article provides guidance to what an integrated EDW is and what design elements are needed to achieve integration.
2008-05-13
2,998 reads
This article examines the built in reports called SQL Server Management Studio Reports and an additional add-on called Performance Dashboard.
2008-05-13
5,062 reads
One very interesting new feature in SQL Server 2005 is the ability to run backups to multiple locations, ensuring you have a second copy of the backup file if your first one were to be corrupted. SQL Server expert Andy Warren takes a look at how this feature works and the implications of using it.
2008-05-12 (first published: 2007-06-12)
8,478 reads
SQL Server trainer and longtime expert, Andy Warren brings us a great article on one basic skill that every DBA should know.
2008-05-12
12,609 reads
A short review of the WROX red covered book that looks at Integration Services for the DBA.
2008-05-12
3,070 reads
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers