Activity overview
Latest activity by AndrewRMClarke
Schema Builds produced when the schema is not used
Normally, one only needs a schema build script for a user when the schema is actually used. One can take the legitimate view that every database user should be mapped to an explicit schema. SQL Com...
Speaking for myself, I'd like to know the modification date (modify_date) for the object if available from the metadata (object catalog views), in the report generated from SQL Compare. / comments
Speaking for myself, I'd like to know the modification date (modify_date) for the object if available from the metadata (object catalog views), in the report generated from SQL Compare.
Installation requirements for SQL Data Generator
In trying to do a custom Python script generator, I've got the error 'An error occurred. ImportError: No module named random - No installed python version was automatically detected; consider inst...
Bless you SloopjohnB, for your interest in the Waffle Generator. / comments
Bless you SloopjohnB, for your interest in the Waffle Generator.
Putting values in a SQL Matrix.- it has a compound key
I create a table....
create table matrix (x int not null,y int not null,element numeric(18,2) not null PRIMARY KEY (x,y))
I want to populate it with values for a matrix of 15(x) by 15(y). This wou...
Call me a wimp if you like, but what about Embedded Help
What's wrong with some Embedded Help exactly like the stuff that the wonderful Heather has written about in http://www.simple-talk.com/dotnet/.net- ... l-be-used/
Don't try to tell me that reflecto...
I like using a browser with Reflector, and it would be so nice to register net components as browsable with IE Opera or firefox. I know it is easy with a /slash command, (i think that only does IE) but it gets tiresome after a while. There are a whole lot of other 'convenience' things that a proper installer would cure, like 'open-with with the right-click. James would never lose his copy of Reflector again. / comments
I like using a browser with Reflector, and it would be so nice to register net components as browsable with IE Opera or firefox. I know it is easy with a /slash command, (i think that only does IE)...
None of the production servers I administer are within my domain. I can't remember when I've been that lucky. Where a server is running a popular website, for example, we put it as close to the internet backbone as we can, in order to minimise connectivity costs, and that usually involves a managed service that is remote from the Windows Domain. Sometimes these servers are in predominately Linux environments. I once had to keep a check on intelligent telephony switches that had SQL Server 'embedded' in them. These certainly weren't connected to a windows network!
I've worked in several places where the SysAdmins have identified the practice of making SQL Servers part of the domain as being a security risk, and there have been several instances where this has led to problems.
If I've just been exceptionally unlucky in having to work outside the domain model, then I'll shut up. After all, I'm not short of ways of monitoring the health of my servers. / comments
None of the production servers I administer are within my domain. I can't remember when I've been that lucky. Where a server is running a popular website, for example, we put it as close to the in...
Dan
Unfortunately, we're talking TDS over the internet to a designated port. On SQL Server 2005, we can create an endpoint that gives us an encrypted link since SQL Server authentication requires the password to go flying through the ether in plain view. (gulp). In a well-ordered universe there will be VPN access to the remote network, but I've yet to meet a SysAdmin who is capable of setting this up.
There are ways of surviving, of course, and I can use all other Red-Gate tools remotely via TDS and SQL Server Authentication, as well as SMO. I can generallly get SNMP info and I can get Whatsup to poll information from an administration page in the public-facing website of the application in order to get alerts for serious problems. (Like, Death is a serious problem) I can get alerted into a catatonic state via Email-based SQL Server alerts, plus scheduled status reports.
I may need to kill a Sysadmin or two before I can get an internet-facing socket through a firewall for the Incident Repository, unless I can provide elaborate justification to prove that an exploit is impossible.
All these problems would be solved if one could set up a remote process that communicated to the repository via a webservice, or the like. I realise that this might upset the occasional DBA but normally these remote databases are serving public-facing sites, or have webservices set up anyway. They tend to be remote from your domain because they are as near as possible to the Internet backbone for bandwidth purposes. Besides which, Reporting Services has changed the DBA mindset towards WebServices. They're cool now.
Andrew / comments
Dan
Unfortunately, we're talking TDS over the internet to a designated port. On SQL Server 2005, we can create an endpoint that gives us an encrypted link since SQL Server authentication requires t...
Domain Model
I've given this a quick whirl.
My main worry is that the design of the product seems to assume that all the servers are in one domain, all are accessible within the domain, and that you can have a ...