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

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

SQL SERVER Unable to Bring SQL Online DoSQLDataRootApplyACL : Failed to Create Directory Tree at SQLDataRoot

Journey to SQL Authority with Pinal Dave, November 1, 2016
Views: 207 | Hits 2

Here is one of email which I received from one of my clients where he mentioned that he was unable to bring SQL Online.Pinal,I need assistance in getting the failed SQL Server resource online on the n...

SQL SERVER Unable to Recycle ERRORLOG Using sp_cycle_errorlog

Journey to SQL Authority with Pinal Dave, October 31, 2016
Views: 138 | Hits 1

There are many DBAs who create jobs in SQL Server to recycle ERRORLOG files every midnight. They also increase the files from 6 to a bigger number so that they have data for more than 6 days.First app...

SQL SERVER FIX Error: Maintenance plan scheduled but job is not running as per schedule

Journey to SQL Authority with Pinal Dave, October 29, 2016
Views: 221 | Hits 2

This was one of the interesting issues I solved in many days. One of my clients contacted me and told that they have scheduled a maintenance plan to take t-log backup at 10 PM but its not running. Whe...

SQL SERVER Configuring Startup Options for SQL Server Management Studio

Journey to SQL Authority with Pinal Dave, October 28, 2016
Views: 249 | Hits 5

Yesterday I started my day early to get to a gym. I know this was the first day and I had loads of work pending to be completed at work too. This got me busy and I started to drive my car, oblivious o...

Triggers: Threat or Menace?

Simple Talk, October 27, 2016
Views: 166 | Hits 3

Triggers are generally over-used in SQL Server. They are only rarely necessary, can cause performance issues, and are tricky to maintain If you use them, it is best to keep them simple, and have onl...

Triggers: Threat or Menace?

Simple Talk, October 27, 2016
Views: 171 | Hits 6

Triggers are generally over-used in SQL Server. They are only rarely necessary, can cause performance issues, and are tricky to maintain If you use them, it is best to keep them simple, and have onl...

SQL SERVER Fix: Error: Msg 1904 The statistics on table has 65 columns in the key list

Journey to SQL Authority with Pinal Dave, October 27, 2016
Views: 221 | Hits 3

With SQL Server 2016, I have come to know some of the restrictions which were applicable earlier are no longer the limits to look for. In one such experimentation is what I stumbled upon the blog post...

Importing Excel Data into Power BI Desktop

Simple Talk, October 26, 2016
Views: 167 | Hits 6

In any commercial setting, Excel Spreadsheets remain the preferred way of collecting and analysing data, and it makes sense that it should be easy to get the data into PowerBI so it can be made mor...

SQL SERVER FIX Error 5120 Database is in Read Only Mode After Attaching Files

Journey to SQL Authority with Pinal Dave, October 26, 2016
Views: 197 | Hits 5

Sometimes you need to know more about permissions on file, service account etc. to fix certain errors. In my recent visit to a customer location, one of the database developers came to me with a probl...

SQL SERVER Displaying SQL Agent Jobs Running at a Specific Time

Journey to SQL Authority with Pinal Dave, October 25, 2016
Views: 184 | Hits 6

Recently I was troubleshooting at a customer location something that looked trivial. When the customer approached me for a consulting requirement wherein they were saying their system was going unresp...

PowerShell Script to Listing all Backups Taken with SQL Server

Journey to SQL Authority with Pinal Dave, October 24, 2016
Views: 138 | Hits 3

I always like to keep a number of scripts handy in my USB drive with my Laptop. These scripts are used for my internal use when I am suddenly looking for something interesting in customer environments...

Fastest Way to Display Code of Any Stored Procedure Interview Question of the Week #094

Journey to SQL Authority with Pinal Dave, October 23, 2016
Views: 209 | Hits 8

A very common question I often see users not sure about the answer. This is indeed a tricky question, but a very simple one. If I am the interviewer, I may ask this question to the user, but if they d...

PowerShell Tip: How to Format PowerShell Script Output?

