SQL Server Archives - Page 196 of 393 - SQL Authority with Pinal Dave

SQL SERVER – Cartoon Challenge – 140 Character Winner is Here

May 4, 2011

Personal, SQL, SQL Performance, SQL Puzzle, SQL Server, SQL Tips and Tricks

Earlier Idera has announced contest where participant can win Windows Mobile Phone by writing 140 character. Here is the details of the contest SQLAuthority News – Win Windows Phone from Idera in 140 Characters – A Cartoon Challenge of SQL. We received more than 200 comments on the blog post…

SQL SERVER – Error: Failed to retrieve data for this request. Microsoft.SqlServer.Management.Sdk.Sfc – ‘DATABASEPROPERTY’ is not a recognized built-in function name. (Microsoft SQL Server, Error: 195)

May 3, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

I have four different machine at home. Office Laptop – Provided by work organization Personal Laptop – My wife uses it Demo Machine – A very old machine – I think I can only do demo of my messenger only – it is 32 bit – single CPU 1 GB…

SQL SERVER – Performance Improvement with of Executing Stored Procedure with Result Sets in SQL Server 2012

May 2, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Earlier I posted article SQL SERVER – Denali – Executing Stored Procedure with Result Sets. After reading this SQL Expert Ramdas asked following and very interesting question: This is a nice feature and i am sure would be used a lot. How is the performance of this as compared with using…

SQL SERVER – Migration Assistant for Access, MySQL, Oracle, Sybase

May 1, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download

SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from Sybase Adaptive Server Enterprise (ASE) to SQL Server or SQL Azure. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration…

SQL SERVER – 2012 – Executing Stored Procedure with Result Sets – New

April 29, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

After reading my earlier article SQL SERVER – Denali – Executing Stored Procedure with Result Sets, one of the readers asked if this new feature (syntax) support multiple resultset of the stored procedure? Very interesting question indeed as most of the stored procedures that I usually come across have more than…

SQL SERVER – 2012 – Executing Stored Procedure with Result Sets

April 28, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure

Here is a normal conversation I heard when I saw that the function (UDF) was used instead of the procedure (SP). Q: Why are you using User Defined Function instead of Stored Procedure? A: I cannot SELECT from SP, but I can from UDF. SQL Server’s next version ‘Denali’ is…

SQL SERVER – Introduction to SQL Azure – Creating Database and Connecting Database

April 27, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

I recently logged into new Azure Portal and I really think the product team has done excellent job to make it user-friendly and self intuitive. Here are the quick steps I have done after I logged into the portal here: Purchased subscription Created Server Created Database Connect using Database Honestly…