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

SQL SERVER – Target Recovery Time of a Database – Advance Option in SQL Server 2012

December 27, 2011

Recently I was going over few advanced options of SQL Server 2012 in database properties and I found a new option in the property screen. Properties screen of SQL Server 2008 R2 Properties screen of SQL Server 2012 I got little curious and decided to learn what does this new…

SQL SERVER – Fix: Error: 15138 – The database principal owns a schema in the database, and cannot be dropped

December 26, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Last day I had excellent fun asking puzzle on SQL Server Login SQL SERVER – Merry Christmas and Happy Holidays – Database Properties – Number of Users. One of the user sent me email asking urgent question about how to resolve following error. Reader was trying to remove the login from…

SQL SERVER – Merry Christmas and Happy Holidays – Database Properties – Number of Users

December 25, 2011

Pinal Dave

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

First of all Merry Christmas and Happy Holidays to everybody. I wish you best holiday season. In today’s blog post – I am sharing very small question received by one of the reader. Though simple sometime a small question make people think. He sent me very similar to following image…

SQL SERVER – A Simple Puzzle and Simple Solution of Datatype and Computed Column

December 24, 2011

Pinal Dave

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

SQL Scripts

Christmas is just near and happy holidays to all of you. Today is Christmas eve and I decided to share something very simple but interesting with you. Recently some one reading my SQL Server Interview Questions and Answers book asked me following question. “Pinal, Instead of puzzle, or difficult interview…

SQL SERVER – A Quick Script for Point in Time Recovery – Back Up and Restore

December 23, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Scripts

Blogging is like writing a big novel in parts. It has its own mood and it has its own colors. Someday I feel like writing philosophy and some day I like writing theory and some day just a script. Today is one of the day when I just feel like…

SQL SERVER – A Quick Trick about SQL Server 2012 CONCAT Function – PRINT

December 21, 2011

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL Function, SQLAuthority Book Review

Yesterday I posted A Quick Trick about SQL Server 2012 CONCAT function and the very first comment in few minutes of Vinod Kumar. He suggested that this function should be also used with the PRINT statement as well. While I was having conversation with him – Jacob Sebastian sent me message…

SQLAuthority News – Introduction to expressor Connectivity to Salesforce – expressor Data Integration Applications

December 19, 2011

Pinal Dave

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

This month, expressor software is releasing the newest version of their data integration product – expressor 3.5. This release includes three significant enhancements to this powerful and adaptable product: an extensibility framework, integration with Melissa Data’s data quality tools, and operators to read from and write to Salesforce.com databases. As…