Exporting and Importing Registered Servers in SSMS
This article shows how to import and export a list of registered servers from SSMS.
Why Early Code Review is Important for Database Deployments
Today, Kendra Little talks about code reviews and why they should be done early.
Learning Spark SQL String Functions with Explanations and Code Examples
Learn how to use different Spark SQL string functions to manipulate string data with explanations and code examples.
One more reason to use foreign key constraints
Since the title might be considered a bit vague, I don’t want you to wade through the article to figure it out. I will spare you the typical clickbait introduction, with me telling you what a foreign key constraint is, and why it and all the other constraint types provided by relational engines are useful. […]
Good Luck is Needed with Old Versions
Today, Grant talks about reasons that companies don't upgrade.
What happens when we drop a column on a SQL Server table? Where's my space?
You have dropped a column and wondering why you haven't recovered any space? Let's take a look.
SQL Logic
In this article, I will discuss the history and thinking behind several types of logic that are typically associated with writing relational database code.
Stairway to Advanced T-SQL Level 5: Turning Data On Its Side Using PIVOT Operator
The PIVOT operator was added to the Transact-SQL language in SQL Server 2005. It allows you to turn your row data on its side, so it can be presented as column data. This is useful when you want take unique column values and have them displayed as column headings, where the column headings are associated with summarized values displayed below each column heading. In this article I will be exploring how to use the PIVOT operator.
Toilets and Your Systems
Today, Grant Fritchey compares a disaster caused by a toilet to technical debt in IT.
Does Your GROUP BY Order Matter?
Sometimes when you do GROUP BY, the order of the columns does matter. For example, these two SELECT queries produce different results:
Blogs
6 Best SQL Training Courses for Beginners (2024 Updated)
We all know that choosing the right basic SQL training is absolutely crucial if...
SQL Saturday Atlanta 2024
By DataOnWheels
Hey there happy coders! Last weekend I had the pleasure of speaking at the...
Test Data Management – 2024 is your year to do it
By HeyMo0sh
This blog post is about Test Data Management – or my take on it....
Forums
Action Over Knowledge
Comments posted to this topic are about the item Action Over Knowledge
a function that acts like both a scalar and table valued function
Hi, i hope i'm doing this question justice. A peer of mine likes the...
What does it mean when Query Store Tracked Queries shows the same Plan Id twice?
I'm investigating a query which sometimes performs badly and, when I locate one of...
Question of the Day
Post Restore Tasks for the Resource Database
I backup the Resource database from my SQL Server 2022 instance. I then install CUs 1, 2, 3, and 4. I have an issue and need to restore my Resource database from backup. Is there anything I need to do after restoring this database?
See possible answers