Forum Replies Created

Viewing 15 posts - 1 through 15 (of 111 total)

  • Reply To: Automate Your Central Management Server Registrations

    Hi I came across this while searching on google, we are looking into automating an inventory of our ever changing environment.

    The SSIS package and Powershell script. Where are these attached....

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    October 4, 2019 at 9:26 am

    #3685947

  • RE: sa account login_time field

    Thanks Gail, will do ðŸ™‚

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    February 7, 2018 at 6:23 am

    #1978849

  • RE: SQL Overview VI - Monitoring Process Locks

    Hi David thanks for this awesome tool,do you have any updates for this tool or planning any perhaps?

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    October 22, 2016 at 7:06 pm

    #1908195

  • RE: Sql Server Service Broker

    thanks for the info Simon 😉

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    November 27, 2015 at 12:05 am

    #1842572

  • RE: SQL Overview VII - SSRS Reports and Subscriptions

    Thanks 😀

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    January 13, 2015 at 2:50 am

    #1769733

  • RE: SQL Overview VII - SSRS Reports and Subscriptions

    Hi David, awesome update!

    I don't see the final .zip attached on the article though :hehe:

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    January 12, 2015 at 5:43 am

    #1769461

  • RE: Database FILEGROUPS question

    Thanks Grant, that is what I got as well, thought I was missing something but thats for confirming my findings 😀

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    May 14, 2014 at 6:46 am

    #1713450

  • RE: Newbie Question

    +1 Grant

    right click (on your local SSMS), run as a different user (domain account)

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    February 12, 2014 at 5:14 am

    #1688290

  • RE: Moving a database log file question

    In Case someone needs info ...

    Moving SQL_TEST datafile from 'E:\MSSQLData\SQL_TEST.ndf' to 'K:\MSSQLData\SQL_TEST.ndf'

    USE master;

    GO

    ALTER DATABASE SQL_TEST SET OFFLINE;

    GO

    ALTER DATABASE SQL_TEST

    MODIFY FILE (NAME = SQL_TEST, FILENAME = 'K:\MSSQLData\SQL_TEST.ndf');

    GO

    --Move the file to...

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    September 19, 2013 at 7:21 am

    #1651499

  • RE: Moving a database log file question

    Thanks for advice , will try to avoid this but will test on a DEV DUMP db I have. Fortunately this was on QA and not PROD ... :hehe:

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    September 6, 2013 at 2:43 am

    #1647951

  • RE: Moving a database log file question

    Hi guys thanks for the prompt response but I didn't explain clearly what happened ...

    My bad ...

    The storage engineer stopped the SQL service ...

    created the new LUN ...

    he physically moved...

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    September 6, 2013 at 2:14 am

    #1647947

  • RE: Formatting date of birth using South African ID number

    lol too many :hehe:

    I think the OP should maybe shed some more light to get rid of these assumptions

    Using the DOB to verify the century is an option

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    November 12, 2012 at 5:49 am

    #1558130

  • RE: MS SQL Server 2008 R2: SQL Native Client error

    an update

    After investigating MS SQL 2005 tools was installed on the server. It ‘looks’ like MS SQL 2005 was installed on this server and then removed but the tools stayed...

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    November 7, 2012 at 1:22 am

    #1556658

  • RE: restore log backups to another server

    transactional replication is also an option if the Server B database is only for reporting purposes

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    October 10, 2012 at 6:39 am

    #1547627

  • RE: Looking for guidelines on using the Tuning Advisor

    well then you got a starting point ...

    Run a SQL trace (not for hours just for those specific problimatic queries) and get the Dev's to execute all or some the...

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    August 8, 2012 at 8:03 am

    #1523125

Viewing 15 posts - 1 through 15 (of 111 total)