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

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

SQL SERVER 2016 FIX: Install Rule Oracle JRE 7 Update 51 (64-bit) or higher is required failed

Journey to SQL Authority with Pinal Dave, July 8, 2015
Views: 9 | Hits

I enjoy spending time with my daughter almost every single day. It keeps me busy at home and most importantly, some quality time with her allows me to relax after a long day at work. But there one thi...

SQL SERVER Identifying Blocking Chain Using SQL Scripts

Journey to SQL Authority with Pinal Dave, July 7, 2015
Views: 46 | Hits 3

There are a number of blog posts that have been written on this very topic. This can be from basics to almost advanced in many ways. I am outlining some of them here below: SQL SERVER Quickest Way to...

SQL SERVER Creating Dataset Using VALUES Clause Without Creating A Table

Journey to SQL Authority with Pinal Dave, July 6, 2015
Views: 69 | Hits 5

You know that you can add data to a table using VALUES clause. But did you know that you can create a dataset using VALUES clause like a table without adding into another table? Suppose you want to cr...

Interview Question of the Week #027 Move TempDB from One Drive to Another Drive When Low Disk Space

Journey to SQL Authority with Pinal Dave, July 5, 2015
Views: 69 | Hits 2

I am often invited to attend various interviews and once in a while, I see practical questions discussed in the interview. Here is one of the important interview question which is related to TempDB. Q...

SQL SERVER Secure by Default The Mantra

Journey to SQL Authority with Pinal Dave, July 4, 2015
Views: 83 | Hits 2

Generally the talks I give at conferences revolve around performance and tuning. These are always the most sought after topic and I dont disappoint the requests because they give me an opportunity to ...

The Railmap Towards Easier Query Tuning?

Simple Talk, July 3, 2015
Views: 33 | Hits

Recently, I’ve been getting more and more engrossed in SQL Server Execution plans for various reasons, including editing the forthcoming third edition of Grant Fritchey’s book. There are certain infog...

SQL SERVER Difference Between Read Committed Snapshot and Snapshot Isolation Level

Journey to SQL Authority with Pinal Dave, July 3, 2015
Views: 107 | Hits 11

It is quite common that when a new feature gets introduced, there is a lot of talk about them. Sometimes even the old capabilities are lesser known because they can be used interchangeably in conversa...

SQL SERVER Why Havent You Disabled CPU Power Saving Yet?! Notes from the Field #087

Journey to SQL Authority with Pinal Dave, July 2, 2015
Views: 76 | Hits 5

[Note from Pinal]: This is an 87th episode of Notes from the Fieldseries. Every week, I personally wait for the notes from the fields from Mike because it containslessons of life which directly impact...

SQL SERVER Steps to Generate Windows Cluster Log?

Journey to SQL Authority with Pinal Dave, July 1, 2015
Views: 79 | Hits 6

Every now and then I sit next to DBA to learn some of their tricks. One of this recent learning is what I plan to share here. It is tough to learn everything all by ourselves, so learning is best done...

SQL SERVER Knowing the Source Application Using APP_NAME() Function

Journey to SQL Authority with Pinal Dave, June 30, 2015
Views: 87 | Hits 2

APP_NAME() function in SQL Server returns the application name of the current session in which it is called. When you execute the following code SELECT APP_NAME() AS application_name You get the follo...

SQL SERVER Getting started and creating JSON using SQL Server 2016

Journey to SQL Authority with Pinal Dave, June 29, 2015
Views: 86 | Hits 16

With SQL Server 2016 CTP out, I know many have started to play around with it and exploring some of the new capabilities. One of the new capabilities that has caught my attention is the introduction o...

Interview Question of the Week #026 64 Bit Vs 32 Bit Confusion

Journey to SQL Authority with Pinal Dave, June 28, 2015
Views: 98 | Hits 15

I often see people getting lost between 64 bit and 32 bit operating systems and application conversation. There are plenty of individuals still today, not sure what is the difference between them as w...

SQL Server 2016 New Feature: Dynamic Data Masking

