Manipulating Filetable Files Programatically
Learn how you can work with FileTable files from T-SQL as an alternative to the drag and drop methods of using Windows Explorer
Do Functions Stop You From Using Indexes?
If you have a function in the WHERE clause, you might have heard you can't use indexes. That's not entirely correct.
Logging SQL and Change-Tracking Events in EF Core
Julie Lerman introduces you to the new logging APIs in .NET Core, concentrating on SQL and change-tracking events, with a focus on providers that output to the console and the debugger.
Saving Data to Various Formats, Using SQL
You have many options when exporting data from a database. In this article, Phil Factor compares several methods including XML and array-in-array JSON for speed and file size.
Using T-SQL to Fix Bad Data in XML Documents Using FLWOR
Learn how to use T-SQL to fix contents of an XML document using FLWOR
Using T-SQL to find the Greatest Common Divisor (GCD) for any number of integers
In this tip we look at T-SQL code that can be used to determine the greatest common divisor for a set of integers.
Measuring Effectiveness
Being effective is important to Steve. Today he talks about the things you might consider when trying to determine if your group is being effective.
New Preview of SQL Server Management Studio Available for Download
On September 24th Microsoft released the first Community Technical Preview for SQL Server 2019, which was CTP2.0. At the same time Microsoft pushed out a new preview for SQL Server Management Studio (SSMS) known as version 18. Now is the time to download this new preview!
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
Alamat kantor resmi BCA KCU MOJOKERTO Telp:0817629933
WhatsApp:0817629933 Jl. HOS. Cokro Aminoto No.5, Mergelo, Jagalan, Kec. Magersari, Kota Mojokerto, Jawa Timur...
Alamat kantor resmi BCA KCP Ujung Berung Telp:083178278662
Wa:083178278662Jl. Raya Ujung Berung No.50, Pakemitan, Kec. Cinambo, Kota Bandung, Jawa Barat 40612
Alamat kantor resmi BCA KCP Prapen Telp:08218200205
WhatsApp:08218200205Jl. Raya Prapen No.38, Sidosermo, Kec. Wonocolo, Surabaya, Jawa Timur 60299
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers