Folks
I wanted to subscribe best online SQL magazine or printed material also
should be fine. There are so many magazines out there. I just wanted to
subscribe one and that got to be the best one. Can anyone suggest one that
you find it very useful, has real life tips, best practices etc?
Thank a lot!
I would suggest the SQL Server Magazine.
HTH, Jens Suessmeyer.
"rupart" <rupart@.discussions.microsoft.com> schrieb im Newsbeitrag
news:8A37A59F-CC48-4862-A7B1-9171AA44DAF1@.microsoft.com...
> Folks
> I wanted to subscribe best online SQL magazine or printed material also
> should be fine. There are so many magazines out there. I just wanted to
> subscribe one and that got to be the best one. Can anyone suggest one that
> you find it very useful, has real life tips, best practices etc?
> Thank a lot!
|||Best...well that's a hard question to answer because what's best for
me would be one that meets my needs. Since my needs would differ from
yours, my best would differ from yours.
Having said that, I find SQL Server Standard and SQL Server Magazine
to be useful. Both are relatively inexpensive and tend to offer good
quality.
SQL Server Magazine provides articles written by a handful of experts
with LOTS of technical expertise and knowledge.
SQL Server Central tends to offer a much more diverse set of authors
with varying levels of expertise and experiences. It's more of a users
helping users kind of approach.
I don't think you'll go wrong with either. Probably even good idea to
get both.
HTH...
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg...l/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
On Fri, 24 Jun 2005 01:17:02 -0700, rupart
<rupart@.discussions.microsoft.com> wrote:
>Folks
>I wanted to subscribe best online SQL magazine or printed material also
>should be fine. There are so many magazines out there. I just wanted to
>subscribe one and that got to be the best one. Can anyone suggest one that
>you find it very useful, has real life tips, best practices etc?
>Thank a lot!
Showing posts with label online. Show all posts
Showing posts with label online. Show all posts
Tuesday, March 27, 2012
Best SQL Magazine
Folks
I wanted to subscribe best online SQL magazine or printed material also
should be fine. There are so many magazines out there. I just wanted to
subscribe one and that got to be the best one. Can anyone suggest one that
you find it very useful, has real life tips, best practices etc?
Thank a lot!I would suggest the SQL Server Magazine.
HTH, Jens Suessmeyer.
"rupart" <rupart@.discussions.microsoft.com> schrieb im Newsbeitrag
news:8A37A59F-CC48-4862-A7B1-9171AA44DAF1@.microsoft.com...
> Folks
> I wanted to subscribe best online SQL magazine or printed material also
> should be fine. There are so many magazines out there. I just wanted to
> subscribe one and that got to be the best one. Can anyone suggest one that
> you find it very useful, has real life tips, best practices etc?
> Thank a lot!|||Best...well that's a hard question to answer because what's best for
me would be one that meets my needs. Since my needs would differ from
yours, my best would differ from yours.
Having said that, I find SQL Server Standard and SQL Server Magazine
to be useful. Both are relatively inexpensive and tend to offer good
quality.
SQL Server Magazine provides articles written by a handful of experts
with LOTS of technical expertise and knowledge.
SQL Server Central tends to offer a much more diverse set of authors
with varying levels of expertise and experiences. It's more of a users
helping users kind of approach.
I don't think you'll go wrong with either. Probably even good idea to
get both.
HTH...
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/t...il/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
On Fri, 24 Jun 2005 01:17:02 -0700, rupart
<rupart@.discussions.microsoft.com> wrote:
>Folks
>I wanted to subscribe best online SQL magazine or printed material also
>should be fine. There are so many magazines out there. I just wanted to
>subscribe one and that got to be the best one. Can anyone suggest one that
>you find it very useful, has real life tips, best practices etc?
>Thank a lot!
I wanted to subscribe best online SQL magazine or printed material also
should be fine. There are so many magazines out there. I just wanted to
subscribe one and that got to be the best one. Can anyone suggest one that
you find it very useful, has real life tips, best practices etc?
Thank a lot!I would suggest the SQL Server Magazine.
HTH, Jens Suessmeyer.
"rupart" <rupart@.discussions.microsoft.com> schrieb im Newsbeitrag
news:8A37A59F-CC48-4862-A7B1-9171AA44DAF1@.microsoft.com...
> Folks
> I wanted to subscribe best online SQL magazine or printed material also
> should be fine. There are so many magazines out there. I just wanted to
> subscribe one and that got to be the best one. Can anyone suggest one that
> you find it very useful, has real life tips, best practices etc?
> Thank a lot!|||Best...well that's a hard question to answer because what's best for
me would be one that meets my needs. Since my needs would differ from
yours, my best would differ from yours.
Having said that, I find SQL Server Standard and SQL Server Magazine
to be useful. Both are relatively inexpensive and tend to offer good
quality.
SQL Server Magazine provides articles written by a handful of experts
with LOTS of technical expertise and knowledge.
SQL Server Central tends to offer a much more diverse set of authors
with varying levels of expertise and experiences. It's more of a users
helping users kind of approach.
I don't think you'll go wrong with either. Probably even good idea to
get both.
HTH...
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/t...il/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
On Fri, 24 Jun 2005 01:17:02 -0700, rupart
<rupart@.discussions.microsoft.com> wrote:
>Folks
>I wanted to subscribe best online SQL magazine or printed material also
>should be fine. There are so many magazines out there. I just wanted to
>subscribe one and that got to be the best one. Can anyone suggest one that
>you find it very useful, has real life tips, best practices etc?
>Thank a lot!
Best SQL Magazine
Folks
I wanted to subscribe best online SQL magazine or printed material also
should be fine. There are so many magazines out there. I just wanted to
subscribe one and that got to be the best one. Can anyone suggest one that
you find it very useful, has real life tips, best practices etc?
Thank a lot!I would suggest the SQL Server Magazine.
HTH, Jens Suessmeyer.
"rupart" <rupart@.discussions.microsoft.com> schrieb im Newsbeitrag
news:8A37A59F-CC48-4862-A7B1-9171AA44DAF1@.microsoft.com...
> Folks
> I wanted to subscribe best online SQL magazine or printed material also
> should be fine. There are so many magazines out there. I just wanted to
> subscribe one and that got to be the best one. Can anyone suggest one that
> you find it very useful, has real life tips, best practices etc?
> Thank a lot!|||Best...well that's a hard question to answer because what's best for
me would be one that meets my needs. Since my needs would differ from
yours, my best would differ from yours.
Having said that, I find SQL Server Standard and SQL Server Magazine
to be useful. Both are relatively inexpensive and tend to offer good
quality.
SQL Server Magazine provides articles written by a handful of experts
with LOTS of technical expertise and knowledge.
SQL Server Central tends to offer a much more diverse set of authors
with varying levels of expertise and experiences. It's more of a users
helping users kind of approach.
I don't think you'll go wrong with either. Probably even good idea to
get both.
HTH...
--
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
On Fri, 24 Jun 2005 01:17:02 -0700, rupart
<rupart@.discussions.microsoft.com> wrote:
>Folks
>I wanted to subscribe best online SQL magazine or printed material also
>should be fine. There are so many magazines out there. I just wanted to
>subscribe one and that got to be the best one. Can anyone suggest one that
>you find it very useful, has real life tips, best practices etc?
>Thank a lot!sql
I wanted to subscribe best online SQL magazine or printed material also
should be fine. There are so many magazines out there. I just wanted to
subscribe one and that got to be the best one. Can anyone suggest one that
you find it very useful, has real life tips, best practices etc?
Thank a lot!I would suggest the SQL Server Magazine.
HTH, Jens Suessmeyer.
"rupart" <rupart@.discussions.microsoft.com> schrieb im Newsbeitrag
news:8A37A59F-CC48-4862-A7B1-9171AA44DAF1@.microsoft.com...
> Folks
> I wanted to subscribe best online SQL magazine or printed material also
> should be fine. There are so many magazines out there. I just wanted to
> subscribe one and that got to be the best one. Can anyone suggest one that
> you find it very useful, has real life tips, best practices etc?
> Thank a lot!|||Best...well that's a hard question to answer because what's best for
me would be one that meets my needs. Since my needs would differ from
yours, my best would differ from yours.
Having said that, I find SQL Server Standard and SQL Server Magazine
to be useful. Both are relatively inexpensive and tend to offer good
quality.
SQL Server Magazine provides articles written by a handful of experts
with LOTS of technical expertise and knowledge.
SQL Server Central tends to offer a much more diverse set of authors
with varying levels of expertise and experiences. It's more of a users
helping users kind of approach.
I don't think you'll go wrong with either. Probably even good idea to
get both.
HTH...
--
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
On Fri, 24 Jun 2005 01:17:02 -0700, rupart
<rupart@.discussions.microsoft.com> wrote:
>Folks
>I wanted to subscribe best online SQL magazine or printed material also
>should be fine. There are so many magazines out there. I just wanted to
>subscribe one and that got to be the best one. Can anyone suggest one that
>you find it very useful, has real life tips, best practices etc?
>Thank a lot!sql
Sunday, March 25, 2012
Best Replication Method to Use
We want to allow our customer base to be able to access their account
information online. I want to setup a second SQL server so the customers can
use this for looks up. The front end to access this info is web based.
What replication method is the best one to use to update the database say
every 24 hours at night? Thanks!!
if your database is not too large, a snapshot replication maybe best for
you.
else somekind of logshipping will be good too, see the other thread on
simple log shipping.
justin
Scopus69 wrote:
> We want to allow our customer base to be able to access their account
> information online. I want to setup a second SQL server so the customers can
> use this for looks up. The front end to access this info is web based.
> What replication method is the best one to use to update the database say
> every 24 hours at night? Thanks!!
|||I think transactional replication would work for this. However this will
require each table you are replicating to have a primary key.
I am a little confused by the data flow. Are you saying data moves from the
web server SQL Server database to another SQL Server? Or is it moving
internally to the SQL Server supporting the web site.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Scopus69" <Scopus69@.nospam.postalias> wrote in message
news:3D5CC7EA-4702-417E-AE2D-9985B1E4B781@.microsoft.com...
> We want to allow our customer base to be able to access their account
> information online. I want to setup a second SQL server so the customers
> can
> use this for looks up. The front end to access this info is web based.
> What replication method is the best one to use to update the database say
> every 24 hours at night? Thanks!!
|||Sorry for the confusion. The GUI interface to the data is a web interface
that connects to the backend SQL server. What I would like to do is setup
another web & SQL server for our cutomers so they can use it for lookups. I
really don't want them in our prduction DB.
I was wondering what is the best way to get the data off the production SQL
server to the customer SQL server on a nightly basis? I don't think log
shipping will work because it will put the shipped DB in "read only"
So what method would be the best to use? Thanks!
"Hilary Cotter" wrote:
> I think transactional replication would work for this. However this will
> require each table you are replicating to have a primary key.
> I am a little confused by the data flow. Are you saying data moves from the
> web server SQL Server database to another SQL Server? Or is it moving
> internally to the SQL Server supporting the web site.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Scopus69" <Scopus69@.nospam.postalias> wrote in message
> news:3D5CC7EA-4702-417E-AE2D-9985B1E4B781@.microsoft.com...
>
>
|||I think transactional is your best bet.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Scopus69" <Scopus69@.nospam.postalias> wrote in message
news:76F950CE-B1EA-493F-8092-5ED6AA73EC75@.microsoft.com...[vbcol=seagreen]
> Sorry for the confusion. The GUI interface to the data is a web interface
> that connects to the backend SQL server. What I would like to do is
> setup
> another web & SQL server for our cutomers so they can use it for lookups.
> I
> really don't want them in our prduction DB.
> I was wondering what is the best way to get the data off the production
> SQL
> server to the customer SQL server on a nightly basis? I don't think log
> shipping will work because it will put the shipped DB in "read only"
> So what method would be the best to use? Thanks!
> "Hilary Cotter" wrote:
|||I also like Transactional Replication if the data is dynamic at the source
and the users who will be talking to your target server need updated
information as well for their lookups. If current data is not an issue, that
is they don't mind the data being static, then may be snapshot will work.
But then again it depends on how large the data is. For me one way
Transactional seems to fit the bill here.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:enpFYKCDGHA.1028@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> I think transactional is your best bet.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Scopus69" <Scopus69@.nospam.postalias> wrote in message
> news:76F950CE-B1EA-493F-8092-5ED6AA73EC75@.microsoft.com...
interface[vbcol=seagreen]
lookups.[vbcol=seagreen]
will[vbcol=seagreen]
based.
>
sql
information online. I want to setup a second SQL server so the customers can
use this for looks up. The front end to access this info is web based.
What replication method is the best one to use to update the database say
every 24 hours at night? Thanks!!
if your database is not too large, a snapshot replication maybe best for
you.
else somekind of logshipping will be good too, see the other thread on
simple log shipping.
justin
Scopus69 wrote:
> We want to allow our customer base to be able to access their account
> information online. I want to setup a second SQL server so the customers can
> use this for looks up. The front end to access this info is web based.
> What replication method is the best one to use to update the database say
> every 24 hours at night? Thanks!!
|||I think transactional replication would work for this. However this will
require each table you are replicating to have a primary key.
I am a little confused by the data flow. Are you saying data moves from the
web server SQL Server database to another SQL Server? Or is it moving
internally to the SQL Server supporting the web site.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Scopus69" <Scopus69@.nospam.postalias> wrote in message
news:3D5CC7EA-4702-417E-AE2D-9985B1E4B781@.microsoft.com...
> We want to allow our customer base to be able to access their account
> information online. I want to setup a second SQL server so the customers
> can
> use this for looks up. The front end to access this info is web based.
> What replication method is the best one to use to update the database say
> every 24 hours at night? Thanks!!
|||Sorry for the confusion. The GUI interface to the data is a web interface
that connects to the backend SQL server. What I would like to do is setup
another web & SQL server for our cutomers so they can use it for lookups. I
really don't want them in our prduction DB.
I was wondering what is the best way to get the data off the production SQL
server to the customer SQL server on a nightly basis? I don't think log
shipping will work because it will put the shipped DB in "read only"
So what method would be the best to use? Thanks!
"Hilary Cotter" wrote:
> I think transactional replication would work for this. However this will
> require each table you are replicating to have a primary key.
> I am a little confused by the data flow. Are you saying data moves from the
> web server SQL Server database to another SQL Server? Or is it moving
> internally to the SQL Server supporting the web site.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Scopus69" <Scopus69@.nospam.postalias> wrote in message
> news:3D5CC7EA-4702-417E-AE2D-9985B1E4B781@.microsoft.com...
>
>
|||I think transactional is your best bet.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Scopus69" <Scopus69@.nospam.postalias> wrote in message
news:76F950CE-B1EA-493F-8092-5ED6AA73EC75@.microsoft.com...[vbcol=seagreen]
> Sorry for the confusion. The GUI interface to the data is a web interface
> that connects to the backend SQL server. What I would like to do is
> setup
> another web & SQL server for our cutomers so they can use it for lookups.
> I
> really don't want them in our prduction DB.
> I was wondering what is the best way to get the data off the production
> SQL
> server to the customer SQL server on a nightly basis? I don't think log
> shipping will work because it will put the shipped DB in "read only"
> So what method would be the best to use? Thanks!
> "Hilary Cotter" wrote:
|||I also like Transactional Replication if the data is dynamic at the source
and the users who will be talking to your target server need updated
information as well for their lookups. If current data is not an issue, that
is they don't mind the data being static, then may be snapshot will work.
But then again it depends on how large the data is. For me one way
Transactional seems to fit the bill here.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:enpFYKCDGHA.1028@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> I think transactional is your best bet.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Scopus69" <Scopus69@.nospam.postalias> wrote in message
> news:76F950CE-B1EA-493F-8092-5ED6AA73EC75@.microsoft.com...
interface[vbcol=seagreen]
lookups.[vbcol=seagreen]
will[vbcol=seagreen]
based.
>
sql
Tuesday, March 20, 2012
Best Practices Analyzer contradicts BOL for SQLSERVERAGENT
The 2005 Best Practices Analyzer (July 2007) contradicts Books Online about what account to run SQLSERVERAGENT under.
BPA says use Network Service Account, BOL explicitly says not to use Network Service Account:
BPA gives a warning saying "SQL Server Service [MY-PC\SQLSERVERAGENT] In Unrecommended Account On Host [MY-PC]. We recommend that the service [SQLSERVERAGENT] on host [MY-PC] be run under Network Service Account. Currently it is designated to run under the account [SOMEDOMAIN\someaccount]."
BooksOnline says "Security Note: Because multiple services can use the Network Service account, it is difficult to control which services have access to network resources, including SQL Server databases. We do not recommend using the Network Service account for the SQL Server Agent service."
So who's right ? BPA or BOL ?
Books online is correct - a non-system account provides more control over access, security.
Just curious...which version of BPA are you running?
-Sue
sqlWednesday, March 7, 2012
Best license program
I have a small company and i make online ERP software in ASP.NET for small
companies. Companies with one server en a maximum of 10 concurrent users.
What SQL server license should i advice for these companies? And how much
does it costs?
I've tried to understand the documents on the microsoft site but i did not
find an satisfying answer.
Thanks in advance.
RonaldIf your database won't be bigger than 2 GB, you can use MSDE which is free.
Otherwise the best is to use Standard Edition with per seat licensing if
your client don't have more than 25 users (not concurrent users, you need a
license for everyone who uses the server), or Standard Edition with a
processor license if there are more than 25 users.
--
Jacco Schalkwijk
SQL Server MVP
"Sandeman" <ilighters@.zeelandnet.nl> wrote in message
news:OAiA2bYlEHA.3452@.TK2MSFTNGP15.phx.gbl...
>I have a small company and i make online ERP software in ASP.NET for small
> companies. Companies with one server en a maximum of 10 concurrent users.
> What SQL server license should i advice for these companies? And how much
> does it costs?
> I've tried to understand the documents on the microsoft site but i did not
> find an satisfying answer.
> Thanks in advance.
> Ronald
>
companies. Companies with one server en a maximum of 10 concurrent users.
What SQL server license should i advice for these companies? And how much
does it costs?
I've tried to understand the documents on the microsoft site but i did not
find an satisfying answer.
Thanks in advance.
RonaldIf your database won't be bigger than 2 GB, you can use MSDE which is free.
Otherwise the best is to use Standard Edition with per seat licensing if
your client don't have more than 25 users (not concurrent users, you need a
license for everyone who uses the server), or Standard Edition with a
processor license if there are more than 25 users.
--
Jacco Schalkwijk
SQL Server MVP
"Sandeman" <ilighters@.zeelandnet.nl> wrote in message
news:OAiA2bYlEHA.3452@.TK2MSFTNGP15.phx.gbl...
>I have a small company and i make online ERP software in ASP.NET for small
> companies. Companies with one server en a maximum of 10 concurrent users.
> What SQL server license should i advice for these companies? And how much
> does it costs?
> I've tried to understand the documents on the microsoft site but i did not
> find an satisfying answer.
> Thanks in advance.
> Ronald
>
Saturday, February 25, 2012
Best license program
I have a small company and i make online ERP software in ASP.NET for small
companies. Companies with one server en a maximum of 10 concurrent users.
What SQL server license should i advice for these companies? And how much
does it costs?
I've tried to understand the documents on the microsoft site but i did not
find an satisfying answer.
Thanks in advance.
Ronald
If your database won't be bigger than 2 GB, you can use MSDE which is free.
Otherwise the best is to use Standard Edition with per seat licensing if
your client don't have more than 25 users (not concurrent users, you need a
license for everyone who uses the server), or Standard Edition with a
processor license if there are more than 25 users.
Jacco Schalkwijk
SQL Server MVP
"Sandeman" <ilighters@.zeelandnet.nl> wrote in message
news:OAiA2bYlEHA.3452@.TK2MSFTNGP15.phx.gbl...
>I have a small company and i make online ERP software in ASP.NET for small
> companies. Companies with one server en a maximum of 10 concurrent users.
> What SQL server license should i advice for these companies? And how much
> does it costs?
> I've tried to understand the documents on the microsoft site but i did not
> find an satisfying answer.
> Thanks in advance.
> Ronald
>
companies. Companies with one server en a maximum of 10 concurrent users.
What SQL server license should i advice for these companies? And how much
does it costs?
I've tried to understand the documents on the microsoft site but i did not
find an satisfying answer.
Thanks in advance.
Ronald
If your database won't be bigger than 2 GB, you can use MSDE which is free.
Otherwise the best is to use Standard Edition with per seat licensing if
your client don't have more than 25 users (not concurrent users, you need a
license for everyone who uses the server), or Standard Edition with a
processor license if there are more than 25 users.
Jacco Schalkwijk
SQL Server MVP
"Sandeman" <ilighters@.zeelandnet.nl> wrote in message
news:OAiA2bYlEHA.3452@.TK2MSFTNGP15.phx.gbl...
>I have a small company and i make online ERP software in ASP.NET for small
> companies. Companies with one server en a maximum of 10 concurrent users.
> What SQL server license should i advice for these companies? And how much
> does it costs?
> I've tried to understand the documents on the microsoft site but i did not
> find an satisfying answer.
> Thanks in advance.
> Ronald
>
Thursday, February 16, 2012
beginning SQL
I purchased SQL Server 2005 and intend to take a class this month. I have installed it. How do I get started trying it out? I took an online tutorial, but I don't understand the mechanics of accessing the db to start with or if I even have a db to work with. Any suggestions?
Book on line > SQL Server 2005 Tutorials >SQL Server Tools Tutorial
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqltut9/html/655e709b-346b-469c-bddc-a5a0238d07e0.htm
HTH
Subscribe to:
Comments (Atom)