News in the Category: SQL Subscribe to the rss of this category.

Total posts: 6467 | Sort by Views | Sort by Hits

SQL SERVER Answer to Puzzle ISNUMERIC and Unexpected Results

Journey to SQL Authority with Pinal Dave, October 31, 2014
Views: 59 | Hits 2

Earlier I blogged aboutPuzzle ISNUMERIC and Unexpected Results SQL in Sixty Seconds#076and it is one of the most popular blog posts. Lots of people answered the question correctly. In the blog post ...

SQL SERVER Beginning Table Valued Constructors Notes from the Field #052

Journey to SQL Authority with Pinal Dave, October 30, 2014
Views: 56 | Hits

[Note from Pinal]: This is a 52th episode of Notes from the Fieldseries.I am very happy that the journey which we started one year ago is a amazing milestone. In this 52 episode in the entire year we ...

SQL SERVER Puzzle ISNUMERIC and Unexpected Results SQL in Sixty Seconds #076

Journey to SQL Authority with Pinal Dave, October 29, 2014
Views: 58 | Hits 1

It has been a long time since I have asked, puzzled on this blog so let us have fun time together with ISNUMERIC function. If you get the correct answer to this question, I will give you one month fre...

Run SQL Queries on MongoLab

MongoLab - MongoDB Hosting, October 28, 2014
Views: 50 | Hits 3

This is a guest post by John A. De Goes, CTO of SlamData. SlamData is the commercial company behind the open source project of the same name. John is the original author and an active contributor to t...

MySQL cant specify target table for update in FROM clause

The Code Project Latest Articles, October 28, 2014
Views: 48 | Hits

How to fix the error "MySQL can't specify target table for update in FROM clause" while executing an update query....

SQL SERVER Exploring SQL Auditing with SQL Compliance Manager

Journey to SQL Authority with Pinal Dave, October 28, 2014
Views: 104 | Hits 2

As database administrators, we are constantly quizzed by our superiors to answer questions such as: how secure is our network, how secure is our data, is data secure at rest, is data secure in transit...

SQL Authority News Embarcadero DB PowerStudio Promotion & Savings

Journey to SQL Authority with Pinal Dave, October 27, 2014
Views: 78 | Hits

If you are regular readers of this blog, you may be aware of that I use many different tools in my daily routine. One of them is DB PowerStudio for Embarcadero. The team has recently announced special...

Full Stack Development on Google App Engine

The Code Project Latest Articles, October 26, 2014
Views: 50 | Hits 9

Effective way to develop and operate full stack web Apps and APIs on Google App Engine, including front end app & UI, restful web services and persistence layer as NoSQL database on Google Cloud Platf...

SQL SERVER How to Flip Value of Bit Field in SQL Server? Part 2

Journey to SQL Authority with Pinal Dave, October 26, 2014
Views: 73 | Hits 4

Yesterday I wrote a blog post aboutSQL SERVER How to Flip Value of Bit Field in SQLServer?. Lots of good suggestions I have received in response of the same. Here are a few different methods to flip ...

SQL SERVER How to Flip Value of Bit Field in SQL Server?

Journey to SQL Authority with Pinal Dave, October 25, 2014
Views: 104 | Hits 6

How do you flip bit field in SQL Server? Well, if you search for this question on internet, you will find many different answers, today we will see my favorite method to flip value for the bit field. ...

The Simple-Talk Magazine

Simple Talk, October 24, 2014
Views: 36 | Hits 2

This year, the Simple-Talk team have produced a magazine. Its been great fun, and a little stressful (deadlines for things to go to print always come too quickly), but we got there in time for SQL in ...

Different Items in RadCombobox in Each Row of RadGrid

The Code Project Latest Articles, October 24, 2014
Views: 50 | Hits

Different items in RadCombobox in each row of RadGrid with sqlDataSource...

Get Ready to Learn SQL: 5. Query Results Using Pattern Matching

The Code Project Latest Articles, October 24, 2014
Views: 111 | Hits 11

In this lesson you are going to explore how to do pattern matching with the SQL Where clause LIKE operator. Using this phrase allows us perform partial matches of data values and obtain answers to que...

Get Ready to Learn SQL Server: What is a Database NULL Value?

The Code Project Latest Articles, October 24, 2014
Views: 68 | Hits 3

What is a Null Value? In databases a common issue is what value or placeholder do you use to represent a missing values. In SQL, this is solved with null. It is used to signifymissingorunknownvalues....

SQL SERVER Database Stuck in Restoring State

Journey to SQL Authority with Pinal Dave, October 24, 2014
Views: 69 | Hits 2

Here is a one of the very common question I keep on getting via email. “I just restored all the backup files of my database, however, my database is still stuck in restoring state. How do I fix it?” W...

SQL SERVER The Why of BIML Notes from the Field #051

Journey to SQL Authority with Pinal Dave, October 23, 2014
Views: 101 | Hits 4

