Who’s Hiring in the Microsoft Data Platform Community? October 2022 Edition
Is your company hiring for a database position as of October 2022? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must in …
Delivering Cloud Transformation Excellence: Collaboration, Communication and Governance – Part 6
The post Delivering Cloud Transformation Excellence: Collaboration, Communication and Governance – Part 6 appeared first on SQLServerCentral.
Transaction locking and row versioning guide
The post Transaction locking and row versioning guide appeared first on SQLServerCentral.
The Basics of Inserting Data into a SQL Server Table
Entry in Greg Larsen series on Learning T-SQL. The series so far: The basic T-SQL Select Statement Ordering a result set in SQL Server The ins and outs of joining tables in SQL Server Summarizing data using GROUP BY and HAVING The Basics of Inserting D …
Erik Darling’s Month of Free Tools Training
Over the past month (plus or minus a couple days), Erik Darling churned out dozens of posts to show how he uses different SQL Server Community Tools that are free and open source to troubleshoot SQL Server issues. You should read all of them. I did. (I …
October is Free Fundamentals Month – And The Training Starts Now.
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. This week is Fundamentals of Index Tuning. To follow along with t …
Convert Problematic Data in SQL Server
The post Convert Problematic Data in SQL Server appeared first on SQLServerCentral.
Join the EAP: Next-gen database cloning
The post Join the EAP: Next-gen database cloning appeared first on SQLServerCentral.
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 …