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

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

SELECT One by Two Interview Question Extended Part II

Journey to SQL Authority with Pinal Dave, April 30, 2016
Views: 27 | Hits 1

The puzzles are interesting and in most cases, if we try to play around a little bit more, many more interesting extensions can be added. A couple of weeks back, I wrote a round SELECT One by Two Wh...

Understanding Database Scalability Vertical and Horizontal

Journey to SQL Authority with Pinal Dave, April 29, 2016
Views: 60 | Hits 6

Since I have started my consulting engagements with customers around the world, I have been asked interesting queries from time to time. In a recent customer call, the customer insisted I assist them ...

Hey DBAs What Are You Assuming/Missing Today? Notes from the Field #122

Journey to SQL Authority with Pinal Dave, April 28, 2016
Views: 58 | Hits

[Note from Pinal]: This is a 122nd episode of Notes from the Field series. This story about Shepherd DBA, Teacher and Mentor. If you know Mike Walsh, he is an amazing person to meet and know. He is a ...

SQL SERVER Computed Column and Conditions with Case Statement

Journey to SQL Authority with Pinal Dave, April 27, 2016
Views: 59 | Hits 4

When I do not find anything on my blog, I write a blog post about it, so next time I do not have to recreate the scripts from the beginning. Just another day, I was doing performance tuning for an org...

SQL SERVER Identify Table Where Clustered Index is Not a Primary Key DMV

Journey to SQL Authority with Pinal Dave, April 26, 2016
Views: 78 | Hits 2

Let us first see scriptwhich will return ustablename with schema where clustered index is not a primary key.The post SQL SERVER – Identify Table Where Clustered Index is Not a Primary Key – DMV appear...

SQL SERVER What is WRK file in Log Shipping?

Journey to SQL Authority with Pinal Dave, April 25, 2016
Views: 56 | Hits 2

Several customers use log shipping for disaster recovery across a remote data center. If you are reading this blog, I would assume that you already know SQL Server log shipping If you dont, then pleas...

What is Difference Between HAVING and WHERE Interview Question of the Week #068

Journey to SQL Authority with Pinal Dave, April 24, 2016
Views: 65 | Hits 8

I do a performance tuning consulting to earn my livelihood. Once in a while, I end up customer who wants to interview me to check if I know SQL. I absolutely have no problem with the interview. This i...

PowerShell Script Backup Every Database In SQL Server

Journey to SQL Authority with Pinal Dave, April 23, 2016
Views: 71 | Hits 8

Using scripts can be a powerful way to automate things that a GUI will fail in many cases. I was working with a client who wanted to write a PowerShell script that would help him automate his backups....

The Tale of the Cunning Dev, Encrypted Procedures, DAC and God Mode = ON Experts Opinion

Journey to SQL Authority with Pinal Dave, April 22, 2016
Views: 71 | Hits 6

A few weeks ago, I was puzzling out the logic of a free tool. The thing with the author of the tool turned out to be almost a detective story: he happened to be a developer living in South America. Ce...

SQL SERVER 2016 Enhancements with AlwaysOn Availability Groups Notes from the Field #121

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

[Note from Pinal]: In this episode of the Notes from the Field series database expert Mike Lawell talks about his thoughts and observation about SQL Server 2016 and enhancements with AlwaysOn Availabi...

Team Database Development and Version Control with SQL Source Control

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

Team database development is hard. It throws up questions about whos responsible for code, how to track changes, and how to share them. For application development, teams can overcome these problems w...

MySQL LEAST and GREATEST Comparison Operators

Journey to SQL Authority with Pinal Dave, April 19, 2016
Views: 93 | Hits 3

The biggest challenge which we often face as a database person is to compare the value across multiple columns. Trust me, if there were no comparison operators, we would have never got this task done....

SQL SERVER Unable to Open Maintenance Plan in Management Studio

Journey to SQL Authority with Pinal Dave, April 18, 2016
Views: 110 | Hits 1

