Moving Encrypted Data to Azure SQL Database
Learn how you can move encrypted data from on premises SQL Server to Azure SQL Database.
2019-11-26
2,538 reads
Azure SQL database
Very Hot Patches
Azure SQL Database can be patched without stopping the sqlsrvr.exe process. Quite a feat of engineering.
2019-10-08
197 reads
2019-08-15
762 reads
Cross Database Queries in Azure SQL Database
Cross database queries in Azure SQL Database aren't as straightforward as you might think, but they aren't hard to implement. Follow along to learn how to implement them.
2019-07-25
38,265 reads
Technology Flows Downstream
The technologies that we see in other data platform products sometimes flow to SQL Server.
2019-06-20
270 reads
2019-05-16
616 reads
Five Ways to Migrate Your On-Premises SQL Database to Azure
There are currently three deployment options for SQL Server Database on the cloud. Well, four, if you count Azure SQL Databases in elastic pool. But Azure SQL DB in...
2019-05-09
A short Azure SQL Database Edge explainer
On Thursday 2 May 2019, Microsoft announced a new edition of SQL Server, targeting Internet of Things (IoT) edge devices. That means SQL Server can now run almost anywhere....
The...
2019-05-06
2019-04-29
798 reads
Building Azure SQL Db with Terraform with Visual Studio Code
I have been using Terraform for the last week or so to create some infrastructure and decided to bring that knowledge back to a problem that I and others...
2019-04-17
Blogs
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Forums
Alamat BCA KCP Abdul Muis Telp/Wa:08218520154
Alamat: Gedung Graha Motor City, Jl. Abdul Muis No.24-26 Level I Suite 101, RT.2/RW.8,...
Alamat BCA KCP Sabang Telp/Wa:08218520154
Alamat: Jl. H. Agus Salim No.57 B, RT.3/RW.1, Kb. Sirih, Kec. Menteng, Kota Jakarta...
Alamat BCA KCP Kebon Sirih Telp/Wa:08218520154
Alamat: Plaza Pupuk Kaltim, Jl. Kebon Sirih No.6A Gedung B Lantai 1, RT.14/RW.2, Gambir,...
Question of the Day
Adding new column with DEFAULT II
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