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: T-SQL

About Collations in SQL Server

Posted on 04/10/201904/24/2019 by Lincoln Bovee'

This post will be fore the purpose of documenting all my findings regarding Collations in SQL Server, including changing the collation on an…

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

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

A Visual Explanation of SQL Joins

Posted on 06/20/201606/20/2016 by Lincoln Bovee'

A good blog-post on joins from a visual aspect. Nicely done. A Visual Explanation of SQL Joins Views – 1396

Read More

Moving the TempDB database to a new drive

Posted on 03/22/201609/16/2017 by Lincoln Bovee'

Often you will need to add or move the tempDB data files, either to match the core count (up to 8 as best…

Read More

Resolving “Cannot resolve collation conflict for equal to operation”

Posted on 03/21/201605/10/2016 by Lincoln Bovee'

I recently had to run a query for one of our developers where the script was inserting a number of rows. All went…

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

T-SQL Querying and Query Processing Order

Posted on 06/23/201401/21/2019 by Lincoln Bovee'

The order in which we write T-SQL queries happen in this order:

1
2
3
4
5
6
SELECT
FROM
WHERE
GROUP BY
HAVING
ORDER BY

however, the order the Query Processor on SQL Server processes…

Read More

Posts navigation

1 2 3 4 Next

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

  • Calling all user group leaders! We want to present for you in 2020! 11/26/2019 Paul Randal
  • The Curious Case of… the failing SQL Server 2019 install 11/23/2019 Paul Randal
  • New Pluralsight course: SQL Server: Using SentryOne Plan Explorer 11/19/2019 Paul Randal
  • Updated sys.dm_os_waiting_tasks script to correctly parse nodeId 10/30/2019 Paul Randal
  • New Pluralsight exam prep course: SQL Server: Understanding Database Fundamentals (98-364) 10/30/2019 Paul Randal

RSS Brent Ozar’s Blog

  • Are You Underpaid? Let’s Find Out: The Data Professional Salary Survey is Open. 12/11/2019 Brent Ozar
  • Upsizing the SQL ConstantCare® Database Servers 12/09/2019 Brent Ozar
  • What Should We Change About This Year’s Data Professional Salary Survey? 12/04/2019 Brent Ozar
  • Updated First Responder Kit and Consultant Toolkit for December 2019 12/03/2019 Brent Ozar
  • SQL ConstantCare® Population Report: Fall 2019 12/02/2019 Brent Ozar
  • SQL Server Doesn’t Encrypt Data By Default. 11/27/2019 Brent Ozar

RSS Richard Siddaway’s PowerShell Blog

RSS SQLBlog.com Posts

RSS MSN PowerShell Blog

  • Improvements in Windows PowerShell Container Images 12/10/2019 Joey Aiello
  • PowerShell 7 Preview 6 11/22/2019 Steve Lee
  • PowerShell Extension Roadmap 11/04/2019 Sydney Smith
  • DSC Resource Kit Release October 2019 10/30/2019 Michael Greene
  • PowerShell 7 Preview 5 10/23/2019 Steve Lee
Powered by Newp WordPress Theme. © 2019 LincolnBlog.net. All Rights Reserved.