Searching for Objects in SQL Server Databases
How to get the most out of SQL Search, a free database search tool for SQL Server Management Studio (SSMS) and Visual Studio that will locate database objects based on their names, columns, or text.
The API Bottleneck
Using an API for data access can be good, but it can also be a performance problem if everyone uses it.
Getting In A State Using Flyway
Flyway Teams baseline migration scripts are a simple and fast way to deploy new copies of a database, at a specific version, for testing work, or to create a new branch during development.
Introduction to SQL Server sequence objects
SQL Server sequence objects can be used in place of identity columns. In this article, Greg Larsen explains how to set up and use sequence objects.
Easily Integrate with Any RESTful API Using the CData API Driver
The evolution of APIs has opened up exciting opportunities for businesses. RESTful APIs are a consistent, straightforward way that enables businesses to work with external data and offer access to their own data. In May 2021, the number of public APIs grew beyond 24,000, with about 2,000 APIs added just since 2019. APIs continue to be beneficial to businesses and developers, and with the CData API Driver, it […]
SQL Server Row-Level Security: A Comparison with Gallium Data
A quick look at how the native SQL Server Row-Level Security compares with Gallium Data's solution for limiting access to rows of data.
SQL Server Database Stuck in Restoring Stat
In this tip we look at different reasons why a SQL Server database will be in a restoring state and things that can be done to access the database.
What we learned at PASS Data Community Summit
Join Steve Jones, Kathi Kellenberger and Grant Fritchey as they each reveal their highlights, learnings and key takeaways from their 2021 Summit experience.
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