SQL Archives - Page 279 of 519 - SQL Authority with Pinal Dave

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

December 26, 2011

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…

SQL SERVER – AdventureWorks for SQL Server 2012 RC0 – Samples Database for SQL Server 2012 RC0

December 18, 2011

Pinal Dave

SQL

SQL Documentation, SQL Download, SQL Sample Database

Microsoft has just released AdventureWorks database for SQL Server 2012 RC0. I am very happy that now I will be able to play with this new sample database and base my various demo script around the same. Here is the link to download AdventureWorks 2012 RC0 database.