Profile cover photo
Profile photo
John Rutherford
198 followers -
Here I am!!
Here I am!!

198 followers
About
Posts

Post has attachment
Getting SQL Server 2017 Running with Docker
My laptop at work was recently upgraded to Windows 10 Enterprise. One of the exciting things for me about the Windows 10 roll-out is that now I am able to use Docker to launch container images without having to install/uninstall software. If you don't know ...
Add a comment...

Post has attachment
Viewing Data from an Extended Event File
I got the idea for this post from a blog post by Paul Randall: Capturing Wait Stats for a Single Operation. He shows how to use an extended event session to capture wait stats and then how to pull that data into a temp table. It was very helpful but it didn...
Add a comment...

Post has attachment
Using Symbolic Links with SSMS templates
For years I have used the template browser in SQL Server Management Studio to store commonly used queries. I have created a sub-folder prefixed with 'aa_ ' so it is listed first then created more sub-folders under that to store my various queries. Then i ha...
Add a comment...

Post has attachment
Windows 10, Credential Guard and Linked Servers
Currently we are looking into upgrading the user desktops and laptops to Windows 10. During testing we ran into an issue using Linked Servers. Any time you attempted to run a query against a linked server you would get a Anonymous Logon error On the machine...
Add a comment...

Post has attachment
Getting Replication Snapshot Delivery Times
Getting Replication Snapshot Delivery Times We use transactional replication quite heavily in our environment. We have multiple publishers, distributors and subscribers. Currently we have three subscribers overseas, one in London and two in Sydney. When we ...
Add a comment...

Post has attachment
**
Getting Started with Dbatools When I started using PowerShell with SQL Server I used a module from CodePlex named SQLPSX. The module provided quite a few functions that made working with SQL server easier. But today Codeplex is gone and I don't think anyone...
Add a comment...

Post has attachment
The Curious Case of Compression - An Availability Group Story
After we started using SQL 2014 availability groups in the corporate environment we ran into a few isolated situations where the business asked us to turn off synchronous replication between the HA nodes because the performance was unacceptable. The DBA tea...
Add a comment...

Post has attachment
The Curious Case of Compression - An Availability Group Story
After we started using SQL 2014 availability groups in the corporate environment we ran into a few isolated situations where the business asked us to turn off synchronous replication between the HA nodes because the performance was unacceptable. The DBA tea...
Add a comment...

Post has attachment
Dynamic Quorum and Dynamic Witness in Windows 2012 R2
The Setup The DBAs  where I work were having a discussion this week about how we should setup Quorum on clusters that have different sets of nodes. We looked at our current setups and noticed that there are some inconsistencies. Some have a File Share Witne...
Add a comment...

Post has attachment
TempDB and SQL 2005
Recently I found some more evidence in support of pre-sizing TempDB and turning off auto-grow. We have a server that has starting having disk issues with TempDB every time it reboots. The server is SQL 2005 SP3 CU11 and when it reboots the TempDB drive fill...
Add a comment...
Wait while more posts are being loaded