Sql Advice: company

Showing posts with label company. Show all posts

Monday, March 19, 2012

Deploying SQL Express 2005

Hello,
I work for a company that manages computers and their software using Active Directory. One of our packages requires SQL Express 2005, and so far I've been unable to find a good resource online. All I need to do is find a .msi file or a batch script that will install it. Thanks!

Start here http://msdn.microsoft.com/vstudio/express/

Sunday, March 11, 2012

Deploying Scripts to Multiple SQL Server Instances

Hello everyone,
I work for a software development company that has over 20 MSSQL2000
developer and support instances/environments in which I frequently
apply incremental updates to. The updates are SQL scripts given to me
by developers that, for example, add columns, drop and create updated
or new stored procedures or views. Sometimes a specific version of our
software may have 15-20 incremental updates to deploy. These updates
need to be applied somewhat immediatly to most of the data instances.
I've been running these manually for quite sometime via SQL Query
Analizer. In case you are wondering, as for applying permissions to
these objects, I've already got a script that sets permissions for
specified users for specified databases that i can run for each
instance in the click of a mouse.
What I am longing for is some sort of utility that may exist out there
for doing exactly what I am doing with these incremental updates, yet
more automated. We name our scripts specifically so that they can be
thrown into a single folder and they are already sorted by date and
type, so that a stored procedure update won't reference a table update
that has not been applied yet, etc.
Anyone have any directions they could point me in? I've tried
searching the newsgroups and net with no luck so far.This is a multi-part message in MIME format.
--=_NextPart_000_02AB_01C3AD1B.1AEF2BB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Check out "master server" in the BOL.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Matt Norwood" <littletinymonkey@.hotmail.com> wrote in message
news:cc80cca0.0311171148.7e43bcff@.posting.google.com...
Hello everyone,
I work for a software development company that has over 20 MSSQL2000
developer and support instances/environments in which I frequently
apply incremental updates to. The updates are SQL scripts given to me
by developers that, for example, add columns, drop and create updated
or new stored procedures or views. Sometimes a specific version of our
software may have 15-20 incremental updates to deploy. These updates
need to be applied somewhat immediatly to most of the data instances.
I've been running these manually for quite sometime via SQL Query
Analizer. In case you are wondering, as for applying permissions to
these objects, I've already got a script that sets permissions for
specified users for specified databases that i can run for each
instance in the click of a mouse.
What I am longing for is some sort of utility that may exist out there
for doing exactly what I am doing with these incremental updates, yet
more automated. We name our scripts specifically so that they can be
thrown into a single folder and they are already sorted by date and
type, so that a stored procedure update won't reference a table update
that has not been applied yet, etc.
Anyone have any directions they could point me in? I've tried
searching the newsgroups and net with no luck so far.
--=_NextPart_000_02AB_01C3AD1B.1AEF2BB0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

Check out "master server" in the =BOL.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Matt Norwood" wrote in message news:cc80cc=a0.0311171148.7e43bcff@.posting.google.com...Hello everyone,I work for a software development company that has over =20 MSSQL2000developer and support instances/environments in which I frequentlyapply incremental updates to. The updates are SQL scripts =given to meby developers that, for example, add columns, drop and create updatedor new stored procedures or views. Sometimes a specific =version of oursoftware may have 15-20 incremental updates to deploy. These updatesneed to be applied somewhat immediatly to most of the data instances.I've been running these manually for quite sometime via =SQL QueryAnalizer. In case you are wondering, as for applying =permissions tothese objects, I've already got a script that sets permissions forspecified users for specified databases that i can run for eachinstance in the click of a mouse.What I am longing for =is some sort of utility that may exist out therefor doing exactly what I am =doing with these incremental updates, yetmore automated. We name our =scripts specifically so that they can bethrown into a single folder and they =are already sorted by date andtype, so that a stored procedure update =won't reference a table updatethat has not been applied yet, =etc.Anyone have any directions they could point me in? I've triedsearching the newsgroups and net with no luck so far.

