Identity in a SELECT
Always be learning right? So when I saw this I had to go HU?! That’s new. What’s going on here?
SELECT
IDENTITY(INT,...
2019-01-02 (first published: 2018-12-19)
4,199 reads
Always be learning right? So when I saw this I had to go HU?! That’s new. What’s going on here?
SELECT
IDENTITY(INT,...
2019-01-02 (first published: 2018-12-19)
4,199 reads
Happy New Year! Every year for New Years we all make a big deal of coming up with New Years...
2019-01-02
1,070 reads
I’ve just signed up on Microsoft’s new learning opportunity Microsoft Learn. The main categories are Azure, Business Apps, and Windows...
2018-12-31
418 reads
I thought I would post this a bit early so everyone can memorize the words before Hanukka starts next week.
I...
2018-12-18 (first published: 2018-11-28)
2,750 reads
Microsoft does a lot of things to try to help us not shoot ourselves in the foot. This little error...
2018-12-17
1,004 reads
TL;DR; BULK INSERT doesn’t have an easy way to specify a column list so the columns in the insert file...
2018-12-12
627 reads
We’ve been doing a lot of upgrading recently and at one point had to move an instance from one 2016...
2018-12-10
219 reads
A while back I wrote about how to find where your backups are. And I’ve also written about I use...
2018-12-10 (first published: 2018-11-26)
2,072 reads
A co-worker showed me a really neat trick the other day. We deal with a lot of connection problems and...
2018-12-05
5,925 reads
I’ve committed to posting a piece of homework for you to do each month. I post at the beginning of...
2018-12-03
195 reads
“Could you help me, we deleted the database’s transaction log file and now that...
I had a couple of clients who were moving content from development catalogs to...
I wanted to test a migration of Azure PostgreSQL from simple to flexible. I...
Comments posted to this topic are about the item Diving Deeper into the Import...
Hi all, I need a list of objects (DMV's and probably other objects) that...
Recently I got sql alerts from one of QA servers, every 2 or 3...
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers