SQL Tips and Tricks Archives - Page 176 of 536 - SQL Authority with Pinal Dave

SQL SERVER – How to Get SQL Server Restart Notification?

June 13, 2014

Few days back my friend called me to know if there is any tool which can be used to get restart notification about SQL in their environment. I told that SQL Server can do it by itself with some configurations. He was happy and surprised to know that he need…

SQL SERVER – SQL Server High Availability Options – Notes from the Field #032

June 12, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Notes from the Field, Shrinking Database

[Notes from Pinal]: When it is about High Availability or Disaster Recovery, I often see people getting confused. There are so many options available that when the user has to select what is the most optimal solution for their organization they are often confused. Most of the people even know…

MySQL – Video Course – MySQL Backup and Recovery Fundamentals

June 10, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL, SQL Backup and Restore

Data is the one of the most crucial things for any organization and keeping data safe is the biggest challenge for any DBA. This is true for any organizations. Think about the scenario that you have a database which is extremely important and suddenly you accidently delete the most important…

MySQL – Introduction to CONCAT and CONCAT_WS functions

June 7, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

MySQL supports two types of concatenation functions. They are CONCAT and CONCAT_WS CONCAT function just concats all the argument values as such SELECT CONCAT('Television','Mobile','Furniture'); The above code returns the following TelevisionMobileFurniture If you want to concatenate them with a comma, either you need to specify the comma at the end…

SQL SERVER – Planned and Unplanned Availablity Group Failovers – Notes from the Field #031

June 5, 2014

Pinal Dave

SQL Tips and Tricks

Notes from the Field, SQL High Availability, SQL Scripts, SQL Server

[Note from Pinal]: This is a new episode of Notes from the Fields series. AlwaysOn is a very complex subject and not everyone knows many things about this. The matter of the fact is there is very little information available on this subject online and not everyone knows everything about this. This is why when a very common question related to AlwaysOn comes, people get confused. Let us learn about Planned and Unplanned Availablity Group Failovers.

SQL SERVER – Iridium I/O – SQL Server Deduplication that Shrinks Databases and Improves Performance

June 2, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Database performance is a common problem for SQL Server DBA’s. It seems like we spend more time on performance than just about anything else. In many cases, we use scripts or tools that point out performance bottlenecks but we don’t have any way to fix them. For example, what do…

SQL SERVER – Faster SQL Server Databases and Applications – Power and Control with SafePeak Caching Options

June 2, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Safepeak

Update: This blog post is written based on the SafePeak, which is available for free download. Today, I’d like to examine more closely one of my preferred technologies for accelerating SQL Server databases, SafePeak. Safepeak’s software provides a variety of advanced data caching options, techniques and tools to accelerate the…