Journey to SQL Authority with Pinal Dave, June 27, 2015
Views: 113 | Hits 10

As most of you know that latest update from Microsoft about SQL Server 2016 was released of CTP2.1 version. There is a long list of new features getting introduced in SQL Server 2016. In this blog, I ...

SQL SERVER Tips working with Files inside SQL Server

Journey to SQL Authority with Pinal Dave, June 26, 2015
Views: 106 | Hits 12

When two SQL enthusiasts meet, often the conversation drifts to questioning each others understanding and implementation. Now, when two DBAs meet it is always a great to see how the conversation goes ...

How to Get NULLs Horribly Wrong in SQL Server

Simple Talk, June 25, 2015
Views: 60 | Hits 8

NULLs in SQL are a mixed blessing.The Three-Valued Logic of SQL has its uses but can cause difficulties to anyone who assumes that NULL has a 'value'. It can make reports go horribly wrong in a number...

SQL SERVER How Do We Find Deadlocks? Notes from the Field #086

Journey to SQL Authority with Pinal Dave, June 25, 2015
Views: 95 | Hits 4

[Note from Pinal]: This is an 86thepisode of Notes from the Fields series.Deadlock is very annoying when they happen in our database. In my early career my biggest frustration was I had no idea why th...

SQL SERVER FIX Export Error Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

Journey to SQL Authority with Pinal Dave, June 24, 2015
Views: 99 | Hits 2

Working with Excel files can always be of great interest. I have not seen a reporting solution in the world that doesnt give an option to export to excel. If you are talking about two separate solutio...

SQL SERVER PowerShell to Count Number of VLFs in SQL Server

Journey to SQL Authority with Pinal Dave, June 23, 2015
Views: 83 | Hits

