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

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

Moving TempDB to New Drive Interview Question of the Week #077

Journey to SQL Authority with Pinal Dave, June 26, 2016
Views: 1 | Hits

Midnight at 1 AM, I received a call from my customer where I have earlier worked on performance tuning project. As soon as I picked up the phone call the first statement from my friend was about TempD...

SQL SERVER Fix Error 948 A downgrade path is not supported. The database cannot be opened because it is version.

Journey to SQL Authority with Pinal Dave, June 25, 2016
Views: 55 | Hits

These past weeks the number of errors I have been getting when attaching a database has been far too many. But the best part of this learning experience is that I get to write about them one after ano...

SQL SERVER Identifying InMemory OLTP Hash Collisions

Journey to SQL Authority with Pinal Dave, June 24, 2016
Views: 72 | Hits

It is about a few weeks back that I wrote about how InMemory OLTP Hash Collisions can happen and how it can affect performance. Here is a recap of that post for your reference and do check the same be...

The .NET support black hole

Frans Boumas blog, June 23, 2016
Views: 62 | Hits 5

Today I ran into a bit of an issue. A work-item for LLBLGen Pro v5.1 is to support all the new features of SQL Server 2016. One of the features of SQL Server 2016 is Always Encrypted. You can enable t...

SQL SERVER SQL Profiler vs Extended Events

Journey to SQL Authority with Pinal Dave, June 22, 2016
Views: 72 | Hits 1

To tell you the truth, I didn't know how to start this article about SQL Profiler vs Extended Events. After all, I decided to take mind off things and to watch a movie. The movie was Iron Man 2. In ad...

Clone, Sweet Clone: Database Provisioning Made Easy?

Simple Talk, June 21, 2016
Views: 48 | Hits 1

One of the difficulties of designing a completely different type of development tool such as SQL Clone is that you have to explain what it is for, but when its use is open-ended it can be exciting to ...

SQL SERVER FIX Linked Server Error 7416 Access to the remote server is denied because no login-mapping exists

Journey to SQL Authority with Pinal Dave, June 21, 2016
Views: 116 | Hits 2

Last time I wrote a blog about linked server creation issue. As I said, these are one of the most common issues. But as soon as such blogs get released, I get a number of requests around them immediat...

SSIS in SSDT: The Basics

Simple Talk, June 20, 2016
Views: 39 | Hits 2

SQL Server Integration Services (SSIS) is a fast and reliable way of importing and exporting data, but it can be tricky to learn, initially. Rob Sheldon provides a beginner's guide to get you started ...

SQL SERVER Event ID 7000 The service did not start due to a logon failure

Journey to SQL Authority with Pinal Dave, June 20, 2016
Views: 84 | Hits

Many times I feel that I have so many blogs that I must have covered all common possible error related to usage of SQL Server. But there are few easy ones which I missed. And thanks to those who take ...

What is a Master Database in SQL Server? Interview Question of the Week #076

Journey to SQL Authority with Pinal Dave, June 19, 2016
Views: 117 | Hits 4

The other day, I received an email from a user, who had dropped master database in their system. I told him directly that he should have not dropped master database as that is a very important system ...

SQL SERVER Installation Error The wrong diskette is in the drive. Insert (Volume Serial Number: ) into drive.

Journey to SQL Authority with Pinal Dave, June 18, 2016
Views: 104 | Hits 2

The world of working with errors always gets the better of me. It is a wonderful way to understand why SQL Server behaves in a certain way and most importantly, it helps me solve some of the problems ...

SQL Server Notifications on Record Change with SignalR and SQLTableDependency

The Code Project Latest Articles, June 17, 2016
Views: 140 | Hits 4

SqlTableDependency is a component used to receive database notifications containing the record values inserted, deleted or update on a database table....

SQL SERVER 2016 How to Import New Sample Database WideWorldImporters

Journey to SQL Authority with Pinal Dave, June 17, 2016
Views: 111 | Hits 1

