Skip to content

SQL Nuggets

Nuggets Of SQL Server Knowledge

Menu
  • Home
  • Blog
  • Speaking
  • Presentations
  • Downloads
  • About

Author: Eric Cobb

Indexes / Performance Tuning

The Power Of Proper Indexing

This image is an actual screen shot of one of our production SQL Server’s CPU usage, taken from our SQL Sentry monitoring system. Obviously this server was under some strain. …

Corruption / DB Engine / Errors

Yikes! Cannot recover the master database!

Recently, during patching for a 2019 SQL Server, the SQL services refused to start after the patching. It was throwing the following heart attack inducing error: Cannot recover the master …

PowerShell

PowerShell: Compare Users’ AD Groups

When it comes to user logins and permissions in SQL Server, I typically prefer to use Active Directory groups. The problem with that is that you don’t always know what …

Conferences

Slides From My March 17th 2021 Geek Sync

You can download the slides from today’s How To Be The DBA When You Don’t Have A DBA Geek Sync here.

Configurations / DB Engine

Upcoming IDERA Geek Sync – March 17th, 2021

Don’t miss my upcoming IDERA Geek Sync, How To Be The DBA When You Don’t Have A DBA, this Wednesday, March 17, 2021. This webinar is for the “Accidental DBA”: …

DB Engine / Indexes

Will You Run Out Of INT And BIGINT Identities In SQL Server?

In the war over Identities vs GUIDs as clustered indexes, one of the arguments in favor of Unique Identifiers is that you may run out of numbers when using a …

Configurations / PowerShell

Setting The Database Owner, Compatibility Level, And Recovery Model With PowerShell

One of the great things about dbatool is that it allows you to run commands against multiple things. Sometimes you may need to run the same command on every server, …

PowerShell

Upcoming Geek Sync: Practical PowerShell For The Busy DBA

Be sure to sign up for my upcoming IDERA Geek Sync, Practical PowerShell For The Busy DBA on November 19th, 2020 at 11:00 AM CT. I will be focusing on …

Configurations / Errors

SQL Server Crashes When Hitting 80 Percent RAM Usage

I recently ran into a situation where a new SQL Server would crash hard every time it would get under a load. Here is a synopsis of what we were …

Conferences

Be Proactive: A Good DBA Goes Looking For Signs of Trouble

Last month I did a session for IDERA Live 2020. This is a free, one day virtual conference put on by IDERA each year, and this year’s focus was “How …

Posts navigation

Older posts

Search

2020 IDERA ACE
MSCE: Data Platform

SUBSCRIBE VIA RSS

RSS Feed RSS - Posts

Subscribe via Email

Receive notifications of new posts by email.

Categories

  • Availability Groups
  • Azure
  • Backups
  • Career
  • Conferences
  • Configurations
  • Corruption
  • DB Engine
  • Errors
  • Extended Events
  • Indexes
  • Management
  • MongoDB
  • Monitoring
  • Open Source Projects
  • Performance Tuning
  • PowerShell
  • Security
  • SQL Agent
  • SQL Scripts
  • SSIS
  • System Views
  • T-SQL
  • Tools

Recent Posts

  • The Power Of Proper Indexing
  • Yikes! Cannot recover the master database!
  • PowerShell: Compare Users’ AD Groups
  • Slides From My March 17th 2021 Geek Sync
  • Upcoming IDERA Geek Sync – March 17th, 2021

Top Posts

  • SQL Scripts: How To Find Missing Indexes
  • Performance Problem When Using OR In A JOIN
  • SQL Scripts: How To Find Index Fragmentation
  • Patching Multiple SQL Servers With Powershell and dbatools
  • Using PowerShell To List Folders And Sizes

Tags

Automation Azure Migration Backups Bad T-SQL Client Tools Clustered Indexes Database Mail Database Maintenance Data Files Data Storage dbatools DBCC CheckDB Encryption Execution Plans Express Edition Getting Started Index Basics Internals Log Files Music City Data Musings NOLOCK Nonclustered Indexes NoSQL Performance Permissions Presentations Quickies Server Administration Speaking SQL Agent SQL Index Insight SQL Metrics Pack SQL Permissions Manager SQL Saturday SQL Sentry SQL Server 2008 R2 SSMS Storing Passwords System Procedures Top Developer Tips Trace Flags Training Transaction Isolation Levels Visual Studio
Copyright © 2021 SQL Nuggets – OnePress theme by FameThemes
This website uses cookies to improve your experience. To find out more see our Privacy & Cookies Policy. Accept
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT