Marios Philippopoulos

Forum Replies Created

Viewing 15 posts - 121 through 135 (of 1,518 total)

RE: Table-valued UDF on one database selects data from another database on the same SQL instance - how to make this work without assigning explicit user permissions on db_2?

SQLKnowItAll (1/23/2012)
Is EXECUTE AS not an option?
http://msdn.microsoft.com/en-us/library/ms188354.aspx
The thought has crossed my mind, but I am a bit short on the specifics.
In fact, I was reading that very page today.

January 23, 2012 at 6:46 pm

#1437444
RE: DBAs and the Career-Life Balance

I have been following this discussion and get the feeling some of you are on call "all the time"?!
How is that possible without ending up in a burnout? I am...

January 18, 2012 at 5:15 pm

#1435608
RE: DBAs and the Career-Life Balance

Tracy McKibben (1/17/2012)
Rather than scramble to keep up with all of the new, sometimes obscure, features that new versions of SQL Server bring, I've worked to position my self as...

January 18, 2012 at 5:31 am

#1435168
RE: Need to grant execute permissions on all sprocs of a specific database to all server logins of a SQL instance without explicitly granting exec permissions on each individual object

GSquared (1/17/2012)
Jeff Moden (1/16/2012)
rlevine (1/16/2012)
Perfect!!
I was able to install my CLR functions into a db called Library and then use these scripts to enable having all users call the functions...

January 17, 2012 at 6:38 am

#1434569
RE: DBAs and the Career-Life Balance

In many IT environments it is a taboo to allow the employees a portion of time during working hours to advance their knowledge and skill sets, unless this is directly...

January 15, 2012 at 6:30 am

#1433815
RE: Running Full and Transaction-Log Backups Concurrently - Any Implications for Database Recovery?

GilaMonster (1/14/2012)
Marios Philippopoulos (1/12/2012)
What happens if a previous log backup, lb0, had started at 9:45 pm (ie. prior to start of the full backup) and completed at 10:05 pm (ie....

January 15, 2012 at 5:31 am

#1433806
RE: Need to grant execute permissions on all sprocs of a specific database to all server logins of a SQL instance without explicitly granting exec permissions on each individual object

azdzn (1/13/2012)
One of the way to do it is to enable the guest user :
Use Your_db
go
grant connect to guest
grant execute to guest
go
Thank you all for the input, it is appreciated.

January 13, 2012 at 2:00 pm

#1433515
RE: Running Full and Transaction-Log Backups Concurrently - Any Implications for Database Recovery?

azdzn (1/12/2012)
Marios Philippopoulos (1/12/2012)
(1) Restore database from fb with norecovery
(2) Restore log from lb2 with recovery
Does it matter that lb2 had started while the full backup was still running?
You have...

January 12, 2012 at 6:04 pm

#1432971
RE: Would like to start my own blog but don't know how

Thank you both, that's what I was looking for. 🙂

January 9, 2012 at 1:59 pm

#1430794
RE: The Stubborn DBA

I'm glad to see there are so many others with the "stubbornness" bug! 🙂
For me the worst feeling is when I get stuck in one of these weird, frustrating problems...

January 9, 2012 at 10:45 am

#1430681
RE: Optimal Disaster/Recovery Strategy for Data Warehouse (BI) application

Michael Lysons (12/21/2011)
Marios Philippopoulos (12/20/2011)
We use DNS aliases with our prod servers. In a DR situation we will simply switch the aliases from prod to DR.
That's the approach we've been...

December 21, 2011 at 6:31 am

#1424184
RE: Optimal Disaster/Recovery Strategy for Data Warehouse (BI) application

We use DNS aliases with our prod servers. In a DR situation we will simply switch the aliases from prod to DR.

December 20, 2011 at 10:35 am

#1423815
RE: Advice needed to ensure least impact on db mirroring during lengthy planned primary-server outage

Thank you both for your answers.
Actually, I wasn't accurate in my original description of the scenario.
There will actually be 2 outages.
(1) At 4 pm we are taking down our DR...

December 15, 2011 at 12:17 pm

#1422171
RE: Optimal Disaster/Recovery Strategy for Data Warehouse (BI) application

Martin Thatcher (12/14/2011)
Hi Marios,
Can you tell me how you set up your SSIS packages to work on both your principal and DR servers without creating 2 versions? Did you...

December 15, 2011 at 3:26 am

#1421807
RE: ReportServer-db query to find which reports are largest contributors to CPU usage in a SQL-2008 SSRS server

JeremyE (12/13/2011)
If you know when the CPU spikes occurred, you can use the view ReportServer.dbo.ExecutionLog2 to go back and see which reports were running during that time. I use the...

December 14, 2011 at 4:48 pm

#1421689

Viewing 15 posts - 121 through 135 (of 1,518 total)