Comments
Sort by recent activity
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.
Bless you SloopjohnB, for your interest in the Waffle Generator. / comments
Bless you SloopjohnB, for your interest in the Waffle Generator.
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...
Problem solved by using patch supplied by Ben.
Thanks. / comments
Problem solved by using patch supplied by Ben.
Thanks.
Hmmm...
I tried various things. Eventually, I just ran the HTML Help Workshop, and tried various activities with it just to convince myself it was fully working.
Then SQL Doc suddenly decided it knew about CHM files.....
My guess is that a registry entry got changed by some process and HTML Help Workshop then changed it back when I fired it up.
For the next release, it might be better to change the user interface to give a warning message that CHM output is not available because it can't detect the HTML Help Workshop, rather than just removing it from the listbox. It's such an irritating design. I hate it when options are disabled, greyed out or removed without any way of finding out why. You may know why, but the PBU sure doesn't. Point and click then becomes stab and curse. / comments
Hmmm...
I tried various things. Eventually, I just ran the HTML Help Workshop, and tried various activities with it just to convince myself it was fully working.
Then SQL Doc suddenly decided it kn...
Yes, I have the HTML Help Workshop installed, the CHM option was on the list and has now vanished. I didn't install a new version of SQL Doc unless the installer did it for me without telling me. It is v 1.2. It has cheerfully done CHM files in the past! The only change I know of is that I registered it (it had been on 15 days when it worked) / comments
Yes, I have the HTML Help Workshop installed, the CHM option was on the list and has now vanished. I didn't install a new version of SQL Doc unless the installer did it for me without telling me. I...
I'm confident that the problem has been fixed. I'm sorry to have been such a nag but I was really looking forward to being able to read data rapidly from encryped SQBs. I suspect we've now got the only guaranteed tamper-proof read-only data medium in the industry. 6.1 will be great. / comments
I'm confident that the problem has been fixed. I'm sorry to have been such a nag but I was really looking forward to being able to read data rapidly from encryped SQBs. I suspect we've now got the...
Robert,
I've re-run it locally on the server to eliminate the network from the equation. I've set all the tables with primary keys. The first part wasn't CPU or Resource-bound. The actual compare is taking 100% CPU- but it is a v slow CPU. Resources are not particularly hit. Unfortunately it is still taking several hours. My guess is that it is a problem with a very large 'inversion' table, so next step is to delete it and try again. / comments
Robert,
I've re-run it locally on the server to eliminate the network from the equation. I've set all the tables with primary keys. The first part wasn't CPU or Resource-bound. The actual compare i...