News in the Category:
SQL 
Total posts: 5498 | Sort by Views | Sort by Hits
Journey to SQL Authority with Pinal Dave, May 19, 2013
Views: 119 | Hits 3
I have been blogging for more than 6.5years and I have so far written over 2500 articles on this blog and every blog has been journey itself. Over six years I have not missed any single blog and no ma...
Journey to SQL Authority with Pinal Dave, May 18, 2013
Views: 179 | Hits 2
Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here ...
Journey to SQL Authority with Pinal Dave, May 17, 2013
Views: 188 | Hits 4
Earlier this week, I asked a puzzle about how REPLICATE works with 8000 and over 8000 characters. I strongly suggest to read the original blog post where I have described the problem in detailSQL SERV...
The Code Project Latest Articles, May 16, 2013
Views: 333 | Hits 42
Google your SQL....
Journey to SQL Authority with Pinal Dave, May 16, 2013
Views: 177 | Hits 2
Today, I am very happy as the journey I started almost 6.5 years ago has very important milestone. I have stopped blogging about my milestone for a long time as I believe that was just taking up the s...
Journey to SQL Authority with Pinal Dave, May 15, 2013
Views: 158 | Hits 5
We all love puzzles and here is interesting puzzle which you can play with me and winAmazon Gift Cards and Bubble Copter R/C. The contest for Amazon Gift Card is open worldwide, however, Bubble Copter...
Journey to SQL Authority with Pinal Dave, May 14, 2013
Views: 224 | Hits 9
I need your help. I recently came across extended stored procedure xp_sscanf. After reading a lot about it and searching online, I could not figure out how and where in real world, I will use this fun...
Journey to SQL Authority with Pinal Dave, May 13, 2013
Views: 236 | Hits 11
It has been along time since we have played a puzzle over this blog. This Monday, let us play a quick puzzle. SQL Server have REPLICATE function which will replicate the string passed as many as times...
Journey to SQL Authority with Pinal Dave, May 12, 2013
Views: 202 | Hits 14
Have you ever worked withCONCAT_NULL_YIELDS_NULL earlier in your career? If yes, you will find this post very interesting. If you have not worked with this function before I think this post will teach...
Journey to SQL Authority with Pinal Dave, May 11, 2013
Views: 299 | Hits
Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here ...
Journey to SQL Authority with Pinal Dave, May 10, 2013
Views: 243 | Hits 14
Presenting a technical session is a greatest experience one can have and I enjoy doing the same. While I write this blog post, I am presenting at Great Indian Developer Summit in India. The event is a...
Journey to SQL Authority with Pinal Dave, May 9, 2013
Views: 266 | Hits 31
In a previous article, I wrote about scale-up vs. scale-out architectures using SQL Server and NuoDB as examples. NuoDB recently announced the general availability of their latest product release, 1.1...
Journey to SQL Authority with Pinal Dave, May 8, 2013
Views: 197 | Hits 4
This is the 51th episode of SQL in Sixty Seconds Video and we will see in this episode how to RESEED identity of the table column. Identity column is every increasing (or decreasing) value based on th...
The MongoDB NoSQL Database Blog, May 7, 2013
Views: 250 | Hits 9
This is a guest post by NYU Information Systems (MSIS) Graduate students Kyle Galloway, Pravish Sood and Dylan Kelemen.We are pleased to announce the Mongo-ODBC project. As NYU MSIS students in Couran...
The Code Project Latest Articles, May 7, 2013
Views: 221 | Hits 9
This article explains how to calculate the Check Digit Vertical (CDV) and Horizontal (CDH) by Sql Server....
The Code Project Latest Articles, May 7, 2013
Views: 219 | Hits 21
This project creates a Visual Studio visualizer for entity framework queries, view edit and run the generated SQL....
Journey to SQL Authority with Pinal Dave, May 7, 2013
Views: 530 | Hits 12
Recently I came across situation where database sharding was once again a suggested solution by architectures. Everytime I hear the word sharding I remember my earlier article about NuoDB onShard No M...
Sahil Malik - blah.winsmarts.com, May 6, 2013
Views: 192 | Hits 14
SharePoint Training: more information
A while ago, I had blogged a quick f...
Journey to SQL Authority with Pinal Dave, May 6, 2013
Views: 208 | Hits 8
Azure SQL database backup used to be a difficult task. Not any more. With SQLBackupAndFTP with Azureit became trivial. Heres what you basically need to do: Once SQLBackupAndFTP with Azure is installed...
peterkellner.net, May 6, 2013
Views: 319 | Hits 28
This is not a big deal, but I have recently bumped into several people that did not know about it so I thought Id do a blog post just to show what it is and how is just trivial to use for useful stuff...
Journey to SQL Authority with Pinal Dave, May 5, 2013
Views: 217 | Hits 6
Sometime I feel I know a lot about SQL Server and very next moment, I realize that honestly I do not know much about this product. Earlier today, I had similar moments. I was playing with few DMVs and...
Journey to SQL Authority with Pinal Dave, May 4, 2013
Views: 226 | Hits 2
Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here ...
Simple Talk, May 3, 2013
Views: 64 | Hits
Although SQL Compare, for SQL Server, is one of Red Gate's best-known products, there are also 'sister' tools that allow you to compare and synchronise MySQL and Oracle databases. MySQL Compare was ...
The Code Project Latest Articles, May 3, 2013
Views: 338 | Hits 13
SQL Server 2000, 2005, 2008, 2008 R2, 2012 Character String Data Types and Functions with Sample SQL Statements. Quick reference, Data Type Tables, Function Tables...
Sahil Malik - blah.winsmarts.com, May 3, 2013
Views: 207 | Hits 9
SharePoint Training: more information
Okay so heres another bak2basics kin...
Journey to SQL Authority with Pinal Dave, May 3, 2013
Views: 201 | Hits 12
This blog post is inspired from my earlier blog post of UPDATE From SELECT Statement Using JOIN in UPDATE Statement Multiple Tables in Update Statement. In the blog post I discussed about how we can...
Journey to SQL Authority with Pinal Dave, May 2, 2013
Views: 239 | Hits 3
I will be presenting once again 3 Technical Sessions on SQL Server and Performance Tuning at Great Indian Developer Summit on May 7, 2013. If you are going to attend the event, you do not want to miss...
Journey to SQL Authority with Pinal Dave, May 1, 2013
Views: 279 | Hits 2
Here are few of the question I often receive - Do you know anything besides SQL Server? So how does it feel when the only thing which you know is SQL Server? Have you worked in the past with any other...
The MongoDB NoSQL Database Blog, April 30, 2013
Views: 225 | Hits 31
This is a guest post from Valeri Karpov, a MongoDB Hacker and co-founder of the Ascot Project.A few weeks ago, a friend of mine asked me for help with PostgreSQL. As someone who’s been blissfull...
Journey to SQL Authority with Pinal Dave, April 30, 2013
Views: 282 | Hits 26
This is one of the most interesting questions I keep on getting on this email and I find that not everyone knows about it. In recent times I have seen a developer writing a cursor to update a table. W...
Simple Talk, April 29, 2013
Views: 58 | Hits
In most databases, very small percentage of data changes between SQL Server backups. We tolerate this because it keeps things simple, and we have grown used to cheap storage and fast networks. To expl...
Simple Talk, April 29, 2013
Views: 73 | Hits 2
One way of getting the advantages of the Cloud without having to migrate the entire database is to just maintain a copy of the data that needs to be accessible to internet-based users in Windows Azur...
The Code Project Latest Articles, April 29, 2013
Views: 238 | Hits 14
Using PHP and MySQL to get if a user is online, the number of users currently online, the highest online ever, the number of users online today, and the Last Seen time of a user....
Telerik News RSS Feed, April 29, 2013
Views: 166 | Hits 4
What's new in Telerik OpenAccess ORM Q1 2013 SP1 Enhancements Update Database from Model: Creation of missing schemas - The automated DLL scripts generation now include creation of new schemas, de...
Journey to SQL Authority with Pinal Dave, April 29, 2013
Views: 191 | Hits 12
Here is an email I receivedduring the weekend. “Hi Pinal, I am a senior tester in the leading organization and we have two different environments 1) Testing 2) Production. As a part of the testing we ...
Journey to SQL Authority with Pinal Dave, April 28, 2013
Views: 200 | Hits 3
Earlier this week Microsoft have released two very interesting downloads which got my attention. Haddop, PowerPivot and PowerView all three are not directly related to traditional RDBMS but their impo...
Journey to SQL Authority with Pinal Dave, April 27, 2013
Views: 273 | Hits 4
Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here ...
Journey to SQL Authority with Pinal Dave, April 26, 2013
Views: 236 | Hits 20
I have previously written about the difference between UNION ALL and UNION multiple times over this blog but it seems like this question never gets old and I keep on getting the question again and aga...
Journey to SQL Authority with Pinal Dave, April 25, 2013
Views: 257 | Hits 16
“How do I return a few of my resultset rows at the bottom of the entire resultset?” I was previously asked this question and my response was that we can do this by using the CASE statement in the ORDE...
The Code Project Latest Articles, April 24, 2013
Views: 285 | Hits 14
Custom StringPadding functions for SQL Server...
The Code Project Latest Articles, April 24, 2013
Views: 236 | Hits 29
Create a SQL Server database using C#....
ASP.NET Announcements, April 24, 2013
Views: 130 | Hits 10
Devart Team is glad to present new versions of dotConnect ADO.NET data providers and LinqConnect 4.2.
dotConnect Data Providers
http://www.devart.com/news/2013/dotconnects76.html for Oracle, MySQL, P...
Journey to SQL Authority with Pinal Dave, April 24, 2013
Views: 177 | Hits 10
This journey of SQL in Sixty Seconds we started almost a year ago and today we are at very interesting milestone where I am recording 50thepisode. Thought I wanted to keep the length of each video to ...
Journey to SQL Authority with Pinal Dave, April 23, 2013
Views: 257 | Hits 12
“How do I return a few of my resultset rows at the bottom of the entire resulset?” This is avery simple question – let me explain this with following diagram. In this following diagram you can notice ...
ASP.NET Announcements, April 22, 2013
Views: 255 | Hits 33
Looking for a free agile & scrum tool that gives you more?
Agile, Scrum, Kanban Code Review Issue & Bug Tracking Project Tracking Integrated testing management Works with GitHub, Subver...
Journey to SQL Authority with Pinal Dave, April 22, 2013
Views: 237 | Hits 5
My book co-author Rick Morelan is giving away SQL Queries Book and DVD set (valued at over $200)in his next webinar. SQL Server is known for handing many requests at once and updating as new data come...
Journey to SQL Authority with Pinal Dave, April 22, 2013
Views: 241 | Hits 7
Note: NuoDBis a complete re-think of relational databases with innovative support for the Clouds dynamic, asynchronous nature. DownloadNuoDBto experience the Scaling Out scenario discussed in this blo...
Journey to SQL Authority with Pinal Dave, April 21, 2013
Views: 258 | Hits 6
It was a great day today as at a SQL Bangalore User Group we had an event “Women in SQL” day. This event was one of the milestone event as in India there was no UG in my knowledge had done an event wh...
Journey to SQL Authority with Pinal Dave, April 20, 2013
Views: 241 | Hits 2
Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here ...
Simple Talk, April 19, 2013
Views: 81 | Hits 2
When you need to present the same SQL Server Reporting Services (SSRS) report in eight or more different languages, or in different formats for different recipients, and the boss demands last-minute c...