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

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

SQL SERVER 8 Performance Related Articles on Logical Reads

Journey to SQL Authority with Pinal Dave, January 31, 2015
Views: 19 | Hits

Earlier this year, I have written few articles which are related to SQL Server Performance and they are published on site of Logical Reads. Here are my personal favorite 8 various articles on the subj...

SQL SERVER FIX Error: Msg 3201, Level 16, State 1, Line 1 Cannot open backup device. Operating system error 3(The system cannot find the path specified.)

Journey to SQL Authority with Pinal Dave, January 30, 2015
Views: 53 | Hits

This blog is in continuation to using the default values. Earlier this week I wrote a blog which talked about the failure of Create Database Command. While working on the reproduction of the issue, I ...

Developer 3 Tips Every SQL Expert Needs to Know to Land the Perfect Job (Part 3 of 3)

Journey to SQL Authority with Pinal Dave, January 29, 2015
Views: 70 | Hits 9

I am very fortunate that I know John Sonmez in person. He is one of those individualswho understands the young mind of developers and depth of software development industry. I am a regular follower of...

SQL SERVER The Basics of the SSIS Script Task Notes from the Field #065

Journey to SQL Authority with Pinal Dave, January 29, 2015
Views: 56 | Hits 2

[Note from Pinal]: This is a new episode of Notes from the Fieldseries. SQL Server Integration Service (SSIS) is one of the most key essential part of the entire Business Intelligence (BI) story.It is...

Developer 3 Tips Every SQL Expert Needs to Know to Land the Perfect Job (Part 2 of 3)

Journey to SQL Authority with Pinal Dave, January 28, 2015
Views: 59 | Hits 11

I am very fortunate that I know John Sonmez in person. He is one of those individualswho understands the young mind of developers and depth of software development industry. I am a regular follower of...

Performance testing of ORM layers in Python and C++

The Code Project Latest Articles, January 28, 2015
Views: 49 | Hits 4

Comparing the performance of two similar CRUD server apps, one written in Python and SQLAlchemy, the other in C++ and YB.ORM....

SQL SERVER How to Know Backup History of Current Database?

Journey to SQL Authority with Pinal Dave, January 28, 2015
Views: 64 | Hits 4

Some blog post and scripts are like ever green references. One such blog has been Get Database Backup History for a Single Database. A number of you have pinged me and for amendments to that script wi...

Developer 3 Tips Every SQL Expert Needs to Know to Land the Perfect Job (Part 1 of 3)

Journey to SQL Authority with Pinal Dave, January 27, 2015
Views: 73 | Hits 12

I am very fortunate that I know John Sonmez in person. He is one of those individualswho understands the young mind of developers and depth of software development industry. I am a regular follower of...

SQL SERVER Error: Fix: Msg 5133, Level 16, State 1, Line 2 Directory lookup for the file failed with the operating system error 2(The system cannot find the file specified.) Part 2

Journey to SQL Authority with Pinal Dave, January 27, 2015
Views: 116 | Hits 1

Errors are a great starting point for learning. Especially, my inbox is always flooded with atleast 2-3 error messages almost every other day. People keep asking me how to solve them, what to do when ...

Questions About T-SQL Control-of-Flow Language You Were Too Shy to Ask

Simple Talk, January 26, 2015
Views: 2 | Hits

Surely, we all know how T-SQL Control-of-flow language works? In fact it is surprisingly easy to get caught out. What, for example, do the BREAK, RETURN and CONTINUE keywords do, precisely, in thei...

Centralize Your Database Monitoring Process

Simple Talk, January 26, 2015
Views: 72 | Hits 13

SQL Server Data Collector, together with Management Data Warehouse, is a fine and useful component for gathering information centrally about how SQL Server instances are being used, and thereby keepin...

SQL SERVER Error: Msg 701, Level 17, State 103. There is insufficient system memory in resource pool to run this query

Journey to SQL Authority with Pinal Dave, January 26, 2015
Views: 58 | Hits 1

