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

SQL SERVER – Expanding Your Skills – Notes from the Field #015

February 13, 2014

Notes from the Field, SQL Backup and Restore

[Note from Pinal]: This is a fifteenth episode of Notes from the Field series. We all want to learn more and progress in our career. It is human nature to look for change and variety after a while. In most of the cases, it is quite easy to move inside…

SQL SERVER – SafePeak SQL Server Acceleration Software Gets an Upgrade

February 12, 2014

Pinal Dave

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

SafePeak, the SQL Server application acceleration software, gets a new version upgrade and launches on Amazon Cloud Marketplace. SafePeak’s idea in a nutshell is simple. SafePeak is a query-level automated caching middleware for SQL Server-based operational applications. SafePeak accelerates apps by caching SQL queries while keeping a 100% ACID compliance…

SQL SERVER – SysTools SQL Recovery Software – An Experiment to Recover Database Corruption

February 11, 2014

Pinal Dave

SQL Tips and Tricks

SQL Backup, SQL Recover, SQL Server

NOTE: This was my experiment with database corruption. If your database is corrupted, you should contact professionals who do this as their primary job. Always make sure that you do experiments on the copy of your database on your development server, rather than on production server. Let us learn about Recover Database Corruption.

Developers – A Fun List of Things Related to Developer

February 9, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Earlier in the month of December 2013, I have written few articles which were related to the Developer and fun stuff. In those articles I had asked if I have missed anything, which I should have in the article and missed or not. I have got quite a few suggestions…

SQL Puzzle – A Quick Fun with Bit Wise Operator – Part 2

February 8, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

This is a follow up, puzzle of SQL Puzzle – A Quick Fun with BitWise Operator. Lots of people really like the earlier puzzle where I have used Bit Wise Operator AND and build a simple puzzle. Today we are going to use another bit wise operator – OR. First execute…

SQL Puzzle – A Quick Fun with Bit Wise Operator

February 7, 2014

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

It has been a long time since we have puzzle on this blog so let us have a quick puzzle this Friday. It is based on Bit Wise Operator and very simple if you know those operators. We will guess the output of the SQL script. For example, here is…

SQL SERVER – Learning SSIS – Where Do I Start? – Notes from the Field #014

February 6, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore

[Note from Pinal]: This is a new episode of Notes from the Field series. SQL Server Integration Service (SSIS) is one of the most key essential part of the entire Business Intelligence (BI) story. It is a platform for data integration and workflow applications. As wikipedia says – It features…