--=_NextPart_000_02AB_01C3AD1B.1AEF2BB0--|||have a read on www.dbghost.com it may be the help you need.
>--Original Message--
>Check out "master server" in the BOL.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Matt Norwood" <littletinymonkey@.hotmail.com> wrote in
message
>news:cc80cca0.0311171148.7e43bcff@.posting.google.com...
>Hello everyone,
>I work for a software development company that has over
20 MSSQL2000
>developer and support instances/environments in which I
frequently
>apply incremental updates to. The updates are SQL scripts
given to me
>by developers that, for example, add columns, drop and
create updated
>or new stored procedures or views. Sometimes a specific
version of our
>software may have 15-20 incremental updates to deploy.
These updates
>need to be applied somewhat immediatly to most of the
data instances.
>I've been running these manually for quite sometime via
SQL Query
>Analizer. In case you are wondering, as for applying
permissions to
>these objects, I've already got a script that sets
permissions for
>specified users for specified databases that i can run
for each
>instance in the click of a mouse.
>What I am longing for is some sort of utility that may
exist out there
>for doing exactly what I am doing with these incremental
updates, yet
>more automated. We name our scripts specifically so that
they can be
>thrown into a single folder and they are already sorted
by date and
>type, so that a stored procedure update won't reference a
table update
>that has not been applied yet, etc.
>Anyone have any directions they could point me in? I've
tried
>searching the newsgroups and net with no luck so far.
>|||thanks!

Tuesday, February 14, 2012

Deny Administrator Access to DB

