| | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
|
| Tell Your Loved Ones You Care The Data Platform community lost a couple of people this week. Euan Garden and Dean Vargas. These were good people. They're going to be sorely missed. While I wanted to say something profound about them, I don't think I can do them justice. They were both simply good. The kind of people you want to be around. The kind of people you want to emulate. I'm not sure what else I can add to that. Instead, I want to encourage you to cherish those around you that you care for. Let them know you care. It's sad, and more than a little horrifying, to say, but you might not get a second chance. Me, I'm off to give my wife another hug. She's been getting a lot of those this week. Grant Fritchey Join the debate, and respond to the editorial on the forums |
| The Weekly News | | All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit. |
| Vendors/3rd Party Products |
| Phil Factor demonstrates some PowerShell tasks that will produce a high-level overview, or narrative, of the main differences in the metadata between two versions of a database, during Flyway Teams migrations. |
| Tony Davis describes a typical database development cycle and deployment pipeline supported by Redgate Deploy. It allows branch-based database development, using disposable databases (clones) and version control tools, promotes continuous integration and testing of changes and automates the build and deployment processes so that they are repeatable, fast and reliable. |
| SQL Monitor allows you to bring your whole estate into a single monitoring landscape that has a consistent interface, whether you have an all-Azure environment, or, more likely, a mixed database environment. Find out more, here! |
| AI/Machine Learning/Cognitive Services |
| In this article we look at how to use the Power BI... |
| In a year that felt far from normal, data manageme... |
| Administration of SQL Server |
| Introduction As I look at SQL Server instances “... |
| Here in this blog, we are going to demo how to c... |
| Introduction Creating SQL Queries is a straightfor... |
| Here is a quick CTE that can be used to generate a... |
| There are two main types of cache which SQL Server... |
| A great way to easily read the XML execution plan ... |
| This article will discuss an overview and use case... |
| I asked about a slow piece of code and why it is so slow. The answer is pretty simple, I messed up, take a look at this piece of... |
| Azure Databricks, Spark and Snowflake |
| Series of Apache Spark posts: Dec 01: What is Apa... |
| Azure SQL Managed Instance |
| There is a setting / feature in Managed Instance w... |
| Recently, I’ve started on a project where we are migrating a customer to Azure SQL Managed Instance, which now supports a few different migration paths. You can simply backup... |
| Career Growth and Certifications |
| How’s that for click bait? Does Unsolicited Stuf... |
| Early on in the history of SQL Server Central, we ... |
| Computing in the Cloud (Azure, Google, AWS) |
| Microsoft has made it possible to integrate Azure Active Directory with Virtual Machines. In this post, Dennes Torres walks you through the steps to set it up. |
| This article will explore AWS RDS SQL Server with ... |
| Introduction In the last few posts we looked at th... |
| An easy way to find if SQL Server has SSL enabled |
| As I’ve been working on my new PowerShell projec... |
| Data Mining / Data Analysis |
| Active gratitude is the feeling you get when a str... |
| It's that time of year again where I get to blend ... |
| Data mining tools are enjoying a dramatic increase... |
| Database Design, Theory and Development |
| The abilities of an organization towards capturing... |
| Today, we’ll discuss a question that relates to ... |
| DevOps and Continuous Delivery (CI/CD) |
| Automation can help hybrid workforces run smoothly... |
| CD Foundation’s report reveals how ubiquitous De... |
| ETL/SSIS/Azure Data Factory/Biml |
| I was honored to work on a cool SSIS lift and shif... |
| In this post, I describe how to create a linked se... |
| New Toolkit certifications are now available on Azure Database for PostgreSQL – Hyperscale (Citus), a managed service running the open-source Postgres database on Azure. |
| PowerPivot/PowerQuery/PowerBI |
| Ever run into a Parameter error when trying to ref... |
| Learn about different functions you can use in Pow... |
| You've heard about Microsoft Dataverse but haven't... |
| As a postscript to my series on Power BI refresh timeouts (see part 1, part 2 and part 3) I thought it would be useful to document how I... |
| A look at why this is such a tricky vulnerability and why the industry response has been good, but not great. |
| Thank you for joining us on “The cloud hub: From... |
| The Log4j flaw exists in a component that is not always easy to detect and is widely used beyond an organization's own networks and systems. |
| Data plays a central role in digital transformatio... |
| ‘Tis the season to be jolly. By now, those words... |
| Learn different ways to create FOR Loops using T-S... |
| In this article we take a look at the different ty... |
| You can find Dubna, a small town three hours away ... |
| December is often a time of reflection, and this y... |
| With edge computing, guaranteeing physical device ... |
| One thing 2021 has shown us is the cloud market is... |
| Right now, Volkan Yazici is working 22 hour days f... |
| Tools for Dev (SSMS, ADS, VS, etc.) |
| There are a number of extensions available for Azu... |
| Virtualization and Containers/Kubernetes |
| Placement policies enable admins to specify constr... |
| This email has been sent to [email protected]. To be removed from this list, please click here. If you have any problems leaving the list, please contact the [email protected]. This newsletter was sent to you because you signed up at SQLServerCentral.com. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter. |
|
|
