Justin Figg

VitaminDBA.com is a source of SQL Server News and Tips coming from a SQL Server sr. database analyst with 10 years of IT experience ranging from Windows Server, Network, and SQL Server administration. I upload articles on the blog on a fairly consistent basis with the intention of at least 1 new article a week.

Tracking Down tempdb usage

by Justin Figg

vitamindba

Determining what is causing your tempdb to grow can be difficult at times and troublesome during production issues. Luckily SQL...

2018-08-08

9,857 reads

SQL Server Availability Group Auto Seeding Error

by Justin Figg

vitamindba

SQL Server Availability Group Auto Seeding is a wonderful thing, it saves database administrators time when setting up availability groups. ...

2018-07-30

696 reads

Keep up with SQL Server Patches!

by Justin Figg

vitamindba

Keep up with SQL Server Patches with us with our feed from Microsoft. Check it out! http://vitamindba.com/sql-server-releases/
The post Keep up with...

2018-07-26

307 reads

Patch and Update SQL Server via Command Line

by Justin Figg

vitamindba

No one likes to patch or update SQL Server, it takes time and can make for very long days. I...

2018-07-25

11,566 reads

Set up Instant File Initialization for SQL Server

by Justin Figg

vitamindba

When a space growth operation is done within SQL Server (create, restore, auto-grow) the engine places zeros across the file...

2018-07-23

130 reads

Performance Tuning Exercise: Lazy Table Spool

by Justin Figg

vitamindba

Folks, it’s time for a bit of a performance tuning exercise. Below is a real world situation where a stored...

2018-07-18

23,002 reads

Install SQL via Windows Command Line

by Justin Figg

vitamindba

I have been on a mission to find easier ways to install SQL Server. I have recently been working on...

2018-07-13

1,990 reads

Save your execution plans!

by Justin Figg

vitamindba

Working with performance problems and query tuning can be a headache and take a lot of time. Most companies I...

2018-07-12

114 reads

Login Failed – Token-based server access validation failed for SQL Server

by Justin Figg

vitamindba

Login failures are a common item to troubleshoot with SQL Server. Out of all of the possible log failure reasons...

2018-06-26

197 reads

Transaction Logs and Availability Groups

by Justin Figg

vitamindba

Everyday I learn something new. A couple of days ago I posted about a problem I had with Always On...

2018-06-21

95 reads

Blogs

AI and Data Engineering on the Edge: The Good, the Bad, and the Overhyped

By Eduardo Pivaral

Running AI and data pipelines on the edge instead of the cloud has gone...

UNION vs UNIONALL: #SQLNewBlogger

While writing another post I realized my UNION query didn’t work as one might...

Deciphering Data Architectures Is Now Available in Multiple Languages

Since the release of my book Deciphering Data Architectures: Choosing Between a Modern Data...

Read the latest Blogs

Forums

Secure Cached Plans

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Secure Cached Plans

Complex Data Processing with dbt Python Models: The Fabric Modern Data Platform

Comments posted to this topic are about the item Complex Data Processing with dbt...

Over or Under Provisioned

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Over or Under Provisioned

Visit the forum

Question of the Day

Secure Cached Plans

The DMV, sys.dm_exec_cached_plans, contains rows for each cached plan on an instance. In Azure SQL Database, not every used has rights to every database, as there does exist an instance behind each database. How is security handled for this DMV in Azure?

See possible answers