If you are a seasoned DBA, then the conversations and monitoring VLFs is something you are already doing. To learn about basics of VLF, check my earlier blog at: SQL SERVER Detect Virtual Log Files (...

SQL SERVER Evaluation Period Has Expired How to Activate SQL Server?

Journey to SQL Authority with Pinal Dave, June 22, 2015
Views: 99 | Hits 1

Sometimes we are in a hurry that we forget activities that are pending. A typical example would be like walking into a room and we keep thinking about why we were there in the first place. Isnt that c...

Interview Question of the Week #025 How to Implement Paging in SQL Server?

Journey to SQL Authority with Pinal Dave, June 21, 2015
Views: 116 | Hits 7

Here is a very popular question when SQL Server interview consists of live coding example. Question: How to implement paging in SQL Server? Explain with the help of script. Answer: Here is the script ...

SQL SERVER Using PowerShell and Native Client to run queries in SQL Server

Journey to SQL Authority with Pinal Dave, June 20, 2015
Views: 122 | Hits 9

I have been getting my hands dirty working with PowerShell commands for a fun learning experience and few have made to this blog. The after effect of this is that I have been pinged for few queries on...

Dynamic SQL Connection in ASP.NET 3.5 with User Controls

The Code Project Latest Articles, June 19, 2015
Views: 100 | Hits 3

Transferring backup files from a remote SQL Server and Dynamic SQL Connection with Restore utility....

SQL SERVER Database Snapshots and Replica Causing Write Delays

Journey to SQL Authority with Pinal Dave, June 19, 2015
Views: 104 | Hits 1

For folks who have not worked with SQL Server Database snapshot feature, please refer to the blog I wrote sometime back (SQL SERVER 2008 Introduction to Snapshot Database Restore From Snapshot). I ...

SQL SERVER Converting Standard SSMS File Results to Delimited Notes from the Field #085

Journey to SQL Authority with Pinal Dave, June 18, 2015
Views: 102 | Hits 1

[Note from Pinal]: This is an 85th episode of Notes from the Fieldseries.Hierarchy is one of the most important concepts in SQL Server but there are not clear tutorial for it.I have often observed tha...

SQL SERVER Stress free life with Spotlight for SQL Server DBA

Journey to SQL Authority with Pinal Dave, June 17, 2015
Views: 97 | Hits 3

Being on the cutting edge of technology is something that we need to be prepared as IT professionals. Newer capabilities get into the software almost every single day and it is difficult to keep track...

SQL SERVER SPARSE Property Doesnt Carry Forward Using SELECT INTO

Journey to SQL Authority with Pinal Dave, June 16, 2015
Views: 117 | Hits 1

During one of the recent posts on a SQLBangalore UG FB page, one of the members asked an interestingly simple question. He was asking why is it that when you use SELECT-INTO to create a new table the ...

SQL SERVER Startup Problem FIX Error 5118, Severity 16, State 1

Journey to SQL Authority with Pinal Dave, June 15, 2015
Views: 92 | Hits 1

I have been monitoring some of the error messages that SQL Server has been throwing in the recent versions and they are self-explanatory. If we understand the English, then half the problem is solved....

Interview Question of the Week #024 What is the Best Recovery Model?

Journey to SQL Authority with Pinal Dave, June 14, 2015
Views: 104 | Hits 8

Here is one of the most popular questions I often see people asking on the internet. Question: What is the best recovery model for my database? Answer:Every situation is different and each situationha...

SQL Server: Login failed for User NT AUTHORITY\ANONYMOUS LOGON

Journey to SQL Authority with Pinal Dave, June 13, 2015
Views: 126 | Hits 1

Errors related to logins are one of the most searched in this blog. Many of the blogs that talk about these errors are the ones that get viewed often too. This is one of the interesting error which yo...

SQL SERVER How Many Line of Code Do You Have in Database?

Journey to SQL Authority with Pinal Dave, June 12, 2015
Views: 116 | Hits 2

Last weekend I happened to be in one of the beautiful cities in Sri Lanka for some fun time with SQL Enthusiasts. We had our first ever SQLSaturday Event in Sri Lanka and it was just too much fun to b...

SQL SERVER The Basics of the Execute Process Task Notes from the Field #084

Journey to SQL Authority with Pinal Dave, June 11, 2015
Views: 105 | Hits 1

[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...

Many ways to relate Orchard things, part 1: database relations

More Whidbey stuff, June 10, 2015
Views: 101 | Hits 2

A long time ago, I wrote a documentation topic on how to implement 1-n and n-n relationships in Orchard using database relations. It was much needed at the time, as this was still a difficult topic. B...

SQL SERVER Security Auditing With ApexSQL Audit

Journey to SQL Authority with Pinal Dave, June 10, 2015
Views: 123 | Hits 2

SQL Servers and databases are probably the most critical IT parts of an enterprise. The most important and confidential data are stored there and even a potential issue with that data can be business ...

SQL SERVER Puzzle with Year Function

Journey to SQL Authority with Pinal Dave, June 9, 2015
Views: 127 | Hits 7

A couple of weeks back, I ran a contest with MONTH () function and had close to 300 of you answer the puzzle. It was a great brain teaser and we had an awesome response from you. Most of you got the a...

Creating a Sql Server database project use in Visual Studio 2012 and use TFS for version control

The Code Project Latest Articles, June 8, 2015
Views: 134 | Hits 6

Creating Sql Server database project use in visual studio 2012 and maintain versions use in TFS...

SQL SERVER Know Your Backup Before Deleting Database

Journey to SQL Authority with Pinal Dave, June 8, 2015
Views: 130 | Hits 3

Earlier last week I wrote a blog around, SQL SERVER FIX Msg 3702, Level 16, State 3 Cannot Drop Database DB_Name Because it is Currently inUse. The premise of that blog was driven by some of the de...

Interview Question of the Week #023 Error Handling with TRYCATCH

Journey to SQL Authority with Pinal Dave, June 7, 2015
Views: 124 | Hits 10

Here is one of the most popular question I see people discussing in SQL Interviews. Question – How do you handle errors with the help of TRY…CATCH? Answer – TRY/CATCH helps to write logic separate the...

SQL SERVER FIX: Msg 3102, Level 16, State 1 RESTORE cannot process database Name because it is in use by this session

Journey to SQL Authority with Pinal Dave, June 6, 2015
Views: 153 | Hits

Some of the simple learnings can come from unexpected places and this blog post is a classic example to that statement. Recently I got an email from one of my readers about the below error message: As...

SQL SERVER FIX Msg 3702, Level 16, State 3 Cannot Drop Database DB_Name Because it is Currently in Use

Journey to SQL Authority with Pinal Dave, June 5, 2015
Views: 117 | Hits 1

We learn from mistakes and we improvise with experience. I couldnt think of a better example than the one below for this. I have been watching many sessions by various speakers and found that many tim...

SQL SERVER Basic Statistics Maintenance Notes from the Field #083

Journey to SQL Authority with Pinal Dave, June 4, 2015
Views: 116 | Hits

[Note from Pinal]: This is a 83rdepisode of Notes from the Fieldseries. Maintenance of the database is very critical activity and I have always seen DBA taking it very seriously. There is a only one p...

SQL SERVER Finding Out Identity Column Without Using Column Name

Journey to SQL Authority with Pinal Dave, June 3, 2015
Views: 138 | Hits 11

There is an interesting observation when querying the identity column of a table Let us create the following tables CREATE TABLE test1 ( id INT IDENTITY (1,1) ) GO CREATE TABLE test2 ( id INT ) Note t...

Using R to Explore Data by Analysis - for SQL Professionals

Simple Talk, June 2, 2015
Views: 16 | Hits

What's the best way for a SQL programmer to learn about R? It's probably by trying out various experiments with an interesting set of data, and some helpful suggestions that point out the parallels wi...

SQLXML Bulk Loader Basics

Simple Talk, June 2, 2015
Views: 92 | Hits 2

SQLXML isn't exactly new technology, but like the even more venerable BCP, it remains the quickest and most reliable way of heaving large quantities of data into SQL Server databases. SQLXML is very v...

SQL SERVER Errors and Limitations of Working with SPARSE Columns in SQL Server

Journey to SQL Authority with Pinal Dave, June 2, 2015
Views: 103 | Hits 1

I make a visit to the local user group whenever I get and keeping the community juices up and running for me. I get an opportunity to share some of the learnings and meet tons of new people. In our re...

SQL SERVER Restore Error: Specified cast is not valid (SqlManagerUI)

Journey to SQL Authority with Pinal Dave, June 1, 2015
Views: 103 | Hits

As I always say, Errors are a great source of learning and I am fortunate to have you as my readers. Because one of my blog reader reported an interesting issue which is worth blogging. This is his in...

Interview Question of the Week #022 How to Get Started with Big Data?

Journey to SQL Authority with Pinal Dave, May 31, 2015
Views: 129 | Hits 15

Big data is one of the most popular subject in recent time and everybody wants to get started on this subject. During recent interviews there are plenty of the questions with related to Big Data. Here...

SQL SERVER Error Msg 511 using SQL Server Sparse columns

Journey to SQL Authority with Pinal Dave, May 30, 2015
Views: 113 | Hits

When I wrote the previous post around SQL SERVER CREATE TABLE Failed Because Column C1024' in Table myTable Exceeds the Maximum of 1024Columns, I thought it was a simple concept. Lesser did I know th...

SQL SERVER Using 20 Logical Processors Based on SQL Server Licensing

Journey to SQL Authority with Pinal Dave, May 29, 2015
Views: 130 | Hits 5

It is second to human nature to utilize every bit of juice for what we pay. You buy something and you would like to get the best out of it right? If you start thinking from an organizations point of v...

Preview of SQL Server 2016 Now Available

Microsoft Certified Professional Magazine Online | Todays Top Picks, May 28, 2015
Views: 4 | Hits

Microsoft released a preview of SQL Server 2016 on Wednesday....

How to Get SQL Server Dates and Times Horribly Wrong

Simple Talk, May 28, 2015
Views: 29 | Hits 1

One of the times that you need things to go right is when you are doing analysis and reporting. This is generally based on time and date. A sure-fire way of getting managers upset is to get the figure...