Journey to SQL Authority with Pinal Dave, October 22, 2016
Views: 143 | Hits 4

I have been writing on various ways of working with PowerShell and how to connect to SQL Server. Personally, when I see text on command prompt it is quite a mess and very difficult to decipher the sam...

Reading, Writing, and Creating SQL Server Extended Properties

Simple Talk, October 21, 2016
Views: 142 | Hits 5

There is a great gulf between wanting to document your database properly with extended properties and actually doing it. Extended Properties have many uses but they aren't easy to use. Phil Factor is ...

How to Fix Ten SSDT Deployment Snags, With or Without ReadyRoll

Simple Talk, October 21, 2016
Views: 199 | Hits 2

Even a database development framework like Sql Server Data Tools (SSDT) doesn't get it right all the time, and there are ten deployment 'gotchas' in particular that can cause some head-scratching amon...

PowerShell Scripts get-process with SQL Server process

Journey to SQL Authority with Pinal Dave, October 21, 2016
Views: 180 | Hits 3

Working with powershell scripts can be interesting. I have in the past shown a number of such scripts that we can use with SQL Server. In this blog, I was playing around understanding how I can use th...

SQL SERVER How to Avoid Triggers for Multiple Row Operations in a Table

Journey to SQL Authority with Pinal Dave, October 20, 2016
Views: 180 | Hits 4

Customers have a unique way to give you challenges that you never faced. It was one of those evenings that I was working late night on some SQL activity when I received a mail from one of my very old ...

SQL SERVER Management Studio Why I am Seeing White Icon Instead of Green or Red?

Journey to SQL Authority with Pinal Dave, October 19, 2016
Views: 241 | Hits 6

One of my clients faced a strange situation. She was using SQL Server Management Studio and was not seeing SQL server and SQL Agent status. It was showing white circle. When she would right click the ...

Retrieving SQL Server Query Execution Plans

Simple Talk, October 18, 2016
Views: 170 | Hits 13

Execution plans explain all you need to know about query performance, and how to fine-tune. Sure, you can see them in SSMS, but what if you need to drill into to the important details? What about u...

Creating and Running an SQL Server Unit Test Best Ways to Test SQL Queries

Journey to SQL Authority with Pinal Dave, October 18, 2016
Views: 232 | Hits 7

I hope it is no secret that testing of written code is as important as writing the code itself, and sometimes even more important. Writing unit test for C#/Java/code coverage is the responsibility of ...

SQL SERVER Database going to Recovery Pending Automatically and Coming Back

Journey to SQL Authority with Pinal Dave, October 17, 2016
Views: 221 | Hits 4

I love connecting community via various channels. One of my clients explained an interesting issue to me. He explained that he has a production database which is going to Recovery Pending state by its...

When was Domain Account Password Changed in SQL Server? Interview Question of the Week #093

Journey to SQL Authority with Pinal Dave, October 16, 2016
Views: 178 | Hits 4

If you are a DBA for quite some time, then at least once you must have encountered below error about Domain Account Password.Error 1069: The service did not start due to a logon failure. I have alread...

SQL SERVER Error: 26014, Severity: 16. Unable to Load User Specified Certificate

Journey to SQL Authority with Pinal Dave, October 15, 2016
Views: 173 | Hits 3

Recently I was consulting a customer and they had plans to change certificate used by SQL Server. After making changes to certificate, we found that we were not able to start the SQL Server Service. L...

SQL Server Understanding Connection Timeouts and Query Timeouts

Journey to SQL Authority with Pinal Dave, October 14, 2016
Views: 193 | Hits 9

Have you ever got into a situation wherein you feel you see something and work for a solution in a completely opposite direction? Recently I was out of the country for a session and at the breakfast t...

SQL SERVER Error Attempted to Perform an Unauthorized Operation

Journey to SQL Authority with Pinal Dave, October 13, 2016
Views: 195 | Hits 4

As you might know I try hard to help the community via various channels. Comment on my blog is one of that channels. Here is a blog post which talks about error about Unauthorized Operation.First appe...

