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

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

SQL SERVER Search Records with Single Quotes

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

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: 61 | Hits 7

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: 93 | Hits 3

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: 100 | Hits 6

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: 77 | 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: 80 | 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: 76 | 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: 211 | Hits 30

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: 235 | 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: 161 | 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: 242 | 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: 312 | Hits 18

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: 235 | 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: 426 | 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: 247 | Hits 8

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: 349 | Hits 24

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: 264 | 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: 287 | 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: 229 | 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: 252 | 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: 331 | 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: 276 | 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: 259 | Hits 5

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: 317 | 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: 302 | 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: 301 | 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: 309 | 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: 233 | 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...

SQL SERVER GROUP BY Columns with XMLPATH

Journey to SQL Authority with Pinal Dave, October 3, 2014
Views: 289 | Hits 11

This is one of the most popular question and I keep on getting again and again in email, Facebookand on social media. I have decided to write about it here in the blog so in future I can directly give...

SQL Antipatterns by Bill Karwin, The Pragmatic Bookshelf

The Code Project Latest Articles, October 2, 2014
Views: 253 | Hits 11

SQL Antipatterns by Bill Karwin, The Pragmatic Bookshelf...

SQL SERVER ?Building Technical Reference Library Notes from the Field #048

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

[Note from Pinal]: This is a 48th episode of Notes from the Fieldseries.How do you build a technical reference library? In other word, when you need help how do you create your own reference so you do...

SQL SERVER A Practical Use of Backup Encryption

Journey to SQL Authority with Pinal Dave, October 1, 2014
Views: 203 | Hits 4

Backup is extremely important for any DBA. Think of any disaster and backup will come to rescue usersin adverse situation. Similarly, it is very critical that we keep our backup safe as well. If your ...

SQL SERVER A Pratical Use of Backup Encryption

Journey to SQL Authority with Pinal Dave, October 1, 2014
Views: 252 | Hits 2

Backup is extremely important for any DBA. Think of any disaster and backup will come to rescue usersin adverse situation. Similarly, it is very critical that we keep our backup safe as well. If your ...

Microsoft Releases SQL Server 2008 R2 SP3

Microsoft Certified Professional Magazine Online | Todays Top Picks, September 30, 2014
Views: 183 | Hits 4

SQL Server 2008 Release 2 Service Pack 3 has been released by Microsoft....

Windows Form Design at Run Time

The Code Project Latest Articles, September 30, 2014
Views: 175 | Hits 5

Windows Form Design at Run Time.Panel has been used as a Form where user can Add ,Move controls.user can Add,text,items,colors and etc using Property Window.Bind Data to DatagridView,ListView,ComboBox...

SQL SERVER UPDATE From SELECT Statement with Condition

Journey to SQL Authority with Pinal Dave, September 30, 2014
Views: 185 | Hits 4

An email from an old college friendlanded my mailbox: “Hey Pinal,” I have two tables. I want to conditionally update data in one table based on another table. How can I do that. I have included sample...

SQL SERVER How to Check Snapshot Isolation State of Database

Journey to SQL Authority with Pinal Dave, September 29, 2014
Views: 176 | Hits 2

It is very easy to know the snapshot Isolation State of Database and here is the quick script for the same. SELECT name , s.snapshot_isolation_state , snapshot_isolation_state_desc , is_read_committed...

SQL SERVER SQL Server 2008 R2 Service Pack 3 Download

Journey to SQL Authority with Pinal Dave, September 28, 2014
Views: 244 | Hits 1

It has been a long time since SQL Server 2008 R2 got Service Pack Update. Microsoft has finally released SQL Server 2008 R2 service pack 3and its feature pack.SQL Server 2008 R2 SP3 contains fixes to ...

SQL SERVER Extension of the SQL Server Natively Compiled Stored Procedures

Journey to SQL Authority with Pinal Dave, September 27, 2014
Views: 305 | Hits 4

Earlier I wrote a blog post aboutthe Location of Natively Compiled Stored Procedure and Naming Convention. In this blog post, I wrote about location of natively compiled stored procedures. In the blog...

A better way to play with HQL in Orchard

More Whidbey stuff, September 26, 2014
Views: 309 | Hits 3

In previous posts, Ive shown how to query Orchard with straight HQL. However, I havent provided a good environment to run and debug these queries so far, because I didnt have one. As a matter of facts...

SQL SERVER Performance Dashboard: Historic Information

Journey to SQL Authority with Pinal Dave, September 26, 2014
Views: 303 | Hits 8

There are a lot of games that I play with my daughter in spare time. Some of them are for just for fun and a lot of them are fun filled with some learning. As she started to grow up, it was important ...

SQL SERVER Database Taking Long Time to Create Notes from the Field #047

Journey to SQL Authority with Pinal Dave, September 25, 2014
Views: 231 | Hits 1

[Notes from Pinal]: There are few things which confuse us when we encounter first time, however, there are few concepts which confuses us even though we face them multiple times. One of the such subje...

Querying Orchard fields with HQL

More Whidbey stuff, September 24, 2014
Views: 236 | Hits 4

Before projections, the official word on fields was that they werent for querying (they are stored in an XML blob on the content item record). Projections enabled field querying for the first time, th...

SQL SERVER Performance Dashboard: Current Activity Section Reports

Journey to SQL Authority with Pinal Dave, September 24, 2014
Views: 220 | Hits 3

You are driving on the highway and you want to know your speed because there are cops generally in that areas you watch the dashboard. Your kid seems to be fiddling with your cell phone you want to ...

FreedReadR: RSS Reader Created With AngularJS (part 2 of 2)

The Code Project Latest Articles, September 23, 2014
Views: 205 | Hits 8

Learn Angular and Firebase API (AngularFire) for live storage of data via Internet using nosql db....

SQL SERVER SSMS: Performance Dashboard Reports Home Page details

Journey to SQL Authority with Pinal Dave, September 23, 2014
Views: 208 | Hits 4

Earlier we discussed in detail what the SSMS: Server Dashboard Report looks like when working with SQL Server Management Studio standard reports. These dashboard reports are an arsenal of amazing weal...

New D-Series of Azure VMs with 60% Faster CPUs, More Memory and Local SSD Disks

ScottGus Blog, September 22, 2014
Views: 213 | Hits 2

Today I’m excited to announce that we just released a new set of VM sizes for Microsoft Azure. These VM sizes are now available to be used immediately by every Azure customer. The new D-Series o...

Improving the Quality of SQL Server Database Connections in the Cloud

Simple Talk, September 22, 2014
Views: 215 | Hits 3

To access SQL Server from the client, you use TDS protocol over TCP. This is fine over reliable LANs but over the internet these connections are relatively slow and fragile, TDS is still used to conne...

SQL SERVER SSMS: Performance Dashboard Installation and Configuration

Journey to SQL Authority with Pinal Dave, September 22, 2014
Views: 200 | Hits 7

If the standard set of reports were not enough, in this blog, let me introduce an interesting addition to the reports. This is called as Performance Dashboard reports. There are a set of predefined ad...

SQL SERVER A Question on SSMS Prompt about Connect to Server

Journey to SQL Authority with Pinal Dave, September 21, 2014
Views: 224 | Hits 1

Today is Sunday, so letting us have some fun thing to discuss and think about. If you have not read my earlier blog postSQL SERVER Connecting to Azure Storage with SSMS. I have discussed about how to...