Few days back I wrote blog about SQL Server 2016 Developer Edition free download. If you didnt get a chance to have a look, here is the link: Download SQL SERVER 2016 Developer Version for FREE. Let u...

SQL SERVER Database Mail Breaks with TLS 1.0 Disabled Discovery Notes from the Field #128

Journey to SQL Authority with Pinal Dave, June 16, 2016
Views: 107 | Hits 2

[Note from Pinal]: In this episode of the Notes from the Field series database expert Ryan Adams explains a very critical error related to Database Mail. Ryan is one guy who spends more time with real...

Measure of a DBA

Simple Talk, June 15, 2016
Views: 66 | Hits 3

Marketing people are often surprised when a new version of SQL Server doesn’t quite generate the atmosphere of excited anticipation that they expected. After all, people seem to get themselves in a st...

Building REST services with ASP.NET Core Web API and Azure SQL Database

The Code Project Latest Articles, June 15, 2016
Views: 128 | Hits 12

In this article you can see how easily you can create REST services using ASP.NET Core Web API and new JSON support in Azure SQL database and SQL Server 2016...

SQL SERVER Unable to Start SQL Agent SQL Server Agent Terminated (Normally)

Journey to SQL Authority with Pinal Dave, June 15, 2016
Views: 120 | Hits 1

Along with performance issues, I also provide consultancy in other break-fix issues like service not starting etc. These are not run of the mill, but on specific cases only. I always suggest my client...

Building Web API REST services on Azure SQL Database using JSON functionalities

The Code Project Latest Articles, June 14, 2016
Views: 113 | Hits 6

In this article you can see how easily you can create REST services using new JSON support in Azure SQL database and SQL Server 2016...

SQL SERVER to Oracle Numeric Datatype Mapping

Journey to SQL Authority with Pinal Dave, June 14, 2016
Views: 126 | Hits 1

Getting into a consulting business has its own set of challenges that I cherish big time. Recently I was consulted by a product team that had some of the best guys in the market. I was surprised why t...

SQL SERVER Maintenance Plan Folder Missing Under Management in SQL Server Management Studio

Journey to SQL Authority with Pinal Dave, June 13, 2016
Views: 131 | Hits 3

The best part of learning is by the error messages that each one of you send me over the years. These are a great source of experimentation and a lot of searching to get to the appropriate error resol...

SQL SERVER FIX Agent XPs Component is Turned Off as Part of the Security Configuration for this Server

Journey to SQL Authority with Pinal Dave, June 12, 2016
Views: 104 | Hits 1

One of my clients has installed a new instance of SQL Server and then wanted to create maintenance plan. They were complaining about getting some error and we're looking forward for my help to solve t...

Can We Have NULL Value in Primary Key? Interview Question of the Week #075

Journey to SQL Authority with Pinal Dave, June 12, 2016
Views: 156 | Hits 11

This is a very interesting question. I really do not know why interviews are fascinated with this question. One of the professional services I offer is to help organizations select an ideal employee f...

SQL SERVER FIX Linked Server Error 7399 Invalid authorization specification

Journey to SQL Authority with Pinal Dave, June 11, 2016
Views: 156 | Hits

I have personally seen when people use Linked Server there are a number of issues from authentication to performance. These issues are part of working with something that has so many variations and pe...

SQL Server 2016 Management Studio Warning: SSMS install detected shared components on this machine

Journey to SQL Authority with Pinal Dave, June 10, 2016
Views: 147 | Hits 5

As soon as SQL Server 2016 Management Studio was released on 1st June 2016, I tried installing it. This is a great way to learn and I love to get going as soon as the new software gets released. I esp...

SQL SERVER 2016 How to Use SQL Server 2016 Stretch Database Notes from the Field #127

Journey to SQL Authority with Pinal Dave, June 9, 2016
Views: 150 | Hits 4

[Notes from Pinal]: First of all, last week SQL Server 2016 released. If you have not downloaded the developer version for free. You can download from here. SQL server 2016 has many different features...

SQL SERVER System Objects Not Visible in SQL Server Management Studio

Journey to SQL Authority with Pinal Dave, June 8, 2016
Views: 134 | Hits 1

There are so many settings in SQL Server Management Studio that it can sometimes make someone nervous. Once of my client sent me email telling that something is not right with their SQL Server 2016 in...

SQL SERVER How Much Free Space I Have in My Database?

Journey to SQL Authority with Pinal Dave, June 7, 2016
Views: 133 | Hits 8

This is one of the simplest query that I wrote for one of my consulting customers who asked me. When I was discussing with the customer on some of the best practices of working with SQL Server, I was ...

SQL SERVER Vertical Select Mode feature in SQL Server Management Studio

Journey to SQL Authority with Pinal Dave, June 6, 2016
Views: 118 | Hits 8

During last SQL Bangalore user group meeting, Balmukund presented a surprise session of tips and tricks with SQL Server Management Studio. Even though I was not able to attend the event due to travel ...

Sort Query Using Dynamic Variables Without EXEC Interview Question of the Week #074

Journey to SQL Authority with Pinal Dave, June 5, 2016
Views: 135 | Hits 5

It does not matter which version of SQL Server we are using, I think this question is going to be there universally all the time when people want to sort query using dynamic variables. Trust me, this ...

SQL SERVER Event ID 107- Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.

Journey to SQL Authority with Pinal Dave, June 4, 2016
Views: 153 | Hits

Generally, I like to pick and choose the way various services are installed when working with SQL Server. I am careful not to have unnecessary services like Reporting Services, Agent etc running. I in...

SQL SERVER Maintain Carriage Return (Enter Key) in SQL Server 2016 Management Studio While Copy and Paste

Journey to SQL Authority with Pinal Dave, June 3, 2016
Views: 176 | Hits 2

With every new release some of the default behavior can surprise because you are so much used to them. But when they dont behave the same, it baffles to when some of these changes were introduced. In ...

SQL SERVER Puzzle Solve Splitting Strings Puzzle

Journey to SQL Authority with Pinal Dave, June 2, 2016
Views: 151 | Hits 4

Some puzzles come as legacy and a great way to do sometimes interviews. In the past, I have written some innovative solutions when it comes to splitting strings inside SQL Server. One of them is at: S...

The PoSh DBA: Accessing SQL Server from PowerShell

Simple Talk, June 1, 2016
Views: 15 | Hits

The worst part for a DBA of getting started with PowerShell is often just figuring out the best way of working with SQL Server. The most suitable approach to accessing SQL Server depends on the sort ...

Dynamic Images in SQL Server Reporting Services

Simple Talk, June 1, 2016
Views: 136 | Hits 5

It is relatively easy to provide a smart BI solution when your customer has all the resources for a new hardware and software platform, but it takes ingenuity to provide an effective simple solution r...

5 Monitoring Queries for SQL Server

Simple Talk, June 1, 2016
Views: 125 | Hits 11

Every DBA squirrels away favourite queries for monitoring SQL Server. Nowadays many of these are too complex to keep in your head. Dennes describes how he uses T-SQL queries for solving problems, whet...

3 Built-In Technologies for Centralizing SQL Server Administration

Simple Talk, June 1, 2016
Views: 98 | Hits 3

DBAs can be more effective in managing their workload by centralizing their procedures. There are several features of SQL server that can be harnessed to this end: PowerShell is only part of the solut...

Download SQL SERVER 2016 Developer Edition for FREE

Journey to SQL Authority with Pinal Dave, June 1, 2016
Views: 166 | Hits 18

Just a few minutes ago SQL Server 2016 is released. You can download SQL Server 2016 Developer Edition for FREE. There are many different versions of SQL Server 2016 and they are all available for dow...

SQL SERVER Identifying Application vs Network Performance Issues

Journey to SQL Authority with Pinal Dave, June 1, 2016
Views: 124 | Hits 3

Your SQL is tuned perfectly and delivers thousands of rows in milliseconds on your test system, but your end users are complaining about slow application performance. Time is of the essence because th...