SQL SERVER Msg 3047, Level 16, State 1: The BackupDirectory Registry Key is Not Configured Correctly

Journey to SQL Authority with Pinal Dave, October 12, 2016
Views: 207 | Hits 2

While writing my earlier blog, I broke a few settings and started getting new errors. Earlier, when I used to run below command, it used to work fine. However, just a day ago, it has given me error re...

SQL SERVER Performance Benefit of Using SPARSE Columns?

Journey to SQL Authority with Pinal Dave, October 11, 2016
Views: 222 | Hits 9

I have written a number of blogs around working with SPARSE Columns in the past and a primer to what SPARSE Columns can be got from the list mentioned:First appeared on SQL SERVER – Performance Benefi...

SQL SERVER Error: Property BackupDirectory is Not Available for Settings

Journey to SQL Authority with Pinal Dave, October 10, 2016
Views: 160 | Hits 2

I break a lot of things on my SQL environment and I believe that is a very good way to learn things. Today, I wanted to perform a restore of a database using a backup which I took earlier. In this blo...

What is a Backup Timeline for Restore Process? Interview Question of the Week #092

Journey to SQL Authority with Pinal Dave, October 9, 2016
Views: 238 | Hits 6

Question: What is a Backup Timeline for Restore Process?Answer: One of the most popular interview question about Backup and Restore Database process.First appeared on What is a Backup Timeline for Res...

SQL SERVER Unable to Start Services After Patching (sqlagent_msdb_upgrade.sql)

Journey to SQL Authority with Pinal Dave, October 8, 2016
Views: 194 | Hits 3

In the recent past, I have heard this issue, at least once or twice every month. Whenever I try to help a such client and I think I know the issue, I get something new. They said that they have applie...

SQL SERVER Fix: The Cluster Resource Could not be Deleted Since it is a Core Resource

Journey to SQL Authority with Pinal Dave, October 7, 2016
Views: 223 | Hits 2

Working with SQL Server is fun. Since SQL Clustering, and AlwaysOn availability group needs Windows Clustering so sometimes there are some cluster issues which I have to deal with and fix. Let us lear...

Stored Procedure for Single & List Object in ASP.NET MVC with angularJS

The Code Project Latest Articles, October 6, 2016
Views: 213 | Hits 9

CRUD operation in .net MVC using Stored Procedure for Single and List Object Data along with SQL Transaction....

SQL SERVER 2016 Creating Clustered ColumnStore with InMemory OLTP Tables

Journey to SQL Authority with Pinal Dave, October 6, 2016
Views: 192 | Hits

I have been writing a lot of my findings with SQL Server 2016 in the recent past. This is also being something I have been investing big time keeping my session at SQLPASS coming in the October timefr...

Who the Devil Wrote This SQL Code?

Simple Talk, October 5, 2016
Views: 173 | Hits 9

The way that you format T-SQL code can affect the productivity of the people who have to subsequently maintain your work. It is never a good experience to see SQL Code, cry out Who the devil wrote t...

SQL Authority News SQL Sentry Becomes SentryOne

Journey to SQL Authority with Pinal Dave, October 5, 2016
Views: 180 | Hits 2

Just earlier today, I have learned fantastic news about new branding for my favorite SQL Server vendor SQLSentry, which is not SentryOne. The new name and new branding truly reflects the organization ...

SQL SERVER Fix Error Msg 35336 Working with ColumnStore Indexes

Journey to SQL Authority with Pinal Dave, October 5, 2016
Views: 139 | Hits 1

Since my consulting have started around performance tuning, I am able to see a number of customers who want to start using the new capabilities of SQL Server for their existing application as they pla...

Which Edition of SQL Server is Best for Development Work?

Simple Talk, October 4, 2016
Views: 184 | Hits 10

You might think, as a developer, that nothing but the best is good enough as a development database. You might be mistaken. There is a lot to be said for LocalDB, but Ed Elliott argues that every edi...

SQL SERVER Performance Choice Coding or Automation

Journey to SQL Authority with Pinal Dave, October 4, 2016
Views: 218 | Hits 10

