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

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

SQL SERVER Presenting 4 Technology Sessions at Great Indian Developer 2014 Contest

Journey to SQL Authority with Pinal Dave, April 21, 2014
Views: 1 | Hits

The Great Indian Developer Conference (GIDS) is one of the most popular annual event held in Bangalore. This year GIDS is scheduled on April 22, 25. I will be presenting total four sessions at this ev...

SQL SERVER Download SQL Server 2014 Developer Edition at USD 59.59

Journey to SQL Authority with Pinal Dave, April 20, 2014
Views: 8 | Hits

Since the release of the SQL Server 2014 earlier this year, lots of people have been asking if people can download the full version of SQL Server 2014. SQL Server 2014 full version is not available fo...

SQL Authority News Microsoft Whitepaper SQL Server 2014 and Windows Azure Blob Storage Service: Better Together

Journey to SQL Authority with Pinal Dave, April 19, 2014
Views: 31 | Hits 4

Microsoft has released SQL Server 2014 earlier this month and now have released very long but interesting white paperon Windows Azure Blog Storage Services. SQL Server Data Files in Windows Azure feat...

SQL SERVER Idera SQL XEvent Profiler a Free Tool for XEvent Monitoring

Journey to SQL Authority with Pinal Dave, April 18, 2014
Views: 12 | Hits

Download Extended Event Profile FREE We often resist the change, we do not like change and we keep on using the same old technology which we have been using it to resolve the new challenges which we f...

Using SDK/library references in Universal Windows Apps

Method ~ of ~ failed, April 17, 2014
Views: 10 | Hits 2

Im just coming back from Build 2014 and it was a great pleasure to talk to customers/developers. It is one of the best parts of my job right now in seeing how customers use the technology our team rep...

SQL SERVER Tools for Proactive DBAs Central Management Server Notes from the Field #024

Journey to SQL Authority with Pinal Dave, April 17, 2014
Views: 7 | Hits

[Note from Pinal]: This is a newepisode of Notes from the Fields series. AlwaysOn is a very complex subject and not everyone knows many things about this. The matter of the fact is there is very littl...

SQL SERVER Life of a SQL Query Query States

Journey to SQL Authority with Pinal Dave, April 17, 2014
Views: 12 | Hits 2

This is the guest blog post written by James Davies, Sales Engineer, Confio Software, a SolarWinds company. It is written based on the Database Performance Analyzer. I encourage you to download it for...

SQL SERVER Calculating XIRR in SQL Server Internal Rate of Return Available

Journey to SQL Authority with Pinal Dave, April 16, 2014
Views: 12 | Hits

Note: Download theXLeratorDB to play along this blog post. XIRR is a widely-used used financial calculation that lends itself to evaluating the rate of return on either historic cash flows or anticipa...

SQL SERVER Three Questions Do You Know Your Servers? Book Gift

Journey to SQL Authority with Pinal Dave, April 15, 2014
Views: 11 | Hits

It has been almost 2 years since we had a poll on this blog so here a poll which ask you three simple questions. Trust me these questions, I have carefully picked after doing a beta testing on a small...

SQL SERVER Finding Last Backup Time for All Database Last Full, Differential and Log Backup Optimized

Journey to SQL Authority with Pinal Dave, April 14, 2014
Views: 39 | Hits 8

Four years ago, I wrote a blog post SQL SERVER Finding Last Backup Time for AllDatabase. It has been a very popular script. SQL ExpertSravanihas posted a fantastic script which also displays last ful...

SQLAuthority News Microsoft Whitepaper Migrating Content Between Report Servers

Journey to SQL Authority with Pinal Dave, April 13, 2014
Views: 22 | Hits 2

A very common challenge developer and administrator face when they have to migrate content between SQL Server Reporting Server. This is becauseSQL Server Reporting Services (SSRS) currently doesnt inc...

SQLAuthority News Microsoft Whitepaper Idle Connection Resiliency

Journey to SQL Authority with Pinal Dave, April 12, 2014
Views: 33 | Hits 4

