Hello friends, Please find the link of this article here – https://social.technet.microsoft.com/wiki/contents/articles/40188.error-unable-to-retrieve-child-resources-in-azure-storage-explorer.aspx
2017-09-27
903 reads
Today I ran into something on a client server I unfortunately see too often. The DBA goes through the trouble...
2017-10-05 (first published: 2017-09-27)
1,669 reads
My goal here is to have something fun (and hopefully educational/thinky) (and yes, I did just make up the word...
2017-09-27
462 reads
It wasn’t until recently that i paid attention to truncation during concatenation, but that’s because whenever I used concatenation before...
2017-09-27
1,237 reads
In relation to the GDPR, I’ve recently been looking at the tools available within SQL Server to support auditing our...
2017-10-05 (first published: 2017-09-26)
5,830 reads
SQL Clone is amazing, and it can really save time and disk space for many organizations. I’ve got a series...
2017-09-26
647 reads
Photo by Patrick Tomasso on UnsplashHow many times have you known that adding an index would improve query performance but you weren’t exactly sure which type of...
2017-09-26
1,940 reads
Before I complete my question let me provide context. I've received an alert saying that a specific database could not...
2017-10-04 (first published: 2017-09-26)
2,703 reads
Photo by Patrick Tomasso on Unsplash
How many times have you known that adding an index would improve query performance but you weren't exactly sure which type of index to add?
This happened to me all the time...
2017-09-26
15 reads
Final Addendum – use dbatools!
Addendum – There is a repo on GitHub which I wrote and recommend using for build/deployment of DACPACs....
2017-09-26
7,479 reads
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Comments posted to this topic are about the item Adding new column with DEFAULT...
Comments posted to this topic are about the item Advanced Deployment Scenarios: Stairway to...
Comments posted to this topic are about the item You Need a DBA Pipeline
Which number did the two COUNT(*) return:
DROP TABLE IF EXISTS #tmp CREATE TABLE #tmp (id INT NOT NULL) INSERT INTO #tmp (id) SELECT gs.value FROM GENERATE_SERIES(1, 5) AS gs ALTER TABLE #tmp ADD my_value INT NOT NULL CONSTRAINT df_tmp_my_value DEFAULT 1 SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1 ALTER TABLE #tmp DROP CONSTRAINT df_tmp_my_value ALTER TABLE #tmp ADD CONSTRAINT df_tmp_my_value DEFAULT 2 FOR my_value SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1See possible answers