The most queried topics in this blog have been around troubleshooting or which solve specific error messages. I always feel when I see something new as messages, I try to check if this is available he...

SELECT One by Two Why Does SELECT 1/2 Returns 0 Interview Question of the Week #067

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

Just like a week, during a user group meeting I was told to ask questions about why the SELECT 1 /2 gives a different answer then one user is expected. Let us see this question in detail about SELECT ...

SQL SERVER Identifying Page Types

Journey to SQL Authority with Pinal Dave, April 16, 2016
Views: 135 | Hits 1

I try to keep the understanding and concepts for learning simple. Because for a strong building one needs to have a solid foundation. The structures stability is a function of how well the foundation ...

Getting started with Azure SQL Data Warehouse

Simple Talk, April 15, 2016
Views: 134 | Hits 6

Azure SQL Data Warehouse is an obvious first-step towards migrating on-premise organisational data to the cloud. So how do you get started with it? Robert Sheldon provides a simple guide that should p...

MySQL FOUND_ROWS() Function for Total Number of Rows Affected

Journey to SQL Authority with Pinal Dave, April 15, 2016
Views: 137 | Hits 1

In SQL Server to get the total number of rows affected by the last statement, you can use the system variable @@ROWCOUNT. Similarly, in MySQL you can find it using FOUND_ROWS () function.The post MySQ...

SQL SERVER Backup Randomly Failing with Error 112 (There is not enough space on the disk.)

Journey to SQL Authority with Pinal Dave, April 14, 2016
Views: 153 | Hits 1

Solving puzzle is something everyone would love to do. It gets our creative thoughts and the things that it challenges how we can solve problems. Recently I bought a puzzle which my kid had to finish ...

SQL SERVER Network Name resource fails to come online in a Windows Server 2008 R2 Failover Cluster

Journey to SQL Authority with Pinal Dave, April 13, 2016
Views: 153 | Hits

Even if you are a DBA, sometime you need to deal with issues which are not related to SQL Server. It is not by design, but this is part of our job description. It is always interesting to troubleshoot...

SQL SERVER Drive Space Full Due to MDMP Files

Journey to SQL Authority with Pinal Dave, April 12, 2016
Views: 146 | Hits 2

If you are a DBA and if you ever hear about drive space full issues on the SQL Server machine, the first thought to come to your mind would be huge transaction log file. Recently I have also fallen in...

The Practical Problems of Determining Equality and Equivalence in SQL

Simple Talk, April 11, 2016
Views: 69 | Hits 3

In theory, it is easy to determine whether data is equal to, greater than or lesser than a value. Real-world data types can be surprisingly tricky, even for gauging data equivalence. Because SQL canno...

Firebase Google Alphabets Cloud Service Provider

The Code Project Latest Articles, April 10, 2016
Views: 132 | Hits 4

Firebase, A one stop solution for your web or mobile applications on cloud powered by Firebases NoSQL backend and much more....

What is ACID Property in Database? Interview Question of the Week #066

Journey to SQL Authority with Pinal Dave, April 10, 2016
Views: 134 | Hits 3

Today I want to take you all back to the one of the very original database interview questions and answer which I see often discussed in the interview. I have previously written about this ACID proper...

SQL SERVER InMemory OLTP Migration Assistant Powershell Script

Journey to SQL Authority with Pinal Dave, April 9, 2016
Views: 138 | Hits 4

In one of my recent interaction with my client, they were so much impressed with the fact that SQL Server has now introduced the ability to use In Memory OLTP. They said they were interested in implem...

Goodwill and hard learning at SQL Bits 15

Simple Talk, April 8, 2016
Views: 71 | Hits 1

SQL Bits XV, the official launch event for SQL Server 2016, begins in Liverpool, UK, on May 4, 2016. Simple-Talk is a strong supporter of this event, and for good reasons; it’s a fantastic training ev...

QxOrm - C++ ORM (Object Relational Mapping) Library

The Code Project Latest Articles, April 8, 2016
Views: 123 | Hits 2

