Do you frequently use the “log_reuse_wait_type_desc” column in the [crayon-5f297eff3d7ff981952735-i/] view? Have you ever seen the type of OLDEST_PAGE? You are not the only one!! Recently I was troubleshooting...
2019-09-24
1,417 reads
At a project, we asked if we could get a SQL Server login/user so we could make a connection from an Apache Airflow pipeline to the SQL Server instance....
2019-09-24
323 reads
At a project, we asked if we could get a SQL Server login/user so we could make a connection from an Apache Airflow pipeline to the SQL Server instance....
2019-09-24
13 reads
Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...
2019-09-24 (first published: 2019-09-17)
1,002 reads
Watch this week’s video on YouTube! A couple of weeks ago I decided to rebuild my recording studio by getting rid of my fabric backdrop and replacing it with...
2019-09-24
61 reads
Watch this week's video on YouTube
A couple of weeks ago I decided to rebuild my recording studio by getting rid of my fabric backdrop and replacing it with a...
2019-09-24
8 reads
Watch this week's video on YouTube
A couple of weeks ago I decided to rebuild my recording studio by getting rid of my fabric backdrop and replacing it with a...
2019-09-24
7 reads
In SQL Server Integration Services, connection managers are used as gateways for most any external read and write operation. Connection managers are type- and format-specific, and in the case...
2019-09-24 (first published: 2019-09-16)
364 reads
Here are the things you must/should probably know about PASS Summit 2019, as told by me. Included: Advice for first timers Prioritized schedule at a glance Sessions we recommend...
2019-09-23
40 reads
There are two new options for automating your SQL Notebooks with your SQL Servers. Earlier this month, the Insiders build of Azure Data Studio received the ability to add...
2019-09-23
61 reads
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
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