Developers can write data access application that enables ideal connection resiliency with the .NET framework. An idle connection is the one that is active but its not executing a command or waiting f...

SQL SERVER Drop All the Foreign Key Constraint in Database Create All the Foreign Key Constraint in Database

Journey to SQL Authority with Pinal Dave, April 11, 2014
Views: 25 | Hits 4

Earlier I wrote a blog post about how to Disable and Enable all the Foreign Key Constraint in the Database. It is a very popular article. However, there are some scenarios when user needs to drop and ...

SQL SERVER Finding Jobs Shrinking Database Files Notes from the Field #023

Journey to SQL Authority with Pinal Dave, April 10, 2014
Views: 17 | Hits

[Notes from Pinal]:Search on the internet about ‘Shrinking Database’, you will find plenty of advice why it is bad and it should not be done. If you do not believe me, just try it yourself. Even I hav...

Using only TCP/IP for connecting to SQL Server 2008 and Changing the SQL Server 2008's default TCP/IP port

The Code Project Latest Articles, April 9, 2014
Views: 25 | Hits 6

Implementing security in SQL Server by only allowing TCP/IP Network Protocol and changing default TCP port...

MySQL Finding First day and Last day of a Month

Journey to SQL Authority with Pinal Dave, April 9, 2014
Views: 28 | Hits 4

