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

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

SQL SERVER Identify Disk Latency on SQL Server Box Using PowerShell

Journey to SQL Authority with Pinal Dave, May 26, 2015
Views: 63 | Hits

Couple of week back, I was playing around with using Powershell for some simple activities. The fall out of that was the ability to search the SQL Server Error Logs. Though we can search for anything,...

SQL SERVER CREATE TABLE Failed Because Column C1024' in Table myTable Exceeds the Maximum of 1024 Columns

Journey to SQL Authority with Pinal Dave, May 25, 2015
Views: 134 | Hits 3

Sometimes the best way to learn is by taking some of the capabilities to the extreme. This blog post is one of those explorations which I would like to share. A very long time ago I wrote a blog on th...

Interview Question of the Week #021 Difference Between Index Seek and Index Scan (Table Scan)

Journey to SQL Authority with Pinal Dave, May 24, 2015
Views: 192 | Hits 4

Question: What is the difference between Index Seek and Index Scan? Answer:Index Scan retrieves all the rows from the table. Index Seek retrieves selective rows from the table. Index Scan: Since a sca...

SQL Server Knowing Deprecated or Discontinued Features Using Extended Events

Journey to SQL Authority with Pinal Dave, May 23, 2015
Views: 212 | Hits 3

This blog is in continuation to what I wrote couple of weeks back – SQL Server Knowing the Use of Deprecated or DiscontinuedFeatures. The concept of using a deprecated feature is not by intensions by...

SQL SERVER Only Formatted Files on Which the Cluster Resource of the Server has a Dependency can be Used

Journey to SQL Authority with Pinal Dave, May 22, 2015
Views: 233 | Hits

Getting little help and learning from each other always helps. When I dont get to know of something and I need to explore something, I try to check with my SQL friends who can guide me in the right di...

SQL SERVER Adding Reference Data to Master Data Services Notes from the Field #081

Journey to SQL Authority with Pinal Dave, May 21, 2015
Views: 164 | Hits

[Note from Pinal]: This is a 81th 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 ...

SQLiter - Change, Set & Remove Passwords on SQLite Databases

The Code Project Latest Articles, May 20, 2015
Views: 98 | Hits

A small project for encrypting/decrypting SQLite databases....

SQL SERVER Puzzle with MONTH Function Win USD 50 Amazon Gift Card

Journey to SQL Authority with Pinal Dave, May 20, 2015
Views: 106 | Hits 2

It has been a while since we ran the contest. I reached out to kind team of Embarcadero and they agreed to support the next contest. The contest has two steps and they are very simple. It took me a wh...

SQL SERVER Antivirus Exclusions Best Practices With SQL Server

Journey to SQL Authority with Pinal Dave, May 19, 2015
Views: 108 | Hits 6

One of the classics as far as best practices is concerned is to exclude SQL Server files and folders on your antivirus programs running on the server. We all know this statements and often I see DBAs ...

SQL Authority News SQL Server 2014 Service Pack 1 Available for Download

Journey to SQL Authority with Pinal Dave, May 18, 2015
Views: 97 | Hits 3

Last month, Microsoft announced SQL Server 2014 Service Pack 1 and it had issues withSSIS catalog. Microsoft has once again released SQL Server 2014 Service Pack 1 earlier today and it is now availabl...

Interview Question of the Week #020 What is the Difference Between DISTINCT and GROUP BY?

Journey to SQL Authority with Pinal Dave, May 17, 2015
Views: 129 | Hits 13

Question:What is the Difference Between DISTINCT and GROUP BY? Answer:A DISTINCT and GROUP BY usually generate the same query plan, so performance should be the same across both query constructs. GROU...

SQL SERVER Service Pack Error The User Data directory in the registry is not valid. Verify DefaultData key under the instance hive points to a valid directory

Journey to SQL Authority with Pinal Dave, May 16, 2015
Views: 103 | Hits

As a good SQL Server DBA, I always keep updating my SQL Server on my all VMs with the latest service pack available. During my last installation of service pack 2 on SQL Server 2012, I got below error...

SQL SERVER WARNING SQL Server Has Encountered N Occurrence(s) of I/O Requests Taking Longer Than 15 Seconds

Journey to SQL Authority with Pinal Dave, May 15, 2015
Views: 122 | Hits 2

This is one of the most commonly asked questions via blog comments and emails sent across to me. Here is the sample error message which has been reported in SQL Server ERRORLOG. SQL Server has encount...

Natural Language Interface to Database using SIML

The Code Project Latest Articles, May 14, 2015
Views: 108 | Hits 2

Using SIML, a language designed for Digital Assistants, to create a Natural Language Interface to an SQL Database....

Querying DecentCMS, part2: querying the index

More Whidbey stuff, May 14, 2015
Views: 95 | Hits

In the previous post, we looked at the basic concepts DecentCMS querying are built upon, and at how an index is built. In this post, well examine how to query such an index in order to produce a resul...

SQL SERVER SSIS and How to Load Binary Large Objects, or Blobs Notes from the Field #080

