This tip will review the different ways of granting privileges in SQL Server, Oracle, and PostgreSQL, the differences in the concepts of roles, schemas, and owners, and the way to grant permissions on the whole schema.
2023-02-06
644 reads
When I first started working in technology in the 90s, it was a time of outsourcing lots of work overseas. Many large companies followed the wave of manufacturing in the 70s and 80s by many companies, including lots of semi-conductor manufacturers. I watched as a number of jobs moved overseas, though fortunately not mine. In […]
2023-02-06
112 reads
2023-02-06 (first published: 2023-02-04)
197 reads
This tip walks through the steps of how to combine data from SQL Server Analysis Services SSAS 2022 with other data using Power BI Desktop.
2023-02-03
In this article, we are going to talk about nullable and non-nullable columns specifically related to Postgres databases. While the reasons to use nullable or non-nullable columns may seem obvious at first, there are pitfalls associated with each decision that either affect development velocity, affect application performance, or cause downtime. Let's start with definitions. Nullable […]
2023-02-03
1,142 reads
This article provides an overview of Data Fabric and its components.
2023-02-01
4,108 reads
2023-02-06 (first published: 2023-02-01)
377 reads
As with many relational database management systems, MySQL provides a variety of methods for combining data in a data manipulation language (DML) statement. You can join multiple tables in a single query or add subqueries that pull data in from other tables.
2023-02-01
Learn how you can back up your SQL Server 2022 databases to Google Cloud Storage.
2023-01-30
2,036 reads
In this article, we cover how to encrypt a SQL Server stored procedure and how SQL Server hides the source code for these objects once encrypted.
2023-01-30
This is part of a series of new job blog posts. You can find...
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
Back in December 2019, I started presenting my session on mental health with lots...
Comments posted to this topic are about the item Managed Instance Link and SQL...
Comments posted to this topic are about the item Passing parameters to query without...
Comments posted to this topic are about the item Capturing Data Changes
Ask SSC