Tags » Microsoft SQL Server

SQL server generate high NetLogon traffic due to missing / incorrect SPN.

I got an opportunity to work with one of the customer where AD team reported that they were observing high NetLogon requests on DC’s originating from SQL servers. 1,485 more words

Microsoft SQL Server

Find Currently Executing Jobs Running Longer Than 30 Day Average

–By Lori Brown   @SQLSupahStah

I needed to update some of our long running job monitoring code to improve it from the version that we have right now. 476 more words

SQL Server

MS SQL Server AlwaysOn

I continued to explorer my skills and knowledge on MS SQL Server 2016 on AlwaysOn.

I have been tested and  setup three (3) nodes clustering that running on VMWare environment on MS Window Server 2012 R2: 73 more words

Microsoft SQL Server

What is COPY_ONLY?

You’ll frequently hear that you should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up the backup chain. Just in case you haven’t: You should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up the backup chain. 782 more words

Microsoft SQL Server

SQL 2016 SP1 USE HINT

–By Lori Brown   @SQLSupahStah

After installing Service Pack 1 for SQL 2016, I ran across USE HINT and thought I would put out what I could find to document it. 649 more words

SQL Server

Why won't my SQL Logins work?

I recently had an interesting time getting the SQL Auth logins on a new instance working. I was doing a side by side upgrade and the only server principals used by the application were SQL Server authenticated logins. 298 more words

Microsoft SQL Server