June Blog Post Wrap-up

June Blog Post Wrap-up
Download PDF

KeePass – to improve your process

Before proceeding with the article, please take this quick password safety test …. Read More ….


TSQL Basics Part 12: OUTER APPLY – Video Explanation

Next, we have the OUTER APPLY. And this is a lot like, instead of an INNER JOIN, where it’s gonna be a lot like a LEFT OUTER JOIN between…. Read More ….


SQL Server Memory Hog Query

Mon, 28 Jun 2021

The article could be named, “How to use up all of your SQL Server available memory with a single CTE query.” Another name for the article could just be “SQL Server Bug Report” depending on how you look at it Read more…


Raving fan of June 2021

Fri, 25 Jun 2021

We contacted Steve when we were in desperate need of repair on a corrupted SQL database. After dealing with a couple of other vendors without success, we found Steve (Stedman Solutions) through a Google search that showed some promising review Read more…


TSQL Basics Part 11: CROSS APPLY – Video Explanation

Thu, 24 Jun 2021

This is part 11 of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each of these types of joins, and when they should be used. Then we’ll explore some common use Read more…


Rows and Range, Preceding and Following

Wed, 23 Jun 2021

These enhancements are often times referred to as the windowing functions. Overview:ROWS PRECEDING, FOLLOWING, UNBOUNDED, refer Read more…


TSQL Basics Part 10: CROSS JOIN – Video Explanation

Tue, 22 Jun 2021

This is part 10 of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each of these types of joins, and when they should be used. Then we’ll explore some common use Read more…


Finding tables that don’t have a clustered index.

Mon, 21 Jun 2021

Although clustered indexes are not required, and there are many cases where you should not use a clustered index, quite often clustered indexes can be overlooked when creating a table. This is actually more likely if you are inheriting Read more…


Raving fan of May 2021

Fri, 18 Jun 2021

We were moving our SaaS offering from one cloud provider to another and took the opportunity to evaluate our database performance and security ahead of the move. Steve and team worked with us to do an assessment of current stat Read more…


TSQL Basics Part 9: FULL OUTER JOIN – Video Explanation

Thu, 17 Jun 2021

This is part 9 of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each of these types of joins, and when they should be used. Then we’ll explore some common use Read more…


The time has come! SchemaDrift is Ready to Download!

Wed, 16 Jun 2021

Save yourself Time and Money with Steve Stedman’s new database comparison tool. Following in its cousin’s (Database Health Monitor) footsteps, SchemaDrift is FREE! It is currently in Beta phase but … Read more…


TSQL Basics Part 8: RIGHT OUTER JOIN w/ exclusion – Video Explanation

Tue, 15 Jun 2021

This is part 8 of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each of these types of joins, and when they should be used. Then we’ll explore some common use Read more…


SQL Daily Monitoring – SQL Server Versions

Fri, 11 Jun 2021

Here listed is the current percentages of SQL server versions running our Daily Check-up with Database Health Monitor. Compare this month’s percentages to Last Month’s …. Read more…


TSQL Basics Part 7: LEFT OUTER JOIN w/ exclusion – Video Explanation

Thur, 10 Jun 2021

So next we have the LEFT OUTER JOIN with exclusion. And this is one of my favorite ways to find missing data. And what this is Read More …


Get a List of Tables That Are Compressed

Wed, 9 Jun 2021

Modern versions of SQL Server have the option for row or page level compression. Here is the script to find those tables that have compression enabled… Read More …


TSQL Basics Part 6: ANTI SEMI JOIN – Video Explanation

Tue, 8 Jun 2021

the SEMI JOIN is what’s known as the ANTI SEMI JOIN. And this is simply changing the exists to not exists. And what… Read More ….


DBCC Shrink Fails with Error

Mon, 7 Jun 2021

Recently when shrinking a SQL Server data file, I ran into the following error: Read More …


TSQL Basics Part 5: SEMI JOIN – Video Explanation

Thur, Jun 2021

Okay, so there’s this thing that’s called a SEMI JOIN. And a lot of people may argue is really not a JOIN. But what …. Read More ….


TSQL Query to find the user the SQL services run as

Wed, Jun 2 2021

Occasionally I need to look up what user the SQL Server services are running as, and when this happens, you can either …. Read More ….

 

More from Stedman Solutions:

SteveStedman5
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!

Leave a Reply

Your email address will not be published. Required fields are marked *

*