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.
I got the same problem with SQL Compare v 8. It writes the file out when it does the comparison, and then tries to write it out again a second time, but aborts when it finds to its surprise that the file is already there. If you nick out the /synchronize switch it seems to work. / comments
I got the same problem with SQL Compare v 8. It writes the file out when it does the comparison, and then tries to write it out again a second time, but aborts when it finds to its surprise that t...
Can you please tell me the right syntax for using IronPython and the .NET Random() function / comments
Can you please tell me the right syntax for using IronPython and the .NET Random() function
A lot of us investigate databases using build scripts in text editors, and do complex searches using Regexes. However, I only do this rarely, and would be happy to forgo regex in SQL Search for the time being. I can always go back to the technique of using a text editor when I need to do something fancy. / comments
A lot of us investigate databases using build scripts in text editors, and do complex searches using Regexes. However, I only do this rarely, and would be happy to forgo regex in SQL Search for the...
I want to be able to drag an object from the Object Explorer into the search textbox, just like I do into the Query window. Right-click functionality would be ok if it was 'as well' rather than instead. / comments
I want to be able to drag an object from the Object Explorer into the search textbox, just like I do into the Query window. Right-click functionality would be ok if it was 'as well' rather than ins...
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.