Journey to SQL Authority with Pinal Dave, May 14, 2015
Views: 103 | 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...

Querying DecentCMS, part 1: building an index

More Whidbey stuff, May 13, 2015
Views: 102 | Hits 3

DecentCMS’s search module provides the infrastructure to build and query search indexes, as well as a file-based implementation that is suitable for small sites. Querying in DecentCMS is based o...

SQL SERVER PowerShell Script When Was SQL Server Last Restarted?

Journey to SQL Authority with Pinal Dave, May 13, 2015
Views: 105 | Hits 2

I have always wanted to learn a bit of scripting and I was always searching for a good reason to learn something new. As I said, this is my learning and I am open to learning some scripting tricks fro...

XML Document Sourced SSRS Report Using HTTP URL

The Code Project Latest Articles, May 12, 2015
Views: 88 | Hits 1

IntroductionIn my Business Intelligence development experience, most of my SQL Server Reporting Services (SSRS) Reports have largely been based off a relational data sources such Microsoft SQL Server ...

SQL SERVER Identify Page Splits Using Extended Events in SQL Server

Journey to SQL Authority with Pinal Dave, May 12, 2015
Views: 111 | Hits 2

Digging some of my older posts reveal I have written a blog already on Page Splits with SQL Server. This was no surprise because I am in constant need to reinvent as I write the blog posts. Now you mi...

ADO.Net Connectivity using Stored Procedure and Output parameters

The Code Project Latest Articles, May 11, 2015
Views: 89 | Hits 5

This articles explains the insertion of data into SQL Database using Stored Procedures with Output Parameters. Some Bootstrapping is also used to create a good looking HTML....

SQL SERVER Introduction to Database Engine Tuning Advisor (a.k.a. DTA)

Journey to SQL Authority with Pinal Dave, May 11, 2015
Views: 105 | Hits 4

While talking to one of the attendees after my session at GIDS, I realized that I dont have much information available on my blog about the usage of one of the fantastic performance tuning tool called...

Interview Question of the Week #019 How to Reset Identity of Table

Journey to SQL Authority with Pinal Dave, May 10, 2015
Views: 112 | Hits 4

Here is the question which I received in email: Question: I have a table which has an identity column. I have recently deleted old and archive it to another place. Now I want to reset the identity of ...

SQL SERVER Script: Current IO Related Waits on SQL Server

Journey to SQL Authority with Pinal Dave, May 9, 2015
Views: 109 | Hits 2

Playing around with DMVs is so much fun. Many a times we need little inspiration and a problem in hand to solve. Out of many things I monitor, I have personally seen folks having trouble in finding wh...

Optimizing Batch Process in SQL Server

Simple Talk, May 8, 2015
Views: 34 | Hits

SQL Server batch processes are usually run from SQL Agent in background. They can take significant time and resources, especially if they are ETL tasks. Quite often, the responsibility for creating th...

Load Testing Mysql with mysqlslap

The Code Project Latest Articles, May 8, 2015
Views: 102 | Hits 2

I have a few thoughts for some testing/comparison of mysql tables that I have been curious about. Before starting though, I thought it was prudent that I should give it some thought about the approach...

SQL SERVER Backup Failure Error: 3203, Severity: 16, State: 1

Journey to SQL Authority with Pinal Dave, May 8, 2015
Views: 102 | Hits

In the recent past, I have been writing about different error messages on SQL Server that one encounters. Thanks to my blog readers who have been sharing a lot of errors with me either by email or by ...

SQL SERVER Using Package Configurations in SSIS 2012 and Beyond Notes from the Field #079

Journey to SQL Authority with Pinal Dave, May 7, 2015
Views: 120 | Hits

[Notes from Pinal]: I know quite a lot of things about SSIS but every single time when I read notes from the field, I realize that there are so many small but very important features exist. A similar ...

Documenting your SQL Server Database

Simple Talk, May 6, 2015
Views: 110 | Hits 6

One of the shocks that a developer can get when starting to program in T-SQL is that there is no simple way of generating documentation for routines, structures and interfaces, in the way that Javado...

Visual Basic SQL to XML

The Code Project Latest Articles, May 6, 2015
Views: 104 | Hits 5

Visual Basic SQL to XML...

Mysql Uptime Check Script

The Code Project Latest Articles, May 6, 2015
Views: 98 | Hits 1

Mysql Uptime Check Script...

Renaming a Database in Mysql

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

Renaming a database in Mysql...

SQL Server Knowing the Use of Deprecated or Discontinued Features

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

Upgrading your SQL Server environment is inevitable and I know most many are doing this given SQL Server 2015 support will end first half next year. Whenever I get in front of customers, I have questi...

SQL SERVER Generating Row Number Without Ordering Any Columns

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

Row_number function is used to generate a serial number for a given record set. But you need to always use ORDER BY clause so that the numbers are assigned to the specific order. Let us create the fol...

SQL SERVER Who ALTERed My Database? Catch Them Via DDL Trigger

