Linking Access to SQL Server Reposted on SSC
This is an older article that was recycled for Fri, but still seems to get a decent number of views...
2007-11-04
449 reads
Andy Warren
Two TechEds Better Than One?
Just saw the announcement that there will be two back to back TechEd's next year. Both will be held in...
2007-11-03
339 reads
Linking Access to SQL Server
For quick and dirty work, sometimes Access is the best way to work with SQL Server. Andy Warren brings a basic tutorial on how you can link Access to your SQL Server tables to easily and quickly manipulate data.
2007-11-02 (first published: 2006-01-25)
27,088 reads
Mini Review: Building Technical User Communites by Greg Low
I had the chance to see Greg do a presentation at the PASS Summit in Denver that was based on...
2007-11-02
348 reads
Using DMO to Restore a Database
This article by Andy Warren includes code samples showing you how to restore a database from a file or a device backup.
2007-11-01 (first published: 2001-05-07)
24,601 reads
Nominations INETA North America Board of Directors
Picked this up from the local Net group here in Orlando. INETA is actually pretty helpful when it comes to...
2007-10-31
1,410 reads
SQLSaturday Finally Has a Logo
Sometimes its the little things that seem to take forever! We've had a text only logo up for a while,...
2007-10-31
1,436 reads
If Exists (Select 1...) vs If Exists (select * ...)
If exists is a well known way to improve performance because it returns as soon as it matches a single...
2007-10-30
1,946 reads
How Much Pizza and Soda for a User Group Meeting (Why You Should RSVP)?
After a few meetings of oPASS this year the numbers I use are 2 slices of pizza and 2 drinks...
2007-10-29
1,442 reads
SQLSaturday Finally Listed in PASS Connector
If you subscribe to the Connector (the main communication email from PASS.org) you should have gotten one yesterday that finally...
2007-10-25
1,390 reads
Blogs
Master SQL Subqueries with This Free Course
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
Forums
When trying to use a LocalDB, I get an error
I tried to find an appropriate forum to post the question. This one seems...
Resolving Access Denied Errors During SQL Server Database Attachment
Comments posted to this topic are about the item Resolving Access Denied Errors During...
The Lesser Used Functions
Comments posted to this topic are about the item The Lesser Used Functions
Question of the Day
SQL in an Azure VM Backup
If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)
See possible answers