Sharing the Code

I don't know how many of you use the ScriptDOM. I haven't really used it, but was very impressed with Mala Mahadevan's Stairway Series on the topic. I have recommended this to a few customers that were looking for some complex code analysis features, which go beyond what SQL Prompt or SQL Fluff do.

I noticed this week that ScriptDom has been open sourced by Microsoft. The code is available on GitHub, which means you can fork it and change it. Or submit PRs. No idea if Microsoft will take them, but if you write solid, useful code, they might.

I like that more and more Microsoft is open-sourcing and sharing code that they write. Usually, their repos aren't for software they sell, but maybe they will change that at some point.

There are over 5000 repos in their account right now, including one for VSCode, which I use almost every day. While I don't plan on contributing or even bug-fixing, I bet some of you might. I might contribute to the docs, which I do regularly for the SQL Server docs. There are a lot of changes here, but there are a few marked way0utwest.

BTW, if you don't want to do your own PRs, send me a note. I'm happy to edit the docs and submit changes.

I am a fan of open-source projects, because I do think collaboration is useful in many situations. While I don't expect many people to actually make changes to software, some will. Some, like me, will correct docs, and others will find issues in the code and report them. All of those efforts help us improve software, and I am all for higher quality software.

Now if we could get Microsoft to open-source SSMS, maybe a few of you would find ways to improve that application.

Steve Jones - SSC Editor

Join the debate, and respond to the editorial on the forums

A constant challenge for many development teams is how to include test data management in the development process. Testing with consistent, realistic and compliant datasets, and bringing the database into CI and DevOps pipelines, has been shown to catch data-related issues long before they reach customers. Step in Redgate Clone, Redgate’s new DevOps test data management tool that provisions production-like data in seconds for SQL Server, PostgreSQL, MySQL and Oracle databases.

This article explains why Flyway is fundamentally well-suited to the task of bringing control and automation to database development work and then the features of Flyway Teams edition that become necessary when a team of developers need to work concurrently on a database.

The Big 3 public cloud providers see gains and pro...

DBCC FREEPROCCACHE is a DBCC command in Microsoft SQL Server that can be used to clear the procedure cache, which is a region of memory that stores the execution...

You’re planning to migrate to SQL Server 2022, and you want your databases to be faster after the migration. This is NOT a blog post about how to migrate...

Sometimes I need to know how fast a database is growing, or which particular database is growing the most out of all the databases on a SQL instance.   Now... The...

On April 13, 2023, Microsoft released SQL Server 2022 Cumulative Update 3. This is Build 16.0.4025.1. By Microsoft’s count, there are 9 public fixes and improvements in this CU,...

Unfortunately there is no built in function to tra...

In this article, we will compare the warehouse con...

In this article, we look at how Snowflake handles deadlocks and the process of creating a deadlock and detecting a deadlock.

Data governance has become an essential agenda item for many organizations. The reasons are varied, but two of the most compelling ones are: (1) as the number of data assets grows, it becomes harder to properly control access to them; and (2) new and more stringent privacy regulations are increasing the calls for compliance.

This last April 27 we had a great opportunity and ...

Reading Time: 5 minutes In this post I want to cover spreading your SQL Server wings with Azure SQL Database. As part of a series of posts about...

Big data analytics is within easy reach of SQL developers and analysts by using Synapse Analytics Serverless SQL Pools. Data stored in Azure Data Lake can be analysed at...

Reading Time: 3 minutes In this post I want to co...

As a team member within a business environment, yo...

This is a list of links, in no particular order, that you should read in no particular order. But read all of the words at the end of these... The...

You can now customize the right sizing recommendations for virtual machines and virtual machine scale sets to make them more relevant and actionable for your workloads.

In 2023, connect, share & learn with like-minded peers, speakers, and industry leaders during the full week of data celebrations. Summit happens in person, from November 14th to 17th in Seattle. Check out the blog post to learn more.

The schedule for EightKB 2023 Edition has been announced! We’re kicking off at 1pm UTC on May the 24th…here’s the schedule: – N.B. – If you click on the...

The schedule for EightKB 2023 Edition has been announced! We’re kicking off at 1pm UTC on May the 24th…here’s the schedule: – N.B. – If you click on the... The...

We are proud and honored to announce DPWIT-Mental Health and Wellness Day, May 5th,2023,

Sometimes special characters are a nuisance. If you are trying to create some user accounts in on-premise or cloud environments, you should avoid special characters in usernames. In this blog post I will show how to find this special characters.

Final days to register for the May 5th in-person *storytelling & presenting data* masterclass in Chicago! Join Cole and the SWD team for our last in-person public workshop of...

Sometimes people say to avoid the snowflake schema and stick to a clean star schema. Why is that? Is something wrong with creating a snowflake schema?

Shutting down a node abruptly is not the right way to decommission or remove a node from the Elasticsearch cluster. Doing so will cause your shards which are replicated to go down in replication and it could cause disruption to the clients who are currently consuming data from Elasticsearch.

(2023-Apr-25) It’s not hard to see that many different teams were involved in building Azure Data Factory (ADF) product at Microsoft. It doesn’t have conformed constraints for naming the objects... The...

You can now easily unroll multiple arrays inside a single Flatten transformation in Azure Data Factory and Azure Synapse Analytics using a data pipeline with a Mapping Data Flow.

This one had me stumped lately. I had an variable in ADF where the value contained carriage returns. I needed to remove them. I guessed that would be easy:...

I was working with a client who has having trouble debugging an ADF pipeline, related to an ODBC linked service not working as expected. The user had configured the...

A quick description of 3 metrics that SQL tracks in Availability Groups. These metrics are important when evaluating the health of your Availability Group, and knowing what sort of...

We put Intel's quad-core Core i3-13100F and 13100 ...

Upgrading to an SSD is a quick way to grab a speed...

Different rounding differences can appear in DAX depending on data types and operations performed: knowing these details helps you write more robust DAX formulas and avoid comparison errors.

Microsoft closes the door on further Windows 10 fe...

Microsoft is changing its Windows Server 2022 licensing policies to... The post Microsoft Changes Windows Server 2022 Licensing Policies appeared first on Petri IT Knowledgebase.

An important aspect of building and managing a database is organizing the objects within your database. This can be accomplished using schemas within a database and PostgreSQL supports the use of schema for these types of functions.

Previously on Extreme Learning, I discussed all the ways I've broken production using healthchecks. In this post I'll do the same for PostgreSQL.

At Redgate, we’ve spent a lot of time adding PostgreSQL functionality to our DevOps tools. We’ve also hired an advocate, Ryan Booz, to help us spread the word and... The...

A Little About Parameter Sensitivity In SQL Server...

A Little About Key Lookups In SQL Server I’m working on ramping up my recording and streaming setup now that life has settled down a little bit, and publishing...

A Little About Sorts In SQL Server Query Plans I’m working on ramping up my recording and streaming setup now that life has settled down a little bit, and...

A Little About Filtered Indexes In SQL Server I’m working on ramping up my recording and streaming setup now that life has settled down a little bit, and publishing...

In this article, we look at how to enhance and cha...

Version controlling a Power BI PBIX file along with all its data can be problematic, for reasons of both size and privacy. In this post I look at managing...

Test performance of your Power BI reports when multiple users are running them at the same time

This book aims to improve your SQL queries using design patterns, how does it fare?

I had someone ask recently about getting SQL Data Compare results in Excel. It’s easy to do and this post looks at the process. Exporting a Comparison I won’t... The...

This month’s big changes are performance tuning ...

Today we are excited to announce that the Degree o...

ScriptDOM is a powerful .NET library for code parsing, generating an abstract syntax tree (AST) that can be leveraged to apply code formatting, detect antipatterns, and more. We are thrilled...

General availability enhancements and updates released for Azure SQL and Azure SQL Managed Instance in late-April 2023

Today, we’re officially announcing the general availability for Centrally Managed Azure Hybrid Benefit for SQL Server.

Today, we’re excited to announce the expansion of our Confidential VM family with the launch of the DCesv5-series and ECesv5-series in preview. Featuring 4th Gen Intel® Xeon® Scalable processors,...

R is a powerful programming language and environment for statistical computing and graphics. In this post, we will provide a quick introduction to R using the famous iris dataset.

Cross DB Ownership Chaining is a feature of SQL Server that allows one database to access objects in another database, even if the two databases are owned by different...

Stanford and Georgetown have a new report on the s...

Microsoft T-SQL supports a language feature called table-valued parameter (TVP), which is a parameter of a table type that can be passed to a stored procedure or function. For...

When recently troubleshooting an issue, I needed to update a database record to test application functionality. Because the table had an Always Encrypted column, some extra steps were needed...

Learn different ways to select data between two dates using various techniques along with how to improve performance for very large tables.

The cuts affect workers in the US, Canada, and Cos...

Cross-Site Request Forgery (CSRF) attacks are widespread, and even some BigTech companies suffer from them. To understand this, we need to understand CSRF in detail.