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

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

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: 33 | Hits 1

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: 33 | 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: 47 | Hits 3

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: 51 | 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...

SQL Domain Controller Interview Question of the Week #072

Journey to SQL Authority with Pinal Dave, May 22, 2016
Views: 68 | Hits 2

This blog is an outcome of questions asked by my client and answer provided to them after doing a lot of searches on the internet. I am very confident that sooner or later, these questions will show u...

SQL Server 2016 Introducing AutoGrow and Mixed_Page_Allocations Options TraceFlags

Journey to SQL Authority with Pinal Dave, May 21, 2016
Views: 81 | Hits 5

I have been playing around with SQL Server 2016 for a while now and I have seemed to have learnt a number of interesting options when playing around with the new version. One of the readers after read...

SSMS Renaissance

Simple Talk, May 20, 2016
Views: 24 | Hits 2

For many good reasons, DBAs and database developers use SQL Server Management Studio (SSMS), not SQL Server Data Tools (SSDT). It is a great relief for them, after several SQL Server releases-worth of...

SQL SERVER Disabling 15000 Partitions (15k)

Journey to SQL Authority with Pinal Dave, May 20, 2016
Views: 85 | Hits 6

I am really having fun working with customers who are pushing the learning barrier in my new consulting role. The more customers I meet; merrier I am because I am getting interesting challenges that p...

SQL SERVER Handling XML Documents Notes from the Field #125

Journey to SQL Authority with Pinal Dave, May 19, 2016
Views: 82 | Hits 5

[Note from Pinal]: This is a 125th episode of Notes from the Field series. Handing XML documents is not an easy task. Trust me till today I see lots of experts struggling when they have to deal with X...

How to Build a Search Page with Elasticsearch and .NET

Simple Talk, May 18, 2016
Views: 1 | Hits

Although SQL Server's Full-Text search is good for searching text that is within a database, there are better ways of implementing search if the text is less-well structured, or comes from a wide vari...

Using Westwind.Globalization to edit loose RESX Files

Rick Strahls WebLog, May 18, 2016
Views: 66 | Hits 5

I received a message yesterday that asked a simple question regarding the Westwind.Globalization library. Westwind.Globalization is a library that allows you to use a database to store localization re...

SQL SERVER 2016 Management Studio Highlighting Current Line Option

Journey to SQL Authority with Pinal Dave, May 18, 2016
Views: 107 | Hits 8

With every new release, there is changes that are being made to the tools that support it. It is tough sometimes to keep up with the pace. I am always an old school guy and I try not to change the sty...

Comparison Logical Architecture between Oracle and SQL Server

Journey to SQL Authority with Pinal Dave, May 17, 2016
Views: 86 | Hits 6

Learning is a journey and that is something I love to keep in mind. Even after being so many years in the industry, I dont stop learning from peers and people around me. This is the best way I can get...

SQL SERVER Steps to Migrate Clustered Disk / LUN

Journey to SQL Authority with Pinal Dave, May 16, 2016
Views: 68 | Hits 3

During my last engagement with a client, I was asked to provide steps to move SQL databases from H drive to J drive. H drive contains all user and system databases. This was a clustered instance, so w...

Primary Key and Null in SQL Server Interview Question of the Week #071

Journey to SQL Authority with Pinal Dave, May 15, 2016
Views: 94 | Hits 7

There are moments and time when interviewer sometimes gets highly disappointed. Well, I had such a moment a few days ago. Before you look at the answer - please try to answer this SQL SERVER question ...

SQL SERVER FIX: SQL Profiler Error Cannot Retrieve Trace Definition for SQL Server Version

Journey to SQL Authority with Pinal Dave, May 14, 2016
Views: 94 | Hits 1

As soon as I opened profiler and clicked on connect button, I was welcomed with below the message box. This is one of the funniest error message which I have seen from long time. There is no message!!...

SQL SERVER Understanding FAILOVERCLUSTERROLLOWNERSHIP with SQL Server Cluster Rolling Upgrade

Journey to SQL Authority with Pinal Dave, May 13, 2016
Views: 66 | Hits

I hardly get questions around the cluster and I try to keep away from the queries because some of these can lead to some deep level working with cluster. Some conversations can lead to a great learnin...

SQL SERVER Data Lineage Tracking in ETL Processes Notes from the Field #124

Journey to SQL Authority with Pinal Dave, May 12, 2016
Views: 91 | Hits 3

[Notes from Pinal]: Everybody knows about ETL Processes. It is a simple process where data is extracted, transformed and loaded into an application or database. However, still today, not many people k...

SQL SERVER Unable to Start SQL Server TDSSNIClient Initialization Failed with error 0xd

Journey to SQL Authority with Pinal Dave, May 11, 2016
Views: 82 | Hits 1

As a part of my passion, I do visit the forums and try to help. I contacted him personally via email and found an interesting situation. So, sharing it via the blog. I saw below post in a public forum...

Looking at VIEWs, Close Up

Simple Talk, May 10, 2016
Views: 73 | Hits 6

Views in SQL can be difficult. It isn't easy to judge when to use them, It isn't always obvious how to determine if a view can be indexed or if it is updateable. Joe Celko takes a tricky topic and com...

SQL SERVER Error Msg 5042, Level 16 The File tempdev02 Cannot be Removed Because it is Not Empty

