How to Customize the Default Table View in SQL Server Diagrams
When designing a SQL Server database, I like to define foreign-key (FK) relationships using database diagrams. I also like the tables in my diagrams to display the column names and their data types, for easy review and also because data-type mismatches are a common error when defining FKs and I…
READ MORE
Downloads for “Introduction to Full-Text Searching in SQL Server 2012”
Below are the presentation and script files I used for my July 8 talk to the Virtual Access Groups on full-text searching in SQL Server: PowerPoint Presentation Scripts
Copying data between two Azure Databases
We use Windows Azure around here a lot, it works great with Access but it has one limitation: you can’t copy data from one database to another since they don’t support the USE statement. Use Generate Script Instead To get around this limitation use the following technique: Launch SQL Server…
READ MORE