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

SQL TECH BLOG

Category: Tools

Azure Purview Best Practice: Naming your scans

August 12, 2021 Daniel Janik

If you’ve ever been a DBA and seen the mess that you get with SQL Agent Jobs without a clean naming standard for your job schedules and job names then you’ll appreciate this tip.

Read More »

SSMS Quick Tip: Never lose your script from overwrite again!

May 7, 2020 Daniel Janik

Twenty something years ago when I started my SQL Server career there was an amazing tool called Query Analyzer. Honestly I’d say if Microsoft did nothing more than bring this tool back and call it Azure Data Studio I would have been excited and beyond happy.

Read More »

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 »

Azure Data Factory trigger tip

April 30, 2020April 30, 2020 Daniel Janik3 Comments

This tip comes from my DBA days working with SQL Agent Job schedules. If you’ve ever worked on a server where many people created job schedules you’ll know exactly what I mean when I say the schedule names can be really annoying.

Read More »

SSMS Quick Tip

April 30, 2020 Daniel Janik

Today’s quick tip is for SQL Server Management Studio (SSMS). From time to time when I’m speaking I’ll get a question on how I pulled up help for a given DMV or table.

Read More »

Deploy BACPAC to Azure Managed Instance failing from SSMS?

April 3, 2020 Daniel Janik

Recently I ran into an error when trying to copy a small database bacpac into an Azure Managed Instance. It’s said that SSMS is able to do this task. Let’s see it in action.

Read More »

Azure Data Studio extension – help wanted

February 13, 2020 Daniel JanikLeave a comment

I’ve created a sample ads extension that checks TSQL syntax in real-time for potential bad practice.

Read More »

Quick tip: Quickly bulk edit lines in SSMS

February 12, 2020 Daniel JanikLeave a comment

Have you ever needed to bulk edit a table from excel to change it into a group of insert statements or change multiple query lines?

Read More »

Taking a gamble on Azure Data Studio Notebooks

May 30, 2019 Daniel JanikLeave a comment

If you’re a data professional or application developer chances are you’ve run into Microsoft SQL Server once or twice.

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 »

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...