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

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

SQL SERVER Database Stuck in In Recovery Mode After Restart

Journey to SQL Authority with Pinal Dave, March 4, 2015
Views: 37 | Hits

Read this blog and I am sure it will bring some instances in your environments. This is one of the common issues I have observed while working with SQL Server from long time now. In this blog we will ...

SQL SERVER Security Conversations and Notes with a DBA

Journey to SQL Authority with Pinal Dave, March 3, 2015
Views: 52 | Hits 2

One of the great things about working in Pluralsight is that I get to meet a lot of people (trust me on this). I am lost for words when it comes to how my day job helps me in achieving some of the coo...

Kerosene ORM: a dynamic, configuration-less and self-adaptive ORM for POCO objects supporting a SQL-like syntax from C#

The Code Project Latest Articles, March 2, 2015
Views: 80 | Hits 13

The seventh version of the dynamic, configuration-less and self-adaptive Kerosene ORM library, that provides full real support for POCO objects, natural SQL-like syntax from C#, and advanced capabilit...

SQL SERVER Script to Convert Date to Julian Dates

Journey to SQL Authority with Pinal Dave, March 2, 2015
Views: 54 | Hits 1

There are many methods to store date values. One of them is Julian date. It is a seven digit number where first four is the year part and the next three digits are the number of days from Jan 01. If y...

Interview Question of the Week #008 Is GO T-SQL Statement?

Journey to SQL Authority with Pinal Dave, March 1, 2015
Views: 68 | Hits 12

I often get this question in the email – more frequently than I would like to get. Question: “Is GO a T-SQL statement?” Answer: “No, GO is not a T-SQL statement, it is a command which is recognized by...

SQL SERVER FIX: SQL Server Not Starting Msg 864, Level 16, State 1- Buffer Pool Extension Feature

Journey to SQL Authority with Pinal Dave, February 28, 2015
Views: 52 | Hits

Recently I got an email from one of the student who attended my SQL Server 2014 Pluralsight Course from last year, he was trying to use Buffer Pool Extension feature and got into some unique trouble. ...

For the Love of Stored Procedures

Simple Talk, February 27, 2015
Views: 58 | Hits 10

It is an exaggeration to say that I like stored procedures. They are an essential if somewhat dangerous part of the Sybase and SQL Server landscape, rather like a volcano, bog or swamp. If you use a s...

Hey DBA Protecting a Proactive Attitude Notes from the Field #069

Journey to SQL Authority with Pinal Dave, February 26, 2015
Views: 67 | Hits 3

[Note from Pinal]: This is a 69th episode of Notes from the Fieldseries. Mike Walsh is an amazing person to meet and know. I am fortunate to be his friend. Every single time I meet him, I learn someth...

SQL SERVER Storing Data in Hindi, Chinese, Gujarati and Tamil (or any other) Language in the Same Table

Journey to SQL Authority with Pinal Dave, February 25, 2015
Views: 80 | Hits 8

Long time ago, I have written a blog which talks about multi language support available with SQL Server. SQL SERVER 2005 Multiple Language Support I have been getting below questions on regular basi...

Tips to fix CodedUI tests

The Code Project Latest Articles, February 24, 2015
Views: 72 | Hits 11

This article introduces some techniques to fix CoedUI automation tests, including a few generic approaches instead of much more specific functional definitions to handle problematic components such as...

SQL SERVER Configure, Monitor and Restore Backups from Mobile & Web browser

Journey to SQL Authority with Pinal Dave, February 24, 2015
Views: 89 | Hits 5

So tell me if this is a fantasy or a reality: You are on a beach, sipping on your cocktail and looking at the sea when you get a frantic call from your boss, One of the junior DBAs has just deleted al...

SQL SERVER COLUMNSTORE and COLUMNSTORE_ARCHIVE data compression

Journey to SQL Authority with Pinal Dave, February 23, 2015
Views: 70 | Hits 2

In earlier blogs on Fundamentals of Columnstore Index, I took a simple approach on taking a tour of how to create a simple Columnstore index. Having said that, SQL Server 2014 supports columnstore and...

Interview Question of the Week #008 Write Scripts to Convert String to Title Case or Proper Case

