@JNK sure, server-side trace that captures all SQL:StmtCompleted and SP:Completed in both databases
And make sure login is part of the column set
Even if login doesn't change it would still be a useful exercise to see all of the things that are getting called and some of the parameters for the call that leads to the exception that you don't get from the exception itself.
A question was earlier posted, but then closed by Jack Douglas because he stated it was not a real question. I am having the same issue as the person who originally posted the question and I don't know how it could be stated any more clearly. So to say it's not a real question makes no sense. ...
We are going to be hashing some sensitive data (ssn) as well as encrypting it. The hash will be for apps that just need to match data and we'll only allow a few things to decrypt it. Since computing a hash of all possible SSNs isn't that complex, we are going to add a salt value prior to hashing.
The question becomes, how would you manage sharing the salt value between teams/apps/etc Or do you?
The HR folks will need to actually get the SSNs of people for some report so we need to undo whatever we do
The hash, since we're storing as ascii, will take less disk and should provide a mechanism for diverse things to determine is it a match (whenever they need to sync up between system a and b)
They have silly requirements here that level 3 data must be encrypted at rest and in flight. That's reasonable but it's silly because that only applies to new stuff. All this PII data is stored unencrypted and all the legacy apps just pull and store it in the clear but all the new needs to follow the rules
TL;DR - You can store the salt in plaintext without any form of obfuscation or encryption, but don't just give it out to anyone who wants it.
The reason we use salts is to stop precomputation attacks, such as rainbow tables. These attacks involve creating a database of hashes and their plainte...
Security, much like sql server internals, is something that I try to avoid looking at as I know going down that rabbit hole is going to occupy a great deal of time.
@bluefeet but it's good that you can't change them without changing all the objects that reference them. Just like SCHEMABINDING for a function or view.
Also allows you to create a different table type, and introduce it gradually to existing code, instead of wholesale swap. I think it's a good thing,
then once you've stopped using the old version in all of your code, you can just drop it.
@bluefeet Yes, I had originally envisions all this user defined table type reuse until I ran into that snag. Now, even if my UDTT are identical if they are used by different procs, I bite the bullet and make "duplicates"
Using either of the following functions alone perform well (dbo.getCorrectInventoryKey(Inventory_Key) and dbo.getEntityFullName2(Inventory_Key, '.')), but when used together (dbo.getEntityFullName2(dbo.getCorrectInventoryKey(Inventory_Key), '.')) the query never returns...
CREATE function [db...
@billinkc you shouldn't need to do that unless both (a) and (b) are true: (a) they are likely to change AND (b) the changes will affect the different procedures differently
Recompiling one stored procedure or five stored procedures to reference a new TVP is not really any different.
@AaronBertrand It was a SOX boogeyman issue. ZOMG, 10 procs are included in this change. You said you were only changing one thing. "Well, it's not really but I have to drop and recreate b/c of this dependency"
@billinkc well that's like my wheel warranty - if I take advantage of one or two wheels, they do it on the spot; if it's three or all four, they have to call in an adjuster to inspect the wheels. Red tape for the sake of it.
That's irrelevant because no matter the context it never returns, but use of the functions together is noted at the top... dbo.getEntityFullName2(dbo.getCorrectInventoryKey(Inventory_Key), '.') — E-Madd12 mins ago
Does any know if this query can be converted and run in sql 2000
SELECT deqs.last_execution_time AS [Time], dest.TEXT AS [Query]
FROM sys.dm_exec_query_stats AS deqs
CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
WHERE dest.TEXT like '%sp_OACreate%'
ORDER BY deqs.last_execution_time D...
playing with my biggest friends in the javascript chat, came to my mind, but why the chat can not be limited and therefore benefit users who write less using the following logic:
Probably this post will take up many downvotes, cause sort of chat's
elites do not agree this, but this will ma...
Stack Overflow has a place for questions. Incidentally that place for questions has existed since the private beta! OMG it is so ooooold! I know it is surprising, but it is the truth! Check this out: stackoverflow.com/questions! So many questions! It's like, millions! How come people have been posting questions in the place for questions all this time! That is very surprising, given that that place is labelled "Questions"! No one would think it is the place for questions! And look at this: stackoverflow.com/questions/ask! You can post even more! OMG This is so exciting. — R. Martinho Fernandes33 mins ago
Auto-kill all questions that don't contain a question mark in the body! Because, you know, I can't state a problem if I don't ask in the form of a question!
I can see many 'questions' without a proper question in the body at any point I come to SO. Except for the code (<?php ?>), why don't we detect if the whole question contains an interrogation sign "?" ?
If it doesn't contain an interrogation sign, we can:
Strongly advice users to write an actu...
What the OP is suggesting would:
reward help vampires
punish regular users
That's about it.
Why would he want to do this? Because he is a troll and a help vampire:
http://chat.stackoverflow.com/transcript/17?m=9239651#9239651
http://chat.stackoverflow.com/transcript/17?m=9227286#9227286
...
In mysql i am trying to get last 7 days data so i tried with following query
date_sub(curdate(), interval 7 day) <= visited_time from visitor table gives date from 5/10/2013 to 5/16/2013
but here the same query date_sub(curdate(), interval 7 day) <= date_entered from order table gives date fro...
My post is going to be about something else, but I wanted to mention a few explicit examples that defy the logic "we don't need stored procedures because we're using an ORM!"
So I'm looking for explicit examples of things where they'll have to use stored procedures (or some middle translation layer).
I encountered an Established User, quite active on scifi.stackexchange, who still had some quality problems. Looking at his profile, I realized he has not voted a single time.
That surprised me! How could one be active on a Stack Exchange site and not vote a single time? Not even on the answer ...
I have the following table structure with ID, State and Date
20130323000004 Final 3/23/2013
20130323000004 Final 3/25/2013
20130323000004 Final 3/26/2013
20130323000004 Needs Review 4/5/2013
20130323000004 Final 4/10/2013
20130323000004 Final 5/1/2013
...
I need to design an winforms application at work making use of a Pivot Grid control. The following are the contestants:
Telerik PivotGrid
ComponentOne OLAP for Winforms
Active Analysis
DevExpress PivotGrid
Which one should I suggest and what are the pro's and con's of each?
I would like to ...
@JNK how often does the data in your other table change? Wonder if you could subvert the issue with an ugly workaround, e.g. simply adding a trigger that repeats DML actions against a copy in the same database as the broker procedure.
(Or keeping that table in the same database in the first place, and putting the synonym in the other direction.)
I know it's a late answer, but I hope it's useful for someone.
I made a short evaluation on some ASP.NET OLAP controls that have the possibility of displaying Analysis Services data in a web page. I didn't have anything in mind, just that all calculations should not be done by the client, but on...
Seriously, I uploaded those swim class pics last weekend (to her blog) and someone on facebook commented "We're not even allowed to have cameras at swim class because of all the pervs". Five minutes later my wife called me and said "That's it!"
@BrentOzar i was noting that i get funny looks when i say "multi-instance failover cluster" ... i have to backtrack and say "y'know ... active/active?"
@MikeFal yeah. i'm torn but i ultimately have to hope that brandon either sees potential in me, or didnt and that schmoozing wouldnt really influence him. i also have to spend some time with the frau since we've been going 100 MPH over the last 3 weeks.
You will want to UNPIVOT the data using a UNION ALL first, then apply a PIVOT/TRANSFORM:
transform sum(val)
select col
from
(
SELECT 'Col1' as col, Col1 as Val
FROM test
union all
SELECT 'Col2' as col, Col2 as Val
FROM test
union all
SELECT 'Col3' as col, Col3 as Val
FROM test
...
He's just uppity when he hears the term. I stress row vs. record and column vs. field because of what they imply and the kind of misperceptions that take place as a result.
I don't understand the purpose of the IsInactive flag here. In the article he even describes that you can tell if a row is active/inactive based on the start/end date.
That said I will admit that I skimmed the article to some degree. :-)
@BrentOzar and just to sum up, I think you can use the correct terms consistently, without feeling the need to correct everyone on the Internet. If an expert like you says field and record all the time, everyone who follows you is going to do it too. :-(
All right Indian food and then hockey. Not sure when I'll be back in here.
A question was earlier posted, but then closed by Jack Douglas because he stated it was not a real question. I am having the same issue as the person who originally posted the question and I don't know how it could be stated any more clearly. So to say it's not a real question makes no sense. ...
Using either of the following functions alone perform well (dbo.getCorrectInventoryKey(Inventory_Key) and dbo.getEntityFullName2(Inventory_Key, '.')), but when used together (dbo.getEntityFullName2(dbo.getCorrectInventoryKey(Inventory_Key), '.')) the query never returns...
CREATE function [db...
playing with my biggest friends in the javascript chat, came to my mind, but why the chat can not be limited and therefore benefit users who write less using the following logic:
Probably this post will take up many downvotes, cause sort of chat's
elites do not agree this, but this will ma...
I can see many 'questions' without a proper question in the body at any point I come to SO. Except for the code (<?php ?>), why don't we detect if the whole question contains an interrogation sign "?" ?
If it doesn't contain an interrogation sign, we can:
Strongly advice users to write an actu...
What the OP is suggesting would:
reward help vampires
punish regular users
That's about it.
Why would he want to do this? Because he is a troll and a help vampire:
http://chat.stackoverflow.com/transcript/17?m=9239651#9239651
http://chat.stackoverflow.com/transcript/17?m=9227286#9227286
...
In mysql i am trying to get last 7 days data so i tried with following query
date_sub(curdate(), interval 7 day) <= visited_time from visitor table gives date from 5/10/2013 to 5/16/2013
but here the same query date_sub(curdate(), interval 7 day) <= date_entered from order table gives date fro...
I have the following table structure with ID, State and Date
20130323000004 Final 3/23/2013
20130323000004 Final 3/25/2013
20130323000004 Final 3/26/2013
20130323000004 Needs Review 4/5/2013
20130323000004 Final 4/10/2013
20130323000004 Final 5/1/2013
...
I need to design an winforms application at work making use of a Pivot Grid control. The following are the contestants:
Telerik PivotGrid
ComponentOne OLAP for Winforms
Active Analysis
DevExpress PivotGrid
Which one should I suggest and what are the pro's and con's of each?
I would like to ...
You will want to UNPIVOT the data using a UNION ALL first, then apply a PIVOT/TRANSFORM:
transform sum(val)
select col
from
(
SELECT 'Col1' as col, Col1 as Val
FROM test
union all
SELECT 'Col2' as col, Col2 as Val
FROM test
union all
SELECT 'Col3' as col, Col3 as Val
FROM test
...
