Activity
Mon
Wed
Fri
Sun
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
What is this?
Less
More

Memberships

Learn Microsoft Fabric

Public • 5.4k • Free

6 contributions to Learn Microsoft Fabric
How to: Create a warehouse with case-insensitive (CI) collation.
1. All Fabric warehouses by default are configured with case-sensitive (CS) collation Latin1_General_100_BIN2_UTF8. You can also create warehouses with case-insensitive (CI) collation - Latin1_General_100_CI_AS_KS_WS_SC_UTF8. 2. Currently, the only method available for creating a case-insensitive data warehouse is via REST API. 3. Run the code in the Warehouse to check the collation (SELECT name, collation_name FROM sys.databases) 4. Copy the Attached code. 5. Go to workspace, create a new item (notebook), and paste the code into the Notebook. 6. Change the Workspace name in the notebook script(e.g., "displayName": "TestFabricDW",) to the name of the data warehouse you want to make case insensitive. 7. Run The Notebook. 8. You should receive a response with the status code 202 Accepted. To confirm the Notebook has run succesfully. 9. Go back to workspace, select workspace, Select TestFabricDW Data Warehouse, Click on SQL Query And Run This code (SELECT name, collation_name FROM sys.databases;) 10. You can see that the collation has changed for TestFabricDW data Warehouse. 11. Run A Couple Of SQL Scripts to Confirm. 12. sql 13. CREATE TABLE Employee_Test ( 14. EmpId INT, 15. EmpName VARCHAR(100), 16. EmpSalary INT, 17. EmpLocation VARCHAR(100) 18. ); 19. 20. SELECT * FROM Employee_Test; 21. SELECT * FROM employee_test; 22. SELECT * FROM emPLOyee_TEST; 23. NOTE: Once a Warehouse is created, the collation setting cannot be changed. Carefully consider your needs before initiating the creation Processes.
1
5
New comment 3d ago
0 likes • 4d
It may be helpful when you want to migrate the database to Fabric Warehouse.
0 likes • 3d
@Will Needham Thank you
DP-600
I passed DP-600. Thank you so much! Your videos and community helped a lot to clear the exam.
6
8
New comment 5d ago
0 likes • 9d
Thank you, Will
1 like • 9d
I will go by JAN
DP-700 beta exam experiences and tips (by Ali Stoops)
Hey everyone, for people preparing for the DP-700 beta exam, this blog post by Ali Stoops gives some good insights into what the exam entails, and some tips. Has anyone taken the DP-700 beta exam yet? Or planning to in the near future? I do plan on covering it with content, but it likely won't be until early next year
32
9
New comment 6d ago
DP-700 beta exam experiences and tips (by Ali Stoops)
1 like • 9d
I passed DP 600. Thank you Will.
SEPTEMBER FABRIC UPDATES ANNOUNCED (FabCon2024)
So now we have confirmation of the new features that are being launched at FabCon. There are three main places to look: - The September 2024 Fabric Update Blog - Arun Ulag's summary of the announcements, which is also useful - If you like video, you can watch the Microsoft YouTube video on the updates: https://www.youtube.com/watch?v=sWQMlt9ikE0 It will take a few hours (or days/ weeks) to digest everything that's in there, but a few that caught my eye on first look: General: - Git Integration is now GA - New Fabric Terraform provider has been released (Preview), to enable infrastructure-as-code/ automation. - Access Databricks Unity Catalog tables from Fabric (public preview) Data Warehouse - T-SQL NOTEBOOKS! This is really cool - and opens up new options for Data Analytics (who know T-SQL), I mentioned this in my latest video. - Delta column mapping in the SQL analytics endpoint (public preview) - this allows users to be a bit more liberal with column names (including spaces, if that's your jam) Data Engineering - Support for spaces in Lakehouse Delta table names - T-SQL Endpoint now working on Lakehouse with Schemas (but Lakehouse Schemas still preview: use with caution!).
34
15
New comment Oct 3
SEPTEMBER FABRIC UPDATES ANNOUNCED (FabCon2024)
1 like • Sep 27
@Will Needham Thank you for another great session. I liked these announcements. Delta column mapping in the SQL analytics endpoint. Enabling SQL analytics endpoint on schema enabled Lakehouse’s. Database Migration Experiences.
Incremental Refresh for Dataflow Gen2 (Public Preview)
Hey everyone, the conference updates are now starting 👀 Starting with this incremental refresh feature added to the Dataflow Gen2. You can read more here: https://blog.fabric.microsoft.com/en-us/blog/announcing-public-preview-incremental-refresh-in-dataflows-gen2/
25
14
New comment 27d ago
Incremental Refresh for Dataflow Gen2 (Public Preview)
0 likes • Sep 27
Great to see. Hey Will, Can you help me determine which capacity we need to have to use this feature?
1-6 of 6
Pavan Kumar
2
9points to level up
@pavan-kumar-1816
Having good amount of experience as a Database developer, administrator and performance tuning expert in a Microsoft SQL Server.

Active 3d ago
Joined Sep 16, 2024
INDIA
powered by