Forum Replies Created

Viewing 15 posts - 4,606 through 4,620 (of 6,041 total)

  • RE: If or When?

    Steve Jones - SSC Editor (4/11/2014)

    Eric M Russell (4/11/2014)

    Obviously the government, whether it be Congress or some agency dedicated to the task, can't come up with the standards; it has...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    April 11, 2014 at 9:40 am

    #1705378

  • RE: If or When?

    Steve Jones - SSC Editor (4/11/2014)

    Eric M Russell (4/10/2014)

    The standards would not have to be very technical. Dedicated sysadmin accounts, removal of service accounts from sysadmin role, seperation duties, application...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    April 11, 2014 at 9:05 am

    #1705354

  • RE: If or When?

    Gary Varga (4/11/2014)

    john.riley-1111039 (4/11/2014)

    There are many circumstances in life where we prepare for relatively unlikely events. We install sprinklers and fire extinguishers in buildings,

    air bags in cars, pilots...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    April 11, 2014 at 7:37 am

    #1705284

  • RE: If or When?

    Gary Varga (4/10/2014)

    Just define legal requirements to be best endeavours. I think that most sectors where it counts there are further standards, for example in the UK we have the...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    April 10, 2014 at 10:43 am

    #1704976

  • RE: If or When?

    OCTom (4/10/2014)

    Hackers are not going to try to hack all severs. They look for the easiest path. This is one area where it's best to be the ugly duckling at...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    April 10, 2014 at 9:54 am

    #1704959

  • RE: If or When?

    I believe that SQL Server already has the required features to implement auditing (SQL Server Audit and extended events), granular controls (permissions), and seperation of duties (database and server roles)....

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    April 10, 2014 at 7:54 am

    #1704904

  • RE: Lobbying for Change

    Jeff Moden (4/9/2014)

    Eric M Russell (4/9/2014)

    In Washington D.C., lobbyists use money, sex, and three martini lunches to promote their cause and grease the skids. Can we do that with Microsoft?...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    April 10, 2014 at 7:05 am

    #1704879

  • RE: Is there something comparable to checking the mdf files like there is the ldf files?

    defyant_2004 (4/9/2014)

    Thanks, this will help me out.

    I am surprised there is nothing similar to dbcc sqlperf('logspace') like a dbcc sqlperf('dataspace')

    Look around on the website http://www.sqlskills.com/blogs/paul/ for articles by Paul...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    April 9, 2014 at 2:27 pm

    #1704688

  • RE: Is there something comparable to checking the mdf files like there is the ldf files?

    defyant_2004 (4/9/2014)

    I am trying both these queries out, thank you.

    It appears I have to run the first query individually for each database, unlike the dbcc sqlperf ('logspace') which gives all...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    April 9, 2014 at 12:43 pm

    #1704658

  • RE: Is there something comparable to checking the mdf files like there is the ldf files?

    defyant_2004 (4/9/2014)

    Hello,

    I use dbcc sqlperf ('logspace') to keep an eye on the logs for our databases. I like that it tells me how big the log file is and...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    April 9, 2014 at 10:38 am

    #1704605

  • RE: Lobbying for Change

    In Washington D.C., lobbyists use money, sex, and three martini lunches to promote their cause and grease the skids. Can we do that with Microsoft? 🙂

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    April 9, 2014 at 7:49 am

    #1704508

  • RE: Getting Fired

    enriarg (4/8/2014)

    I was let go of a company when I first started as a programmer because I fall a doze of in a meeting... truth to be told I have...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    April 9, 2014 at 7:36 am

    #1704496

  • RE: Data Security Policies

    Yet Another DBA (4/9/2014)

    Eric M Russell (4/8/2014)

    I hate to say it, but the only way we're every going to see any industry wide application of standard data security policies is...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    April 9, 2014 at 7:23 am

    #1704492

  • RE: simple store procedure

    ankit.oza (4/7/2014)

    Thank You All!!:-)

    I don't think anyone here has provided an example of executing dynamic SQL. There are various approaches and pitfalls, so I'll provide a link the definitive tutotial...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    April 8, 2014 at 11:03 am

    #1704213

  • RE: Data Security Policies

    jay-h (4/8/2014)

    Eric M Russell (4/8/2014)

    I hate to say it, but the only way we're every going to see any industry wide application of standard data security policies is through government...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

    April 8, 2014 at 10:41 am

    #1704206

Viewing 15 posts - 4,606 through 4,620 (of 6,041 total)