Skip to content
  • Home
  • About
  • Resources
  • Twitter
  • LinkedIn
Search
Close

SQL TECH BLOG

Tag: Performance

May the forced be with you?

May 4, 2020May 5, 2020 Daniel Janik

Today is May the fourth and I’ll start by saying: Happy Star Wars day to all. Since it is May the fourth I figured a Star Wars themed post would be nice.

Read More »

Free SQL tuning tool: How’s My Database?

February 13, 2019February 13, 2019 Daniel Janik1 Comment

It’s taken longer than I thought it may and I’ve run into several problems along the way but had a few people in the MVP community swing some homeruns to help me complete the BETA of this new SQL Server community query tuning tool.

Read More »

Are scalar functions really a bad thing?

September 10, 2018September 10, 2018 Daniel Janik6 Comments

I’ve read a lot of things lately pointing to scalar functions as if they were the devil. In this blog I’m going to explore if that’s the case. Let’s have a look.

Read More »

Back to basics: What is a HEAP table?

May 16, 2018May 23, 2018 Daniel Janik2 Comments

Understanding the fundamentals is key for success, with everything you do. These days SQL Server has expanded into much more than just a database; but, products that ingest data for analysis still need to get the data from a source, such as an OLTP SQL database.Read More »

SQL Tuning: Finding statements for missing indexes

April 20, 2018April 20, 2018 Daniel Janik1 Comment

Missing indexes are an important part of the indexing strategy. I usually start with sys.dm_db_index_usage_stats to find both inefficient and unused indexes and then supplement with missing indexes.

The missing index DMVs are great but they’ve always been missing something.

Read More »

Query tuning: Apply yourself

April 6, 2018 Daniel Janik1 Comment

It’s Friday and I’m ready for the weekend as I’m sure everyone else is. This weekend I’m looking forward to getting yard work done and browsing through the whoisactive SQL Ops Studio extension code.

Read More »

SQL Server: The danger of large data types

September 22, 2017September 25, 2017 Daniel Janik1 Comment

Databases are platforms that are designed to securely store and retrieve your data. Perhaps that’s why they’re called a data “base”? So if your data is in a base, you’d want to lay it out in some logic way.

Read More »

SQL Server: SARGability part 2

September 6, 2017 Daniel Janik1 Comment

In case you missed the first post on this topic, you can read it here: SQL Server: SARGability. This post continues the series and today we’re going to discuss the dangers of functions.

Read More »

DBA 101: Tuning lookups

April 27, 2017April 27, 2017 Daniel JanikLeave a comment

Sometimes it helps to go back to the basics and indexing is always a great topic. SQL Server has a wide variety of indexes; but, today we’re going classic and talking about Non-clustered indexes.

Read More »

Query tuning 101: What’s a probe residual?

April 17, 2017April 17, 2017 Daniel Janik1 Comment

Query tuning is an important process that will probably never go away and sharpening your tuning skills is always a good idea.

I’ve spoken on this topic many times and talked about probe residuals before. Mostly at SQL Saturday events and for some online webinars.

Read More »

Posts navigation

Older Posts
Welcome to SQLTechBlog.com. We are dedicated to posting high quality news and blogs concerning Microsoft SQL Server.

I'm speaking!

  • 2016-06-11 | SQLSaturday #528 | Curacao
  • 2016-07-14 | Query Plan Analysis | MSSQLTips Webcast
  • 2016-08-06 | SQLSaturday #515 | Baton Rouge
  • 2016-08-13 | SQLSaturday #550 | San Antonio
  • 2016-08-27 | SQLSaturday #553 | Oklahoma City
  • 2016-09-24 | SQLSaturday #563 | Dallas
  • 2016-10-26 | PASS Summit 2016 | Seattle
  • 2017-04-20 | PASS NTSSUG | Dallas
  • 2017-10-07 | SQL Saturday #678 | Orlando
  • 2018-06-09 | SQLSaturday #773 | Los Angeles
  • 2018-06-23 | SQLSaturday #766 | Houston
  • 2018-08-11 | SQLSaturday #749 | Baton Rouge

Other Blogs I like

  • Shane O'Neill
  • SQLKitten.com

Follow me

  • View @SQLSME’s profile on Twitter
  • View sqlsme’s profile on Instagram
  • View danielcjanik’s profile on LinkedIn

Subscribe

RSS Feed

Follow SQL TECH BLOG on WordPress.com

Recent Posts

  • Azure Purview Best Practice: Naming your scans
  • Using PyApacheAtlas to import SQL Server extended properties to Azure Purview
  • AWS Community Builders #AWSCommunity
  • Running SQL Server in Google Cloud Platform
  • Living in the new normal as a data engineer

Tags

#ThanksToAll Administration AWS Azure Best Practice bug? Career Clippy Compliance Data Catalog DBA Development Gaming gdpr Linux Management Studio Monday comic Monitoring Off Topic Oracle PASS Performance Purview Query Plans Query Tuning security Speaking SQLOpsStudio SQL Saturday sql server SQL Server 2016 SQL Server 2017 Storage Tools

Categories

  • Administration
  • Arduino
  • AWS
  • AWSCommunity
  • Azure
  • Azure Data Factory (ADF)
  • Azure Data Studio
  • Career
  • Comic
  • Compliance
  • DBA
  • Development
  • Gaming
  • GCP (Google Cloud Platform)
  • Google
  • Governance
  • Help Wanted
  • IoT
  • Learning
  • life
  • Linux
  • Migration
  • MSDOS
  • Off Topic
  • Oracle
  • Performance
  • PowerShell
  • Purview
  • Python
  • Query Plans
  • Query Tuning
  • security
  • Speaking
  • SQL Saturday
  • sql server
  • SQLOpsStudio
  • Storage
  • Sustainability
  • Thank you
  • Tools
  • Uncategorized

Archives

  • August 2021
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • February 2020
  • May 2019
  • February 2019
  • September 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
Blog at WordPress.com.
Back to top
  • Follow Following
    • SQL TECH BLOG
    • Join 67 other followers
    • Already have a WordPress.com account? Log in now.
    • SQL TECH BLOG
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...