Journey to SQL Authority with Pinal Dave, May 4, 2015
Views: 118 | Hits 7

Here is an interesting comment from one of my previous blogs on how to change the compatibility level of SQL server post posted earlier. Some of these comments are interesting and can provide some int...

Interview Question of the Week #018 Script to Remove Special Characters Script to Parse Alpha Numerics

Journey to SQL Authority with Pinal Dave, May 3, 2015
Views: 138 | Hits 7

If you ask me – there are certain questions not appropriate for an interviewas they are often very subjective. There are some questions, which really do not help to identify if the candidate has the n...

Design and Build an Organized SSRS Project

The Code Project Latest Articles, May 2, 2015
Views: 135 | Hits 6

Before starting I want to wish you all a happy labor day :) Overview Building a report on SQL Server Reporting Services (SSRS) is very easy and fast, and it has the most important features to create a...

SQLAuthority News Presented 3 Technical Session at Great Indian Developer Summit 2015

Journey to SQL Authority with Pinal Dave, May 2, 2015
Views: 115 | Hits

Great Indian Developer Summit is my favorite technology event and I have been extremely happy to present technology sessions here for over 5years. Just like every year, this year, I presentedthree tec...

SQL AZURE How to Disable and Enable All Constraint for Table and Database

Journey to SQL Authority with Pinal Dave, May 1, 2015
Views: 112 | Hits 1

Recently I wrote blog to enable and disable all constraints in the databaseSQL SERVER How to Disable and Enable All Constraint for Table and Database. One of my reader told me that this trick of sp_m...

SQL SERVER Recovering from Snapshots Notes from the Field #078

Journey to SQL Authority with Pinal Dave, April 30, 2015
Views: 114 | Hits 1

[Note from Pinal]: This is a 78thepisode of Notes from the Fields series.What do you do when data is deleted accidentally or you are facing disaster? Well, there are plenty of the things, you can do, ...

Visual Studio Code first impressions

More Whidbey stuff, April 29, 2015
Views: 151 | Hits 18

This morning, Microsoft made a surprise announcement (or two): a new cross-platform code editor named Visual Studio Code. It runs on Mac, Linux, and of course Windows. It’s lean, fast, it has In...

SQL SERVER Finding Tables with Primary or Foreign Keys

Journey to SQL Authority with Pinal Dave, April 29, 2015
Views: 110 | Hits 4

If you want to know if a table has a primary key or foreign key, you can find out this in many ways. Let us create these tables CREATE TABLE product_master ( prod_id INT PRIMARY KEY, prod_name VARCHAR...

How to: Consume ASP.NET Webmethod in AngularJS

Sushila Patels Weblog, April 29, 2015
Views: 187 | Hits 9

There are many queries related to how ASP.NET webmethod can be consumed in AngularJS. The post demonstrate how to do it. The solution is attached with has samples that show how this can be done In Sam...

SQL SERVER Script: Knowing Data and Log Files Are On the Same Drive

Journey to SQL Authority with Pinal Dave, April 29, 2015
Views: 96 | Hits 3

Last week it was wonderful to spend time at the GIDS conference to meet all the enthusiastic developers. Had fun preparing for the session and the number of people who walked to me and say they read t...

Making Data Analytics Simpler: SQL Server and R

Simple Talk, April 28, 2015
Views: 79 | Hits 3

R an SQL Server are a match made in heaven. You don't need anything special to get started beyond the basic instructions. Once you have jumped the hurdle of reliably and quickly transferring data be...

Management studio for Mongodb, -Mongodb Part 3

The Code Project Latest Articles, April 28, 2015
Views: 112 | Hits 13

I like command prompts, and CLI’s at times, perhaps you too like them. But most of the time I love to visualize stuff. For example, how does mongodb databases, collections and documents look vis...

SQL SERVER Collect and Analyze SQL Server Data Efficiently

Journey to SQL Authority with Pinal Dave, April 28, 2015
Views: 108 | Hits 4

dbForge Event Profiler is one of the most useful SQL Server build-in tools. The Profiler records data associated with various SQL Server events for further analysis. This data is stored in a trace fil...

SQL SERVER Using High Performance Power Plan for SQL Server

Journey to SQL Authority with Pinal Dave, April 27, 2015
Views: 117 | Hits 5

A lot of times, I have seen DBAs and administrators have their own startup tasks that they perform when rebuilding or bringing a new server online. Some of these practices are powerful and are mean to...

CRUD ASP.MVC 4 with Angular.js

The Code Project Latest Articles, April 26, 2015
Views: 129 | Hits 7

CRUD in ASP.MVC 4 with scripting lang as Angular and Database as MS SQL 2008R2...

Interview Question of the Week #017 Performance Comparison of Union vs Union All

Journey to SQL Authority with Pinal Dave, April 26, 2015
Views: 155 | Hits 16

Here is what I just learned from email. One of the very prestigious organization asks one of theircandidatefollowing questions – Question: If you have optionsto use Union or Union All – which one of t...