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

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

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

Journey to SQL Authority with Pinal Dave, August 22, 2014
Views: 1 | 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...

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

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

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

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

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

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

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

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

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

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

[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: 1 | Hits

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

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

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

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

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

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

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

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

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

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

[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: 1 | Hits

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

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

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

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

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

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

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

[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...

SQL Authority News Play by Play with Pinal Dave A Birthday Gift

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

Today is my birthday. Personal Note When I was young, I was always looking forward to my birthday as on this day, I used to get gifts from everybody. Now when I am getting old on each of my birthday, ...

SQL SERVER SSMS: Top Object and Batch Execution Statistics Reports

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

The month of June till mid of July has been the fever of sports. First, it was Wimbledon Tennis and then the Soccer fever was all over. There is a huge number of fan followers and it is great to see t...

SQL SERVER SSMS: Top Queries by CPU and IO

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

Let me start this blog post with a personal story. Personal Story – Dad and I My fascination for computers started way back when I was about to get into highschool. My father once took me to his offic...

Developer Cross-Platform: Fact or Fiction?

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

This is a guest blog post by JeffMcVeigh.Jeff McVeigh is the general manager of Performance Client and Visual Computing within Intels Developer Products Division. His team is responsible for the devel...

The SQL of Membership: Equivalence Classes & Cliques

Simple Talk, July 28, 2014
Views: 1 | Hits

It is awkward to do 'Graph databases' in SQL to explore the sort of relationships and memberships in social networks because equivalence relations are classes (a set of sets) rather than sets. Howeve...

Practically Cloudy: SQL Server Disaster Recovery to Microsoft Azure - Backups

Simple Talk, July 28, 2014
Views: 1 | Hits

In the first in a series on the practicalities of using the Microsoft Azure Platform for the SQL Server professional, Buck Woody shows that, whatever your version of SQL Server, there is a way of stor...

SQL SERVER SSMS: Top Transaction Reports

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

Let us start with a personal story. Personal Story – My Daughter and I My day has its own part of long meetings and my daughter tries to pull a string here and there to get my attention almost every o...

Developers Life Every Developer is the Incredible Hulk

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

The Incredible Hulk is possibly one of the scariest superheroes out there. All superheroes are meant to be out of this world and awe-inspiring, but I think most people will agree with I say The Hulk t...

MySQL UDF Validate Integer Function

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

There is a default function in SQL Server called ISNUMERIC to determine if the string is numeric. In SQL Server ISNUMERIC returns 1 for non numerials also. Ex ISNUMERIC (‘,’) returns 1. To avoid this ...

SQL SERVER SSMS: Transaction Log Shipping Status Report

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

History has its own way to define now civilizations thrived. Most of the cities flourished in the river side and transporting lumber was one of the key activity. Most of the cities like Seattle and ma...

SQL SERVER How to Format and Refactor Your SQL Code Directly in SSMS and Visual Studio

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

This article shows how to use ApexSQL Refactor,a free SQL code formatting and refactoring tool. You can download ApexSQL Refactor, and explore it through the article. ApexSQL Refactor is a free tool, ...

SQL SERVER Andy Defines Basic RDBMS: Isolation in Processes Notes from the Field #038

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

[Note from Pinal]: This is a new episode of Notes from the Fieldseries.Every time I give an introductory note, however, this time there is no need of intronote. This note is from Andy and as we all kn...

SQL Authority News Webinar: SQL Server 2014 In-Memory OLTP and SafePeak In-Memory Caching

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

In the past couple of months many of us heard about the new SQL Server 2014 and its In-Memory technologies, such as In-Memory OLTP for high-transactional application and the ColumnStore INDEXs for BI ...

Northwind Database with NoSQL DBreeze

The Code Project Latest Articles, July 23, 2014
Views: 1 | Hits

Using NoSQL DBreeze database with ASP.NET on SQL Northwind Database....

SQL SERVER Finding Object Dependencies in SSMS SQL in Sixty Seconds #071

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

While we are doing development, we create and drop objects. We build new things and we need to understand the relationships between database objects when we are doing various activities in SQL Server....

SQL SERVER Free Entry to SQLPASS 2014 is Possible

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

The other day, I received an email from Dell and I was extremely delighted to read it. It contained details how one can go for FREE to SQLPASS. What is SQLPASS? The three-day event will be marked by a...

SQL SERVER SSMS: Activity All Blocking Transactions

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

Working out of India has its own challenges and I enjoy here despite these challenges thrown at me. One of the biggest advantage I have working with Pluralsight is, I can still get my job done by work...