Exporting and Importing Registered Servers in SSMS
This article shows how to import and export a list of registered servers from SSMS.
This article shows how to import and export a list of registered servers from SSMS.
Today, Kendra Little talks about code reviews and why they should be done early.
Learn how to use different Spark SQL string functions to manipulate string data with explanations and code examples.
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. […]
Today, Grant talks about reasons that companies don't upgrade.
You have dropped a column and wondering why you haven't recovered any space? Let's take a look.
In this article, I will discuss the history and thinking behind several types of logic that are typically associated with writing relational database code.
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.
Today, Grant Fritchey compares a disaster caused by a toilet to technical debt in IT.
Sometimes when you do GROUP BY, the order of the columns does matter. For example, these two SELECT queries produce different results:
By Rohit Garg
In the expansive landscape of software development, the relationship between Database Administrators (DBAs) and...
We’re working through the major refresh of my Certified Kubernetes Administrator series at Pluralsight! The...
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
Hi everyone, So I have a SSIS package that performs some importing/exporting from MySQL...
Hello SSC, I am not a DBA,. I have some DBA knowledge, but my...
I am currently working on creating a baseline for our server, using various counters...
In which editions of SQL Server 2022 can you run Reporting Services?
See possible answers