Adam ThurgarNov 26, 20181 minChaining job schedulesIf 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 ...
Adam ThurgarNov 19, 20181 minDR - fixing problems foundThis is the third blog about DR. Whilst contracting at a major international investment bank, I was involved in their DR testing. Every 6...
Adam ThurgarNov 12, 20181 minDR a simulated disaster # 2In part 1 of "DR a simulated disaster # 1", I blogged about a simulated DR with reduced staff. That was a stressful day. Recovering fro...
Adam ThurgarNov 5, 20181 minDR a simulated disaster # 1A 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...
Adam ThurgarOct 24, 20182 minSynching SQL Agent jobsI 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 ...
Adam ThurgarOct 16, 20181 minIndexes on foreign keysSQL Server automatically creates a clustered index on a primary key column/s. You can change this to be a non clustered index if required...
Adam ThurgarOct 10, 20181 minReading a transaction log file backupHave you ever had to find out what happened to your SQL Server. Who deleted that data? What event triggered something to happen. Sometime...
Adam ThurgarOct 3, 20181 minApplication and web site usabilityRecently I temporarily lost about 60 to 70% of my vision. Everything was blurry and reading/writing was really difficult. What I noticed...
Adam ThurgarSep 26, 20181 minPower BI Desktop auto refreshI 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...
Adam ThurgarSep 20, 20181 minWhat 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...
Adam ThurgarSep 11, 20182 minPower BI Desktop prototypeA friend asked me about automating their processes for providing financial information. It was all done in Excel and the input of data w...
Adam ThurgarSep 4, 20181 minCorruption detectionCurrently I am looking at a database that is getting corrupted regularly. The table in question has over 1.3 billion rows with no cluster...
Adam ThurgarAug 23, 20181 minTesting queriesWhen 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...
Adam ThurgarAug 16, 20181 min.NET Framework 3.5 SP1 requiredI started doing an installation of SQL Server 2014 on Windows Server 2016 Datacenter. The SQL Server installation iso had been downloaded...
Adam ThurgarAug 11, 20182 minBaseline your SQL ServerHave 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...
Adam ThurgarJul 30, 20181 minDocumenting your SQL ServerNot many people like writing documentation. DBA's especially. So when you have to document information on your SQL Servers how do you go ...
Adam ThurgarJul 24, 20181 minInstallation automationHaving 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...
Adam ThurgarJul 17, 20181 minFilestreamFrom recollection, filestream was a feature introduced in SQL Server 2012. I just wonder if it will go the way of some other now abandone...
Adam ThurgarJul 10, 20181 minFull Text SearchA 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...
Adam ThurgarJul 8, 20181 minSQL Server Life 4 - SatisfactionSteve Jones from SQLServerCentral.com http://www.sqlservercentral.com/ asked in his editorial from the 5th of July to write 4 posts about...