SQL SERVER SSMS Tip: How to Get Larger Fonts for Results in Grid Output

Journey to SQL Authority with Pinal Dave, May 31, 2016
Views: 143 | Hits 3

A couple of weeks back, I was at the GIDS (Great Indian Developer Conference) speaking on my favorite topic of performance. Often as a speaker I make sure I attend a couple of sessions from friends or...

SQL SERVER Configuration Manager MMC could not create the snap-in. The snap-in might not have been installed correctly

Journey to SQL Authority with Pinal Dave, May 30, 2016
Views: 101 | Hits

I have always felt the social media has a bigger impact on the current generation. It can easily spoil their time on one side or it can be awesomely productive if utilized the right way. As there are ...

What is NOT NULL Constraint? Interview Question of the Week #073

Journey to SQL Authority with Pinal Dave, May 29, 2016
Views: 103 | Hits 6

I am an independent database consultant and I focus on SQL Server Performance Tuning. The other day when I was working with my customer on a large project on performance tuning, we noticed a table whi...

SQL SERVER Finding Waits For Any Session with Extended Event wait_info

Journey to SQL Authority with Pinal Dave, May 28, 2016
Views: 89 | Hits 2

One of the most sought after blog is around Wait Stats when it comes to performance troubleshooting. The place to bookmark would be - SQL SERVER Wait Stats Wait Types Wait Queues Day 0 of 28. I ge...

Automatically Create Data Access Layers and Business Layers From Microsoft Access or SQL Server Databases

The Code Project Latest Articles, May 27, 2016
Views: 118 | Hits 6

How to automatically create data access layers and business layers from a Microsoft Access or a SQL Server database...

SQL Server InMemory OLTP Hash Collisions Performance Overhead

Journey to SQL Authority with Pinal Dave, May 27, 2016
Views: 90 | Hits 4

Sometimes the best of learnings are based on peoples questions. I always feel when questions are asked, more the learnings are. In a recent session for a customer who had implemented SQL Server 2014 I...

SQL SERVER Why DBAs Need to Know about Kerberos Notes from the Field #126

Journey to SQL Authority with Pinal Dave, May 26, 2016
Views: 102 | Hits 1

[Note from Pinal]: Not everyone knows about Kerberos. Many think it is a two headed dog from mythology, well that is true but when we talk about database, it is all about security. In this episode of ...

Using SSIS to Load Data Into Azure SQL Data Warehouse

Simple Talk, May 25, 2016
Views: 15 | Hits

It is a good time to get familiar with Azure SQL Data Warehouse. The first objective must be to get data into it. SSIS is a good way to start, and its certainly worth gaining confidence with the ETL p...

SQL SERVER FIX: Error 1807 Could not obtain exclusive lock on database model. Retry the operation later Part 2

Journey to SQL Authority with Pinal Dave, May 25, 2016
Views: 107 | Hits 2

I have always mentioned in the blogs that the most sought out blogs would be around troubleshooting or around specific error messages. These blogs are the biggest source of page views from various sea...

Im speaking at a Free AzureCraft event in London on June 3rd

ScottGus Blog, May 24, 2016
Views: 90 | Hits

Ill be in the UK next week presenting at the free AzureCraft event being held on June 3rd and 4th.  This event was created by the UK Azure User Group and is a great way to learn about Azure as we...

PowerShell Querying SQL Server From Command Line

Journey to SQL Authority with Pinal Dave, May 24, 2016
Views: 105 | Hits 4

PowerShell is quite an interesting capability that is added as part of Windows. I wonder how many of us really appreciate the power of this tool being out of the box. The more I see it being used in c...

SQL SERVER What is Trace Flag An Introduction

Journey to SQL Authority with Pinal Dave, May 23, 2016
Views: 93 | Hits 2

Last week I published below blog where I talked about a trace flag. Backup Randomly Failing with Error 112 (There is not enough space on the disk.) One of the reader commented, whether he needs to ena...