MySQL Archives - Page 7 of 17 - SQL Authority with Pinal Dave

SQL SERVER – Startup Problem – FIX – Error 5118, Severity 16, State 1

June 15, 2015

I have been monitoring some of the error messages that SQL Server has been throwing in the recent versions and they are self-explanatory. If we understand the English, then half the problem is solved. It becomes easier and quicker for an administrator if they ever encounter such errors. This blog…

SQL SERVER – One Trick of Handling Dynamic SQL to Avoid SQL Injection Attack?

February 6, 2015

Pinal Dave

SQL Tips and Tricks

MySQL, SQL Scripts, SQL Server, SQL Server Security

SQL Server has so many things to learn and I always find it amazing. My conversations with customers often come up with security questions esp around SQL Injection. Many have claimed SQL Injection is a SQL Server problem. It takes quite some time for me to let them know there is nothing about SQL Server and SQL Injection. SQL Injection is an outcome of wrong coding practices. One of the recommendations I give is about not using Dynamic SQL. There might be some situations where you can’t avoid it. My only advice would be, avoid if possible. In this blog, I would demonstrate a SQL Injection problem due to dynamic SQL and a possible solution you can have.

SQL SERVER – Watching Table Variable Data in TempDB

January 17, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL

I cannot get enough of working with TempDB and the learning never stops. Previously, when I wrote about SQL SERVER – Is tempDB behaving like a Normal DB?, SQL SERVER – Inside Temp Table Object Creation and Difference TempTable and Table Variable – TempTable in Memory a Myth many did…

MySQL – Scaling Existing Applications: Key Observations and Measurements

October 7, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL, ScaleBase

In the earlier blog post we discussed about How to Create a Distributed Relational SQL Database, today we will continue to learn about Scaling Existing Applications: Key Observations and Measurements. In the use case of an existing application that is on the verge of reaching the limits of its monolithic…

MySQL – How to Create a Distributed Relational SQL Database

October 6, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL, ScaleBase

Distributed relational databases are a perfect match for Cloud computing models and distributed Cloud infrastructure. As such, they are the way forward for delivering new web scale applications. But how is the data distributed in a distributed relational database? What is the best way to distribute data for my applications?…

SQL SERVER – How to Check Snapshot Isolation State of Database

September 29, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL

It is very easy to know the snapshot Isolation State of Database and here is the quick script for the same. SELECT name , s.snapshot_isolation_state , snapshot_isolation_state_desc , is_read_committed_snapshot_on FROM sys.databases s Upon running above code it will return the results describing the status of the isolation level for your…

Google Drive Trick – Google Spreadsheet Formatting Dates to String

September 14, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL, Software Development

I have been using google drive and google spreadsheet for a while. I work with experts around the world and we all use different date format. The biggest confusion which often happens when we are sharing data is a timestamp. For some people it is natural to have dates time…