[Note from Pinal]: This is a 51th episode of Notes from the Fieldseries. In one of the earlier blog post we discussed about BIML and lots of people askedwhat is actually BIML and why one should use it...

Generate SPA Web App instantly in Minutes

The Code Project Latest Articles, October 22, 2014
Views: 64 | Hits 13

Generate a web app instantly, directly from a database(SQL Server)...

SQL SERVER Search Records with Single Quotes SQL in Sixty Seconds #075

Journey to SQL Authority with Pinal Dave, October 22, 2014
Views: 75 | Hits 1

Earlier I wrote two blog posts about Search Records with Single Quotes in two parts. Refer the blog posts over here. Search Records with Single Quotes Search Records with Single Quotes Part2 Though I...

Does NoSQL = NoDBA?

Simple Talk, October 21, 2014
Views: 4 | Hits

Theres a joke doing the rounds at SQL conferences and seminars: three DBAs walk into a NoSQL bar and leave when they cant find a table. You may have heard it before, but it made Matt Hilbert sit down ...

Resizing and Storing Image Files - File System and Database Part 1

The Code Project Latest Articles, October 21, 2014
Views: 67 | Hits 12

This article will describe and demonstrate a technique for resizing and storing image files on the local file system and image meta data in SQL Server using ASP.NET 4.51....

How to connect HTML Page with SQL Server

The Code Project Latest Articles, October 21, 2014
Views: 60 | Hits 9

How to connect HTML page with SQL Server...

SQL SERVER Search Records with Single Quotes Part 2

Journey to SQL Authority with Pinal Dave, October 21, 2014
Views: 76 | Hits 12

Yesterday I wrote a blog post about and it has created quite a lot of interest in the community SQL SERVER Search Records with Single Quotes. Here are a few other alternatives which I received as a c...

SQL SERVER Search Records with Single Quotes

Journey to SQL Authority with Pinal Dave, October 20, 2014
Views: 104 | Hits 11

Every day when I woke up there are hundreds of emails with various questions related to SQL. I spend my first hour of the day answer each of them. How do I search records with single quotes in it? Her...

SQL SERVER Combined Multiple .SQL files into One Single File

Journey to SQL Authority with Pinal Dave, October 19, 2014
Views: 89 | Hits 11

Here is an interesting problem which I enjoyed solving yesterday. There were multiple SQL Files in my one folder. When I had to send it to my friend I had to collect all the files into a folder and zi...

EXCEL / SQL SERVER Extract the Domain from an Email Address

Journey to SQL Authority with Pinal Dave, October 18, 2014
Views: 113 | Hits 6

Just like any business person, I work with Excel pretty much half of my time when I am not working with SQL Server. Recently I faced challenges when I wanted to extract domain from the email address. ...

SQL SERVER Finding Max Value From Multiple Values

Journey to SQL Authority with Pinal Dave, October 17, 2014
Views: 117 | Hits 7

Here is a question which I have received a few days ago. “I have three different variables, I want to find out which one of them has the maximum or highest value. How can I do that? I know I can do th...

SQL SERVER Do You Know Your Datas Classification? Notes from the Field #050

Journey to SQL Authority with Pinal Dave, October 16, 2014
Views: 84 | Hits 1

[Notes from Pinal]:Data is a very simple word, yet it is very powerful. There is a famous saying – Know Your Data. I have quite often found that developers do not know their data, they are often confu...

SQL SERVER Beginning Reading Transaction Log File

Journey to SQL Authority with Pinal Dave, October 15, 2014
Views: 92 | Hits 6

In this article we will examine what the SQL Server Transaction Log is, why do we need one and how it works. Transaction Log Overview The SQL Server transaction log is maybe one of the most unclear pa...

SQL Authority News Save USD 600 for SQL Live! 360 in November

Journey to SQL Authority with Pinal Dave, October 14, 2014
Views: 82 | Hits

I love talking about performance tuning and I love teaching about performance tuning. I think this is one subject, which everyone would like to discuss about, as this subject never gets old. I stay in...

SQL SERVER What is the Difference Between An INNER JOIN and WHERE Clause

Journey to SQL Authority with Pinal Dave, October 13, 2014
Views: 222 | Hits 31

Just received a question in email: “What is the Difference Between An INNER JOIN and WHERE Clause?” Well, the answer can be quite long but I will try to answer in few words and a very simple one. If y...

SQL SERVER SQL Server 2008 Service Pack 4 Download

Journey to SQL Authority with Pinal Dave, October 12, 2014
Views: 243 | Hits 6

It has been a long time since SQL Server 2008 got Service Pack Update. Microsoft has finally released SQL Server 2008 service pack 4 and its feature pack.SQL Server 2008 SP4 contains fixes to issues r...

Basic SQL Queries for Beginners

The Code Project Latest Articles, October 11, 2014
Views: 168 | Hits 6

In This Article lets see in detail of Basic SQL Query...

SQL SERVER Add Auto Incremental Identity Column to Table After Creating Table

Journey to SQL Authority with Pinal Dave, October 11, 2014
Views: 250 | Hits 12

