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

SQL SERVER – Three Questions – Do You Know Your Servers? – Book Gift

April 15, 2014

It has been almost 2 years since we had a poll on this blog so here a poll which ask you three simple questions. Trust me these questions, I have carefully picked after doing a beta testing on a small group of people. It was very intriguing to see that…

SQL SERVER – Finding Last Backup Time for All Database – Last Full, Differential and Log Backup – Optimized

April 14, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL DMV

Four years ago, I wrote a blog post SQL SERVER – Finding Last Backup Time for All DatabaseDatabase – Last Full, Differential and Log Backup. Well, in technology, there is always space for improvement and we should always be ready to learn and progress. SQL Expert TheSQLGuru came up with…

SQLAuthority News – Microsoft Whitepaper – Migrating Content Between Report Servers

April 13, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL White Papers

A very common challenge developer and administrator face when they have to migrate content between SQL Server Reporting Server. This is because SQL Server Reporting Services (SSRS) currently doesn’t include a feature for migrating content items and settings from one Reporting Services report server to another report server. There are…

SQLAuthority News – Microsoft Whitepaper – Idle Connection Resiliency

April 12, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL White Papers

Developers can write data access application that enables ideal connection resiliency with the .NET framework. An idle connection is the one that is active but it’s not executing a command or waiting for data. It is very important to understand how idle connection is reconnecting back in the .NET framework…

SQL SERVER – Drop All the Foreign Key Constraint in Database – Create All the Foreign Key Constraint in Database

April 11, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts

Earlier I wrote a blog post about how to Disable and Enable all the Foreign Key Constraint in the Database. It is a very popular article. However, there are some scenarios when user needs to drop and recreate the foreign constraints. Here is a fantastic blog comment by SQL Expert…

SQL SERVER – Finding Jobs Shrinking Database Files – Notes from the Field #023

April 10, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, Shrinking Database, SQL Backup and Restore

[Notes from Pinal]: Search on the internet about ‘Shrinking Database’, you will find plenty of advice why it is bad and it should not be done. If you do not believe me, just try it yourself. Even I have blogged about it before that it is an absolutely bad thing…

MySQL – Finding First day and Last day of a Month

April 9, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL, SQL DateTime

MySQL supports a lot of DATE and TIME related functions. If you want to find out last day of a month, you can make use of an inbuilt function named LAST_DAY. SET @date:='2012-07-11'; SELECT LAST_DAY(@date) AS last_day; The above code returns the value 2012-07-31 However, there is no inbuilt function…