SQL Server

SQL Server with Access Articles, tips and tricks

Tuesday, October 14th @ 6.30pm CDT – Working with XML Data Efficiently

Ben Clothier, Access MVP and co-founder of the AccessUserGroups.org, will be presenting at this month's meeting for the SQL Server with Access Group. He will discuss working with XML data with an SQL Server backend. Earlier this year Ben posted a 2 part blog posts on this topic and this will be an u [...]

Tuesday, October 14th @ 6.30pm CDT – Working with XML Data Efficiently2014-10-04T06:55:13-05:00

Be an SQL Server Consultant from Home – Chicago Event

We're happy to announce yet another event for all of you SQL Experts!  On September 11th, Juan Soto, President of Access Experts, will be presenting to Chicago’s SQL Server User Group. Just one week away! Join fellow SQL experts for Juan Soto's presentation “Wish You Could Live the Glamorous Compute [...]

Be an SQL Server Consultant from Home – Chicago Event2014-09-08T19:41:14-05:00

SQL Server with Access Meeting

Please join Ben Clothier on Tuesday August 12th at 6.30pm CDT for our monthly meeting. We are excited to have monthly meetings to discuss Access with SQL Server topics! We meet every second Tuesday of the month at 6:30 PM Central Daylight Time (CDT). Topic: Managing large files with Access and SQL S [...]

SQL Server with Access Meeting2014-09-02T21:30:40-05:00

Are you having performance issues with SQL Server?

Lately I've been getting calls from people suffering from performance issues with SQL Server, in particular with the 2012 version. My first question these days is: "Which SQL Server client are you using?" A good Access developer would know the answer to that question, but if you don't, open control [...]

Are you having performance issues with SQL Server?2018-10-28T13:45:40-05:00

Copy 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. When there is a will, there is a way, and we've got a way you can copy data between Azure databases. Use Generate [...]

Copy Data Between Two Azure Databases2014-10-23T21:00:26-05:00

Replicating made simple: SQL Azure Data Sync

On May 13th, at 6:30 PM CST, I will be speaking about how you can easily create a solution that enable you to have your Access program working across broad geographic regions by leveraging SQL Azure Data Sync which is still in preview. In the talk, we will demonstrate how to get set up with replicat [...]

Replicating made simple: SQL Azure Data Sync2014-05-12T00:07:46-05:00

Running Transactions in a Stored Procedure

A lot of times, I write a stored procedure to do several things. More often than not, I might be doing mass inserts, updates or deletions. Now, I'm not your average suspenders-and-belt guy. No, I go one step further and insist on wearing an overall over my suspenders and my belt, thank you very much [...]

Running Transactions in a Stored Procedure2015-09-11T23:05:09-05:00

Working with XML Data Efficiently – Part Two

This is part two of our two-part series on working with XML data with a SQL Server backend. Part one can be found here. In part one, we showed how much simpler and effective it was to manipulate XML data by doing it directly in the SQL Server layer as opposed to front-end or middle-layer code. The i [...]

Working with XML Data Efficiently – Part Two2016-04-02T00:00:23-05:00

Working with XML Data Efficiently – Part One

This is part one of a two-part series that discusses working with XML data with an SQL Server backend. Part two is discussed here. I've personally found XML files to be something of a bugbear. They're going to require some kind of transformation to get it in a format that's useful for importing or e [...]

Working with XML Data Efficiently – Part One2016-04-02T00:25:45-05:00

Easily update all tables that have the same field name

We talked about concatenating multiple records into a single string using FOR XML PATH and we also talked about EXISTS clause. Here's a practical example that incorporates both. In one of our projects, we have an archive database that contains historical data of select tables from the production dat [...]

Easily update all tables that have the same field name2013-11-05T20:12:38-05:00

Easily create a Beta environment in SQL Server

We are specialists in creating Access to the cloud solutions using SQL Server. We therefore maintain a number of databases and our clients are constantly asking us for improvements. Of course, we require that those go through a full cycle of testing and deployment: We copy an existing database using [...]

Easily create a Beta environment in SQL Server2013-10-14T20:12:28-05:00
Contact Us
close slider
  • This field is for validation purposes and should be left unchanged.