How to work with Python in Azure Data Studio
Introduction In this article, we will learn how to use Python in Azure Data Studio. Azure Data Studio is a great tool to handle your data, work with your notebooks and create your code. Python is one of the most popular programming languages in the ent …
Generating Repeatable Sets Of Test Rows
In order to test graph structures, I needed a large set of random data. In some ways, this data will resemble the IMDB database I will include later in this chapter, but to make it one, controllable in size and two, random, I created this random datase …
[Video] Office Hours: Ask Me Anything at the Mediterranean Sea
On the last day of my Israel trip, I went through the highly upvoted questions from https://pollgab.com/room/brento and answered ’em, standing in front of the beach. Here’s what we covered: 00:00 Start 00:37 AllThePartyPeople: On our server …
The Redgate 100: Top Influencers List
The post The Redgate 100: Top Influencers List appeared first on SQLServerCentral.
How to Build a Data Science Time Series Model with SQL Server
The post How to Build a Data Science Time Series Model with SQL Server appeared first on SQLServerCentral.
T-SQL Language Changes in SQL Server 2022 Part 2
SQL Server 2022 is in preview and I wrote a previous article on the T-SQL language changes. This article is a second part, covering a few more of the changes in T-SQL that are coming with this new version of the database platform. The previous article …
Vegas Home Office Tour
I’ve been teaching online from home for years, and you’d probably think my office would keep growing and growing – but actually, my setup has gotten a lot smaller since the last time I blogged about it. I don’t really need space …
Free Live Webcast: Why is One Query Sometimes Slow and Sometimes Fast?
Sometimes the exact same query goes slow out of nowhere. Your current fix is to update statistics, rebuild indexes, or restart the SQL Server. It works, but you don’t know why. The single most common reason is parameter sniffing. SQL Server “snif …
Easy and Cost Effective way to Encrypt Every SQL Server Database
The post Easy and Cost Effective way to Encrypt Every SQL Server Database appeared first on SQLServerCentral.
Redgate Summit: The Database DevOps Transformation
The post Redgate Summit: The Database DevOps Transformation appeared first on SQLServerCentral.
Buckle Up: October is Free Fundamentals Month!
How about some completely free SQL Server training? Every weekday during the month of October, one of the modules from my Fundamentals classes will be absolutely free to watch. But you gotta watch it that day – you snooze, you lose. To prep, bloc …
Time to register for PASS Data Community Summit
The post Time to register for PASS Data Community Summit appeared first on SQLServerCentral.
How to Visualize Python Charts in Power BI Part 4
Introduction This is the 4th part of the topic of how to visualize Python charts in Power BI (part one, two, and three). Previously, we talked about violin plots, box plots, and hexagonal binning plots. In this chapter, we will cover the following topi …
PostgreSQL Triggers Part 2
Article Overview In this article, we will learn how to drop, alter, enable, and disable a PostgreSQL trigger. In the 1st part of this series, we got an overall view of database triggers, PostgreSQL-specific triggers, types of PostgreSQL triggers, and h …
Optimize Large SQL Server Insert, Update and Delete Processes by Using Batches
The post Optimize Large SQL Server Insert, Update and Delete Processes by Using Batches appeared first on SQLServerCentral.