Skip to content

LincolnBlog.net

…my observations in the world of SQL Server, PowerShell, .Net etc…

  • Home
  • SQL Server
    • Administration
    • Diagnostics
    • Performance
    • Security
    • T-SQL
    • Tools
  • PowerShell
    • Remoting
    • Tools
  • Linux
  • .Net Development
    • Visual Studio
    • C#
    • MVC
    • ASP.NET
  • Servers
    • IIS
    • SharePoint
    • Hyper-V
    • MSMQ
  • Windows

Author: Lincoln Bovee'

PostgreSQL vs. SQL Server Notes

Posted on 02/13/201902/19/2019 by Lincoln Bovee'

This blog will be where I post my PostgreSQL administration learning and it’s comparison to SQL Server from a SQL Server DBA’s viewpoint.…

Read More

Restoring a database using STOPATMARK

Posted on 01/11/201901/11/2019 by Lincoln Bovee'

This post will demonstrate how to restore a database from a log file up to a certain LSN (typically the one right before…

Read More

Properly Taking a Cluster Offline for Disk Maintenance

Posted on 08/14/201808/14/2018 by Lincoln Bovee'

I recently needed to replace the older, slower attached disks on our clustered SQL instance offline so as to copy each drive to…

Read More

Building an AlwaysOn Availability Group SQL Cluster

Posted on 03/07/201801/17/2019 by Lincoln Bovee'

Here are the steps to build at SQL Server 2017 AlwaysOn Availability Group. We will be using Windows 2016 Standard 64-bit for the…

Read More

Some database design guidelines and best practices

Posted on 01/29/201803/12/2018 by Lincoln Bovee'

Below are some best practices known within the SQL Server database community use when designing tables. 1. All data columns should be properly…

Read More

SQL documentation tools and permissions required

Posted on 01/25/201801/26/2018 by Lincoln Bovee'

Database documentation tools like Devarts’ dbDocumenter will require, at a minimum, VIEW DEFINITION rights to the login:

1
2
3
4
USE myDatabase
GO
 
GRANT VIEW DEFINITION TO [DOMAIN\MyADGroup]

Views – 620

Read More

Random SQL tips and best practices

Posted on 06/20/201712/13/2017 by Lincoln Bovee'

Kevin Kline posted on wait states here with some valuable insight: TROUBLESHOOTING SQL SERVER WAIT STATS A number of these are from Adam…

Read More

PowerShell Robocopy GUI Tool – PowerCopy

Posted on 05/31/2017 by Lincoln Bovee'

Here is a very cool PowerShell script that creates a Windows form front-end GUI for RoboCopy: PowerShell Robocopy GUI Tool – PowerCopy Views…

Read More

What is a .TUF file in the DATA folder?

Posted on 05/30/2017 by Lincoln Bovee'

The TUF files you see in the ..\DATA folder is a “transaction undo file” which contains modifications to the database that were not…

Read More

Bulk-copy SQL Server Agent jobs to new server

Posted on 03/23/201703/23/2017 by Lincoln Bovee'

The easiest way to bulk-copy all SQL Agent jobs to a new server is to follow these steps 1. Load SSMS and connect…

Read More

Posts navigation

1 2 3 … 14 Next

Recent Posts

  • PostgreSQL vs. SQL Server Notes 02/13/2019
  • Restoring a database using STOPATMARK 01/11/2019
  • Properly Taking a Cluster Offline for Disk Maintenance 08/14/2018
  • Building an AlwaysOn Availability Group SQL Cluster 03/07/2018
  • Some database design guidelines and best practices 01/29/2018
  • SQL documentation tools and permissions required 01/25/2018
  • Random SQL tips and best practices 06/20/2017
  • PowerShell Robocopy GUI Tool – PowerCopy 05/31/2017
  • What is a .TUF file in the DATA folder? 05/30/2017
  • Bulk-copy SQL Server Agent jobs to new server 03/23/2017

RSS Paul Randal’s Blog

  • Using the Wait Statistics Report in Azure Data Studio 02/13/2019 Paul Randal
  • Changing the SSH port for a RHEL Azure VM 01/30/2019 Paul Randal
  • Twenty years ago today… 01/29/2019 Paul Randal
  • 2018 review: the year by the numbers 12/31/2018 Paul Randal
  • 2018: the year in books – a new record! 12/31/2018 Paul Randal

RSS Brent Ozar’s Blog

  • Updated First Responder Kit and Consultant Toolkit for February 2019 02/20/2019 Brent Ozar
  • What does Azure SQL DB Automatic Index Tuning actually do, and when? 02/19/2019 Brent Ozar
  • Building SQL ConstantCare® Version 2: Easy-to-Afford Monitoring 02/18/2019 Brent Ozar
  • [Video] How to Capture Baselines with sp_BlitzFirst 02/15/2019 Brent Ozar
  • Should you run SSAS/SSIS/SSRS on the SQL Server? 02/14/2019 Brent Ozar
  • How fast can a $21,468/mo Azure SQL DB load data? 02/13/2019 Brent Ozar

RSS Richard Siddaway’s PowerShell Blog

  • PowerShell v6.1.3 install problem 02/19/2019
  • PowerShell v6.1.3 02/19/2019
  • Testing the operating system 02/18/2019
  • PowerShell v6 experimental features 02/13/2019
  • To install or not 01/31/2019

RSS SQLBlog.com Posts

  • SQL Server Data Migration: Tools and Services 01/19/2019
  • SQL Saturday Pordenone is back! Discover the 2019 edition! 01/05/2019
  • Compare SQL Server, MySQL and PostgreSQL Features 10/29/2018
  • Discover how SQL Server can use Python to access any NoSQL engine 10/26/2018
  • My AWS Aurora Postgres instance is 100% CPU. What’s next? 10/26/2018
  • The 3rd edition of the ebook SQL Server Execution Plans 10/24/2018

RSS MSN PowerShell Blog

  • DSC Resource Kit Release February 2019 02/21/2019 Katie Kragenbrink [MSFT]
  • Parsing Text with PowerShell (3/3) 01/28/2019 Steve Lee
  • Parsing Text with PowerShell (2/3) 01/24/2019 Steve Lee
  • The PowerShell-Docs repositories have been moved 01/24/2019 Sean Wheeler (PowerShell)
  • Announcing the PowerShell Preview Extension in VSCode 01/23/2019 Sydney Smith [MSFT]
Powered by Newp WordPress Theme. © 2019 LincolnBlog.net. All Rights Reserved.