Collaborate Disseminate
In this article, Michael Otey shows you how to use SQL Server Report Builder. SQL Server Report Builder and Reporting Services Microsoft SQL Server Reporting Services (SSRS) enables you to create, deploy, and manage printed, web, email, and mobile reports using data from SQL Server databases and Analysis Services (SSAS) as well as other relational…
The post Install and Use SQL Server Report Builder appeared first on Petri IT Knowledgebase.
SQL Server is a relational database. But what is a relational database exactly? Mike Otey, our resident SQL Server expert, explains in this article. What is a relational database? A relational database is a type of data storage mechanism that organizes data into tables where each table consists of rows and columns. It is typically…
The post SQL Server Essentials: What Is a Relational Database? appeared first on Petri IT Knowledgebase.
Continue reading SQL Server Essentials: What Is a Relational Database?
In this article, we’ll examine some of the main challenges of today’s backup and disaster recovery procedures. Then, we’ll dive into the top five most important features to look for in an on-premises Veeam storage solution for your backups. Data protection is one of the most critical tasks for IT administrators, and there is no…
The post Top 5 Features to Look for in On-Premises Veeam Storage appeared first on Petri IT Knowledgebase.
Continue reading Top 5 Features to Look for in On-Premises Veeam Storage
A Windows Server Active Directory (AD) forest is the topmost logical container in an AD configuration. In this article, Michael Otey explains the role forests play in an AD configuration and why it is necessary to consolidate Active Directory forests and domains to improve security and management. Every Active Directory deployment contains at least one forest, the parent container in…
The post 5 Reasons to Consolidate Active Directory Domains and Forests appeared first on Petri IT Knowledgebase.
Continue reading 5 Reasons to Consolidate Active Directory Domains and Forests
Once you have created a user database, you can begin to create tables using the SQL CREATE TABLE statement. Databases typically have many different tables. If you haven’t yet created your first database in SQL Server, check out this article on Petri about how to create a SQL database using the SQL CREATE DATABASE statement. Tables are structures…
The post SQL Server – How to Add a Table Using SQL CREATE TABLE appeared first on Petri IT Knowledgebase.
Continue reading SQL Server – How to Add a Table Using SQL CREATE TABLE
SQL Server is Microsoft’s premier data platform. While its core is a relational database engine, it also includes many other subsystems and capabilities that go far beyond just a relational database. In this tutorial, I’ll explain how to create a database. While not everyone realizes this at first, SQL Server provides business intelligence using Analysis Services, reports…
The post SQL Server – How to Create a SQL Database appeared first on Petri IT Knowledgebase.
In this SQL Server Management Studio tutorial (SSMS), I will show you the primary database management and development capabilities provided by the tool. Microsoft SQL Server Management Studio (SSMS) is the primary management and development tool for SQL Server and has been since its release back with SQL Server 2000. SSMS provides a graphical interface…
The post Master SQL Server: SQL Server Management Studio Tutorial appeared first on Petri IT Knowledgebase.
Continue reading Master SQL Server: SQL Server Management Studio Tutorial
SQL Server is a relational database management system (RDBM) developed by Microsoft that competes with Oracle, IBM DB2, MySQL, PostgreSQL, and other RDBMs. In this article, I’ll explain in detail what is SQL Server and go through its release history over the past three decades. I’ll also detail what are the different SQL Server versions…
The post SQL Server Essentials: Understanding SQL Server and its Different Editions appeared first on Petri IT Knowledgebase.
Continue reading SQL Server Essentials: Understanding SQL Server and its Different Editions
SQL Server’s T-SQL query language has a plethora of data retrieval options. That includes the ability to query a SQL database, as well as providing a sum function, a count aggregate function, and grouping columns. The SQL GROUP BY clause can make use of all of these capabilities. In this article, I’ll show you how…
The post SQL Server Essentials: Using the SQL GROUP BY Clause appeared first on Petri IT Knowledgebase.
Continue reading SQL Server Essentials: Using the SQL GROUP BY Clause
If you’re following industry trends, there’s no doubt that generative AI is the hottest new technology of the past year. And with Microsoft, Google, and other major tech companies jumping on this generative AI bandwagon, this trend isn’t going to be abated anytime soon. In IT, a rapidly growing number of software vendors now have…
The post Is AI Going to Change Backup and Recovery Strategies? appeared first on Petri IT Knowledgebase.
Continue reading Is AI Going to Change Backup and Recovery Strategies?