(Rafael Victoria-Pereira) Normalization, explained in the first TechTip of this series, is more than just a theoretical concept. It’s time to put it to work in your database.
Other News
Some tips for using SQL Server 2019 cursors
Some tips for using SQL Server 2019 cursors Try to avoid using SQL Server cursors, whenever possible. SQL Server cursors can results in some performance degradation in comparison with select statements. Try to use correlated subquery or derived tables, if you need to perform row-by-row operations. Use READ ONLY cursors, whenever possible, instead of updatable cursors. Because using cursors can...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Previous SQL Server Updates
Hello everyone, this is John your Austin SQL Server Consultant here and today I am going to answer a question that comes up often so I wanted to blog about it for everyone. The question of the day is where can I download the previous SQL Server Updates?
Measuring Time: From Java to Kernel and back
(Jaromir Hamala) Even the most basic problems become interesting when you dig deep enough. Today, I would like to do a deep dive into measuring time in Java.
Use an API KEY or ACCESS TOKEN to connect to Db2 on IBM Cloud
(Henrik Loeser) In the past, I have blogged about how to access a Db2 database on IBM Cloud from your local machine. I cataloged the cloud host and its database. Then, connected to it using the command line processor (CLP) by passing a username and password.
Debugging ASP.NET Web Request Failures: The Complete Guide
(Michael Shpilt) You’re sending an HTTP request to your ASP.NET server, and out of the blue, it returns a 500 error. Now what? The error code doesn’t say too much by itself. Did a database request fail? What was the exact database query?
Common .NET Controls Crash Course, Part 3: ListBoxes
(Hannes DuPreez) A ListBox shows items inside a list. You can select items one by one, or even select multiple items depending on whether the SelectionMode property is set to SelectionMode.MultiSimple or SelectionMode.MultiExtended.
Reusing and Recycling Data Structures in gRPC Services in .NET Core
(Peter Vogel) Here’s everything you need to know to create a standard set of reusable message formats to use with your gRPC services.
MySQL: Check who’s trying to access data they should not
(Frederic Descamps) To illustrate how easy it’s to see who’s trying to access data they have not been granted for, we will first create a schema with two tables:
Manual upgrade to Oracle 19c (CDB/PDB)
(Stefan) Actually it is very cool to do everything with so called „auto tools“. If you prefer to do the Upgrade to 19c manually and step-by-step then you can follow my article and have fun otherwise skip this blog article