Why I’m Learning Git via the Command Line Interface
Today Kendra discusses the advantages of using a command line interface for Git.
How to Complain Bitterly using SQL Data Generator
How to use reverse regex expressions in SQL Data Generator to fill a text column in SQL Server with fake, but very realistic complaints.
Introduction to Gaps and Islands Analysis
T-SQL window functions simplify solving many complex queries. In this article, Edward Pollack demonstrates how the functions can be used to find gaps and islands in a dataset.
Let's Fix a Password Problem
Grant discusses the need for password managers to help prevent security issues between different accounts.
Provisioning ADF - Level 2 of the Stairway to Azure Data Factory
In this next level of the Stairway to Azure Data Factory, learn how to build your first ADF environment.
Monitoring your Servers and Databases with New Relic Infrastructure and SQL Monitor
New Relic Infrastructure is a capable server monitoring tool but adding Integrations provides only 'bare bones' monitoring for SQL Server. Grant Fritchey argues that to "instrument" a complex system such as SQL Server, effectively, you also need a tool that is built specifically for this purpose.
The 2020 Data Professional Salary Survey Results Are In.
We asked what you make, and 1,734 of you in 63 countries answered. Altogether, you made $170,753,936 this year. Damn, y’all are bringing home the bacon!
Re-oiling the gears for the data dictionary or catalog
Documentation is never a favorite task for developers. This article describes how you can use database system catalogs to make generating column descriptions less labor-intensive and also jump start a data dictionary or catalog.
Two Important ‘ONLINE’ Column-Level Operations in SQL Server
Today Kendra talks about two of the online options used when working with indexes.
Going Serverless with Azure SQL Database
Microsoft has a new virtual core offering of Azure SQL database called serverless and this offering optimizes the price performance tradeoff and simplifies performance management for databases with intermittent and unpredictable usage.
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers