The Best of SQLServerCentral, Vol.7
The seventh volume in this collection brings you a compilation of the best articles we've seen over the past year, from over 50 authors.
2022-04-26 (first published: 2013-03-15)
7,664 reads
Articles
Understanding the Mapping Data Flow Activity in Azure Data Factory
Learn about using Mapping Data Flows in Azure Data Factory.
2022-04-25
9,665 reads
The 10 Benefits of Monitoring for Leaders
A third-party database monitoring tool is an investment that drives enormous value for the bottom line of a business in ten key ways, from simplifying cloud migration to retaining talent. Here's how.
2022-04-25
Understanding SQL Server Linked Servers
In this tip we look at how to setup a Linked Server in SQL Server using SQL Server Management Studio.
2022-04-25
2022-04-22
10,511 reads
Getting an Overview of Changes to a PostgreSQL Database using Flyway
How to use Flyway and PowerShell to automatically generate a database build script every time Flyway successfully created a new version. You can then investigate schema changes between versions simply by using a Diff tool to compare build scripts.
2022-04-22
Site Reliability Engineering vs. DevOps
What’s the difference between Site Reliability Engineering and DevOps? In this article, Grant Fritchey defines each one and compares them.
2022-04-22
Basic Git for DBAs: Getting Started with Git
Learn the basics of Git in this article if you've never used this version control system before. We will cover setting up a repo, adding files, changing them, and getting your history.
2022-04-20 (first published: 2020-06-08)
25,733 reads
CASE STUDY: The hybrid monitoring needs of a fast-growing global business
With ambitious expansion plans, PointsBet needed an expansive overview of its server estate, whether on Azure or on-premises, anywhere around the world. Find out how SQL Monitor rose to the challenge.
2022-04-20
How to get length of Text, NText and Image columns in SQL Server
There is sometimes a need to figure out the maximum space that is being used by a particular column in your database. You would initially think that the LEN() function would allow you to do this, but this function does not work on Text, NText or Image data types, so how do you figure out the length of a value in a column that has one of these data types?
2022-04-20
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
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...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
SQL Art, Part 3: Happy Easter Fun in SSMS
Comments posted to this topic are about the item SQL Art, Part 3: Happy...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers