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

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

SQL SERVER Live Plans for Long Running Queries

Journey to SQL Authority with Pinal Dave, September 2, 2014
Views: 45 | Hits 5

If you are a SQL Server DBA or developer who is majorly dealing with queries which are running for a long time, you may have one request every time you see a long running query. The request is how to ...

Preventing SQL Injection Attack ASP.NET - Part I

The Code Project Latest Articles, September 1, 2014
Views: 54 | Hits 12

SQL Injection is a very common attack in web applications. This article explains how SQL Injection occurs and how to prevent it....

SQL SERVER How to Know Cardinality of Executed Query?

Journey to SQL Authority with Pinal Dave, September 1, 2014
Views: 72 | Hits 7

Earlier I wrote three blog posts on SQL Server 2014 Cardinality. Read them over here to get the context of this blog post. SQL SERVER How to Force New Cardinality Estimation or Old Cardinality Estima...

SQL Authority News 3000th Blog Posts and Thank You

Journey to SQL Authority with Pinal Dave, August 31, 2014
Views: 83 | Hits 2

3000th Blog Posts! When I realized that I am writing my 3000th blog post (list of all of my blog posts), I just got blank with happiness. I could not come up with what exactly to write. It has been a ...

SQL SERVER CTRL + R Shortcut Does Not Work in SSMS

Journey to SQL Authority with Pinal Dave, August 30, 2014
Views: 93 | Hits 2

I just formatted my computer and installed fresh SQL Server 2014. The very first thing which I did was to open SQL Server Management Studio and execute a sample query. As soon as I executed the query,...

SQL SERVER Query to Find Seed Values, Increment Values and Current Identity Column Value of the Table with Max Value of Datatype Part 2

Journey to SQL Authority with Pinal Dave, August 29, 2014
Views: 102 | Hits 1

Seven years ago, I wrote a blog post about – Query to Find Seed Values, Increment Values and Current Identity Column value of the table. It is quite a popular blog post and lots of people like it as i...

When you really need to know why your SQL Querys slow

Simple Talk, August 28, 2014
Views: 46 | Hits 6

It is useful to know that a SQL Query is slow, but it is even better to know why. To do this, we need to see how SQL Server’s Query Optimizer has translated the query into something that it can execut...

SQL SERVER Detecting Corruption with Suspect Pages Table Notes from the Field #043

Journey to SQL Authority with Pinal Dave, August 28, 2014
Views: 109 | Hits 2

[Note from Pinal]: This is a newepisode of Notes from the Fields series.I often hear about database corruption and I like to stay away from the problems related to corruption. When database gets corru...

SQL SERVER Query to Find Seed Values, Increment Values and Current Identity Column Value of the Table with Max Value of Datatype

Journey to SQL Authority with Pinal Dave, August 27, 2014
Views: 76 | Hits 1

Seven years ago, I wrote a blog post about – Query to Find Seed Values, Increment Values and Current Identity Column value of the table. It is quite a popular blog post and lots of people like it as i...

Menu Control Panel

The Code Project Latest Articles, August 26, 2014
Views: 75 | Hits 6

Development of a style menu control panel whose structure is handled from a SQL server database...

C#: Create, read and write MS Access (mdb, accdb), MySQL, SQL Server, SQL Server Compact and SQLite databases

The Code Project Latest Articles, August 26, 2014
Views: 87 | Hits 20

Both MS Access formats (mdb and new - accdb), MSSQL 2008 R2, MSSQL CE, SQLite, MySQL...

SQL SERVER Fix Error 7202 Could not find server in sys.servers. Verify that the correct server name was specified

Journey to SQL Authority with Pinal Dave, August 26, 2014
Views: 63 | Hits

The other day I received following error when I tried to restore a database from one server to another server. Msg 7202, Level 11, State 2, Line 1 Could not find server ‘MyLinkedServer’ in sys.servers...

SQL Authority News Secret Tool Box of Successful Bloggers: 52 Tips to Build a High Traffic Top Ranking Blog

Journey to SQL Authority with Pinal Dave, August 25, 2014
Views: 115 | Hits 2

When I started this blog, it was meant as a bookmark for myself for helpful tips and tricks. Gradually, it grew into a blog that others were reading and commenting on. While SQL and databases are my f...

SQL SERVER How to See Active SQL Server Connections For Database

Journey to SQL Authority with Pinal Dave, August 24, 2014
Views: 99 | Hits 9

Another question received via email - “How do I I know which user is connected to my database with how many connection?” Here is the script which will give us answer to the question. SELECT DB_NAME(db...

Developers Life Summary of Superhero Articles

Journey to SQL Authority with Pinal Dave, August 23, 2014
Views: 79 | Hits 5

Earlier this year, I wrote an article series where I talked about developer’s life and compared it with Superhero. I have got amazing response to this series and I have been receiving quite a lots of ...

Chris Date and the Relational Model

Simple Talk, August 22, 2014
Views: 4 | Hits

Chris Date is famous for his writings on relational theory. At IBM in the seventies, and afterwards, he was a friend and colleague of Edgar Codd, who invented the principles of the relational databas...

SQL SERVER How to Force New Cardinality Estimation or Old Cardinality Estimation

Journey to SQL Authority with Pinal Dave, August 22, 2014
Views: 85 | Hits

After reading my initial two blog posts on New Cardinality Estimation, I received quite a few questions. Once I receive this question, I felt I should have clarified it earlier few things when I start...

Azure: New DocumentDB NoSQL Service, New Search Service, New SQL AlwaysOn VM Template, and more

ScottGus Blog, August 21, 2014
Views: 3 | Hits

Today we released a major set of updates to Microsoft Azure. Todays updates include: DocumentDB: Preview of a New NoSQL Document Service for Azure Search: Preview of a New Search-as-a-Service offer...

SQL SERVER Backing Up and Recovering the Tail End of a Transaction Log Notes from the Field #042

Journey to SQL Authority with Pinal Dave, August 21, 2014
Views: 97 | Hits

[Notes from Pinal]: The biggest challenge which people face is not taking backup, but the biggest challenge is to restore a backup successfully. I have seen so many different examples where users have...

SQL SERVER Cardinality Estimation and Performance SQL in Sixty Seconds #072

Journey to SQL Authority with Pinal Dave, August 20, 2014
Views: 83 | Hits

Yesterday I wrote blog post based on my latest Pluralsight course on learning SQL Server 2014. I discussed newly introduced cardinality estimation in SQL Server 2014 and how it improves the performanc...

SQL SERVER Simple Demo of New Cardinality Estimation Features of SQL Server 2014

Journey to SQL Authority with Pinal Dave, August 19, 2014
Views: 82 | Hits 3

SQL Server 2014 has new cardinality estimation logic/algorithm. The cardinality estimation logic is responsible for quality of query plans and majorly responsible for improving performance for any que...

SQL SERVER Learn SQL Server 2014 Online in a Day My Latest Pluralsight Course

Journey to SQL Authority with Pinal Dave, August 18, 2014
Views: 78 | Hits 2

Click here watchSQL Server 2014 Administration New Features. SQL Server 2014 was released earlier this year and it has been extremely popular in Microsoft world. Here is the announcement for everyone,...

Create Table and Stored Procedure in Sql Server and connect it from Asp.Net using C#

The Code Project Latest Articles, August 17, 2014
Views: 73 | Hits 4

We will create a Table and Stored Procedure in Sql Server 2008R2 and data will be inserted and retrieved by using Asp.net using C#...

SQL SERVER Convert Seconds to Hour : Minute : Seconds Format

Journey to SQL Authority with Pinal Dave, August 17, 2014
Views: 59 | Hits 1

Here is another question I received via email. “Hi Pinal, I have a unique requirement. We measure time spent on any webpage in measure of seconds. I recently have to build a report over it and I did f...

SQL SERVER Convert Old Syntax of RAISEERROR to THROW

Journey to SQL Authority with Pinal Dave, August 16, 2014
Views: 85 | Hits 11

I have been quite a few comments on my Facebookpage and here is one of the questions which instantly caught my attention. “We have a legacy application and it has been a long time since we are using S...

SQL SERVER Validating If Date is Last Day of the Year, Month or Day

Journey to SQL Authority with Pinal Dave, August 15, 2014
Views: 92 | Hits 9

Here is one more question I recently received in an email- “Pinal, is there any ready made function which will display if the given date is the last day or the year, month or day? For example, if a da...

Getting Started with MongoDB and Java: Part II

The MongoDB NoSQL Database Blog, August 14, 2014
Views: 64 | Hits 2

By Trisha Gee, Java Engineer at Advocate at MongoDBIn the last article, we covered the basics of installing and connecting to MongoDB via a Java application. In this post, I’ll give an introduc...

SQL SERVER Script to Find First Day of Current Month

Journey to SQL Authority with Pinal Dave, August 14, 2014
Views: 94 | Hits 10

Earlier I wrote a blog post about SQL SERVER Query to Find First and Last Day of CurrentMonth and it is a very popular post. In this post, I convert the datetime to Varchar and later on use it. Howev...

Questions about T-SQL Expressions You Were Too Shy to Ask

Simple Talk, August 13, 2014
Views: 56 | Hits 6

Nobody seems to ask questions about SQL Expressions in forums, even though expressions can cause all sorts of problems. Even the books on T-SQL skate over them in haste to get to more complicated topi...

SQL SERVER ?Finding Out What Changed in a Deleted Database Notes from the Field #041

Journey to SQL Authority with Pinal Dave, August 13, 2014
Views: 91 | Hits 4

[Note from Pinal]: This is a 41th episode of Notes from the Fieldseries.The real world is full of challenges. When we are reading theory or book, we sometimes do not realize how real world reacts work...

SQLAuthority News Live Virtual Classroom New Trend in Technology

Journey to SQL Authority with Pinal Dave, August 13, 2014
Views: 57 | Hits 1

This blog post is by Nupur Dave, who is housewife and works from home. Changing times and a super busy lifestyle have rendered most of us powerless when it comes to doing what we love to do. I feel th...

Quickly Investigating What's in the Tables of SQL Server Databases

Simple Talk, August 12, 2014
Views: 49 | Hits 4

From SQL Server Management Studio it is difficult to look through the first few rows of a whole lot of tables in a database. This is odd, since it is a great way to get quickly familiar with a databas...

SQL Authority News FalafelCON 2014: 2 days with the Best Developers in the World

Journey to SQL Authority with Pinal Dave, August 12, 2014
Views: 58 | Hits 1

I love presenting at various forums on various technologies. I am extremely excited that I got invited to speak at Falafel Conference 2014 in San Francisco. I will present two technology sessions on S...

SQL SERVER Integrate Your Data with Skyvia Cloud ETL Solution

Journey to SQL Authority with Pinal Dave, August 12, 2014
Views: 70 | Hits 1

In our days data integration often becomes a key aspect of business success. For business analysts its very important to get integrated data from various sources, such as relational databases, cloud C...

Database Beginning with Cloud Database As A Service

Journey to SQL Authority with Pinal Dave, August 11, 2014
Views: 79 | Hits 7

I love my weekend projects. Everybodydoesdifferent activities in their weekend – like traveling, reading or just nothing. Every weekend I try to do something creative and different in the database wor...

SQL SERVER How to Roll Back SQL Server Database Changes

Journey to SQL Authority with Pinal Dave, August 11, 2014
Views: 69 | Hits 4

In a perfect scenario, no unexpected and unplanned changes occur. There are no unpleasant surprises, no inadvertent changes. However, even with all precautions and testing, there is sometimes a need t...

SQL Authority News Download and Install Adventure Works 2014 Sample Databases

Journey to SQL Authority with Pinal Dave, August 10, 2014
Views: 119 | Hits 3

If you are using SQL Server there are good chances that you are familiar with AdventureWorks.AdventureWorks is a Sample Database shipped with SQL Server and it can be downloaded from CodePlex site. Ad...

SQL SERVER Microsoft SQL Server Migration Assistant V6.0 Released

Journey to SQL Authority with Pinal Dave, August 9, 2014
Views: 90 | Hits 6

Every company makes a different decision about the database when they start, but as they move forward they mature and make the decision which is based on their experience and best interest of the orga...

SQL SERVER Introduction to SQL Server 2014 In-Memory OLTP

Journey to SQL Authority with Pinal Dave, August 8, 2014
Views: 103 | Hits 9

In SQL Server 2014 Microsoft has introduced a new database engine component called In-Memory OLTP aka project Hekaton which is fully integrated into the SQL Server Database Engine. It is optimized for...

Getting Started with MongoDB and Java: Part I

The MongoDB NoSQL Database Blog, August 7, 2014
Views: 89 | Hits 5

By Trisha Gee, Java Engineer and Advocate at MongoDBJava is one of the most popular programming languages in the MongoDB Community. For new users, its important to provide an overview of how to work w...

SQL SERVER SSIS Parameters in Parent-Child ETL Architectures Notes from the Field #040

Journey to SQL Authority with Pinal Dave, August 7, 2014
Views: 110 | Hits 1

[Notes from Pinal]: SSIS is very well explored subject, however, there are so many interesting elements when we read, we learn something new. A similar concept has been Parent-Child ETL architecture’s...

SQL SERVER SSMS: Memory Usage By Memory Optimized Objects Report

Journey to SQL Authority with Pinal Dave, August 6, 2014
Views: 111 | Hits 3

At conferences and at speaking engagements at the local UG, there is one question that keeps on coming which I wish were never asked. The question around, Why is SQL Server using up all the memory and...

Reply to "What ORMs have taught me: just learn SQL"

Frans Boumas blog, August 5, 2014
Views: 189 | Hits 33

This is a reply to "What ORMs have taught me: just learn SQL" by Geoff Wozniak. I've spent the last 12 years of my life full time writing ORMs and entity modeling systems, so I think I know a thing ...

SQL SERVER SSMS: Database Consistency History Report

Journey to SQL Authority with Pinal Dave, August 5, 2014
Views: 85 | Hits

Doctor and Database The last place I like to visit is always a hospital. With the monsoon season starting, intermittent rains, it has become sort of a routine to get a cycle of fever every other year ...

SQL SERVER SSMS: Backup and Restore Events Report

Journey to SQL Authority with Pinal Dave, August 4, 2014
Views: 101 | Hits 3

A DBA wears multiple hats and in fact does more than what an eye can see. One of the core task of a DBA is to take backups. This looks so trivial that most developers shrug this off as the only activi...

Fix: Add an Existing Entity Framework .edmx File to Visual Studio 2013

WebLog of Ken Cox [MVP], August 3, 2014
Views: 84 | Hits 10

One of my older code samples for RainWorx AuctionWorx uses Entity Framework and SQLCE to bulk import AdventureWorks products as sample auction, classified, and fixed price listings into the system. Wh...

Developers Life Every Developer is a Captain America

Journey to SQL Authority with Pinal Dave, August 3, 2014
Views: 83 | Hits 7

Captain America was first created as a comic book character in the 1940s as a way to boost morale during World War II. Aimed at a childrens audience, his legacy faded away when the war ended. However,...

MySQL Export the Resultset to CSV file

Journey to SQL Authority with Pinal Dave, August 2, 2014
Views: 75 | Hits 2

In SQL Server, you can use BCP command to export the result set to a csv file. In MySQL too, You can export data from a table or result set as a csv file in many methods. Here are two methods. Method ...

SQL SERVER SSMS: Disk Usage Report

Journey to SQL Authority with Pinal Dave, August 1, 2014
Views: 81 | Hits 7

Let us start with humor! I think we the series on various reports, we come to a logical point. We covered all the reports at server level. This means the reports we saw were targeted towards activitie...

Developers Life Disaster Lessons Notes from the Field #039

Journey to SQL Authority with Pinal Dave, July 31, 2014
Views: 69 | Hits 1

[Note from Pinal]: This is a 39th episode of Notes from the Fieldseries.What is the best solution do you have when you encounter a disaster in your organization. Now many of you would answer that in t...