Skip to content

Mohammad Darab

Consultant at Microsoft | Former MS MVP | CKA & CKAD

  • Home
  • About
  • Contact
  • Interviews
  • Speaking
  • Big Data Clusters

Category: SSMS

Posted on December 20, 2015April 27, 2018

How to Change Autogrowth in SQL Server 2012

It’s wise to set SQL Server file autogrowth to a set number rather than the default percent. That is because the percent setting can end up growing your file very large. The larger your file, the larger that percent will be. It’s better to set your file autogrowth to a set number and keep an eye on it for proper maintenance. Continue reading “How to Change Autogrowth in SQL Server 2012”

Posted on November 11, 2015July 20, 2018

How to Enable or Disable Intellisense in SSMS

If for some ODD reason you want to disable Intellisense in SQL Server Management Studio, there is a very easy way to do so.

How to Enable or Disable Intellisense in SSMS

Open SSMS – Click on Tools, Options, Expand Text Editor, Transact – SQL, and then click on Intellisense (check screenshot below) Continue reading “How to Enable or Disable Intellisense in SSMS”

Posted on September 13, 2015April 27, 2018

How to Refresh IntelliSense Cache in SSMS

I recently created a database called “testDB” and when I typed “USE testDB” in the SSMS Query window it gave me a little red squiggly underline (see below snapshot).use database red errorWhy did this happen when I just created a new database? That’s because the local IntelliSense cache hasn’t updated yet. Continue reading “How to Refresh IntelliSense Cache in SSMS”

Posted on September 4, 2015April 27, 2018

Gain More Real Estate in SQL Server Management Studio

The default layout in SSMS is too restrictive. I’m always having to scroll up and down and it gets pretty annoying. So I made a simple settings change that gives me more “real estate.” Continue reading “Gain More Real Estate in SQL Server Management Studio”

About Me

Mohammad Darab

Mohammad Darab

Data & AI at Microsoft | Former MS MVP | CKA & CKAD | Blogger & Speaker
Read more...

Search

Microsoft Data Platform MVP

MS MVP Logo - Mohammad Darab

Certified K8s Administrator

Certified Kubernetes Administrator

Certified K8s App Developer

Mohammad Darab Certified Kubernetes Application Developer

IDERA ACE Class of 2019

IDERA ACE Class 2019

Big Data Clusters Book

SQL Server Big Data Clusters Book

Newsletter

SQL Blog Awards

SQL server blogs

Mohammad Darab Blogger

Azure AI Fundamentals
Azure Fundamentals Mohammad Darab
Azure Data Fundamentals - Mohammad Darab

Popular Posts

  • How to Find Last Login Date of a SQL Server Login?
  • Could Not Locate Statistics In The System Catalogs of Secondary Replica
  • Dirty Reads vs Phantom Reads in SQL Server
  • Setup SQL Email Alert for Disk Space Usage
  • Create Database Audit for INSERT, UPDATE, DELETE in SQL Server

Categories

  • Audit
  • Availability Groups
  • Azure
  • Backup Restore
  • Big Data Clusters
  • Blog
  • Blog Stats
  • Certification
  • DBA Toolkit
  • DBCC
  • DMVs
  • Docker
  • Failover Cluster
  • Guest Blog
  • HA / DR
  • Hyper-V
  • Interview
  • Kubernetes
  • Lab
  • Linux
  • Perfmon
  • Performance Tuning
  • Professional Development
  • Review
  • Script
  • Security
  • SQLCMD
  • SQL Saturday
  • SQL Server
  • SQL Server 2019
  • SSMS
  • STIGs
  • Training
  • Troubleshoot
  • TSQL
  • User Group

DISCLAIMER

This is my personal blog. The opinions I express here do not represent those of my employer. The information I provide is on an as-is basis. I make no representations as to accuracy, completeness, currentness, suitability, or validity of any information on this blog and will not be liable for any errors, omissions, or delays in this information or any losses, injuries, or damages arising from its use.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Twitter
  • LinkedIn
  • YouTube
Proudly powered by WordPress