Journey to SQL Authority with Pinal Dave, February 22, 2015
Views: 88 | Hits 8

Just received a question in email: “I just got out of the interview and I was asked to write scripts to convert a string to Title Case. I was also asked to refer to the website over here to validate m...

SQL SERVER Script to Find Strings with Same Characters

Journey to SQL Authority with Pinal Dave, February 21, 2015
Views: 79 | Hits 9

One of my blog followers asked me if it is possible to check whether all the characters of a column value is same. For example if there are values like KKK and KKT, the value KKK should be the output ...

SQL SERVER FIX Error: 905, Severity: 21, State: 1 Database xxx cannot be started in this edition of SQL Server because it contains a partition function xxx.

Journey to SQL Authority with Pinal Dave, February 20, 2015
Views: 77 | Hits 1

Recently one of my blog reader contacted me via mail and told that after upgrading from Enterprise Evaluation Edition to Standard Edition, the database was not accessible. To troubleshoot, I have aske...

SQL SERVER Finding Top Offenders in SQL Server 2012 Notes from the Field #068

Journey to SQL Authority with Pinal Dave, February 19, 2015
Views: 76 | Hits 5

[Note from Pinal]: This is a 68thepisode of Notes from the Fields series.Performance tuning gets easier with SQL Server 2012. For the first time, you can capture a workload and find your top offenders...

SQL SERVER Notes and Observations on ReadOnly Databases in SQL Server

Journey to SQL Authority with Pinal Dave, February 19, 2015
Views: 96 | Hits 3

In the past couple of weeks, I have written few blogs that revolve around utilizing readonly databases. It was fun working on this special case scenario that I had stumbled upon an interesting set of ...

Azure: Machine Learning Service, Hadoop Storm, Cluster Scaling, Linux Support, Site Recovery and More

ScottGus Blog, February 18, 2015
Views: 66 | Hits 1

Today we released a number of great enhancements to Microsoft Azure. These include: Machine Learning: General Availability of the Azure Machine Learning Service Hadoop: General Availability of Apac...

SQL SERVER Cloud Based Data Integration Made Easy A Real World Scenario

Journey to SQL Authority with Pinal Dave, February 18, 2015
Views: 73 | Hits 4

If you are a DBA, once in a while, you will have a situation where you end up with some tasks which will be boring and annoying. Trust me in my life, I often come across similar scenarios quite often....

SQL SERVER Quiz with DATEADD Function

Journey to SQL Authority with Pinal Dave, February 17, 2015
Views: 81 | Hits 4

How many of us use some sort of date or datetime function when working with SQL Server? I cannot think of a single developer who would ever say they dont work with datetime conversions in their applic...

SQL SERVER Installation Error INSTALLSHAREDDIR parameter is not valid because this directory is compressed or is in a compressed directory

Journey to SQL Authority with Pinal Dave, February 16, 2015
Views: 83 | Hits 1

One of my blog reader contacted me for assistance. Here is his email: Hello Pinal, I am trying to install SQL Server on my laptop but getting below errors: SqlServer.Configuration.Sco.DirectoryAttribu...

Interview Question of the Week #007 How to Reindex Every Table of the Database?

Journey to SQL Authority with Pinal Dave, February 15, 2015
Views: 89 | Hits 9

Some questions areextremely popular questions and they never get old. Here is one such question which I see very often asked to DBAs in their early career. Question: How to re-indexevery table of the ...

SQL SERVER Msg 8152, Level 16, State 14 String or binary data would be truncated

Journey to SQL Authority with Pinal Dave, February 14, 2015
Views: 80 | Hits 2

Earlier this week, I have blogged about how to suppress Warning: Null value is eliminated by an aggregate or other SET operationSQL SERVER Warning: Null value is Eliminated by an Aggregate or Other S...

On Selecting a Database System Fit for the Task

Simple Talk, February 13, 2015
Views: 63 | Hits 3

Now that the rate of hot air hissing out of the NoSQL marketing balloon seems to be abating, we can take stock of the obvious qualities of the technologies in a less excitable atmosphere. There are so...

