The identity column, the insert and the linked server.
tl;dr; When doing an insert across a linked server you have to include the list of fields to be inserted...
2018-06-14
462 reads
tl;dr; When doing an insert across a linked server you have to include the list of fields to be inserted...
2018-06-14
462 reads
Monday Grant Fritchey (b/t) put up a great post EXTENDED EVENTS, THE SYSTEM_HEALTH SESSION, AND WAITS that talks about how...
2018-06-14 (first published: 2018-06-06)
2,667 reads
We’ve been doing a fair amount of interviewing recently and one of our big questions is What do you do...
2018-06-08 (first published: 2018-05-28)
4,086 reads
Here we are again. The beginning of another month. At the beginning of each month I put out a SQL...
2018-06-04
238 reads
This is one of my favorite scripts. It pulls all of the data from the error log and dumps it...
2018-05-31
377 reads
A common misunderstanding is that the CONNECT permission lets you do more than just connect to a database. It doesn’t....
2018-05-23
458 reads
I get to help with technical interviews every now and again, and one of the questions we always ask is...
2018-05-21
509 reads
It’s TSQL Tuesday again! This month our host is Riley Major (b/t) and the subject is Giving Back. He’s given...
2018-05-18 (first published: 2018-05-08)
1,813 reads
Impersonation is a highly useful tool in your toolbox. With the EXECUTE AS clause you can allow your stored procedure...
2018-05-16
377 reads
I’ve been blogging for a while now. I’ve thought about blogging quite a bit. I’ve even done quite a few...
2018-05-14
488 reads
By Chris Yates
I get asked a lot about why or how I began working with databases...
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...
Hi, we lost our sever sql2000 To restore database to a new one we...
Comments posted to this topic are about the item Do You Really Need HA?
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers