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
534 reads
Kenneth Fisher
What queries are getting blocked?
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,680 reads
Interview questions: What’s the first thing you would do if a user reports slowness.
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,098 reads
SQL Homework – June 2018 – Alter a database
Here we are again. The beginning of another month. At the beginning of each month I put out a SQL...
2018-06-04
242 reads
Updated query to view data in the error log
This is one of my favorite scripts. It pulls all of the data from the error log and dumps it...
2018-05-31
382 reads
The public role
A common misunderstanding is that the CONNECT permission lets you do more than just connect to a database. It doesn’t....
2018-05-23
465 reads
What are the system databases?
I get to help with technical interviews every now and again, and one of the questions we always ask is...
2018-05-21
517 reads
Why I blog: TSQL Tuesday #102
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,818 reads
The trials and tribulations of REVERTing from impersonation
Impersonation is a highly useful tool in your toolbox. With the EXECUTE AS clause you can allow your stored procedure...
2018-05-16
386 reads
Blogging and when to keep your big mouth shut
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
494 reads
Blogs
SQL Server gMSA: Why So Many DBAs Still Aren't Using It in 2026
By SQLPals
SQL Server gMSA: Why DBAs Still Aren't Using It in 2026 ...
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Forums
Alamat Kantor BCA KCU Magelang Telp:08217555651
Hub Via Wa:628217555651 Alamat Jl. Ahmad Yani No.1, Magelang, Kec. Magelang Tengah, Kota Magelang,...
Alamat Kantor BCA KCU KUDUS Telp:08217555651
Hub Via Wa:628217555651 Alamat Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus,...
Alamat Kantor BCA KCU Gang Tengah Telp:08217555651
Hub Via Wa:628217555651 Alamat Gg. Tengah No.88, Kranggan, Kec. Semarang Tengah, Kota Semarang, Jawa...
Question of the Day
Database Mail Configuration
If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?
See possible answers