What is SQL Server injection?

SQL injection is a technique in which attackers insert malicious code into strings fields of an application (Web or not) that are later delivered to an instance of SQL Server for parsing and execution. They can use it to gain unauthorized access to your sensitive data like customer information, personal data, business secrets, and more.  Most times, he

SQL Server migration to Amazon RDS best practices

We talked about availability and security best practices on Amazon RDS. Completing the series of posts, today we will know about Migration on Amazon RDS using SQL Server. In this article, best practices will be defined for the Native Backup/Restore and AWS data migration service. Native Backup/Restore is straightforward The database is backed up to

SQL Server on Amazon RDS – security best practices

Let’s discuss running SQL Server on Amazon RDS and security best practices. We already reviewed some availability best practices, and now will focus on security best practices. We will divide it into access restriction, audit, and data encryption.  Access restriction (VPC, Security Groups, Subnets) We can restrict access at different levels. First,  creating an individual

Using PowerShell to monitor disk usage

Part of the database and system administrator’s daily routine consists of monitoring disk usage. It can be achieved manually, however, it is much more logical to do this automatically. Even better – the automatic script can warn only when a specific space threshold on the specific drive has left. In this article, we are going

High Availability in SQL – all you need to know

You probably heard Service Level Agreement (SLA), Recovery Time Objective (RTO) and Recovery Point Objective (RPO) terminology. Another common phrase is – High Availability – it means that the SQL Server databases will be reachable, having in mind the least possible downtime, after any server crash or failure. It is closely related to high availability

What is SQL Server parameter sniffing?

SQL Server generates a query plan for a stored procedure using (sniffing) the parameters sent by the first time. By “first time” means that SQL Server is forced to compile a stored procedure because it is not in the procedure cache. All subsequent executions of that same query will go to the cache to reuse

Selecting the right database for your application

There is a trend we’re seeing across the industry, a single application using multiples databases. The companies are no longer standardizing on a particular database. Developers are now working backward from the use case and they’re billing and picking the right tool for the job (the right database for the use case). There are many

What hardware is your SQL Server bottle-necking on?

Hardware Components Your SQL Server Depend On Only 4 components that matter: CPU RAM Disk Networking   Which hardware component SQL Server bottlenecks on in 99% of cases? Disk.   I bet you $100, that your SQL Server is bottlenecking on Storage, Disk, input/out (IO) or whatever you want to call it. Its Disk. In

How to use SQL Server FILESTREAM feature for large databases

Do’s and don’ts   What is SQL Server FileStream feature? This feature allows adding unstructured documents into the database. You can store images, PDFs, videos, or whatever files you want into SQL Server database. This allows to have transactional consistency of images.   We have worked with very large FILESTREAM implementation. And I will show

Amazon AWS
Mark Varnas

Amazon AWS cloud storage selection guide: When to use S3, EBS or EFS.

Which AWS Storage options work for SQL Servers? If you looking for AWS storage options for SQL Servers for your EC2 instance, your choices are limited. You can use EBS GP2 or EBS Provisioned IOPS – that’s it! Amazon has multiple storage options. It may be a bit confusing which to use for what purpose.

sql performance
Mark Varnas

How to eliminate SQL Server migrations performance risks with DReplay

using THE LEAST USED SQL feature called Distributed Replay (DReplay) There are a lot of things that can go wrong during SQL migration. One of them – random TSQL calls which become slower. And they do. Here is an actual example where we tested two SQL Server configurations prior to SQL Upgrade and Migration. In

How to re-initialize SQL Server Merge replication publication

SQL Server Merge Steps 1. Connect to publisher instance: CIXSQL01\TOUCHSTORE. 2. Click right on Replication folder and click on “Launch Replication Monitor” option. 3. Click right on publication that you want to reinitialize and click on “Generate Snapshot” 4. After generating the snapshot go back to Local Replication, expand the publication you want to reinitialize,

FREE Scripts to Instantly
Improve SQL Server Performance

3 FREE Scripts to Instantly
Improve SQL Server Performance

Learn how to increase Performance of SQL Server INSTANTLY with 3 free scripts.