DBA in training: SQL Server under the hood
In this article of the series, Pamela Mooney explains the architecture of SQL Server under the hood, including some query anti-patterns to avoid.
2021-02-23
SQL
Oracle archived redo size – the research
Oracle archived redo size may be smaller than that of online redo log files. In this article, Jonathan Lewis takes a deeper look.
2021-02-04
Exploring errors to reveal unauthorized information
Database administrators can never stop thinking about security. In this article, Fabiano Amorim shows how data can be revealed through error messages when views are used to secure rows.
2020-11-25
Concurrency Control in SQL Server
Learn a bit about concurrency problems in SQL Server, the issues they create, and the different isolation levels that help you solve them.
2020-05-12
27,807 reads
SQL Server Integrates Hadoop and Spark out-of-the box: The Why?
Why has Microsoft added new capabilities in SQL Server to connect to other types of data sources? Read on to learn more.
2021-05-14 (first published: 2019-09-09)
10,091 reads
SQL and NoSQL Database Features and Differences
In this tip we will talk about the features and main differences between SQL and NoSQL databases.
2019-04-10
Introduction to SQL for Cosmos DB
This article by Adam Aspin reviews the Azure Cosmos DB SQL API from the perspective of the relational database developer. More specifically it will show you how to leverage your Structured Query Language skills to exploit the core possibilities of Cosmos DB as a NoSQL document database.
2019-03-25
219 reads
Resumable Online Index Create and Rebuild Operations
Index maintenance can be a real headache for database administrators as tables grow larger and maintenance windows shrink. In this article, Greg Larsen demonstrates resumable index operations available with SQL Server 2017 and 2019. This feature helps DBAs work around those small maintenance windows by allowing certain index operations to be paused and restarted again later.
2019-03-21
1,738 reads
Introduction to SQL Server Security — Part 3
SQL Server supports partially contained databases. This gives you the option of adding database users with a password inside the database. This makes the database easier to move to another instance or participate in an Always On Availability Group. In this article, Robert Sheldon explains how to work with users in contained databases.
2019-03-11
Introducing SQL+ Dot Net
SQL+.net is the first real innovation in data access for quite some time, and was built exclusively for SQL developers.
2019-03-07
3,582 reads
Blogs
Create and Verify Microsoft Fabric Capacity
From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....
What is Always Encrypted and how does it work?
Always Encrypted was a new encryption feature added to SQL Server with the 2016...
Power BI – Empowering Users to Disable Tooltips
By DataOnWheels
Let’s set the scene. You’ve built a wonderful, useful, and descriptive report for your...
Forums
Falschgeld kaufen in essen WhatsApp….. +17785578351 Kaufen Sie 100 % nicht nachw
Falschgeld kaufen in essen WhatsApp….. +17785578351 Kaufen Sie 100 % nicht nachweisbare gefälschte Banknoten...
Display columns from multiple rows in single
Hello, Im looking for assistance. I have this query and need to display the...
Azure Datawarehouse or SQL Pools and profiler equivalent...
I added the Profiler module to AZure Data Studio in our ("Microsoft Azure SQL...
Ask SSC