ASP.NET News from Blogger:
Journey to SQL Authority with Pinal Dave
Total News: 1765
Yesterday my friend Vinod Kumar wrote excellent blog post onSQL Server 2012: Using SEQUENCE. I personally enjoyed reading thecontenton this subject. While I was reading the blog post, I thought of ver...
During my 8 years of career, I have been many times interviewer and quite often interview candidate myself. If I am interviewer I do ask many questions from easy to difficult one. When I am a candidat...
SQL Server management Studio 2012 is wonderful tool and has many different features. Many times, an average user does not use them as they are not aware about these features. Today, we will learn one ...
Some confusion never go away. Here is the one of the ancient one. Precision of the SmallDateTime is the one concept/confusion I receive more than once a day everyday. Let me start the with question: W...
If you are regular reader of this blog, you must be aware of that there are two kinds of blog posts 1) I share what I learn recently 2) I share what I learn and request your participation. Today’s blo...
Codeplex is my favorite site. CodePlex is Microsoft’s free open source project hosting site. You can create projects to share with the world, collaborate with others on their projects, and download op...
Note: I have used SQL Server 2012 for this small fun experiment. Here is what we are going to do. We will run the script one at time instead of running them all together and try to guess the answer. I...
Nakul Vachhrajani is a Technical Specialist and systems development professional with iGATE having a total IT experience of more than 7 years.Nakul is an active blogger with BeyondRelational.com (150+...
Microsoft has just released SQL Server 2012 Upgrade Technical Guide. This guide is very comprehensive and covers the subject of upgrade in very much depth.This is indeed a great detailed white paper. ...
Joes 2 Pros SQL Server Learning series is indeed fun. Joes 2 Pros series is written for beginners and who wants to build expertise for SQL Server programming and development from fundamental. In the b...
Sometime a simple solution have even simpler solutions but we often do not practice it as we do not see value in it or find it useful. Well, today’s blog post is also about something which I have seen...
As you know I have been writing on Columnstore Index for quite a while. Recently my friend Vinod Kumar wrote about SQL Server 2012: ColumnStore Characteristics. A fantastic read on the subject if you ...
Data modeling is the most important task for any BI professional. Matter of the fact, the biggest challenge is toorganizing disparate data into an analytic model that effectively and efficiently suppo...
Developer Training Kit is my favorite part of any product. The reason behind is very simple because it give the single resource which gives complete overview of the product in nutshell. A developer ca...
This blog post is inspired fromSQL Interoperability Joes 2 Pros: A Guide to Integrating SQL Server with XML, C#, and PowerShell SQL Exam Prep Series 70-433 Volume5. [Amazon] | [Flipkart] | [Kindle] ...
This blog post is inspired fromSQL Programming Joes 2 Pros: Programming and Development for Microsoft SQL Server 2008 SQL Exam Prep Series 70-433 Volume4. [Amazon] | [Flipkart] | [Kindle] | [IndiaPl...
This blog post is inspired fromSQL Architecture Basics Joes 2 Pros: Core Architecture concepts SQL Exam Prep Series 70-433 Volume3. [Amazon] | [Flipkart] | [Kindle] | [IndiaPlaza] This is follow up ...
This blog post is inspired fromSQL Queries Joes 2 Pros: SQL Query Techniques For Microsoft SQL Server 2008 SQL Exam Prep Series 70-433 Volume2.[Amazon] | [Flipkart] | [Kindle] | [IndiaPlaza] This is...
This blog post is inspired fromBeginning SQL Joes 2 Pros: The SQL Hands-On Guide for Beginners SQL Exam Prep Series 70-433 Volume1. [Amazon] | [Flipkart] | [Kindle] | [IndiaPlaza] This is follow up ...
One of the very common question I receive on my facebook is that if there is any tutorial for SQL Server 2012 newenhancedfeatures and solutions. I see this demand a bit increasing as the SQL Server 20...
How many time you have felt that there should be need of the tool which help you to migrate SQL Server Reports from one server to another server. Well, I am glad to see this migration tool for migrati...
I think there was a time when lots of questions were coming via either email or blog comments. Now a days, the trend is changed in recent time. Most of the question I receive is through social media. ...
Just a day ago in evening I asked very simple question on my Facebook Page. The question was written in jiffy and in very light mood. When writing question I left few things out, and it did miss few d...
SQL Server 2012 launched on March 7, 2012. SQL Server 2012 was available on April 1, 2012 for General Availability. Recently I have received quite a few queries that they are facing issues with SQL Se...
Balmukund Lakhani(Blog | Twitter | Site) is currently working as Technical Lead in SQL Support team with Microsoft India GTSC. In past 5+ years with Microsoft he was also a part of Premier Field Engin...
Data is powerful. Data drives businesses. Data supports decision making and fuels progress. But managing datamaking data work for usisn’t inherently easy. And if there is one thing that is certain, it...
Microsoft has recently introduced few changes in how the certification works. I have tried tosimplifythe same thing over here. The new certification line is calledMicrosoft Cloud-built Certifications....
Migration is always a challenge. How many times we have stayed away from migrating product to another server or next version because we are worried what will happen once we migrate. There are two main...
This blog post is inspired fromSQL Interoperability Joes 2 Pros: A Guide to Integrating SQL Server with XML, C#, and PowerShell SQL Exam Prep Series 70-433 Volume5. [Amazon] | [Flipkart] | [Kindle] ...
This blog post is inspired fromSQL Programming Joes 2 Pros: Programming and Development for Microsoft SQL Server 2008 SQL Exam Prep Series 70-433 Volume4. [Amazon] | [Flipkart] | [Kindle] | [IndiaPl...
This blog post is inspired fromSQL Architecture Basics Joes 2 Pros: Core Architecture concepts SQL Exam Prep Series 70-433 Volume3. [Amazon] | [Flipkart] | [Kindle] | [IndiaPlaza] Basics of a Query ...
This blog post is inspired fromSQL Queries Joes 2 Pros: SQL Query Techniques For Microsoft SQL Server 2008 SQL Exam Prep Series 70-433 Volume2. [Amazon] | [Flipkart] | [Kindle] | [IndiaPlaza] What i...
This blog post is inspired fromBeginning SQL Joes 2 Pros: The SQL Hands-On Guide for Beginners SQL Exam Prep Series 70-433 Volume1. [Amazon] | [Flipkart] | [Kindle] | [IndiaPlaza] Lets get some basi...
I have always enjoyed learning about Fast Track Data Warehousing Technology.The goal of a Fast Track Data Warehouse reference architecture is to achieve an efficient resource balance between SQL Serve...
Read Part 1Working with FileTables in SQL Server 2012 Part 1 Setting UpEnvironment Read Part 2Working with FileTables in SQL Server 2012 Part 2 Methods to Insert Data IntoTable In this third part ...
This second part ofPerformance Tuning Part 1 of 2 Getting Started andConfiguration. I suggest you read the first part before continuing on this second part. Analysis and Detection If you have notice...
Performance tuning is always a complex subject whenever one has to deal with it. When I was beginning with SQL Server, this was the most difficult area for me. However, there is a saying that if one h...
It has been more than 3 months since we have started experimenting with a new concept in SQL in Sixty Seconds. Every Wednesday, we putt a fresh new interesting concept out via video.Rick Morelan,Vinod...
SQL Server Cheatsheet has been extremely popular download from my blog. There are plenty of request for me to update it with SQL Server 2012 features. I have finally upgraded the cheatsheet with SQL S...
Earlier during TechEd 2012, I presented a session on SQL Server Misconception and Resolutions. It was a pleasure to present this session with Vinod Kumar during the event. Great Indian Developer Summi...
Read Part 1Working with FileTables in SQL Server 2012 Part 1 Setting UpEnvironment In this second part of the series, we will see how we can insert the files into the FileTables. There are two metho...
Filestream is a very interesting feature, and an enhancementof FileTable with Filestream is equallyexciting. Today in this post, we will learn how to set up the FileTable Environment in SQL Server. Th...
Pinal Dave on LinkedIn! It seems like a few year ago, there was a big boom in social media websites. All of a sudden there were so many sites to choose from. MySpace or Orkut? Blogging websites for yo...
Pinal Dave on Youtube! Some people might not know it, but YouTube is actually more than a place to watch funny cat videos and people singing their favorite pop songs its actually a social media site....
SQL Server has so manyenhancementsand features that quite often I feel like playing with various features and try out new things. I often come across situation where I want to try something new but I ...
Pinal on Facebook and Google+ Unless you have been living under a rock for the last few years, you know that Facebook is the first and last word in social networking. Everyone has a Facebook account ...
Pinal Dave on Twitter! Frequent readers of my blog might know that I am trying to get more involved in all social media sites, both professionally and personally. Readers might also know that I have o...
Microsoft SQL Azure labs has recently released Data Explorer client. I was looking forward to visualizing tool for quite a while and I am delighted to see this tool. I will be trying out this tool in ...
Here is another interesting follow up blog post ofSQL SERVER sp_describe_first_result_set New System Stored Procedure in SQL Server2012. While I was writing earlier blog post I had come across DMVsys...
TechEd India 2012 was held in Bangalore last March 21 to 23, 2012. Just like every year, this event is bigger, grander and inspiring. Here is my blog post reviewing the eventSQLAuthority News #TechEd...
View Other bloggers