Is Homomorphic SQL Query Encryption a good idea – and should I use It?

My web app still needs a lot of work on it in the security department, so I’m considering implementing homomorphic encryption for my SQL database- to help protect from the outcomes of SQLi.
I know the basic principles of how homomorphic en… Continue reading Is Homomorphic SQL Query Encryption a good idea – and should I use It?

Install and Use SQL Server Report Builder

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.

Continue reading Install and Use SQL Server Report Builder

April’s Patch Tuesday Brings Record Number of Fixes

If only Patch Tuesdays came around infrequently — like total solar eclipse rare — instead of just creeping up on us each month like The Man in the Moon. Although to be fair, it would be tough for Microsoft to eclipse the number of vulnerabilities fixed in this month’s patch batch — a record 147 flaws in Windows and related software. Continue reading April’s Patch Tuesday Brings Record Number of Fixes

xp_cmdshell as dbo user only able to run ‘ping localhost’ to verify RCE?

I am doing a pentest on a client’s ASP web application and I have identified a blind SQL injection. However, after enabling xp_cmdshell, I am only able to run the ping localhost command to verify the RCE, which has a 3-second delay. I also… Continue reading xp_cmdshell as dbo user only able to run ‘ping localhost’ to verify RCE?

SQL Server Essentials: What Is a Relational Database?

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?

Secure authentication method for creating an Excel data connection to SQL Server

My company has a website with data stored in Microsoft SQL Server on the production server. The production server is not in Active Directory. The firewall allows connections to the production SQL server from the company offices.
I need to … Continue reading Secure authentication method for creating an Excel data connection to SQL Server

SQL Server – How to Add a Table Using SQL CREATE TABLE

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 – How to Create a SQL Database

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.

Continue reading SQL Server – How to Create a SQL Database

Master SQL Server: SQL Server Management Studio Tutorial

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