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

Category: Tools

PostgreSQL vs. SQL Server Notes

Posted on 02/13/201903/30/2020 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

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 – 1439

Read More

My Microsoft Code Extensions

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

Here are the current set of MS Code extensions I use on a daily basis. Views – 2259

Read More

Devart Studio for SQL Server Issues

Posted on 12/18/201512/18/2015 by Lincoln Bovee'

I am documenting known issues I have run into with Devarts’ Studio for SQL Server here. I want to state up front that…

Read More

PASS 2015 – Seattle WA – Day 3

Posted on 10/28/201512/03/2015 by Lincoln Bovee'

PASS 2015 10-28-30 Seattle WA SQL Server Indexing for Performance Kimberly Trip NOTE: Narrow NC indexes very rarely are useful. NOTE: Putting a…

Read More

PASS 2015 – Seattle WA – Pre-Con Day 2 – Dmitri Korotkevitch

Posted on 10/28/201502/12/2016 by Lincoln Bovee'

PASS 2015 10-27-30 Seattle WA Pre-Con Day 2 – SQL Server Internals – The Practical Angle Dmitri Korotkevitch Data Storage 101 Data Pages…

Read More

Using SQL Server 2012 Performance Dashboard Reports

Posted on 01/29/201401/21/2019 by Lincoln Bovee'

Below is the link to install (on your local workstation instance of SSMS) the SQL Server 2012 Performance Dashboard Custom Reports. SQL Server…

Read More

Using SQL Profiler to trace a sproc

Posted on 01/10/2014 by Lincoln Bovee'

Using SQL Profiler to trace a Stored Procedure call Views – 1625

Read More

Recent Posts

  • About TempDB and the Version Store 07/16/2019
  • Using PowerShell to Failover Availability Groups and WFC Cluster Nodes 05/21/2019
  • About Availability Groups Database Seeding 04/19/2019
  • About Collations in SQL Server 04/10/2019
  • PostgreSQL vs. SQL Server Notes 02/13/2019
  • Restoring a database using STOPATMARK 01/11/2019
  • Availability Groups: Things to remember 12/07/2018
  • 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

RSS Paul Randal’s Blog

  • The Mentoring Class of 2023 12/20/2022 Paul Randal
  • Mentoring 2023 – want some help from me? 12/01/2022 Paul Randal
  • The Curious Case of… community 11/27/2022 Paul Randal
  • The Curious Case of… disconnected AG secondary replica and transaction log out of space issue 10/18/2022 Paul Randal
  • The Curious Case of… eager writing and minimally-logged operations 04/12/2022 Paul Randal

RSS Brent Ozar’s Blog

  • [Video] Office Hours: 22 Good Questions and a Stinker 02/02/2023 Brent Ozar
  • [Video] Office Hours: Quickie Before Dinner 02/01/2023 Brent Ozar
  • Office Hours, ChatGPT Edition: AI Answers 4 of Your Questions 01/31/2023 Brent Ozar
  • [Video] Office Hours: Ten Minutes of SQL Server Answers 01/26/2023 Brent Ozar

RSS Richard Siddaway’s PowerShell Blog

  • Time for cube calculation 01/29/2020
  • Spheres 01/29/2020
  • Recent releases 01/28/2020
  • Circles 01/28/2020
  • VScode improvement 12/31/2019

RSS SQLBlog.com Posts

RSS MSN PowerShell Blog

  • PowerShell/OpenSSH Team Investments for 2023 01/23/2023 Steve Lee
  • PowerShell Extension for Visual Studio Code January 2023 Update 01/21/2023 Sydney Smith
  • PowerShellGet 3.0 Preview 18 01/12/2023 Sydney Smith
  • Announcing PowerShell Crescendo 1.1.0-preview01 12/06/2022 Jason Helmick
  • PowerShell Extension for Visual Studio Code October 2022 Update 12/05/2022 Andy Jordan
Powered by Newp WordPress Theme. © 2023 LincolnBlog.net. All Rights Reserved.