Journey to SQL Authority with Pinal Dave, May 10, 2016
Views: 80 | Hits 1

As a SQL Server DBA you would know that sometimes it is possible to make mistakes with the database. Few of the time it can be corrected. Out of them, some are easy and some are difficult. I was runni...

PowerShell Backup SQL Server System Databases

Journey to SQL Authority with Pinal Dave, May 9, 2016
Views: 119 | Hits 6

I have been lately writing on powershell and didnt know there are many more scenarios that can be enabled. I was traveling for a consulting assignment over the weekend for a customer location. Though ...

List All the Stored Procedure Modified in Last Few Days Interview Question of the Week #070

Journey to SQL Authority with Pinal Dave, May 8, 2016
Views: 105 | Hits 9

There are few questions which never gets old. Today we are going to one such question. Every single time I go for expert panel in the interview and I end up seeing candidate failing to answer this que...

SQL SERVER Change Color for System Object Name in Text Editor (SSMS 2016)

Journey to SQL Authority with Pinal Dave, May 7, 2016
Views: 99 | Hits 2

You might have seen my earlier posts about SQL Server 2016 management studio. There are a lot of changes which have happened in SSMS area. One of such change which I heard is that SSMS now uses Visual...

Taking Azure SQL Data Warehouse for a Test-Drive

Simple Talk, May 6, 2016
Views: 5 | Hits

Azure SQL Data Warehouse uses SQL to query the data, but there are some differences to SQL Server's dialect of TSQL, and queries don't necessarily work in the same way. DBAs are also required to use ...

SQL SERVER Optimizing Tabular Models for Self-Service Reporting: Summarize By Notes from the Field #123

Journey to SQL Authority with Pinal Dave, May 6, 2016
Views: 75 | Hits 2

[Note from Pinal]: This is a new episode of Notes from the Field series. I personally have no problem accepting that I do not know many topics. One of the such topic is Tabular Models. I always wanted...

9 Clickbait Simple-Talk Titles You Wont Believe Exist!

Simple Talk, May 5, 2016
Views: 38 | Hits 4

At Simple-Talk, we specialize in practical, down-to-earth technical articles, and usually choose our titles to match. There’s no mistaking what “Comparing Networking options in Azure“ might be about, ...

Connecting to SQL Data Warehouse

Simple Talk, May 5, 2016
Views: 70 | Hits 5

The most frustration with any new system is often in just working out how to connect to it. Oddly, you cant use SSMS with SQL Data Warehouse, but it is fine with SSDT, SSIS, Power BI desktop, sqlcmd, ...

SQL SERVER Skip Save Changes to the Following Items? Prompt in Management Studio (SSMS 2016)

Journey to SQL Authority with Pinal Dave, May 5, 2016
Views: 67 | Hits 5

As a DBA/Developer, you must have seen below screen lot of times and most of the time you must have hit No. I know it is one of those moments when you want to leave from work and those annoying popup ...

SQL SERVER 2016 Scroll Bar Enhancement in Management Studio (SSMS 2016)

Journey to SQL Authority with Pinal Dave, May 4, 2016
Views: 97 | Hits 3

While I am getting ready to play with SQL Server 2016, I am finding fresh look and feel for SQL Server Management Studio. I heard that its uses latest version of visual studio shell. There are many en...

Automatically Creating UML Database Diagrams for SQL Server

Simple Talk, May 3, 2016
Views: 56 | Hits 5

SQL Server database developers seem reluctant to use diagrams when documenting their databases. It is probably because it has, in the past, been difficult to automatically draw precisely what you want...

SQL SERVER Q&A: SQL Clustering Virtual Server Name and Instance Name

Journey to SQL Authority with Pinal Dave, May 3, 2016
Views: 99 | Hits 5

Of late some of the troubleshooting scenario I am getting involved is amazing. Though some of them are complex, it gives me a unique opportunity to learn and try something new to share later with you ...

SQL SERVER FIX: Setup Was Not Able to Access Domain

Journey to SQL Authority with Pinal Dave, May 2, 2016
Views: 84 | Hits 1

One of my clients approached me to provide assistance in performance tuning which is my bread and butter these days. Often once you get into an engagement, they try to maximize the time they get with...

How to Insert Multiple Rows in a Single SQL Query Interview Question of the Week #069

Journey to SQL Authority with Pinal Dave, May 1, 2016
Views: 132 | Hits 13

There are so many different databases in the world and many of them use the language SQL for their programming. It is very easy to assume that if they are using SQL, we can easily use code from one da...

SELECT One by Two Interview Question Extended Part II

Journey to SQL Authority with Pinal Dave, April 30, 2016
Views: 72 | Hits 4

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: 113 | Hits 8

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: 96 | Hits 1

[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: 98 | 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: 103 | Hits 3

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: 80 | 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: 90 | Hits 9

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: 105 | Hits 9

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: 93 | 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: 89 | Hits 2

[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: 137 | Hits 9

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: 122 | 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 Security Audit Basics

Simple Talk, April 18, 2016
Views: 21 | Hits

SQL Server Server Audit has grown in functionality over the years but it can be tricky to maintain and use because it lacks centralization and analysis tools. It can do a fast and lightweight audit of...

SQL SERVER Unable to Open Maintenance Plan in Management Studio

Journey to SQL Authority with Pinal Dave, April 18, 2016
Views: 138 | 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: 151 | 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: 157 | Hits 2

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