That shouldn't be the case - why must SQL Server validate that all columns are selectable? If I explicitly reference that column, maybe. Or if I'm denied on the PK column(s).
Ah no EXISTS is the same. I just messed up. Far too early/late to be doing this.
Argh! Ok so that whole thing only works if there are only column-level permissions. Grant SELECT on the whole table, then DENY a column, no error with COUNT(*).
CREATE USER blat WITHOUT LOGIN;
GO
DROP TABLE dbo.x;
GO
CREATE TABLE dbo.x(a INT, b INT PRIMARY KEY);
GO
GRANT SELECT ON dbo.x TO blat;
GRANT SELECT ON dbo.x(b) TO blat;
DENY SELECT ON dbo.x(a) TO blat;
GO
EXECUTE AS USER = 'blat';
GO
SELECT COUNT(1) FROM dbo.x;
GO
REVERT;
spectacular. You have a place for every person tastes. You want a beach?, you have lots of it, prefer a hot weather?, then go to the north, you want to go to the mountain?, then go...you want to go to a glaciar or want lots of green, rain, etc, then go the south
@PaulWhite, I think it's been asked before, but will there be recordings of your precon in Lisbon? I'd gladly pay the precon registration amount to see it
@Gonsalu No, I'm afraid not. Actually, I would never do it if it was recorded. (a) I hate being recorded with a passion; and (b) recordings have a way of being shared (not by you, clearly).
I think they copied DELETE DCC FROM CommonDim.DimCessionCategory AS DCC WHERE DCC.AuditKey = 0 and wanted to evaluate how many rows were going to be deleted based on that audit key. Instead of 30 as expected, it might have been 58. Pure speculation on my part
Maybe my friend will post this urgent, M$ sux0r question to dba.se
@PaulWhite soooo ... if this is too personal just tell me to take a long walk off of a short pier ... but ... when you travel to lisbon, are they helping you with travel expenses? that's a heckuva flight
@swasheck Yes but only because Niko is insane. Other SQL Saturday events don't; they assume you'll cover the cost of travel, accommodation etc. from ticket sales.
This is based on the misconception that XML indexes are currently the only type that could ever have an id scheme that is >= 256000 (at least based on their observation; this scheme is not documented AFAIK, so not even sure if it's intentional). Probably fine in current versions, but who knows wh...
I think he might be right (at least about what the tutorial writer was trying to accomplish), but I'd be really surprised if Microsoft documents it that way, and it would be really stupid to do so. I'm thinking about paint and corners...
I kind of get some of these decisions. Not trying to prioritize but one that I really didn't understand was the cop who killed a biker because he was typing an e-mail on his laptop while driving.
Ferguson and the Tamir Rice incident are at least partially defensible.
Not saying they were right, or that they didn't shovel up a bunch of bullshit to justify use of force, but neither were completely innocent people at least seeming to be a threat to some people.
I will repeat: I am not saying the cops are right in either of those cases, and in fact the bullshit leads me to believe they over-reacted and killed relatively innocent people.
But in those three scenarios I mention I know there are two where I don't know what I would have done and whether it would have any different or better outcome than what happened. With the biker I know that he would still be alive because I would have pulled over.
There's the video of the swat team that shoot a drunk homeless man in a national park about six times and then while he's down shoot him with the non-lethal bean bag.
Or the baby they flashbanged while trying to bust a teenager for possession.
@AaronBertrand True. I don't know that I would have reacted any better during a confrontation. However I'm neither trained to handle such situations nor have I volunteered to handle them.
Guy in Minneapolis recently got tasered for sitting in a skyway waiting for his daughter to get out of daycare. I know he's not dead but it's still ridiculous.
Yeah, like I said, I don't agree that they were right, but I don't know for certain what I would have done. I'd like to think I would have reacted better, but...
The fact that bothers me is the statistics about how often a grand jury fails to bring an indictment (very, very small amount), and how many of those are against cops (100% IIRC).
Agreed. They should have a different category when a cop may have done something wrong. We used to hear a lot of noise about internal affairs - assume they are victims of budget cuts, but that's the type of group who should be on this.
For the Tamir Rice thing a couple of things still make it less clear cut to me. The video is grainy, so it's hard for me to tell whether he's holding the gun or not, pointing it anywhere, etc. I've watched the video multiple times and I honestly can't tell you I can make out a gun at any point. There's also no audio so we don't know what was said by the cops before the car stopped or by Tamir at any point. Again, not arguing for the cops, just saying there is some wiggle room there.
And one more time, I'm just playing devil's advocate. The story the cops came up with is bullshit, but we don't know everything that really happened or how exactly they saw it.
Saw a study linked that indicates, statistically speaking, black people are viewed older than they truly are. 3 year old appear at 8 or some crazy nonsense
There was a bomb threat when I was in HS. They called an emergency pep rally so everyone gathered into the gym and I could see a PO with a k9 unit walking about in the halls and thought it was odd. Later on, I see under the police blotter in the paper that there was a reported threat at the school address.
I am looking at writing SSIS connector for Avaya. I wanted to understand what skills do I need to write a component in SSIS? Do we need people with .Net skills and SSIS skills?
And is there any standard process of documentation followed by MS community?
Thanks and regards,
Kunal
I am looking at writing SSIS connector for Avaya. I wanted to understand what skills do I need to write a component in SSIS? Do we need people with .Net skills and SSIS skills?
And is there any standard process of documentation followed by MS community?
Thanks and regards,
Kunal