MySQL supports a lot of DATE and TIME related functions. If you want to find out last day of a month, you can make use of an inbuilt function named LAST_DAY. SET @date:='2012-07-11'; SELECT LAST_DAY(@...

SQL SERVER What is SSAS Tabular Data Model and Why to Use it

Journey to SQL Authority with Pinal Dave, April 8, 2014
Views: 20 | Hits

Analysis services in SQL Server 2012 can be either deployed in multi-dimensional mode or tabular mode or power pivot for SharePoint as well. Tabular mode is a new enhancement in SQL Server 2012 analys...

SQLAuthority News Speaking at C-Sharp Corner Annual Conference 2014 April 11-13 Delhi

Journey to SQL Authority with Pinal Dave, April 7, 2014
Views: 20 | Hits 1

I will be speaking atC-Sharp Corner Annual Conference 2014 – April 11-13 – Delhi. I am extremely excited and fortunate with the opportunity to present a technical session at the North India’s largest ...

SQL SERVER Fix Error 1759 Computed column in table is not allowed to be used in another computed-column definition

Journey to SQL Authority with Pinal Dave, April 6, 2014
Views: 44 | Hits 1

This is a very common error with beginning developers when they start working with computed columns. When a new developer finds a joy of computed column, it is very natural to use the same computed co...

A SQL Cmdlet a Day 2 Piping and Select

The Code Project Latest Articles, April 5, 2014
Views: 18 | Hits 2

This post expands on the basics of SQL Server PowerShell and introduces piping as well as using Select in PowerShell cmdlets, the first post can be found here. Technet defines piping as passing that o...

SQL SERVER Unable to ALTER Computed Column in SQL Server How to ALTER Computed Column

Journey to SQL Authority with Pinal Dave, April 5, 2014
Views: 19 | Hits

A Very common question, I often receive is Q: “How to ALTER computed columns?” A: There is NOway to alter computed column. You will have to drop and recreate it. Here is a demonstration of it. If you ...

SQL SERVER Finding Last Backup Time for All Database Last Full, Differential and Log Backup

Journey to SQL Authority with Pinal Dave, April 4, 2014
Views: 39 | Hits 2

About four years ago, I wrote a blog post where I posted a script about finding backup time for all the databases. You can see the blog post over here SQL SERVER Finding Last Backup Time for All Data...

SQL SERVER Say No to DB Data Roles SQL Security Notes from the Field #022

Journey to SQL Authority with Pinal Dave, April 3, 2014
Views: 23 | Hits

[Note from Pinal]: This is a 22nd episode of Notes from the Fieldseries.Security is very important and we all realize that. However, when it is about implementing the security, we all are not sure wha...

Developer How To Market Yourself as a Software Developer

Journey to SQL Authority with Pinal Dave, April 2, 2014
Views: 53 | Hits 14

“Everybody wants to make money and build a successful environment around and it is a universal truth my friend”, John mentioned to me while we were talking on Skype earlier this year. Conversation: Jo...

MySQL List User Defined Tables Two Methods

Journey to SQL Authority with Pinal Dave, April 1, 2014
Views: 18 | Hits 2

There are different methods to list out user defined tables in MySQL. We will see two methods in this post. Let us create the following tables in the database named Test Create a database named Test C...

SQL SERVER How to Detect Schema Change Across Two Servers

Journey to SQL Authority with Pinal Dave, March 31, 2014
Views: 18 | Hits 2

If you are database developer or database administrator, you will absolutely feel the story. You can download the software discussedin this blog post to play it along. Story of My Early Career A very ...

SQL SERVER Q and A from Facebook Page

Journey to SQL Authority with Pinal Dave, March 30, 2014
Views: 38 | Hits 6

Social media has changed everything, there were times when we used to send emails but nowadays things have changed. We all have many different ways to connect with each other. Here are a few questions...

SQL SERVER SQL Server 2014 Developer Training Kit and Sample Databases

Journey to SQL Authority with Pinal Dave, March 29, 2014
Views: 45 | Hits 6

SQL Server 2014 RTM is around the corner (2014). There is plenty of the interest in the SQL Server 2014 in recent time. One of the most frequently asked questions is about learning resources of SQL Se...

Roundup from Simple-Talk and Beyond March 31 2014

Simple Talk, March 28, 2014
Views: 11 | Hits

New Articles Weve always liked the idea of mixing our more in-depth articles with others that just give simple answers to simple questions, or a list of nuggets: Articles like Plamen Ratchevs Ten Comm...

SQLite Helper (C#)

The Code Project Latest Articles, March 28, 2014
Views: 91 | Hits 32

Simplify the usage between C# and SQLite...

MySQL Generate Script for a Table Using SQL

Journey to SQL Authority with Pinal Dave, March 28, 2014
Views: 25 | Hits 4

In SQL Server, to generate the CREATE TABLE script for a table, you need to rely on the SQL Server Management Studio (SSMS) tool and there is no inbuilt function supported to do this using SQL. Howeve...

SQLAuthority News Sign up for SQL Authority Low Frequency Newsletter

Journey to SQL Authority with Pinal Dave, March 27, 2014
Views: 19 | Hits

One More Newsletter! You might already be receiving our emails in your mailbox, so why should you sign up for SQL Authority Newsletter (Sign-up). Well, a great question. Let me answer this first. Why ...

SQL SERVER SSIS Execution Control Using Precedence Constraints Notes from the Field #021

Journey to SQL Authority with Pinal Dave, March 26, 2014
Views: 24 | Hits

[Notes from Pinal]:Lots of people think that SSIS is all about arranging various operations together in one logical flow. Well, the understanding is absolutely correct, but the implementation of the s...

SQL Server Indexing Questions We Were Too Shy To Ask

Simple Talk, March 25, 2014
Views: 15 | Hits 1

One of the first things one needs to understand well about SQL Server is indexes, but somehow many of the basic questions don't often get asked or answered much on forums. Rob Sheldon answers some of...

MySQL How to Connect to MySQL Server on Command Prompt

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

I have so far authored 5 courses on MySQL at Pluralsight, and one of the most popular question, I keep on getting is how to connect to MySQL with Command Prompt. You may find it funny enough that peop...

High Performance Relational Division in SQL Server

Simple Talk, March 24, 2014
Views: 34 | Hits 7

Relational division is used in SQL to select rows that conform to a number of different criteria. It is a neglected but effective technique for a number of tasks. Although the SQL can appear daunting ...

SQL SERVER Does Use of CTE Change the Order of Join in Inner Join

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

I just had an interesting conversation the day before when I was discussing about Join Order in one of my recent presentations. The comment which triggered all the conversation was “If I want to chang...

SQL SERVER Turning On Graphical Execution Plan After Enabling ShowPlan Text

Journey to SQL Authority with Pinal Dave, March 23, 2014
Views: 69 | Hits 10

This may be surprising to many, but I have seen quite a few times so far so decided to blog over here. Here is the sequence of the action: The developer turns on Graphical Execution plan for any query...

Professional Development Dr W. Edwards Demings 14 Principles on Total Quality Management

Journey to SQL Authority with Pinal Dave, March 22, 2014
Views: 57 | Hits 7

I was just reading Dr. W. Edwards Demings 14 principles of Total Quality Management. It is indeed very impressive and interesting. I have tried to collect a few of the important resources related to t...

SQL Server 2014 Launch event in Montreal

Laurent Duveau, March 21, 2014
Views: 32 | Hits

With the new version of SQL Server available in a a few days, you might wonder what's in it for you? If you are in the Montral area, don't miss the official launch organized by the Montreal .NET Co...

MySQL Search For Values Within A Comma Separated Values FIND_IN_SET

Journey to SQL Authority with Pinal Dave, March 21, 2014
Views: 40 | Hits 5

MySQL has an inbuilt function called FIND_IN_SET which will search for values within a comma separated values. It basically returns the index position of the first parameter within the second paramete...

SQL SERVER Index Fragmentation Next Steps Notes from the Field #020

Journey to SQL Authority with Pinal Dave, March 20, 2014
Views: 34 | Hits 2

[Notes from Pinal]: Indexes are considered as a silver bullet to performance tuning and do amazing job when they are properly created. Just like any other engine they need maintenance and tuning. As w...

SQL Server 2014 Ready for April 1 Release

Microsoft Certified Professional Magazine Online | Todays Top Picks, March 19, 2014
Views: 15 | Hits

Ahead of its April 1 release, SQL Server 2014 hit its RTM milestone this week....

SQL SERVER Retrieve Last Inserted Rows from Table Question with No Answer

Journey to SQL Authority with Pinal Dave, March 19, 2014
Views: 32 | Hits 3

Some conversations are very interesting and I would like to bring them to everyone’s attention. Here is one of the conversation happened earlier this week. Let us say the question was asked by Dustin....

SQL SERVER Performance: Do-it-Yourself Caching with Memcached vs. Automated Caching with SafePeak

Journey to SQL Authority with Pinal Dave, March 18, 2014
Views: 39 | Hits 3

Weve all been reading a lot of articles that suggest adding a caching layer in front of a database is more efficient than hitting the database directly. Among different caching options there is Do-It-...

MySQL Pattern Matching Comparison Using Regular Expressions with REGEXP

Journey to SQL Authority with Pinal Dave, March 17, 2014
Views: 28 | Hits 3

MySQL supports pattern matching comparison using regular expressions with REGEXP keyword. In this post we will see how to use REGEXP in MySQL. We can use the patterns ^, $, | and sqaure braces to effe...

Uploading files to database from ASP.NET pages

The Code Project Latest Articles, March 16, 2014
Views: 55 | Hits 16

This example will show how is possible to upload files to SQL server database using C# and asp.net. For demostration purposes database will have only...

SQL SERVER What is the Difference Between Latches and Locks

Journey to SQL Authority with Pinal Dave, March 16, 2014
Views: 61 | Hits 8

A very common question I often get in the email is “What is the difference between latches and locks?” The answer to this question is not an easy one. Here is a quick answer from the MS white paper. A...

Thinking in SQL - Working with dates

The Code Project Latest Articles, March 15, 2014
Views: 81 | Hits 29

In this installment, I talk about working with dates and date functions in SQL Server...

SQL SERVER Find Port SQL Server is Listening Port SQL Server is Running

Journey to SQL Authority with Pinal Dave, March 15, 2014
Views: 51 | Hits 6

Here is one of the very common interview questions I often ask people - Q: What is the default Port SQL Server running on? A: 1433 for TCP/IP and 1434 for USD connection. I always get the correct answ...