Experiment: Does sp_recompile on a table update associated views.
tldr: No. You have to use sp_refreshview. One of the only good things to come out of all of the ... Continue reading
2021-09-01 (first published: 2021-08-17)
304 reads
Blog Posts
Let’s talk about typefaces
I have previously written about accessibility in video captions, presentation slides, and disabilities, and I thought I should expand on the latter topic as it relates to typefaces, or...
2021-09-01
35 reads
Using PyApacheAtlas to import SQL Server extended properties to Azure Purview
Azure Purview is a compliance and data governance platform in Microsoft’s Azure cloud. The platform is currently in public preview and has quite a few features; but, does not...
2021-09-01 (first published: 2021-08-11)
403 reads
Daily Coping 31 Aug 2021
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-08-31
17 reads
Expanded Button Formatting, New Spacing Controls, and Drag-and-Drop for List View Now in Block Editor
This month, our team released features in the block editor that give your site a little breathing room: spacing controls for buttons and paragraphs. And the List View tool...
2021-08-31
40 reads
Regular Expression Search & Replace in Visual Studio Code
Kind of a diversion into a Visual Studio Code/Azure Data Studio tip here (this works in both, as well as SQL Server Management Studio). I’m not a regular expression...
2021-08-31
37 reads
SQLCMD: Prevent an Entire Batch From Even Parsing With One Magical Character (Cruel Joke #4)
(last updated: 2021-09-01 @ 14:18 ET / 2021-09-01 @ 18:18 UTC ) In my previous post, SSMS and SQLCMD: Prevent T-SQL Batch From Not Only Executing, but Also From...
2021-08-31
103 reads
Allan Hirt presenting BC Foundations 31 Aug 2021
I’m thrilled to host Allan Hirt presenting an exciting session called “SQL Server Business Continuity Foundations” this Tuesday, August 31, at 10am Central time for our Microsoft Data Platform...
2021-08-30
35 reads
Daily Coping 30 Aug 2021
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-08-30
21 reads
How I carved up 18TB of Storage
In a previous post I told you about how I got a Synology DS920+ on loan to play around with. The device comes with 4 drive bays so there...
2021-08-30 (first published: 2021-08-13)
419 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
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