Collaborate Disseminate
SQL CROSS JOIN queries are used to generate a paired…
The post SQL Server Essentials: Using SQL Cross Joins appeared first on Petri IT Knowledgebase.
Continue reading SQL Server Essentials: Using SQL Cross Joins
Creating backups is one of the most important duties of…
The post SQL Server Essentials: How to Create a Simple Backup Job in SQL Server appeared first on Petri IT Knowledgebase.
Continue reading SQL Server Essentials: How to Create a Simple Backup Job in SQL Server
I’ve been working long time on a web application, consisting of a large amount of data and many services and also communicating with external services.
Now that I’m very happy with the functionality and reliability, before moving from an … Continue reading Planing the security for a public web application, any feedback?
A self join in SQL Server is a useful statement…
The post SQL Server Essentials: Using SQL Self Joins appeared first on Petri IT Knowledgebase.
Continue reading SQL Server Essentials: Using SQL Self Joins
In relational databases like SQL Server, the SQL JOIN statement…
The post SQL Server Essentials: Using SQL Joins appeared first on Petri IT Knowledgebase.
In this article, I’ll cover the basics of using the… Continue reading SQL Server Essentials: Using SQL SELECT and the WHERE and HAVING Clauses to Retrieve Data
SQL Server sample databases can be very useful for learning… Continue reading SQL Server Essentials: SQL Server Sample Databases
Tables are one of the core components of every relational… Continue reading SQL Server Essentials: Modifying Table Data With SQL Insert, SQL Update, SQL Delete and Truncate
SQL Server is Microsoft’s premier data platform. While its core… Continue reading Essential SQL Server: Creating Databases and Tables
I need to prepare my web app for a penetration test. The scenario is: If one of our windows users is hacked, what can the hacker do to my app and my database?
I have a virtual machine on our server, which holds a SQL Server Express and a d… Continue reading How to secure a SQL Server database (windows auth) against a network windows user (penetration test)