SQL SERVER Warning: Null value is Eliminated by an Aggregate or Other SET Operation

Journey to SQL Authority with Pinal Dave, February 13, 2015
Views: 78 | Hits 2

Working with NULLs are always a challenge not many developers understand how NULL works sometimes. In a related note, long back I wrote below blog in which I explained two set options Quoted Identifi...

SQL SERVER The Basics of the Execute Package Task Notes from the Field #067

Journey to SQL Authority with Pinal Dave, February 12, 2015
Views: 78 | Hits 3

[Note from Pinal]: This is a new episode of Notes from the Fieldseries. SQL Server Integration Service (SSIS) is one of the most key essential part of the entire Business Intelligence (BI) story.It is...

Checking the Plan Cache Warnings for a SQL Server Database

Simple Talk, February 11, 2015
Views: 17 | Hits

How often do you check your query plans to see if they contain any warnings? If you're missing them, it means that you're not getting all those hints about missing indexes, join predicates or statisti...

Questions About SQL Server Transaction Log You Were Too Shy To Ask

Simple Talk, February 11, 2015
Views: 19 | Hits

You can give a deep-dive presentation about SQL Server's transaction log, and round it off by inviting questions. Your audience will stare awkwardly at their boots. Afterwards, to your surprise there ...

SQL SERVER Script to Find Leap Year

Journey to SQL Authority with Pinal Dave, February 11, 2015
Views: 79 | Hits 6

A leap year has 366 days. A leap year has 29 days for February month. Suppose you want to find if year is Leap year or not, you can use many methods. But this is one of the simplest methods. In our ex...

SQL SERVER Error: Fix for Error Msg 3906 Failed to update database because the database is read-only

Journey to SQL Authority with Pinal Dave, February 10, 2015
Views: 76 | Hits 3

Some error messages are a great source of troubleshooting when things go wrong. I always request my blog readers to read what the error messages are conveying. Most of the solutions are very much docu...

SignalR Database update notifications in ASP.NET MVC using SQL Dependency

The Code Project Latest Articles, February 9, 2015
Views: 145 | Hits 73

In this we will learn how to displayreal time updates from the SQL Server by usingSignalR andSQL Dependency in ASP.NET MVC. You can download the source from theGithub The following are the steps that ...

SQL SERVER Viewing User Configurable Info in SQL Server

Journey to SQL Authority with Pinal Dave, February 9, 2015
Views: 70 | Hits 3

Most of the blog post as I say is revisiting something I wrote a while back in this blog. Recently one my blog readers asked me about user defined counters and he seems to have bumped into the blog: H...

Interview Question of the Week #006 Is Shrinking Database Good or Bad?

Journey to SQL Authority with Pinal Dave, February 8, 2015
Views: 105 | Hits 11

Here is the most debated Interview Question –Is Shrinking Database Good or Bad? I will try to answer this in a single statement–“Shrinking Database is bad practice for performance as it increases frag...

SQL SERVER What are the Different Ways to Script Procedure with T-SQL

Journey to SQL Authority with Pinal Dave, February 7, 2015
Views: 111 | Hits 17

Ever wondered how a simple task can be done multiple ways. You can script a stored procedure in many ways. You can use SSMS tool and use Generate Script option. However, if you want to do it in T-SQL,...

SQL SERVER One Trick of Handling Dynamic SQL to Avoid SQL Injection Attack?

Journey to SQL Authority with Pinal Dave, February 6, 2015
Views: 120 | Hits 10

SQL Server has so many things to learn and I always find it amazing. My conversations with customers often come up with security questions esp around SQL Injection. Many have claimed SQL Injection is ...

Get Ready to Learn SQL Server 19: Introduction to Sub Queries

The Code Project Latest Articles, February 5, 2015
Views: 101 | Hits 9

The purpose of this article is to introduce you to subqueries and some of their high-level concepts. There are a lot of details to cover in order to learn sub queries, but youll see we cover those in ...

SQL SERVER Invoking a Stored Procedure from Azure Mobile Services Notes from the Field #066

Journey to SQL Authority with Pinal Dave, February 5, 2015
Views: 96 | Hits 4

[Note from Pinal]: This is a 66th episode of Notes from the Fieldseries. Azure Mobile Servicesis a very critical aspect and not many people know about it. When I read this article, I find it humorous ...

The Importance of Caching

Simple Talk, February 4, 2015
Views: 24 | Hits

Performance tuning and optimization definitely have their place in minimizing SQL Server Licensing costs by helping keep CPU utilization low. But its important to remember that the fastest and most e...

The Promise - and the Pitfalls - of In-Memory OLTP

Simple Talk, February 4, 2015
Views: 64 | Hits 2

When SQL Server 2014 was released, it included Hekaton, Microsofts much talked about memory-optimized engine that brings In-Memory OLTP into play. With memory-optimized tables 30 times faster than dis...

Tip-1: Exciting SSMS features derived from Visual Studio

The Code Project Latest Articles, February 4, 2015
Views: 88 | Hits 9

In this series of posts, we’ll see few great yet less known and under utilized tips/features those are there since earlier versions of Visual Studio and later made their way to SSMS (SQL Server ...

Upload and Download Files with JDBC to SQL Servers

The Code Project Latest Articles, February 4, 2015
Views: 74 | Hits

This article presents an example to upload and download files with SQL server through JDBC in a Spring MVC application....

SQL SERVER How to fix the SQL Server Error 8657 or 8658?

Journey to SQL Authority with Pinal Dave, February 4, 2015
Views: 93 | Hits 6

It is sometimes very difficult to troubleshoot error which are relating to memory. In a recent query from one of my customer DBA, he sent me an error message which read like the ones below: Error: 865...

SQL SERVER Script When/Who did Auto Grow for the Database?

Journey to SQL Authority with Pinal Dave, February 3, 2015
Views: 107 | Hits 4

What happens when you try to copy a large file from different hard disks? The operating system tries to see if the destination location has enough space available for the copy to be successful. If we ...

LINQ To SQL Using C#

The Code Project Latest Articles, February 2, 2015
Views: 84 | Hits 15

LINQ to SQL using C#...

SQL SERVER How Can Deadlock Happen on Same Table?

Journey to SQL Authority with Pinal Dave, February 2, 2015
Views: 85 | Hits 13

Interesting TRUE Story As part of learning I get inspiration from the activities we do daily and see how it can be mapped to SQL Server. This in a way many say is an obsession for the subject I love ...

Interview Question of the Week #005 List All the Tables with Name Containing Specific String

Journey to SQL Authority with Pinal Dave, February 1, 2015
Views: 87 | Hits 8

The other day, I received an email from a blog reader. When he appeared for an interview, he was asked to retrieve all the tables where the name of the table contained the words ‘tbls_’. This was a ve...

SQL SERVER 8 Performance Related Articles on Logical Reads

Journey to SQL Authority with Pinal Dave, January 31, 2015
Views: 117 | Hits 3

Earlier this year, I have written few articles which are related to SQL Server Performance and they are published on site of Logical Reads. Here are my personal favorite 8 various articles on the subj...

SQL SERVER FIX Error: Msg 3201, Level 16, State 1, Line 1 Cannot open backup device. Operating system error 3(The system cannot find the path specified.)

Journey to SQL Authority with Pinal Dave, January 30, 2015
Views: 109 | Hits

This blog is in continuation to using the default values. Earlier this week I wrote a blog which talked about the failure of Create Database Command. While working on the reproduction of the issue, I ...

Developer 3 Tips Every SQL Expert Needs to Know to Land the Perfect Job (Part 3 of 3)

Journey to SQL Authority with Pinal Dave, January 29, 2015
Views: 115 | Hits 12

I am very fortunate that I know John Sonmez in person. He is one of those individualswho understands the young mind of developers and depth of software development industry. I am a regular follower of...

SQL SERVER The Basics of the SSIS Script Task Notes from the Field #065

Journey to SQL Authority with Pinal Dave, January 29, 2015
Views: 95 | Hits 3

[Note from Pinal]: This is a new episode of Notes from the Fieldseries. SQL Server Integration Service (SSIS) is one of the most key essential part of the entire Business Intelligence (BI) story.It is...