We talk a lot about optimizing SQL with building the most efficient queries and application architectures. Its what we enjoy doing and what were paid to do. We love to twiddle bits and tweak code, and...

SQL SERVER Rule Windows Server 2003 FILESTREAM Hotfix Check failed on Windows 2012 R2 Cluster

Journey to SQL Authority with Pinal Dave, October 3, 2016
Views: 210 | Hits

For my upcoming training, I was trying to deploy SQL Server 2008 R2 Cluster in my clients lab machines. I encountered a strange error and I was clueless. Let us learn about Rule Windows Server 2003 FI...

How to Introduce Time Delay Between Two T-SQL Commands? Interview Question of the Week #091

Journey to SQL Authority with Pinal Dave, October 2, 2016
Views: 200 | Hits 6

Question: How to Introduce Time Delay Between Two TSQL Commands?First appeared on How to Introduce Time Delay Between Two T-SQL Commands? – Interview Question of the Week #091...

PowerShell Create a User with Read Rights on a Database

Journey to SQL Authority with Pinal Dave, October 1, 2016
Views: 169 | Hits

I have written a number of PowerShell script in the blog and they have been used by many. Most of these scripts are there because someone wanted something different and I got about creating something ...

SQL SERVER Simple Example of BCP Command Line Utility

Journey to SQL Authority with Pinal Dave, September 30, 2016
Views: 217 | Hits 6

I was recently asked if I know the fastest way to export data from SQL Server table. This was very interesting question personally, as I have not run any such tests in the past. However, everytime whe...

SQL SERVER SSMS Trick Switching Columns in Grid Output

Journey to SQL Authority with Pinal Dave, September 29, 2016
Views: 215 | Hits 7

Yesterday when I wrote about what I learnt from Vinods session at the SQL Server User Group meeting, one of my friends wrote back asking what else was discussed. Though I knew some of the tips and tri...

LLBLGen Pro v5.1 EAP 2 released!

Frans Boumas blog, September 28, 2016
Views: 200 | Hits 4

Today we released the second Early Access Program (EAP) build of LLBLGen Pro v5.1! Please see the previous post on the first EAP build and whats included in that version. This version builds further o...

SQL SERVER Hidden SSMS Gem: Find Dialogs Unknown Functionality

Journey to SQL Authority with Pinal Dave, September 28, 2016
Views: 208 | Hits 4

I have an eye for details and I try to keep looking for something new to some of the tasks I have been doing for years together. This exploration and quest to learn new techniques is what has made me ...

SQL SERVER How to Find Out When Your SQL Login Will Expire?

Journey to SQL Authority with Pinal Dave, September 27, 2016
Views: 191 | Hits 4

If you are a SQLDBA, you must have created a login and you must have known about enforcing password policy to SQL Logins. Once of my client asked to provide script to find expiry details about SQL Log...

SQL SERVER Patch Installation Error: The version of SQL Server instance does not match the version

Journey to SQL Authority with Pinal Dave, September 26, 2016
Views: 207 | Hits

Applying a patch is something which is part of everyones life in the software industry. One of my clients reported below error related to Patch Installation Error. First appeared on SQL SERVER – Patch...

Identify Used Space in Log File- Interview Question of the Week #090

Journey to SQL Authority with Pinal Dave, September 25, 2016
Views: 219 | Hits 5

Question: How to identify Used Space in Log File?Answer: Use following command to display used log file size and total used space in the log file.First appeared on Identify Used Space in Log File- Int...

PowerShell Reading Tables Data Using Script

Journey to SQL Authority with Pinal Dave, September 24, 2016
Views: 236 | Hits 4

Earlier in this blog, I have written a number of posts by using PowerShell. The more you play around with this scripting language more are the hidden gems that come out. Personally for me, everyday is...

SQL Simple Utilities

The Code Project Latest Articles, September 23, 2016
Views: 315 | Hits 12

This project provides utilities for SQL server, such as executing a list of SQL scripts, exporting data to an SQL script, and displaying relationships between records....