Hey all,
I am developing an application to track very sensitive company personnel
information. This of course raised the issue of protecting this sensitive
information from everyone not authorized to see it.....including the DB
Administrator. The DB Server (SQL 7) has many databases on it, but the
System Administrator must not be able to access the data in those tables
containing the sensitive information. I have tried denying an SA user
rights to SELECT from a table, but I could still select and view all the
data.
Any ideas?
Jeremy Byron
jbyron@.cynaptec.nb.ns.ca <remove ns to email me>You cannot stop SA from looking at the tables...
HOWEVER - you CAN log the users that view the data.
For the tables that contain sensitive information, you can put a trigger on
the select, update, and delete to generate a log entry.
Of course, you would ask - "But the DBA can delete those rows". Sure they
can - but you can also log it so that you also have it generate a MSMQ
transaction where you can have a service that processes those records into
an external file store.
I would also reccommend seeing the July 2004 edition of SQL Server
Magazine - p.15 on "Privacy Matters" for some other suggestions as well.
=-Chris
"Moi" <moi@.here.com> wrote in message
news:7FF1D2C9B9DB6525.1907DEF59F04D933.8248BD072E33C3AD@.lp.airnews.net...
> Hey all,
> I am developing an application to track very sensitive company personnel
> information. This of course raised the issue of protecting this sensitive
> information from everyone not authorized to see it.....including the DB
> Administrator. The DB Server (SQL 7) has many databases on it, but the
> System Administrator must not be able to access the data in those tables
> containing the sensitive information. I have tried denying an SA user
> rights to SELECT from a table, but I could still select and view all the
> data.
> Any ideas?
> Jeremy Byron
> jbyron@.cynaptec.nb.ns.ca <remove ns to email me>
>|||> you can put a trigger on the select,
Are you sure about that? Books Online doesn't seem to agree:
CREATE TRIGGER trigger_name
ON { table | view }
[ WITH ENCRYPTION ]
{
{ { FOR | AFTER | INSTEAD OF } { [ INSERT ] [ , ]
1; UPDATE ] [ , ] [
DELETE ] }
http://www.aspfaq.com/
(Reverse address to reply.)

Deny Administrator Access to DB

Hey all,
I am developing an application to track very sensitive company personnel
information. This of course raised the issue of protecting this sensitive
information from everyone not authorized to see it.....including the DB
Administrator. The DB Server (SQL 7) has many databases on it, but the
System Administrator must not be able to access the data in those tables
containing the sensitive information. I have tried denying an SA user
rights to SELECT from a table, but I could still select and view all the
data.
Any ideas?
Jeremy Byron
jbyron@.cynaptec.nb.ns.ca <remove ns to email me>
In article <7FF1D2C9B9DB6525.1907DEF59F04D933.8248BD072E33C3A D@.lp.airnews.net>,
Moi <moi@.here.com> wrote:
>Hey all,
>I am developing an application to track very sensitive company personnel
>information. This of course raised the issue of protecting this sensitive
>information from everyone not authorized to see it.....including the DB
>Administrator. The DB Server (SQL 7) has many databases on it, but the
>System Administrator must not be able to access the data in those tables
>containing the sensitive information. I have tried denying an SA user
>rights to SELECT from a table, but I could still select and view all the
>data.
>
AFAIK, this is not possible. Much like the root user in UNIX, sa must and
does, have access to everything.
|||Actually there may be a way:
1. setup a username and role for yourself with the appropriate rights.
2. have someone who should have access to the information change the sa
password at the console.
The downside is that if you ever need to do something with SA privledges,
you will need to have the person who created the password give it to you so
you can get in and do whatever you have to do.
This is more secure, but no foolproof. A sly DBA will be able to setup
their role in such a way that they won't need the SA password.
Tom
Moi <moi@.here.com> wrote in message
news:7FF1D2C9B9DB6525.1907DEF59F04D933.8248BD072E3 3C3AD@.lp.airnews.net...
> Hey all,
> I am developing an application to track very sensitive company personnel
> information. This of course raised the issue of protecting this sensitive
> information from everyone not authorized to see it.....including the DB
> Administrator. The DB Server (SQL 7) has many databases on it, but the
> System Administrator must not be able to access the data in those tables
> containing the sensitive information. I have tried denying an SA user
> rights to SELECT from a table, but I could still select and view all the
> data.
> Any ideas?
> Jeremy Byron
> jbyron@.cynaptec.nb.ns.ca <remove ns to email me>
>

Deny Administrator Access to DB

Hey all,
I am developing an application to track very sensitive company personnel
information. This of course raised the issue of protecting this sensitive
information from everyone not authorized to see it.....including the DB
Administrator. The DB Server (SQL 7) has many databases on it, but the
System Administrator must not be able to access the data in those tables
containing the sensitive information. I have tried denying an SA user
rights to SELECT from a table, but I could still select and view all the
data.
Any ideas?
Jeremy Byron
jbyron@.cynaptec.nb.ns.ca <remove ns to email me>
You cannot stop SA from looking at the tables...
HOWEVER - you CAN log the users that view the data.
For the tables that contain sensitive information, you can put a trigger on
the select, update, and delete to generate a log entry.
Of course, you would ask - "But the DBA can delete those rows". Sure they
can - but you can also log it so that you also have it generate a MSMQ
transaction where you can have a service that processes those records into
an external file store.
I would also reccommend seeing the July 2004 edition of SQL Server
Magazine - p.15 on "Privacy Matters" for some other suggestions as well.
=-Chris
"Moi" <moi@.here.com> wrote in message
news:7FF1D2C9B9DB6525.1907DEF59F04D933.8248BD072E3 3C3AD@.lp.airnews.net...
> Hey all,
> I am developing an application to track very sensitive company personnel
> information. This of course raised the issue of protecting this sensitive
> information from everyone not authorized to see it.....including the DB
> Administrator. The DB Server (SQL 7) has many databases on it, but the
> System Administrator must not be able to access the data in those tables
> containing the sensitive information. I have tried denying an SA user
> rights to SELECT from a table, but I could still select and view all the
> data.
> Any ideas?
> Jeremy Byron
> jbyron@.cynaptec.nb.ns.ca <remove ns to email me>
>
|||> you can put a trigger on the select,
Are you sure about that? Books Online doesn't seem to agree:
CREATE TRIGGER trigger_name
ON { table | view }
[ WITH ENCRYPTION ]
{
{ { FOR | AFTER | INSTEAD OF } { [ INSERT ] [ , ] [ UPDATE ] [ , ] [
DELETE ] }
http://www.aspfaq.com/
(Reverse address to reply.)

Monday, March 19, 2012

Deploying SQL Express 2005

Sunday, March 11, 2012

Deploying Scripts to Multiple SQL Server Instances

Tuesday, February 14, 2012

Deny Administrator Access to DB

Deny Administrator Access to DB

Deny Administrator Access to DB

Sql Advice

Blog Archive

About Me