Question: Is it possible to add an auto incremental identity column to any table in SQL Server after creating a table. Answer: There are two answers – No and Yes. Let us see them one by one. Answer No...

Web App Builder - Single Page Application(SPA) on any Mobile Device

The Code Project Latest Articles, October 10, 2014
Views: 321 | Hits 20

Generate a web app instantly, directly from a database (SQL Server)...

Generically Populate List of Objects from SqlDataReader

The Code Project Latest Articles, October 10, 2014
Views: 240 | Hits 8

This article will show how to create a list of a particular class type from a SqlDataReader object by dynamically creating a lambda expression to carry out the process of populating the list....

SQL SERVER Row Offset in SQL Server For Different Version

Journey to SQL Authority with Pinal Dave, October 10, 2014
Views: 444 | Hits 15

A very common question is how to find row offset in SQL Server. Here are a few examples based on different version of SQL Server. I have included SQL Server 2000 event, though it is almost 15 years ol...

Exploring Your SQL Server Databases with T-SQL

Simple Talk, October 9, 2014
Views: 255 | Hits 9

Most DBAs hoard their own favourite -SQL scripts to help them with their work, often on a USB 'thumbdrive', but it is rare that one of them offers us a glimpse of the sort of scripts that they find us...

Combining SqlConnection and SqlCommand in one Class in C#

The Code Project Latest Articles, October 9, 2014
Views: 359 | Hits 26

This article, along with real code, Combining SqlConnection and SqlCommand in one Class...

SQL SERVER ?Tuning Queries is Sometimes Waste of Time Notes from the Field #049

Journey to SQL Authority with Pinal Dave, October 9, 2014
Views: 269 | Hits 3

[Note from Pinal]: This is a 49th episode of Notes from the Fieldseries. Every day I get few emails where I am asked how to tune queries so the entire server run faster. I always end up writing long a...

SQL SERVER Reset the Identity SEED After ROLLBACK or ERROR

Journey to SQL Authority with Pinal Dave, October 8, 2014
Views: 295 | Hits 4

I have been blogging for almost 8 years now. I believe I have seen pretty much every single kind of email and comments I can receive from users. However, there are sometimes few which just are so inte...

Using SQLite as local database with Universal Apps

The Code Project Latest Articles, October 7, 2014
Views: 235 | Hits 6

This is a very basic and primitive guideline to use SqlLite as a common local database with Windows Universal Apps....

MySQL Scaling Existing Applications: Key Observations and Measurements

Journey to SQL Authority with Pinal Dave, October 7, 2014
Views: 257 | Hits

In the earlier blog post we discussed aboutHow to Create a Distributed Relational SQL Database, today we will continue to learn aboutScaling Existing Applications: Key Observations and Measurements. I...

ASP.NET WebApi - Use Redis as CacheManager

The Code Project Latest Articles, October 6, 2014
Views: 334 | Hits 31

This article walks you through configuration Redis and made basic operations using .net C# client.Redis is one of the fastest and feature-rich key-value stores to come from the NoSQL movement. It is s...

ASP.NET WebAPI - Basic Redis

The Code Project Latest Articles, October 6, 2014
Views: 281 | Hits 8

This article walks you through configuration Redis and made basic operations using .net C# client. Redis is one of the fastest and feature-rich key-value stores to come from the NoSQL movement. It is ...

MySQL How to Create a Distributed Relational SQL Database

Journey to SQL Authority with Pinal Dave, October 6, 2014
Views: 263 | Hits 6

Distributed relational databases are a perfect match for Cloud computing models and distributed Cloud infrastructure. As such, they are the way forward for delivering new web scale applications. But h...

SQL SERVER How to Catch Errors While Inserting Values in Table

Journey to SQL Authority with Pinal Dave, October 5, 2014
Views: 319 | Hits 10

Question: “I often get errors when I insert values into a table, I want to gracefully catch them, how do I do that.” Answer: Very simple. Just use TRY… CATCH. Here is the simple example of TRY…CATCH I...

SQL Queries to Know the Instance Messages State

The Code Project Latest Articles, October 4, 2014
Views: 306 | Hits 3

SQL queries to know the instance messages state...

SQL Server Database Development in Visual Studio

The Code Project Latest Articles, October 4, 2014
Views: 306 | Hits 5

SQL server database project creation using Visual Studio 2013...

SQL SERVER How to Find Running Total in SQL Server

Journey to SQL Authority with Pinal Dave, October 4, 2014
Views: 315 | Hits 8

Finding running total is one of the most popular request user encounters in the industry. There are two different ways to find out running totals. One of the methods is as per SQL Server 2008 R2 and e...

Acceptance Testing with FitNesse: Database Fixtures, Project Overview

Simple Talk, October 3, 2014
Views: 234 | Hits 1

There aren't many frameworks for writing acceptance tests for databases, including SQL Server. FitNesse is an obvious choice since it is designed with a Wiki-style interface that, once it is configure...