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

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

SQL SERVER Mistake to Avoid: Duplicate and Overlapping Indexes Notes from the Field #073

Journey to SQL Authority with Pinal Dave, March 26, 2015
Views: 6 | Hits

[Note from Pinal]:In this episode of the Notes from the Field series database expert KathiKellenbergerexplains about indexes and its impact. We often believe that indexes will improve the performance ...

SQL SERVER Knowing Nested Transactions Behavior with SQL Server

Journey to SQL Authority with Pinal Dave, March 25, 2015
Views: 53 | Hits 2

SQL Server is an interesting database system that baffles me every single day that I get to learn something new. This blog has been my way to share these learnings. Every time I write something new, m...

SQL SERVER Where is ERRORLOG? Various Ways to Find its Location

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

Whenever someone reports some weird error on my blog comments or sends email to know about it, I always ask to share SQL Server ERRORLOG file. There have been many occasions where I need to guide them...

Windows 10 SDK preview and dev tools released

Laurent Duveau, March 23, 2015
Views: 45 | Hits 1

We now have the (preview) tools to start developing for the Windows universal app platform!Good news we dont have to wait until BUILD conference!Read the announcement and get the download links here:h...

SQL SERVER Backup and Restore Behavior of ReadOnly Filegroup Databases

Journey to SQL Authority with Pinal Dave, March 23, 2015
Views: 61 | Hits

Last week I wrote about SQL SERVER Marking Filegroup as ReadOnly with SQLServer and it got me interested into few key questions. One of the questions someone asked was, how will backups behave? Are t...

Interview Question of the Week #012 Steps to Restore Bak File to Database

Journey to SQL Authority with Pinal Dave, March 22, 2015
Views: 84 | Hits 10

Here is the question, I was asked the other day at the conference. Question: If I have a .bak file and I want to restore it database what are the various steps involved in it. Assume that I do notknow...

SQL SERVER Trivia Days in a Year

Journey to SQL Authority with Pinal Dave, March 21, 2015
Views: 74 | Hits 3

Every time I wrote a blog, I tend to get back to most of them via the search. Most of you ask me questions and I do few simple search back to make sure I am able to address them. Yesterday as I was se...

SQL SERVER Add Node in Cluster Rule Node and cluster edition match failed

Journey to SQL Authority with Pinal Dave, March 20, 2015
Views: 102 | Hits 2

Every day I get many emails and blog comment with at least one new problem every day. Recently, one of my blog readers sent an email asking assistance. She already had two node Windows Cluster. Let us...

SQL SERVER Adding a Master Data Services to your Enterprise Notes from the Field #072

Journey to SQL Authority with Pinal Dave, March 19, 2015
Views: 113 | Hits 1

[Note from Pinal]: This is a 72th episode of Notes from the Fieldseries. Master Data Services is one of the most important but very little explored feature ofSQL Server.If you have been reading this b...

Never Ignore a Sort Warning in SQL Server

Simple Talk, March 18, 2015
Views: 50 | Hits

It is always bad news if your SQL queries are having to use the SORT operator. It is worse news if you get a warning that sort operations are spilling onto TempDB. If you have a busy, slow TempDB, the...

Premature Scalability and the Root of All Evil

Simple Talk, March 18, 2015
Views: 84 | Hits 9

When you're designing an application, there is a temptation to build it to a super-scalable future-proof architecture, even when the immediate requirements can be met by a simple single-tier applicati...

IoT Dash - Device Discovery, Commanding and Data Channeling

The Code Project Latest Articles, March 18, 2015
Views: 70 | Hits 3

Discover and command IoT devices in your local network. Channel device-data to your websites, SQL-Server, Azure Table Storage and Azure Event Hubs....

SQL SERVER Backup on mapped drive failing with error Msg 3201, Level 16, State 1 Operating system error 3(The system cannot find the path specified.)

Journey to SQL Authority with Pinal Dave, March 18, 2015
Views: 63 | Hits

We are so used to taking backups and it can sometimes give us new experiences. One of the common messages I see are around taking backups on a share. If you have found this blog while searching for er...

LLBLGen Pro v5.0 CTP 1 released!

Frans Boumas blog, March 17, 2015
Views: 68 | Hits 3

