Are the posted questions getting worse?
-
Eirikur Eiriksson (1/23/2016)
Ed Wagner (1/23/2016)
Eirikur Eiriksson (1/23/2016)
Ed Wagner (1/23/2016)
jasona.work (1/22/2016)
So I just had an amusing moment...I'm checking my servers for DBs that aren't TDE enabled and I come across a DB I *KNOW* was encrypted this morning as I watched the percent_complete and encryption_state in sys.dm_exec_database_encryption_keys. Yet now it's showing encryption state 1?!?
WTH?
So I do some digging into the SQL logs and the server-side trace I have to run, and track down an alter database set encryption off. Get the name of the workstation from the trace, and I think I know who it might be so I go talk to the developer.
Turns out he's publishing changes to the DB (it's still being developed) from Visual Studio and wasn't paying attention to what it was doing at the start of the script (setting encryption off.) So he's going to not run that part of the script from here on out and I'm happy to find I'm not crazy and seeing / remembering things that didn't happen!
That's weird. I think it would have driven me crazy for a time as well. Not having Enterprise Edition, I've never worked with TDE. Do the developers have the permissions to turn off TDE for a database?
Good question Ed, makes me wonder if the devs have sa rights to the prod!
😎
Heh - no wonder poor Jason is wondering if he's gone crazy.
If this is the case then he should!
😎
Very true. Can you imagine what an audit would look like? My audits don't reveal many surprises and I like it that way. If everyone had sa privs...I don't want to think about it any more.
-
Michael L John (1/23/2016)
Eirikur Eiriksson (1/23/2016)
Ed Wagner (1/23/2016)
Eirikur Eiriksson (1/23/2016)
Ed Wagner (1/23/2016)
jasona.work (1/22/2016)
So I just had an amusing moment...I'm checking my servers for DBs that aren't TDE enabled and I come across a DB I *KNOW* was encrypted this morning as I watched the percent_complete and encryption_state in sys.dm_exec_database_encryption_keys. Yet now it's showing encryption state 1?!?
WTH?
So I do some digging into the SQL logs and the server-side trace I have to run, and track down an alter database set encryption off. Get the name of the workstation from the trace, and I think I know who it might be so I go talk to the developer.
Turns out he's publishing changes to the DB (it's still being developed) from Visual Studio and wasn't paying attention to what it was doing at the start of the script (setting encryption off.) So he's going to not run that part of the script from here on out and I'm happy to find I'm not crazy and seeing / remembering things that didn't happen!
That's weird. I think it would have driven me crazy for a time as well. Not having Enterprise Edition, I've never worked with TDE. Do the developers have the permissions to turn off TDE for a database?
Good question Ed, makes me wonder if the devs have sa rights to the prod!
😎
Heh - no wonder poor Jason is wondering if he's gone crazy.
If this is the case then he should!
😎
TDE. The bane of my existence. We had to encrypt the databases, based upon auditing requirements. Well, because the dev's need to have 5 (count 'em, 5) different environments that are copies of production as well as LOCAL COPIES OF PRODUCTION WHEN NEEDED I have to encrypt-decrypt-encrypt-decrypt day after day.
Thankfully I've been able to automate this, and even better, have made some good strides changing the way we do things.
You sure have some unusual situations and requirements where you work. I'm glad you were able to automate things. Otherwise, you'd spent 100% of your time making all these copies.
-
Ed Wagner (1/23/2016)
Eirikur Eiriksson (1/23/2016)
ChrisM@Work (1/22/2016)
Ed Wagner (1/22/2016)
Greg Edwards-268690 (1/21/2016)
Eirikur Eiriksson (1/21/2016)
Greg Edwards-268690 (1/21/2016)
Steve Jones - SSC Editor (1/21/2016)
Greg Edwards-268690 (1/21/2016)
It seems he has an elephant on the menu, and a 6 quart pot to cook it in.But refuses to start carving up the elephant.
dinner's gonna be late
An old company recipe book describes cooking for 5 weeks at 450 degrees after spending 2 months cutting the elephant into bite size pieces. And that it serves about 3000 people.
So have you done this before? 😛
😎
Mine must have been for a small elephant, as it was only 1 400 gallon kettle.
Can you even imagine the size of the fire required for such a large pot? Plus, you'd probably want to finish it in a frying pan to for caramelization, so that would need another fire. 😛
Rub salt and oil into the scored skin. 220C for the first 30 minutes then turn down to 190C for the remaining six weeks of cooking time. Perfect crackling.
I like the sound of it but if it takes me an hour to perfectly pamper the Sunday roast, this would take days. My suggestion is to pour few thousand gallons of high quality olive oil on a target spot in Great Salt Plains State Park, grab the Dumbo by the ears in your Chinook, to a top speed low altitude flyby and drop it about 200 feets from the oil.
😎
Now I have to ask how long it would take to heat up that much oil. You'd have to have it up to temperature or the meat would just get oil soaked without cooking. Also, if you drop it from 200 feet, you're going to have a lot of splashing, so it would be better to lower it in slowly. Lastly, make sure the elephant is dry when you place it in the oil. You don't need to take the helicopter out of the air.
Gee, can you tell I like to cook? 😉
Ed, this is the preparation, rubbing in the salt and oil by dropping Dumbo from around 10 feets, full speed from the Chinook roughly 200 feets from the oil, just to give it a good rub, just under 20 rotations. To follow Chris's gourmet instructions we'll then take it to Iceland, roll it down a steep slope of fresh lava and finally plunge it on a to of a geysir for couple of weeks.
😎
-
Ed Wagner (1/23/2016)
Michael L John (1/23/2016)
Eirikur Eiriksson (1/23/2016)
Ed Wagner (1/23/2016)
Eirikur Eiriksson (1/23/2016)
Ed Wagner (1/23/2016)
jasona.work (1/22/2016)
So I just had an amusing moment...I'm checking my servers for DBs that aren't TDE enabled and I come across a DB I *KNOW* was encrypted this morning as I watched the percent_complete and encryption_state in sys.dm_exec_database_encryption_keys. Yet now it's showing encryption state 1?!?
WTH?
So I do some digging into the SQL logs and the server-side trace I have to run, and track down an alter database set encryption off. Get the name of the workstation from the trace, and I think I know who it might be so I go talk to the developer.
Turns out he's publishing changes to the DB (it's still being developed) from Visual Studio and wasn't paying attention to what it was doing at the start of the script (setting encryption off.) So he's going to not run that part of the script from here on out and I'm happy to find I'm not crazy and seeing / remembering things that didn't happen!
That's weird. I think it would have driven me crazy for a time as well. Not having Enterprise Edition, I've never worked with TDE. Do the developers have the permissions to turn off TDE for a database?
Good question Ed, makes me wonder if the devs have sa rights to the prod!
😎
Heh - no wonder poor Jason is wondering if he's gone crazy.
If this is the case then he should!
😎
TDE. The bane of my existence. We had to encrypt the databases, based upon auditing requirements. Well, because the dev's need to have 5 (count 'em, 5) different environments that are copies of production as well as LOCAL COPIES OF PRODUCTION WHEN NEEDED I have to encrypt-decrypt-encrypt-decrypt day after day.
Thankfully I've been able to automate this, and even better, have made some good strides changing the way we do things.
You sure have some unusual situations and requirements where you work. I'm glad you were able to automate things. Otherwise, you'd spent 100% of your time making all these copies.
All of this is growing pains from once being run out of a garage to becoming a global entity!
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Michael L John (1/23/2016)
Ed Wagner (1/23/2016)
Michael L John (1/23/2016)
Eirikur Eiriksson (1/23/2016)
Ed Wagner (1/23/2016)
Eirikur Eiriksson (1/23/2016)
Ed Wagner (1/23/2016)
jasona.work (1/22/2016)
So I just had an amusing moment...I'm checking my servers for DBs that aren't TDE enabled and I come across a DB I *KNOW* was encrypted this morning as I watched the percent_complete and encryption_state in sys.dm_exec_database_encryption_keys. Yet now it's showing encryption state 1?!?
WTH?
So I do some digging into the SQL logs and the server-side trace I have to run, and track down an alter database set encryption off. Get the name of the workstation from the trace, and I think I know who it might be so I go talk to the developer.
Turns out he's publishing changes to the DB (it's still being developed) from Visual Studio and wasn't paying attention to what it was doing at the start of the script (setting encryption off.) So he's going to not run that part of the script from here on out and I'm happy to find I'm not crazy and seeing / remembering things that didn't happen!
That's weird. I think it would have driven me crazy for a time as well. Not having Enterprise Edition, I've never worked with TDE. Do the developers have the permissions to turn off TDE for a database?
Good question Ed, makes me wonder if the devs have sa rights to the prod!
😎
Heh - no wonder poor Jason is wondering if he's gone crazy.
If this is the case then he should!
😎
TDE. The bane of my existence. We had to encrypt the databases, based upon auditing requirements. Well, because the dev's need to have 5 (count 'em, 5) different environments that are copies of production as well as LOCAL COPIES OF PRODUCTION WHEN NEEDED I have to encrypt-decrypt-encrypt-decrypt day after day.
Thankfully I've been able to automate this, and even better, have made some good strides changing the way we do things.
You sure have some unusual situations and requirements where you work. I'm glad you were able to automate things. Otherwise, you'd spent 100% of your time making all these copies.
All of this is growing pains from once being run out of a garage to becoming a global entity!
Be careful when your company grows. Some people say that growth causes scalability problems. Personally, I think growth exposes the scalability problems that have existed all along.
There's a gas station/truck stop company here in Michigan that's in a similar situation. When they first started out, they had this batch process that processed the orders for their different locations. People wanted to fix it, but everyone was afraid to touch the code because it worked, but was complicated. After a few failed attempts, they bought more hardware. Now that the company is pretty big, all they can do is to throw more hardware at the problem. Everyone's afraid to touch anything because they don't want to be the one to break it and bring all orders for all locations to a grinding halt. In the end, there's no substitute for good design and maintainable code.
-
Grant Fritchey (1/20/2016)
Jeff Moden (1/19/2016)
jasona.work (1/19/2016)
Paintball is getting more and more complicated...I wonder if it'll work with Express or if it needs Enterprise?
I've been outlawed from paint ball forever... I threatened to build a paintball "Nuke".
yeah, I got in trouble when I went hand-to-hand during a paintball game. As I said at the time, "Well, if you'd have given me a bayonet, this wouldn't have happened."
Uh, how does one go Hand-To-Hand, exactly? Were you cramming pellets down someone's throat? I can also envision you sneaking around with a paintbrush and a pallette, drawing happy little Bob Ross trees on peoples' backs...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses -
jonathan.crawford (1/23/2016)
Grant Fritchey (1/20/2016)
Jeff Moden (1/19/2016)
jasona.work (1/19/2016)
Paintball is getting more and more complicated...I wonder if it'll work with Express or if it needs Enterprise?
I've been outlawed from paint ball forever... I threatened to build a paintball "Nuke".
yeah, I got in trouble when I went hand-to-hand during a paintball game. As I said at the time, "Well, if you'd have given me a bayonet, this wouldn't have happened."
Uh, how does one go Hand-To-Hand, exactly? Were you cramming pellets down someone's throat? I can also envision you sneaking around with a paintbrush and a pallette, drawing happy little Bob Ross trees on peoples' backs...
Have you met Grant?
-
Eirikur Eiriksson (1/23/2016)
Ed Wagner (1/23/2016)
Eirikur Eiriksson (1/23/2016)
ChrisM@Work (1/22/2016)
Ed Wagner (1/22/2016)
Greg Edwards-268690 (1/21/2016)
Eirikur Eiriksson (1/21/2016)
Greg Edwards-268690 (1/21/2016)
Steve Jones - SSC Editor (1/21/2016)
Greg Edwards-268690 (1/21/2016)
It seems he has an elephant on the menu, and a 6 quart pot to cook it in.But refuses to start carving up the elephant.
dinner's gonna be late
An old company recipe book describes cooking for 5 weeks at 450 degrees after spending 2 months cutting the elephant into bite size pieces. And that it serves about 3000 people.
So have you done this before? 😛
😎
Mine must have been for a small elephant, as it was only 1 400 gallon kettle.
Can you even imagine the size of the fire required for such a large pot? Plus, you'd probably want to finish it in a frying pan to for caramelization, so that would need another fire. 😛
Rub salt and oil into the scored skin. 220C for the first 30 minutes then turn down to 190C for the remaining six weeks of cooking time. Perfect crackling.
I like the sound of it but if it takes me an hour to perfectly pamper the Sunday roast, this would take days. My suggestion is to pour few thousand gallons of high quality olive oil on a target spot in Great Salt Plains State Park, grab the Dumbo by the ears in your Chinook, to a top speed low altitude flyby and drop it about 200 feets from the oil.
😎
Now I have to ask how long it would take to heat up that much oil. You'd have to have it up to temperature or the meat would just get oil soaked without cooking. Also, if you drop it from 200 feet, you're going to have a lot of splashing, so it would be better to lower it in slowly. Lastly, make sure the elephant is dry when you place it in the oil. You don't need to take the helicopter out of the air.
Gee, can you tell I like to cook? 😉
Ed, this is the preparation, rubbing in the salt and oil by dropping Dumbo from around 10 feets, full speed from the Chinook roughly 200 feets from the oil, just to give it a good rub, just under 20 rotations. To follow Chris's gourmet instructions we'll then take it to Iceland, roll it down a steep slope of fresh lava and finally plunge it on a to of a geysir for couple of weeks.
😎
Won't you need to bag it for the sous-vide step?
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden -
Ed Wagner (1/23/2016)
Eirikur Eiriksson (1/23/2016)
Ed Wagner (1/23/2016)
jasona.work (1/22/2016)
So I just had an amusing moment...I'm checking my servers for DBs that aren't TDE enabled and I come across a DB I *KNOW* was encrypted this morning as I watched the percent_complete and encryption_state in sys.dm_exec_database_encryption_keys. Yet now it's showing encryption state 1?!?
WTH?
So I do some digging into the SQL logs and the server-side trace I have to run, and track down an alter database set encryption off. Get the name of the workstation from the trace, and I think I know who it might be so I go talk to the developer.
Turns out he's publishing changes to the DB (it's still being developed) from Visual Studio and wasn't paying attention to what it was doing at the start of the script (setting encryption off.) So he's going to not run that part of the script from here on out and I'm happy to find I'm not crazy and seeing / remembering things that didn't happen!
That's weird. I think it would have driven me crazy for a time as well. Not having Enterprise Edition, I've never worked with TDE. Do the developers have the permissions to turn off TDE for a database?
Good question Ed, makes me wonder if the devs have sa rights to the prod!
😎
Heh - no wonder poor Jason is wondering if he's gone crazy.
Ed, that is a coincidence. We hit the same issue a couple of weeks ago. I set up TDE on Test / QA and Pre-Prod. Came to the day we going to do Production and I checked the state of the other three environments... All Ags as well.
Turned out TDE has been "switched off". Checked the logs found out when, discussing this with my colleague, who has had far more experience that me with Visual Studio and deployments... She noticed the time in the log overlapped with an automated deployment. Sure enough in the project SET ENCRYPTION wasn't set. As Release Manager has its own login (its not the Devs) and raised privileges, the encryption setting was over written.
As a foot note, we did some testing and discovered you can set it as ON as a default in the builds, and even for those DB's that don't need it, it doesn't set it on (lack of certificate) it doesn't error so the build succeeds. Although there is nothing logged to the SQL ErrorLog.
But in the end we were happy with that, as it didn't break anything.
Cheers,
Rodders...
-
Eirikur Eiriksson (1/23/2016)
Ed Wagner (1/23/2016)
Eirikur Eiriksson (1/23/2016)
Ed Wagner (1/23/2016)
jasona.work (1/22/2016)
So I just had an amusing moment...I'm checking my servers for DBs that aren't TDE enabled and I come across a DB I *KNOW* was encrypted this morning as I watched the percent_complete and encryption_state in sys.dm_exec_database_encryption_keys. Yet now it's showing encryption state 1?!?
WTH?
So I do some digging into the SQL logs and the server-side trace I have to run, and track down an alter database set encryption off. Get the name of the workstation from the trace, and I think I know who it might be so I go talk to the developer.
Turns out he's publishing changes to the DB (it's still being developed) from Visual Studio and wasn't paying attention to what it was doing at the start of the script (setting encryption off.) So he's going to not run that part of the script from here on out and I'm happy to find I'm not crazy and seeing / remembering things that didn't happen!
That's weird. I think it would have driven me crazy for a time as well. Not having Enterprise Edition, I've never worked with TDE. Do the developers have the permissions to turn off TDE for a database?
Good question Ed, makes me wonder if the devs have sa rights to the prod!
😎
Heh - no wonder poor Jason is wondering if he's gone crazy.
If this is the case then he should!
😎
Oh H**L NO the devs don't have SA (QA or Prod)! They do get db_owner (for now) on the DBs they work on, but they're not "the owner" of the DB. In this case, the Dev was using the SQL Login that the application is going to use (which also has db_owner) to implement his changes from Visual Studio.
Hmm. Some quick Google doesn't seem to confirm that this would work or not work...
TESTING TIME! :hehe:
-
jonathan.crawford (1/23/2016)
Grant Fritchey (1/20/2016)
Jeff Moden (1/19/2016)
jasona.work (1/19/2016)
Paintball is getting more and more complicated...I wonder if it'll work with Express or if it needs Enterprise?
I've been outlawed from paint ball forever... I threatened to build a paintball "Nuke".
yeah, I got in trouble when I went hand-to-hand during a paintball game. As I said at the time, "Well, if you'd have given me a bayonet, this wouldn't have happened."
Uh, how does one go Hand-To-Hand, exactly? Were you cramming pellets down someone's throat? I can also envision you sneaking around with a paintbrush and a pallette, drawing happy little Bob Ross trees on peoples' backs...
Ahhh the happy painter. His show was mesmerizing.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
A few questions for the threadizens. Interested in this from everyone, but especially interested in what you guys who consult think.
What blockers are you seeing for Azure?
What blockers are you seeing for a datawarehouse?
What blockers are you seeing for a datawarehouse on azure?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Bandwidth, latency and data out of the country (for 1 and 3)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
GilaMonster (1/25/2016)
Bandwidth, latency and data out of the country (for 1 and 3)Makes sense.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
I've heard that legislation might be an issue for some industries.
In Mexico, banks can't have their information outside of their physical locations.
Viewing 15 posts - 52,351 through 52,365 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply