One of the things that makes you a well-rounded person is adventure. But often, when one thinks of adventure, they think of fun, grand, and most likely, well-planned adventure holidays. Climbing the Matterhorn, crossing the Gobi desert, or perhaps most adventurous of all, navigating Disney World on July 4th (shudder). In each of these types … Read more
Today I am starting (well, restarting) a new feature here on Simple-Talk, The Editor’s Blog. This blog will cover topics about writing technical blogs and articles, how to access the information on Simple-Talk at your convenience, and even other writing issues like how to write an excellent presentation and abstract. Topics will sometimes be Simple-Talk centric, … Read more
This is the third part of a series on SQL Server Dynamic Data Masking. The first part in the series was a brief introduction to dynamic data masking, completing solutions, and use cases. The second part covered setting up masking and some examples. This part starts exploring side channel attacks against dynamic data masking. This … Read more
This is the second part of a series on SQL Server Dynamic Data masking. The first part in the series was a brief introduction to dynamic data masking, including use cases. The focus of this blog will is setting up masking and some base examples. Configuring Masking Masking data is a straightforward process. Choose the … Read more
Some time between January and now, a new preview feature was included in Power BI Portal. It’s a new Manage Connections and Gateway window, still in preview. We can access this option on the Settings button. In the past, the connections were related to on-premises data gateways. For each gateway we could create many connections … Read more
In this blog, we will explore the disparities between on-premises and cloud infrastructures, highlighting their respective benefits and drawbacks. What is an On-Premises Architecture? An on-premises data center refers to a physical facility owned and operated by an organization, serving as a central hub for managing and housing its own IT infrastructure. This infrastructure includes … Read more
The concept of tact is simple. Telling people truths, often harsh truths, without making it seem harsh. Hopefully, it is clear that being truthful is one of the more essential things in life. As a person in technology (and certainly as an editor), we often need to be honest when the truth hurts a bit … Read more
This is the beginning of a series on SQL Server Dynamic Data Masking. Dynamic Data Masking is a concept familiar with all developers and users of sensitive data. It is implemented in SQL Server with simplicity and elegance, requiring minimal changes to front end applications, including reporting, and almost no changes to queries. The series … Read more
After the great announcement of Microsoft Fabric this week, it’s time to get a trial and start playing with this great product. Microsoft Fabric is a very broad product, so it requires some additional configuration for the start of a trial. Configuring the Tenant By default, the Power BI tenants are disable for Microsoft Fabric. … Read more
.In this blog I will illustrate how we can ingest data from a blob storage to a Microsoft Fabric Data Warehouse using T-SQL. Create a new workspace On the left ribbon, click Workspaces. Click the New Workspace button. Provide a name for the workspace. On advanced configuration, ensure you choose Premium by Capacity, and you … Read more
I just finished writing this book a few weeks ago, and as I read it, I thought “why not review my own book?” Of course, the question that first comes to mind is “are you insane?” It seems like a no-win proposition. Anything less than “best book evah” and it will seem like false modesty. … Read more
A company’s Azure environment can easily grow to a level that managing all the objects may become harder. The solution of this problem requires methods to query resources, such as Azure Functions, based on their properties. One of the fetures used for this is the Azure Resource Graph . However, Function Apps configuration is beyond … Read more
In the first part of this series, we spoke about MySQL Replication, the different types, replication formats, benefits, and downsides, as well as a brief introduction to the requirements needed for setting up MySQL Replication. To ensure we stay on track with our intended topic, it’s important to have certain prerequisites in place before we … Read more
MySQL Replication is a process where data from one MySQL database known as the source (formerly called “master”) is copied over to one or more other databases called replicas (formerly called “slaves”). Think of this like having a backup buddy that is always in sync and up to date, giving you peace of mind. It’s … Read more
If you have ever played a game of chess against someone good, or perhaps against a computer, you know that a good player is always thinking multiple moves ahead, working every combination of moves their opponents may possibly make, and getting a plan for their next set of moves. It is a fun game, but … Read more
The basic differences between Synapse Serverless and the Dedicated pool are obvious: While the serverless doesn’t store data, only access data from storage accounts and scale the MPP environment automatically, the dedicate SQL Pool keeps a static number of servers according to the service level we choose and a constant number of distributions – always … Read more
When you are writing T-SQL scripts to save away, for example one to create a new database, there are often optional bits of code you need to run sometimes, and not others. In the creating a database script, there are quite a few parameters you will want as part of your script. The database name, … Read more
Over the past 25 years, I have answered a lot of programming questions in online forums, from co-workers, and from friends. It has been a while since I had been around forums, but I recently decided it was time to get back to what started me in the SQL community: answering questions. Not only is … Read more
Originally published on 21 August 2020 as “Understanding digital transformation & how it transcends to driving organizational growth“, edited by Louis Davidson including updated references. IDC report forecasts that global spending on enterprise applications will rise from $279.6 billion in 2022 to 385.2 billion in 2025. Nearly all of this will be in public cloud … Read more
I wrote about Managed Identity Secrets a few weeks ago, but since that article was published I made new interesting discoveries to add more to these secrets. The combination of possibilities is considerable, and I faced two new situations I hadn’t faced before. Let’s discover the new secrets. Storage Accounts and Triggers The storage … Read more