Weve released LLBLGen Pro  v5.0 CTP 1! Its a Community Technical Preview (CTP) of the upcoming v5.0 which is in development since fall 2014. The CTP is open for all v4.x customers (its in the cus...

Everything about SQL- Get Started

The Code Project Latest Articles, March 17, 2015
Views: 75 | Hits 7

Topics to be Covered SQL Basics Introduction What is a database? What does Relational mean? A small example SQL Statement Naming Things Creating Things Everything about SELECT Statement Introduction F...

SQL SERVER Marking Filegroup as ReadOnly with SQL Server

Journey to SQL Authority with Pinal Dave, March 17, 2015
Views: 55 | Hits 1

My love for writing about ReadOnly databases have pushed me to explore more about this topic. Based on previous blogs, few readers did ask me that they heard about marking filegroups as ReadOnly and t...

SQL SERVER Interesting Observation with Currency Symbols

Journey to SQL Authority with Pinal Dave, March 16, 2015
Views: 76 | Hits 7

The currency symbols like $ and are implicitly treated as money value in SQL Server If you run the following code SELECT$ SELECT You can see that both of the above statements return the value 0.00 It...

Interview Question of the Week #011 Script to Convert List to Table and Table to List

Journey to SQL Authority with Pinal Dave, March 15, 2015
Views: 89 | Hits 14

Now today’s interview question is really more of daily routine task for many of the developer. 11 years ago, when I went to my very first interview call. My interview was scheduled at 6 PM in one of t...

SQL SERVER SCRIPT SQL Listening on Dynamic Port?

Journey to SQL Authority with Pinal Dave, March 14, 2015
Views: 90 | Hits 8

With every release of SQL Server, sometimes I need to revisit some of the old blogs to see how they have enhanced. This learning experience is an ongoing process and the best way I learn is by doing a...

SQL SERVER Interesting Function AGENT_DATETIME

Journey to SQL Authority with Pinal Dave, March 13, 2015
Views: 110 | Hits 11

One in a while I come across such interesting side of SQL Server that it even surprises me. Just the other day I came across function AGENT_DATETIME. I had never used it before and now I just found us...

SQL SERVER The Basics of the File System Task, Part 1 Notes from the Field #071

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

[Note from Pinal]: This is a new episode of Notes from the Fieldseries.Every time I give an introductory note, however, this time there is no need of intronote. This note is from Andy and as we all kn...

SQL SERVER Error Msg 6401, Level 16: Cannot roll back Transaction

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

In a recent Usergroup meet that I attended someone asked me this simple yet interesting question about how transactions work and is there any concept like nested transactions inside SQL Server. Though...

Identifying and Solving Index Scan Problems

Simple Talk, March 10, 2015
Views: 10 | Hits

When you're developing database applications, it pays to check for index scans in the SQL Server query plan cache. Once you've identified the queries, what next? Dennes Torres gives some preliminary g...

SQL SERVER FIX A connection cannot be made to redirector. Ensure that SQL Browser service is running. (Microsoft.AnalysisServices.AdomdClient)

Journey to SQL Authority with Pinal Dave, March 10, 2015
Views: 84 | Hits 2

Life gives you learning lessons from unexpected times, here is one such experience that I felt is worth sharing. It may be a surprise to my blog readers that I also have SQL Server Analysis Services i...

SQL SERVER How to Add User Across Databases

Journey to SQL Authority with Pinal Dave, March 9, 2015
Views: 107 | Hits 3

In this era of standards, many organizations want to be using some of the cutting edge technologies in their organizations. In many of these interactions I was lucky enough to meet few DBAs who give m...

Interview Question of the Week #010 What is the Difference Between Primary Key Constraints and Unique Key Constraints?

Journey to SQL Authority with Pinal Dave, March 8, 2015
Views: 98 | Hits 16

I often see people getting confused between Primary Key and Unique Key. I see where people get confused about the same. Let us discuss. Question: “What is the Difference Between Primary Key Constraint...

SQL SERVER Using Buffer Pool Extension with In-Memory OLTP?

Journey to SQL Authority with Pinal Dave, March 7, 2015
Views: 88 | Hits 1

I am always amazed to see the questions asked by my blog reader which lead me to learn more about SQL Server. Here is the question which took me little time to figure out the answer. If you are new to...

Real Time Notifications using SignalR and SQL Dependency

The Code Project Latest Articles, March 6, 2015
Views: 98 | Hits 16

Server side push notification using SignalR and SQL...

SQL SERVER ReadOnly Databases with ReadOnly File Attribute

Journey to SQL Authority with Pinal Dave, March 6, 2015
Views: 98 | Hits 2

As part of continued series of ReadOny databases, the earlier blog had an interesting comment that read as some people were getting errors of 5120 and others. This got me curious and was in the pendin...

SQL SERVER Using Raw Files in SSIS Notes from the Field #070

Journey to SQL Authority with Pinal Dave, March 5, 2015
Views: 85 | Hits 3

[Notes from Pinal]: SSIS is very well explored subject, however, there are so many interesting elements when we read, we learn something new. A similar concept has beenCreating the SSIS catalog. Linch...

SQL SERVER Database Stuck in In Recovery Mode After Restart

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

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: 88 | Hits 4

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: 140 | Hits 17

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: 85 | Hits 2

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: 97 | Hits 14

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: 78 | Hits 1

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: 89 | 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: 85 | 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: 102 | 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: 93 | 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: 106 | 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: 99 | Hits 3

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: 147 | 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: 91 | 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: 92 | 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: 87 | 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: 124 | Hits 5

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: 77 | Hits 2

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: 87 | 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: 130 | 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...