Talking and exploring In-Memory topics inside SQL Server 2014 has been interesting to me. When I wrote the blog around table variable not being just an In-Memory structure, one of my course listener (...

Interview Question of the Week #004 List All Columns and Their Data Type for a View

Journey to SQL Authority with Pinal Dave, January 25, 2015
Views: 96 | Hits 7

Earlier this week I wrote a blog about finding stored procedure parameters and their data types.After that blog I received few emails from my blog readers asking for similar script for a view. I asked...

Data with Structure Migration from MySQL to SQL Server 2012

The Code Project Latest Articles, January 24, 2015
Views: 90 | Hits 9

Simple approach to migrate data and structure from MySQL to SQL Server...

SQL SERVER How to Bind Resource Governor for InMemory Enabled Databases?

Journey to SQL Authority with Pinal Dave, January 24, 2015
Views: 84 | Hits 2

I have done a number of courses for Pluralsight. Last year when SQL Server 2014 was released, I planned to do a session on the same. The course SQL Server 2014 Administration New Features was a lot of...

The Target of Your Defection

Simple Talk, January 23, 2015
Views: 52 | Hits 2

I was a bit nervous this morning. I had been tasked with adding two SQL instances back into a master/target (MSX/TSX) relationship so that they would receive updated job code that had a new DFS share ...

Standalone sql profiler - ExpressPreofiler

The Code Project Latest Articles, January 23, 2015
Views: 97 | Hits 19

Standalone sql profiler - ExpressPreofiler...

SQL SERVER Who is Consuming my TempDB Now?

Journey to SQL Authority with Pinal Dave, January 23, 2015
Views: 115 | Hits 15

Off late my love for TempDB and writing on topics of tempDB has been a great learning experience. The more I work with tempDB, the more fascinated I am. TempDb is being used by a number of operations ...

SQL SERVER The DBA goes to MARS Maintenance, Architecture, Research and Support Notes from the Field #063

Journey to SQL Authority with Pinal Dave, January 22, 2015
Views: 79 | Hits 2

[Note from Pinal]: This is a 63rdth episode of Notes from the Fieldseries. Storytelling is an art very few have mastered in their life. When I requested Stuart to share his ideas about his famous blog...

SQL SERVER Backups are Non-negotiable Lifeline for DBAs

Journey to SQL Authority with Pinal Dave, January 21, 2015
Views: 72 | Hits 3

I have had my share of DBA friends who have told me a number of horror stories from their experiences. Thinking back, these look like moments to laugh away but there are some serious learnings we get ...

SQL SERVER How DBAs Have to be Proactive in Identifying and Fixing Problems Before They Happen

Journey to SQL Authority with Pinal Dave, January 20, 2015
Views: 70 | Hits 9

In real life our dear ones always love to have surprises. If we do things even before they can think, we are in for some fun for rest of the days/weeks. I vividly remember a conversation with my daugh...

Fluent JDBC Query API

The Code Project Latest Articles, January 19, 2015
Views: 76 | Hits 9

Fluent JDBC Query API for more convenient native SQL querying...

SQL SERVER How to Find Weak Passwords Using T-SQL?

Journey to SQL Authority with Pinal Dave, January 19, 2015
Views: 95 | Hits 9

Recently one of my blog reader emailed me below question. Hi Pinal, Need your urgent help. In recent past, we have been attacked by the hacker who was able to get in to our SQL Server via sysadmin acc...

Extracting the filename from a full path in SQL Server

The Code Project Latest Articles, January 18, 2015
Views: 64 | Hits 5

Sometimes, you want to extract the filename (with or without the extension) from the full path of a file. It's easy in C# and so forth - just use the Path.GetFileName method. But what if you want it i...

Interview Question of the Week #003 How to Write Script for Database Cursor?

Journey to SQL Authority with Pinal Dave, January 18, 2015
Views: 72 | Hits 4

Just another day I heard a senior DBA discussing advantages and disadvantages of the cursor. Well, personally I am a firm believer of the set based operations. However, there are few places where curs...

SQL SERVER Watching Table Variable Data in TempDB

Journey to SQL Authority with Pinal Dave, January 17, 2015
Views: 82 | Hits 15

I cannot get enough of working with TempDB and the learning never stops. Previously, when I wrote about SQL SERVER Is tempDB behaving like a Normal DB?, SQL SERVER Inside Temp Table Object Creation ...

A Start with Automating Database Configuration Management

Simple Talk, January 16, 2015
Views: 7 | Hits

For a number of reasons, it pays to have the up-to-date source of all the databases and servers that you're responsible for in a central archive, in version control, and this is a job that is best au...

SQL SERVER Configuration and Performance of SQL Server is Now Easy to Master

Journey to SQL Authority with Pinal Dave, January 16, 2015
Views: 75 | Hits 11

This is one of the toughest topics to address, and I am always looking at new tools that can help me learn and understand SQL Server better. In many cases, I fall back to MSDN documentation and offici...

Amazon's Aurora: A Distributed SQL Database Alternative For MySQL Applications

Simple Talk, January 15, 2015
Views: 6 | Hits

SQL-based distributed Cloud Relational databases aren't new, but Amazon's Aurora offers an alternative to SQL Azure, and, being MySQL-compatible, provides the obvious route to the cloud for hosted LAM...

SQL SERVER The Easy Functions of SQL Server Notes from the Field #062

Journey to SQL Authority with Pinal Dave, January 15, 2015
Views: 71 | Hits 5

[Note from Pinal]:In this episode of the Notes from the Field series database expert KathiKellenbergerexplains about easy and amazing functions of SQL Server. Kathi is an amazing instructor, she was t...

Resource Governor Enhancements in SQL Server 2014

The Code Project Latest Articles, January 14, 2015
Views: 71 | Hits 4

Resource Governor Enhancements in SQL Server 2014...

SQL SERVER How to Increase Number of Errorlog Files

Journey to SQL Authority with Pinal Dave, January 14, 2015
Views: 84 | Hits 5

A long back I had written a blog on – SQL SERVER Recycle Error Log Create New Log file without Server Restart. Recently one of my blog reader emailed me with this question: Hi Pinal, In our SQL Serv...

SQL SERVER Visibility into the Overall Health of Your SQL Server Environment You Cant Fix What You Cant See

Journey to SQL Authority with Pinal Dave, January 13, 2015
Views: 121 | Hits 7

I am sure most of us have experienced driving a four wheeler. The first time I went behind the wheels, it was an amazing experience. My excitement was multiplied by tension in the face of my father. A...

SQL SERVER Finding Tables Created Last Week DBA Tip Part II

Journey to SQL Authority with Pinal Dave, January 12, 2015
Views: 123 | Hits 6

When I wrote my previous blog post on SQL SERVER Finding Tables Created Last Week DBA Tip, lesser did I know something as simple as this can become such an interesting topic of conversation. I have ...

Interview Question of the Week #002 Script to Find Byte Size of a Row for All the Tables in Database

Journey to SQL Authority with Pinal Dave, January 11, 2015
Views: 119 | Hits 8

In recent times I was part of the interview panel where I was stunned to see that following question was asked to interviewee. I personally believed that this question is no longer relevantas we are i...

How to connect ASP.NET website to Remote Database for CRUD operations

The Code Project Latest Articles, January 10, 2015
Views: 78 | Hits 17

This article is an overview for connecting an ASP.NET website or a web application to a remote SQL Server database....

SQL SERVER What is the query used in sp_cursorfetch and FETCH API_CURSOR?

Journey to SQL Authority with Pinal Dave, January 10, 2015
Views: 65 | Hits

In a recent debugging exercise for performance, one of my friend recently posted a question to me: When I view activity monitor, under the recent expensive queries and under query column, there I see ...

SQL SERVER What is is_not_trusted in sys.foreign_keys?

Journey to SQL Authority with Pinal Dave, January 9, 2015
Views: 66 | Hits 1

My greatest source of learning is via my blog. Many of you take time in asking your toughest questions and sometimes basic questions that make me think. This interaction creates a source of exploratio...

SQL SERVER Iterating over Metadata with BimlScript Notes from the Field #061

Journey to SQL Authority with Pinal Dave, January 8, 2015
Views: 76 | Hits 4

[Note from Pinal]: This is a 36th episode of Notes from the Fieldseries.One of the common question I receive every other day is – I have learned BI but I feel that there is no automation in the BI fie...

SQL SERVER Identify and Filter In-Memory Optimized Tables SQL in Sixty Seconds #079

Journey to SQL Authority with Pinal Dave, January 7, 2015
Views: 89 | Hits 5

Earlier I had written a blog about SQL SERVER Beginning In-Memory OLTP with SampleExample which covers the basics of working with In-Memory OLTP. Though that post gets you started, one of my colleagu...

Going to Extremes to Release Bug Fixes and New Features

Simple Talk, January 6, 2015
Views: 32 | Hits

XP is no general panacea; but for the right team, and for a product that needs to release bug fixes and new features as fast as possible, its benefits are obvious. Working on one of Red Gate's most p...

Discrete and Continuous data in SQL

Simple Talk, January 6, 2015
Views: 14 | Hits

Not all data is discrete; some data types represent a continuum. In SQL, we have to approximate them and live with the special problems of handling continuous data. We need to understand the problem...

SQL SERVER Finding Tables Created Last Week DBA Tip

Journey to SQL Authority with Pinal Dave, January 6, 2015
Views: 85 | Hits 9

My conversations with my DBA friends are always interesting. They have unique ways to solve problems and organizations take them for granted. Most of the DBAs want to be in control of their environmen...

SQL SERVER Schema Change Reports SQL in Sixty Seconds #078

Journey to SQL Authority with Pinal Dave, January 6, 2015
Views: 71 | Hits 10

Earlier, I wrote a blog post about Schema Change Reports andFinding Tables Created Last Week – DBA Tip. I received quite a few emails about the same. It seems like a quite a popular topic. As per few ...

SQL SERVER Filter In-Memory OLTP Tables in SSMS

Journey to SQL Authority with Pinal Dave, January 5, 2015
Views: 127 | Hits 10

Earlier I had written a blog about SQL SERVER Beginning In-Memory OLTP with SampleExample which covers the basics of working with In-Memory OLTP. Though that post gets you started, one of my colleagu...

Interview Question of Week #001 Script to List Foreign Key Relationships and Constraint Name

Journey to SQL Authority with Pinal Dave, January 4, 2015
Views: 132 | Hits 17

Two years ago I wrote a book SQL Server Interview Questions and Answers with my very close friend Vinod Kumar. It is a very popular book of mine and has sold many thousands of copies so far. Every sin...

SQL SERVER UNION With TEXT DataType Returns Error but and UNION ALL Works Reasons

Journey to SQL Authority with Pinal Dave, January 3, 2015
Views: 91 | Hits 1

Earlier I demonstrated a very interesting behaviorin my blog post –UNION and UNION ALL with TEXT DataType Observation, where we see that UNION clause with TEXT datatype returns Error but withUNION AL...

SQL SERVER Fix Missing Mirroring and Transaction Log Shipping option in the Database Properties

Journey to SQL Authority with Pinal Dave, January 2, 2015
Views: 117 | Hits 6

If you are a SQL Server developer or DBA, the chances are you are quite familiar working with SQL Server Management Studio. The longer you have been in the industry, more likely are you to take these ...

Questions About Pivoting Data in SQL Server You Were Too Shy to Ask

Simple Talk, January 1, 2015
Views: 88 | Hits 14

Of all the basic SQL operations, the pivot seems to cause the most problems. We can tell from the way that old articles on Simple-Talk on the topic continue to be read. It turns out that there are sev...

SQL SERVER Year 2014 Reflections by Tim Radney Notes from the Field #060

Journey to SQL Authority with Pinal Dave, January 1, 2015
Views: 63 | Hits 2

[Notes from Pinal]: New Year’s Resolutions is a funny word. Everybody makes it on January 1st but breaks it in very few days. I used to make resolutions too, but for a while, I have stopped this pract...