Go Back   Access World Forums > Apps and Windows > SQL Server

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-25-2018, 02:51 PM   #1
MickJav
Newly Registered User
 
Join Date: Nov 2005
Location: Margate
Posts: 617
Thanks: 31
Thanked 8 Times in 8 Posts
MickJav is on a distinguished road
Just installed Sal server 2017 express and the ssms

Haven't had a chance to play much but the fun begins now I think I'll create a access db to play with it.

__________________
After 20 years working with access i have no more hair to give.


Database Dreams home page:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.



Project Manager - Developer help information:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
MickJav is offline   Reply With Quote
Old 12-13-2018, 02:21 AM   #2
ahmed_optom
Newly Registered User
 
Join Date: Oct 2016
Posts: 45
Thanks: 9
Thanked 1 Time in 1 Post
ahmed_optom is on a distinguished road
Re: Just installed Sal server 2017 express and the ssms

its fun, but you realise just how powerful and user friendly access is when you start messing around with sql/mysql.
ahmed_optom is offline   Reply With Quote
Old 12-13-2018, 02:37 AM   #3
Eugene-LS
Newly Registered User
 
Join Date: Dec 2018
Posts: 18
Thanks: 6
Thanked 2 Times in 2 Posts
Eugene-LS is on a distinguished road
Re: Just installed Sal server 2017 express and the ssms

Quote:
Originally Posted by MickJav View Post
I think I'll create a access db to play with it.
It's normal - MSA 2003 -2019 are ready for that

Eugene-LS is offline   Reply With Quote
Old 12-13-2018, 02:38 AM   #4
MickJav
Newly Registered User
 
Join Date: Nov 2005
Location: Margate
Posts: 617
Thanks: 31
Thanked 8 Times in 8 Posts
MickJav is on a distinguished road
Re: Just installed Sal server 2017 express and the ssms

Quote:
Originally Posted by ahmed_optom View Post
its fun, but you realise just how powerful and user friendly access is when you start messing around with sql/mysql.

Yep it's not wysiwyg it's a nightmare waiting to jump on you one late lonely night I'm only looking to be able to create DB's with it I really don't want to be a DBA lost enough hair already
__________________
After 20 years working with access i have no more hair to give.


Database Dreams home page:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.



Project Manager - Developer help information:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
MickJav is offline   Reply With Quote
Old 12-13-2018, 03:15 AM   #5
Galaxiom
Super Moderator
 
Join Date: Jan 2009
Location: NSW Australia
Posts: 11,329
Thanks: 80
Thanked 1,418 Times in 1,338 Posts
Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold
Re: Just installed Sal server 2017 express and the ssms

Quote:
Originally Posted by ahmed_optom View Post
its fun, but you realise just how powerful and user friendly access is when you start messing around with sql/mysql.
Your perception of power will depend on what you know about SQL server and its Management interface. Anyone who writes SQL in MSSQLSMS would consider Access featureless or worse.

SQL Server supports a far simpler join syntax as well many more joins in queries such as OUTER APPLY, CROSS APPLY and FULL OUTER JOIN to name a few.

Table Valued Functions that return a table that can be used in a join.

SQL can run .NET complied functions. It can read and write to the file system. File tables present themselves as a File System Share. Putting files into the table is as simple as copying the file into a folder.

Full Text Search allows the content of these files to be indexed. The indexes can be queried to find any word combinations occurring near each other in the documents.

SQL server supports connections straight into LDAP databases such as Windows Active Directory. I can directly query anything about my users without resorting to masses of VBA like I had to in Access.
Galaxiom is offline   Reply With Quote
Old 12-13-2018, 03:26 AM   #6
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 5,803
Thanks: 140
Thanked 1,566 Times in 1,538 Posts
Minty has a spectacular aura about Minty has a spectacular aura about Minty has a spectacular aura about
Re: Just installed Sal server 2017 express and the ssms

+1 @ Glaxiom comments !

Full Outer joins are a delight when you try and do something like compare 2 stock tables for all the differences. (e.g what is in both but qty differs , what is missing from A and what is missing from B)

Try doing that in access without leaping through a lot of hoops.
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
Old 12-13-2018, 04:23 AM   #7
MickJav
Newly Registered User
 
Join Date: Nov 2005
Location: Margate
Posts: 617
Thanks: 31
Thanked 8 Times in 8 Posts
MickJav is on a distinguished road
Re: Just installed Sal server 2017 express and the ssms

Lol I've yet to get there at the moment I'm to busy to get into it I'm sure when I do I'll find it very usefully and maybe even better than access but at the monent I'm a newbee with no real understanding of it but I have books so will learn and then there's alway the kind people here.

__________________
After 20 years working with access i have no more hair to give.


Database Dreams home page:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.



Project Manager - Developer help information:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
MickJav is offline   Reply With Quote
Old 12-13-2018, 06:38 PM   #8
WayneRyan
AWF VIP
 
Join Date: Nov 2002
Location: Camarillo, CA
Posts: 7,085
Thanks: 6
Thanked 56 Times in 54 Posts
WayneRyan is a jewel in the rough WayneRyan is a jewel in the rough WayneRyan is a jewel in the rough
Re: Just installed Sal server 2017 express and the ssms

On iPad so not easy to type.

Must add:

1) common table expressions (CTEs)
2) window functions in queries (lead, lag, row_number(), etc)
3) real triggers bound to data
4) real constraints bound to data
5) cross database/ Cross server queries
6) XML support for queries (multirow to CSV)
7) excellent monitoring with system views

Coupled with an access front-end.

Just my $0.02 worth.
Wayne

__________________
Pool Players Know All The Angles
WayneRyan is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
New to SQL Server Express mjdemaris SQL Server 3 07-28-2016 05:38 PM
SQL Server Express Edition DBinPhilly General 2 05-28-2013 02:06 PM
SQL Express vs SQL Server Thales750 SQL Server 1 06-06-2011 12:36 PM
SQL Server Express '05 on top of SQL Server '08 running as mirror? madEG SQL Server 2 11-18-2010 02:59 PM
SQL Server Express...where to start CEH SQL Server 19 08-28-2008 09:53 PM




All times are GMT -8. The time now is 11:02 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World