News in the Category:
SQL
Total posts: 5507 | Sort by Views | Sort by Hits
Journey to SQL Authority with Pinal Dave, May 25, 2013
Views: 146 | Hits 3
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 24, 2013
Views: 164 | Hits 10
Abstract of my Pluralsight CourseBuilding a Successful BlogModule – Frequently Asked Questions. If you have been following this blog series about starting and maintaining a blog, you might be excited ...
Simple Talk, May 23, 2013
Views: 129 | Hits 4
Databases often need more than just the database objects to run. There may be certain server objects and components, and SQL Agent objects, that are required as well. For an automated deployment, thes...
Journey to SQL Authority with Pinal Dave, May 23, 2013
Views: 162 | Hits 3
Abstract of my Pluralsight CourseBuilding a Successful BlogModule – Blogging Rules, Ethics and Etiquette. To have a successful blog, your posts should be interesting, you probably would like to have a...
Journey to SQL Authority with Pinal Dave, May 22, 2013
Views: 210 | Hits 11
Abstract of my Pluralsight CourseBuilding a Successful BlogModule – Writing an Interesting Blog. Getting Started Is writing an interesting blog so simple that I can just TELL you how to do it right no...
Journey to SQL Authority with Pinal Dave, May 21, 2013
Views: 211 | Hits 10
Abstract of my Pluralsight CourseBuilding a Successful BlogModule – Getting Started with Blogging. Choosing a Blog Host If youve recently decided to start blogging, the very first thing you have to de...
Journey to SQL Authority with Pinal Dave, May 20, 2013
Views: 206 | Hits 17
Abstract of my Pluralsight CourseBuilding a Successful BlogModule – Getting Started with Blogging. Thinking about starting a blog? Confused about the entire idea of blogging? I have created a course o...
The Code Project Latest Articles, May 19, 2013
Views: 238 | Hits 22
SQL Server culture mapping with .NET Framework....
Journey to SQL Authority with Pinal Dave, May 19, 2013
Views: 328 | Hits 20
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: 264 | Hits 5
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: 241 | Hits 6
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: 376 | Hits 49
Google your SQL....
Journey to SQL Authority with Pinal Dave, May 16, 2013
Views: 204 | Hits 5
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...
Simple Talk, May 15, 2013
Views: 57 | Hits 1
When problems arise in SQL Server, we're faced with a server full of suspects, including disk I/O, memory, CPU, incorrect or missing indexes, badly written T-SQL code, out of date statistics, and full...
Journey to SQL Authority with Pinal Dave, May 15, 2013
Views: 181 | Hits 6
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: 246 | 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: 254 | 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: 223 | Hits 15
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: 313 | 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: 262 | 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: 290 | Hits 34
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: 206 | 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: 259 | 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: 229 | 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: 229 | 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: 538 | 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: 201 | 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: 224 | 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: 336 | 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: 226 | 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: 237 | 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: 353 | 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: 214 | Hits 9
SharePoint Training: more information
Okay so heres another bak2basics kin...
Journey to SQL Authority with Pinal Dave, May 3, 2013
Views: 211 | 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: 245 | 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: 290 | 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: 238 | Hits 32
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: 294 | Hits 27
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: 61 | 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: 74 | 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: 242 | Hits 15
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: 176 | 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: 199 | 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: 207 | 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: 283 | 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: 239 | Hits 21
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: 267 | Hits 17
“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: 291 | Hits 14
Custom StringPadding functions for SQL Server...
The Code Project Latest Articles, April 24, 2013
Views: 246 | Hits 29
Create a SQL Server database using C#....