So, the requirement is to call a Web service through SSIS and calling the SSIS from a Sql service broker activated Store proc. Here is what I have currently doing
Queue
CREATE QUEUE [schema].[ProccessingQueue] WITH STATUS = ON , RETENTION = OFF , ACTIVATION ( STATUS = ON , PROCEDURE_NAME = [...
I am attempting to configure replication streaming for the first time and I think I almost there, but I'm getting one message during pg_ctl -D start of the standby server. I am not a DBA or PostgreSQL DBA by trade, so this might not be a replication configuration question. Perhaps more of a gene...
@swasheck Yes, being able to make good plots is important. But I think part of the problem is we don't always know what metrics will be useful in advance, or what distribution they will follow
So I'm trying to gather everything I can, and store enough info to calculate useful statistics when I figure out what they are
@TomV I read the rules from your link. Seems to have some similarities with bridge. And many differences, so I'd expect the strategies to be quite different.
@Heinzi -- I did try it, it worked, that's why I posted it. Maybe it doesn't work on T-SQL, but it's fine on Postgres and MySQL. — Malvolio8 hours ago
To play devil's advocate, the question is tagged with sql and that tag has a description:
>
Structured Query Language (SQL). For questions about the language, not Microsoft SQL Server (tag sql-server).
@ypercubeᵀᴹ I would perhaps rewrite the second sentence as something like this: "Applies to any database product that has implemented SQL, not just Microsoft SQL Server."
@AndriyM Fair enough. The point about the "not Microsoft SQL Server" is an attempt to point people to the [sql-server] tag instead of tagging [sql] when they mean the product.
Shucks, this is a pretty popular feature-request... Let's give it a try & see if it's more helpful than annoying:
This'll pop up every time someone tries to ask a question with sql. It's not context-sensitive - if they've already included everything in that list, they'll still get the popup. B...
Anyway, that was a good example of how confusing the sql tag is, I admit, although I also think the current description may be adding to the confusion somewhat.
As long as there are trains leaving the airport there is a station there, but If you need to get out of the center of Brussels your options are basically walking or taking a cab to the train station
If the train station gets closed too, you're pretty much out of luck as there won't be enough taxis to take everybody home.
Have somebody pick you up, but the traffic jams would be yuuuuge
A second metro station appears to have gone too, jeebus
There is a question How can an operation that cannot be made idempotent be made atomic? and they seem to answer it "An operation can be made atomic by recording the system state before the operation so that if it does not complete the system can be returned to its original state."
I wonder, why is it not idempotent?
IMO, if you can record last state and then overwrite your data then why cannot you do the same again?
@JamesLupolt that's true but you can probably guess the usual suspects and do a disco plot to get a sense of their shape. Otherwise EMA seems like an easier choice, but won't factor in seasonality. I guess you could just run seasonality calcs without knowing if it's seasonal in nature
@ValentinTihomirov Idempotence refers to the ability for an operation to be completed multiple times without state changing after the first time the operation is completed. Think about running UPDATE tbl SET col = 1; multiple times. This is clearly not the same as atomic. The statement itself is atomic if it can be either completed successfully, or fully rolled back. In this case, if you ran that against an ACID-compliant system, the operation could be called an atomic, idempotent operation.
an example of a non-idempotent, atomic operation would be UPDATE tbl SET col = col + 1; - clearly this can be made atomic, but it is never going to be considered idempotent.
an example of a non-idempotent, atomic operation would be UPDATE tbl SET col = col + 1; - clearly this can be made atomic, but it is never going to be considered idempotent.
@swasheck My guess is that they were prepared for something in the near future, but they were in a hurry now because the captured guy seems willing to talk.
So they probably wanted to drop their bombs quickly before they were caught
@swasheck If you see the captured guy was able to walk around his neighbourhood for months, and locals said "ye everybody knew he was there" I'm sure there is a fair number of people still supporting these types of actions
@JSapkota If you know that airport, it's only a few steps from the sliding door entrance, and a lot of people carry bags in an airport. I'd wager they have only been inside for a couple of minutes before they hit
@Mathematics It's quite shocking if you realize that you could've been a casualty if they did that last week on Monday or Friday (like me), or any of your relatives or coworkers at any given day
@swasheck It's just unreal seeing those pictures, seeing everybody talk about it, (still) not be able to have a cellphone call, receiving loads of mail with either support or asking if everybody is ok
@swasheck Thanks
I don't think many people were productive around here today
efff me. I guess I need to be more careful with my sarcasm:
^^^ what @a_horse_with_no_name said. Better yet, do it in production then you'll know extremely quickly where the problem code is. — Max Vernon18 hours ago
@TomV There was a bombing (that kind of failed and killed only the bomber if I remeber correctly) a few years ago in Madrid airport.
I was on a plane that landed less than 1 hour later at the same airport. It was chaos.
(Flight from Athens to Madrid) All our phones were ringing the moment we started them after landing. From frightened relatives who had watched the news on TV - we were happily oblivious till then.
@PaulWhite Yes, kind of. They didn't reply on your question, about the recovery model (full, simple, or bulk logged) but - to me - it seems like they are open to suggestions about how to solve their problem.
Which I can't answer of course - I suppose they want something like simultaneouous backups of more than one db (form the same point in time). No idea if that is feasible or not.
@TomV I didn't have much access to media, so it didn't affect me much. I was a tourist, on vacation for only 5 days. I'm sure it would be much more effective if it had happened on my return, in the Athens airport.
@ypercubeᵀᴹ Maybe, part of the impact was probably due to the fact that I was there for my uncle's wedding, and the hotel where the party was served as a field hospital so you had severed bodies in the lobby
Since you're not taking log backups anyway because of the disk space issues, in case of hardware failure you will have to revert to the daily backup anyway. The only case the log will help you is in case of user error where you can take a tail backup and recover to a point in time (given enough space for a tail backup)
If management doesn't care about the thing enough to finally upgrade it or P2V it, I don't think they care about the database, so it shouldn't be too bad if you lose the entire database
@A_V Mind you your hair is very valuable, You might not realize it when you're still young, but you will value each and every one of them when older. Also: wear sunscreen
This old sqlserver 2000 instance has a 14Gb disc for data and a 30Gb disc for backups.
Even though it is old, it still has tons of users doing transactions so the logfile of the only database that is on this server fills the data drive everyday.
I figured I would put it in simple recovery and f...
@TomV I agree laughing is much better than crying.... I remember when I was doing a bicycle tour through Belgium, talking to a guy about how the country wanted to break into two parts even though they were so united fighting the Nazis. Maybe a more united Belgium will be the silver lining in this horribleness.
@Erik I'm not on either side of the fence, but the whole thing is fairly complicated. I'm perfectly comfortable explaining but I don't think we should flood the heap with it
It's just a thing that most of the supporters on either side don't understand because history is boring, and I am convinced it's an absolute non-issue but easily abused by certain politicians to explain their own failure. That's part of what happens in BXL now, their are I don't know 20 mayors and equally as much police forces, but none of them want to give up political powers and sell it to the voters as "hey but the other guys will get more power over us"
Shucks, this is a pretty popular feature-request... Let's give it a try & see if it's more helpful than annoying:
This'll pop up every time someone tries to ask a question with sql. It's not context-sensitive - if they've already included everything in that list, they'll still get the popup. B...
