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

SQL TECH BLOG

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 »

Using PyApacheAtlas to import SQL Server extended properties to Azure Purview

August 11, 2021 Daniel Janik

Azure Purview is a compliance and data governance platform in Microsoft’s Azure cloud. The platform is currently in public preview and has quite a few features; but, does not currently import any of the extended properties that you may have added over the years to your SQL Server objects.

Read More »

AWS Community Builders #AWSCommunity

July 30, 2020 Daniel Janik

AWS Community Builders social medium ALT

I’m excited and happy to announce that I’m part of the AWS Community Builders.  Check out more on Twitter with the #AWScommunity tag. To learn more about the program and other cool things that AWS is doing in the cloud, check out this blog from AWS:

https://aws.amazon.com/blogs/aws/announcing-the-new-aws-community-builders-program/

Running SQL Server in Google Cloud Platform

July 6, 2020 Daniel Janik

On a few occasions I’ve referred to GCP (Google Cloud Platform) as the “Windows Phone of cloud providers” and what I meant by that is they have a great product that little market share when compared to Azure and AWS; but, should you be looking at GCP?

Read More »

Living in the new normal as a data engineer

June 28, 2020 Daniel Janik

For the past few months most of the world has been in quarantine and you may think that this is the new normal, especially now that “re-opening” has been rolled back or paused in many places.

Read More »

SQL Server 2019 CU5 is out

June 24, 2020June 24, 2020 Daniel Janik

Earlier this week Microsoft released the latest cumulative update for SQL Server 2019 and as you can expect there are quite a few items addressed including a fix for UDF inlining that I had posted on recently. You can find the update and a complete list of fixes here:

https://support.microsoft.com/en-us/help/4552255/cumulative-update-5-for-sql-server-2019

Weekend Cloud Comic

June 19, 2020 Daniel Janik

I got a mailer for “The Container Store” this week and thought of the following scenario so I figured I’d hand-draw a comic to lighten your weekend. Enjoy!

ContainerComic

SQL 2019 UDF (User defined function) inlining

June 9, 2020June 24, 2020 Daniel Janik

SQL Server 2019 brings a lot of great new features. Many are introduced by the IQP (Intelligent Query Processing) features and greatly improve query performance.

Read More »

Which Azure Data Platform service should I choose?

May 17, 2020 Daniel Janik

So you’ve decided to use Azure for your existing or new data project? This blog series is focused on choosing the right technology for your project. It’s tough right? So many options and so many variables. This post will focus more on the cost of choices.

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 »

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