Power BI offers the ability for users who have access to a dataset in the Power BI service (PowerBI.com) to connect to the dataset using Excel. Normally, this feature...
2021-10-13 (first published: 2021-09-30)
202 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-10-13
14 reads
Goal of this demo: Update a Power BI model schema by adding a column to the data model without opening a PBIX file and ensure the scheduled refresh still...
2021-10-13 (first published: 2021-10-01)
1,498 reads
I was fortunate to present a pre-con at the PASS Summit alongside Kendra Little in 2019. That was the last in person event, and I really enjoyed the session....
2021-10-13
13 reads
Yesterday, I had about 30 existing queries (and some multi-query processes) that I needed to turn into individual stored procedures. […]
The post SQL Server meta-development (with regular expressions and...
2021-10-13
11 reads
This is the third post in the series about system-versioned ledger tables, a new feature introduced in Azure SQL Database. You can read Part 1 and Part 2 if...
2021-10-13
24 reads
I’m late, but I wanted to get this out. I started the post, then got distracted with travel to Europe late last week. In any case, this month the...
2021-10-13
32 reads
In this article, I have shown the importance of performing three different validation tests against your Availability Group Endpoints. Each test also demonstrates what can be run in the...
2021-10-12
33 reads
In this article, I have shown the importance of performing three different validation tests against your Availability Group Endpoints. Each test also demonstrates what can be run in the...
2021-10-12
12 reads
In this article, I have shown the importance of performing three different validation tests against your Availability Group Endpoints. Each test also demonstrates what can be run in the...
2021-10-12
20 reads
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item The Problem Isn't Always Your...
Comments posted to this topic are about the item Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers