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
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers