The importance of automating processes can’t be overestimated. Most things start out as a manual procedure until you work out exactly how things should happen, but many times they stay that way ...

Using Access to build a front end for SQL Server Your email has been sent What are the advantages of using Access as the front end to a SQL Server database? For starters, it's likely that your ...

I got it. The INSERT INTO was missing the draft status id field and also the name in the new table was still DRAFT_STATUS_ID but labeled Draft Status Id.

On Tuesday Microsoft announced the release to manufacturing for SQL Server 2012 as well as an "evaluation version" for download, with general availability coming April 1. With this release, Microsoft ...

Are you ready to unlock the power of Microsoft SQL Server 2014? In this blog entry I will examine my 3 favorite new features that show how SQL Server 2014 provides high-performance OLTP, optimization ...

SQL Server 2012 is a large, complex product that represents Microsoft's vision of where data is headed. If that vision were to be summed up in one word, that word would be: big. To meet the challenges ...