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

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

February 8, 2014

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…

SQL SERVER – Retrieve All the Data from VARCHAR(MAX) Column

February 5, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

In this blog post we will discuss a very common problem which developer who are working with SQL Server Management Studio and VARCHAR(MAX) Datatype faces. In database table if you have over 8200 characters in a column with datatype VARCHAR (MAX) it is not easy to display them in SSMS.…

SQL SERVER – Synchronize Schema across Multiple Environment – How to Overcome Database Migration Challenge

January 31, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Embarcadero, SQL Utility

Let us begin today’s blog post with interested story, which we all database developers go through once in a life time. Story of Database Developer This about a scenario – you have been out of town on vacation for one week and now you are just back to work. You…

SQL SERVER – Back& Reborn as Premier Back End SaaS Provider

January 28, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Utility

Back&, an international provider of Back Office Services, is proud to announce the launch of their revolutionary Zero Entry pricing model and Back End SaaS product. By creating a Better BackOffice, Back& has destroyed the barriers of cost and time – enabling companies and small business of any size access…

SQL SERVER – Rename a Table Name Containing [ or ] Identifier in the Name – Part 2

January 26, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

Yesterday I posted article where we discussed how to rename a table name where identifier is part of the tablename. Read the blog post Rename a Table Name Containing [ or ] in the Name – Identifier in the Table Name. If the table name contains an identifier, it is…