Skip to content

SQL Nuggets

Nuggets Of SQL Server Knowledge

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

Author: Eric Cobb

Errors

PSSDIAG Error: There Is No Instance Named X

I’m writing this as a reminder to myself for a problem I just had to solve. When running the PSSDIAG tool, if you are running it against SQL 2016 SP2 …

Configurations / DB Engine / Indexes

Disabling An Index Drops Compression

This post is more of an FYI, and to remind myself in case I run into it again down the road. Here at work we have a very large, very …

Career

I Am Now A Microsoft Certified Trainer

I am very excited to announce that as of yesterday I am now a Microsoft Certified Trainer (MCT)! This is something that I have been wanting to do for years, …

Availability Groups / Configurations

Does SQL Server Now Distribute Transactions Evenly Across Multiple Log Files?

It is generally known throughout the SQL Server world that having multiple log files on a database is not a good idea. While multiple data files spread across multiple drives …

Configurations / PowerShell

Setting Drive Allocation Unit Size With PowerShell

There seems to be some ongoing debate around whether or not formatting your data and log drives with 64KB allocation unit size even matters anymore. I would encourage you to …

Configurations / Corruption / PowerShell / SQL Agent

Setting Up Database Mail And SQL Agent Alerts With PowerShell

As a DBA, you need to know when there’s a problem on your SQL Servers. And while I highly recommend you use a full-fledged monitoring system, there are also some …

Conferences

Slides From SQL Saturday Tampa 2020

SQL Saturday Tampa 2020 was this past weekend , and I have to say that I really enjoyed it! This was my first time at the Tampa event, and I …

Configurations / PowerShell

Disable Telemetry On Multiple SQL Servers With PowerShell

Starting with SQL Server 2016, when you install SQL Server it also installs the CEIP (Customer Experience Improvement Program) Services, also known at Telemetry. In previous versions of SQL Server …

Conferences

Speaking At SQL Saturday Tampa 2020

In just a little over 3 weeks I’ll be speaking at SQL Saturday Tampa 2020! This event will be held on Feb 29 2020 at USF MUMA College of Business, …

Conferences

Slides From SQL Saturday Nashville 2020

The slides from my presentation “How To Be The DBA When You Don’t Have A DBA” can be downloaded here. In this particular presentation there are a lot of links …

Posts navigation

Older posts
Newer 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
  • Using PowerShell To List Folders And Sizes
  • Performance Problem When Using OR In A JOIN
  • Patching Multiple SQL Servers With Powershell and dbatools
  • SQL Scripts: How To Find Index Fragmentation

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