QxOrm C++ library: Persistence (based on QtSql Qt library) - Serialization (based on boost::serialization library) - Reflection (introspection)...

SQL SERVER Identifying Database Default Locations for Data and Logs

Journey to SQL Authority with Pinal Dave, April 8, 2016
Views: 136 | Hits

How often have you had the opportunity to go back to basics and learn the same thing again in a different manner? How many of you are developers here? I am sure each one of us write a piece of code th...

SQL SERVER Huge Transaction Log in Snapshot Replication!

Journey to SQL Authority with Pinal Dave, April 7, 2016
Views: 153 | Hits 2

Learning never stops for me! I was into a situation where the log space for the database is not getting reused and it is increasing in size. As usual, I asked to check sys.databases catalog view and w...

SQL SERVER What is DBCC TRACEON and DBCC TRACEOFF messages in ERRORLOG?

Journey to SQL Authority with Pinal Dave, April 6, 2016
Views: 161 | Hits 3

One of my clients asked me more about these messages logged in the SQL Server ERRORLOG. If you are new to SQL Server and dont know how to reach to ERRORLOG, read below Where is ERRORLOG? Various Ways ...

SQL SERVER How to Change SQL Server Collation on Microsoft Azure VM (IaaS)

Journey to SQL Authority with Pinal Dave, April 5, 2016
Views: 165 | Hits 1

I have been using Microsoft Azure, SQL Virtual Machine (IaaS) for quite some time because few of my clients ask questions about them. My clients generally use images from gallery to deploy SQL Server....

MySQL Different Methods to Know Current User

Journey to SQL Authority with Pinal Dave, April 4, 2016
Views: 150 | Hits 1

There are different methods to know the name of the current user in MySQL. There can be many reasons we want to know who is the current user. Here is list of the of the few of the such reasons.Customi...

SQL SERVER Who Changed the Password of SQL Login? Interview Question of the Week #065

Journey to SQL Authority with Pinal Dave, April 3, 2016
Views: 178 | Hits 5

Today's interview question was not really asked interview, but it is indeed a real world scenario which everyone should know the answer of. I strongly suggest you bookmark this blog post at once in yo...

SQL SERVER FIX: Could not connect because the maximum number of 1 user connections has already been reached

Journey to SQL Authority with Pinal Dave, April 2, 2016
Views: 148 | Hits 2

Sometimes making a change in something for which the impact is not known, could cause a heavy loss. A similar situation happened when one of my clients called me and told that he is in big trouble and...

How to save Excel files to SQL Server and make them downloadable from an ASP.NET Web API project

The Code Project Latest Articles, April 1, 2016
Views: 119 | Hits 6

Save Excel (or other types of) files to SQL Server, then read them out again and make them downloadable via a link on an ASP.NET Web API page...

Relational Algebra and its implications for NoSQL databases

Simple Talk, April 1, 2016
Views: 116 | Hits 7

With the rise of NoSQL databases that are exploiting aspects of SQL for querying, and are embracing full transactionality, is there a danger of the data-document model's hierarchical nature causing a ...

SQL SERVER 2016 Early Thoughts and Observations Notes from the Field #120

Journey to SQL Authority with Pinal Dave, April 1, 2016
Views: 128 | Hits 3

[Note from Pinal]: In this episode of the Notes from the Field series database expert Mike Lawell explains about Live Query Statistics in SQL Server 2016. Statistics are heart of SQL Server. They pla...

SQL SERVER Finding If Status of Bulk Logging Enabled or Not From Logs

Journey to SQL Authority with Pinal Dave, March 31, 2016
Views: 136 | Hits 1

Backup related questions are always challenging and sometimes our basics is shaken when someone randomly asks us something we were not aware of. Sometimes it takes a little bit of digging around in do...

Day 1 : Database Connectivity ASP.NET/C# with SQL Server (Create Operation)

The Code Project Latest Articles, March 30, 2016
Views: 132 | Hits 5

CRUD operation in ASP.NET/C# with SQL Server for beginners...

SQL SERVER How to Query Active Directory Data Using ADSI / LDAP Linked Server

Journey to SQL Authority with Pinal Dave, March 30, 2016
Views: 135 | Hits 2

There are situations when you need to integrate SQL Server with other product. Once of the classic example was seen during my last visit to a client. They wanted list of email addresses and phone num...

SQL SERVER How to Add Multiple New Columns to Table with Default Values?

Journey to SQL Authority with Pinal Dave, March 29, 2016
Views: 146 | Hits 4

This is a follow up blog post of my earlier blog post on the same subject. You can read my earlier blog post over here. I recently received an email where a user asked how to add more than one new col...

MySQL How to Drop Table If Exists in Database?

Journey to SQL Authority with Pinal Dave, March 28, 2016
Views: 111 | Hits 1

In this post SQL Server 2016 T-SQL Enhancement Drop if Exists clause, we have seen the new feature introduced in SQL Server version 2016. One of my friends recently asked me question that how to dro...

What is a Self Join? Explain with Example Interview Question of the Week #064

Journey to SQL Authority with Pinal Dave, March 27, 2016
Views: 111 | Hits 8

A very popular question I often see in the interviews of developers. It does not matter if you are a SQL developer, .NET developer, JAVA developer or Python Developer, this question is always popular ...

SQL SERVER Patch Upgrade Failed to connect to server. Error: 0x80070422

Journey to SQL Authority with Pinal Dave, March 26, 2016
Views: 133 | Hits

One of my recent interaction with a client was to assist in performing Upgrade the SQL Server 2008 R2 with service pack 2. As usual, I asked for setup logs from C:\Program Files\Microsoft SQL Server\...

MySQL ELT() and FILED() Functions to Extract Index Position From List

Journey to SQL Authority with Pinal Dave, March 25, 2016
Views: 152 | Hits 2

MySQL supports some functions that can be used to extract the index position or the actual value from a set of values arranged as an array. ELT() and FIELD() are example of such functions. Let us unde...

I Dont Know DBAs Should Learn to Use This Phrase Notes from the Field #119

Journey to SQL Authority with Pinal Dave, March 24, 2016
Views: 111 | Hits 1

[Note from Pinal]: This is a 119th episode of Notes from the Field series. If you know Mike Walsh, he is an amazing person to meet and know. He is technical expert, but along with that he is a true li...

SQL Authority News Behind the Scene Story of New Look

Journey to SQL Authority with Pinal Dave, March 23, 2016
Views: 118 | Hits 2

SQLAuthority.com blog started on November 1, 2006. Since that day I have blogged over 3500 blog posts and have witnessed over 110 million views on this blog. Today I am happy to tell you that SQLAutho...

SQL SERVER Extended Events to watch for using ColumnStore Index

Journey to SQL Authority with Pinal Dave, March 22, 2016
Views: 108 | Hits

In the recent past, I have written a number of posts around ColumnStore Index and how they function. Some of the nuances of working with ColumnStore Indexes are available in this blog for reference. I...

SQL SERVER How Enable Transparent Database Encryption (TDE) for Database Mirroring?

Journey to SQL Authority with Pinal Dave, March 21, 2016
Views: 95 | Hits 3

Life can teach you interesting lessons and push you beyond the boundary of what we call as a comfort zone. Recently I had a customer who was working on SQL server 2008 R2 and was enabling Mirroring. T...

Interview Question of the Week #063 How to Recompile Stored Procedure for Specific Table?

Journey to SQL Authority with Pinal Dave, March 20, 2016
Views: 140 | Hits 5

I have kept busy with SQL Consultancy now a days. Just the other day, while doing performance tuning exercise we had made major changes in the data stored in one of the main tables. The impact was so ...

SQL Server web based backup tool

The Code Project Latest Articles, March 19, 2016
Views: 158 | Hits 9

An Asp.Net one page application for get backup from MS-SQL Server...