ST

 

Excellence in SQL Server

  • HOME

  • EXPERTISE

  • BLOGS

  • CONTACT US

  • Blog

  • More

    • All Posts
    • AlwaysOn Availability Groups
    • Alerts
    • Trace Flags
    • Performance
    • Best Practice
    • Maintenance
    • Security
    • Configuration
    • Problems and Issues
    • SQL Server 2016
    • Tips and Tricks
    Search
    Adam Thurgar
    • Nov 26, 2018
    • 1 min

    Chaining job schedules

    If you have a number of jobs that need to run one after another then you could setup individual schedules for each job. The problem here ...

    2 views0 comments
    Adam Thurgar
    • Nov 19, 2018
    • 1 min

    DR - fixing problems found

    This is the third blog about DR. Whilst contracting at a major international investment bank, I was involved in their DR testing. Every 6...

    3 views0 comments
    Adam Thurgar
    • Nov 12, 2018
    • 1 min

    DR a simulated disaster # 2

    In part 1 of "DR a simulated disaster # 1", I blogged about a simulated DR with reduced staff. That was a stressful day. Recovering fro...

    2 views0 comments
    Adam Thurgar
    • Nov 5, 2018
    • 1 min

    DR a simulated disaster # 1

    A few years ago whilst being an FTE at a medium sized financial company, the CEO and the CIO decided to simulate a disaster to test our D...

    3 views0 comments
    Adam Thurgar
    • Oct 24, 2018
    • 2 min

    Synching SQL Agent jobs

    I was asked the other day how to make sure that all the SQL Server Agent jobs on a production server are the same on the DR server. This ...

    4 views0 comments
    Adam Thurgar
    • Oct 16, 2018
    • 1 min

    Indexes on foreign keys

    SQL Server automatically creates a clustered index on a primary key column/s. You can change this to be a non clustered index if required...

    2 views0 comments
    Adam Thurgar
    • Oct 10, 2018
    • 1 min

    Reading a transaction log file backup

    Have you ever had to find out what happened to your SQL Server. Who deleted that data? What event triggered something to happen. Sometime...

    1 view0 comments
    Adam Thurgar
    • Oct 3, 2018
    • 1 min

    Application and web site usability

    Recently I temporarily lost about 60 to 70% of my vision. Everything was blurry and reading/writing was really difficult. What I noticed...

    3 views0 comments
    Adam Thurgar
    • Sep 26, 2018
    • 1 min

    Power BI Desktop auto refresh

    I really like what I have been able to do with my Power BI Desktop prototype. I have now extended its functionality to start a SQL Server...

    7 views0 comments
    Adam Thurgar
    • Sep 20, 2018
    • 1 min

    What trace flags are on?

    Have you ever wondered about what trace flags are enabled on your SQL Server. With all the different 'best practices' for tempdb with -T1...

    7 views0 comments
    Adam Thurgar
    • Sep 11, 2018
    • 2 min

    Power BI Desktop prototype

    A friend asked me about automating their processes for providing financial information. It was all done in Excel and the input of data w...

    3 views0 comments
    Adam Thurgar
    • Sep 4, 2018
    • 1 min

    Corruption detection

    Currently I am looking at a database that is getting corrupted regularly. The table in question has over 1.3 billion rows with no cluster...

    5 views0 comments
    Adam Thurgar
    • Aug 23, 2018
    • 1 min

    Testing queries

    When you test potential changes to a query, how do you test it to make sure it is reliable and repeatable. One of the most common mistake...

    10 views0 comments
    Adam Thurgar
    • Aug 16, 2018
    • 1 min

    .NET Framework 3.5 SP1 required

    I started doing an installation of SQL Server 2014 on Windows Server 2016 Datacenter. The SQL Server installation iso had been downloaded...

    4 views0 comments
    Adam Thurgar
    • Aug 11, 2018
    • 2 min

    Baseline your SQL Server

    Have you ever got a new server (physical or virtual) and it just hasn't performed as you expected. It looks like it has all the right con...

    6 views0 comments
    Adam Thurgar
    • Jul 30, 2018
    • 1 min

    Documenting your SQL Server

    Not many people like writing documentation. DBA's especially. So when you have to document information on your SQL Servers how do you go ...

    10 views0 comments
    Adam Thurgar
    • Jul 24, 2018
    • 1 min

    Installation automation

    Having been asked to help build development and test environments in AWS for a client who is looking at moving all of their on premise da...

    4 views0 comments
    Adam Thurgar
    • Jul 17, 2018
    • 1 min

    Filestream

    From recollection, filestream was a feature introduced in SQL Server 2012. I just wonder if it will go the way of some other now abandone...

    2 views0 comments
    Adam Thurgar
    • Jul 10, 2018
    • 1 min

    Full Text Search

    A rarely used part of SQL Server is its' full text search capabilities. Honestly, it is quite a basic implementation of FTS but it can do...

    6 views0 comments
    Adam Thurgar
    • Jul 8, 2018
    • 1 min

    SQL Server Life 4 - Satisfaction

    Steve Jones from SQLServerCentral.com http://www.sqlservercentral.com/ asked in his editorial from the 5th of July to write 4 posts about...

    13 views0 comments
    12
    3
    45