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

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

SQL SERVER List the Name of the Months Between Date Ranges Part 2

Journey to SQL Authority with Pinal Dave, December 22, 2014
Views: 1 | Hits

Last week I wrote a blog post aboutSQL SERVER List the Name of the Months Between Date Ranges. It was written in the response to the question How to list the name of the months between two date rang...

Gotcha: Entity Framework gets slow in long Iteration Loops

Rick Strahls WebLog, December 21, 2014
Views: 1 | Hits

Thought Id highlight a common problem Ive run into a few times with a few of my customers using Entity Framework. I spent some time today with a customer debugging a very, very slowly process using En...

SQL SERVER List the Name of the Months Between Date Ranges Correction

Journey to SQL Authority with Pinal Dave, December 21, 2014
Views: 1 | Hits

Earlier I wrote a blog post aboutSQL SERVER List the Name of the Months Between Date Ranges. It was written in the response to the question – How to list the name of the months between two date range...

SQLAuthority News Presented on Database Worst Practices at SQLPASS 2014 in Seattle November 5, 2014

Journey to SQL Authority with Pinal Dave, December 20, 2014
Views: 1 | Hits

Earlier last month, I had the opportunity to present at SQLPASS 2014. The event was held in Seattle in November 2014.I had a great time attending this event and I presented on the topic Database Worst...

SQL SERVER Reverse String Word By Word Part 4

Journey to SQL Authority with Pinal Dave, December 19, 2014
Views: 1 | Hits

EarlierI wrote a blog post aboutSQL SERVER Reverse String Word By Word. SQL Server ExpertSanjay MonparaandYuri Petrovcontributed to the blog post with their excellent script which I have blogged earl...

SQL SERVER Creating the SSIS Catalog Notes from the Field #058

Journey to SQL Authority with Pinal Dave, December 18, 2014
Views: 1 | Hits

[Notes from Pinal]: SSIS is very well explored subject, however, there are so many interesting elements when we read, we learn something new. A similar concept has beenCreating the SSIS catalog. Linch...

SQL SERVER Reverse String Word By Word Part 3

Journey to SQL Authority with Pinal Dave, December 17, 2014
Views: 1 | Hits

EarlierI wrote a blog post aboutSQL SERVER Reverse String Word By Word. SQL Server ExpertSanjay Monpara wrote a great comment to the blog post where he has proposed alternate solution. Right after th...

C#: Avoiding Performance Issues with Inserts in SQLite

The Code Project Latest Articles, December 16, 2014
Views: 1 | Hits

If you are new to SQLite, you may well run across one of the most confounding of its implementation details the moment you attempt to do some sort of bulk or batch processing of inserts or updates. ...

SQL SERVER Proving that the Source of the Problems arent Tied to the Database

Journey to SQL Authority with Pinal Dave, December 16, 2014
Views: 1 | Hits

I have always wondered how Sherlock Holmes cracked the toughest of mysteries every single time. This fascination always lead me to learn new techniques every single time. The backbone for every succes...

SQL SERVER Reverse String Word By Word Part 2

Journey to SQL Authority with Pinal Dave, December 15, 2014
Views: 1 | Hits

EarlierI wrote a blog post aboutSQL SERVER Reverse String Word By Word. SQL Server ExpertSanjay Monpara wrote a great comment to the blog post where he has proposed alternate solution. Right after th...

SQL SERVER Can Database Primary File Have Any Other Extention Than MDF

Journey to SQL Authority with Pinal Dave, December 14, 2014
Views: 1 | Hits

Here is interesting question I received yesterday. I personally think it is one of the most interesting questions I have received this month. “Can Database Primary File Have Any Other Extention Than M...

SQL SERVER Download RML Utilities for SQL Server

Journey to SQL Authority with Pinal Dave, December 13, 2014
Views: 1 | Hits

Microsoft RML Utilites are very helpful when analysing performance. It helps answering questions like Do you know which databases are using the most resources on your server? Do you know which applica...

How To Insert Records Into A Table That Has No Primary Key, using LINQ to SQL?

The Code Project Latest Articles, December 12, 2014
Views: 1 | Hits

This tip provides an idea about how to insert a record into a table having no primary key using LINQ to SQL....

SQL SERVER Monitoring SQL Server Never Got This Easy

Journey to SQL Authority with Pinal Dave, December 12, 2014
Views: 1 | Hits

In administering SQL Server databases, the DBA is often presented with the task of identifying resource bottlenecks on the system and the sources of those bottlenecks. Also, the DBA is challenged with...

Hey DBA Baselines and Performance Monitoring Why? Notes from the Field #058

Journey to SQL Authority with Pinal Dave, December 11, 2014
Views: 1 | Hits

[Note from Pinal]: This is a 58th episode of Notes from the Fieldseries. Mike Walsh is an amazing person to meet and know. I am fortunate to be his friend. Every single time I meet him, I learn someth...

SQL SERVER Fixing Backup Error Operating system error 5(Access is denied.) SQL in Sixty Seconds #077

Journey to SQL Authority with Pinal Dave, December 10, 2014
Views: 1 | Hits

This error has to be one of the most famous error. I have installed SQL Server quite a many times, but I keep on getting this error once in a while. This is also one of the most searched error online....

SQL SERVER List the Name of the Months Between Date Ranges

Journey to SQL Authority with Pinal Dave, December 9, 2014
Views: 1 | Hits

Here is another interesting question, I received the other day. “How to list the name of the months between two date ranges?” Very interesting question. I had no script ready for it so I asked my frie...

SQL SERVER -Fix Error Cannot open backup device. Operating system error 5(Access is denied.)

Journey to SQL Authority with Pinal Dave, December 8, 2014
Views: 1 | Hits

This has to be the most popular error in taking database backups. There are many reasons for this error and there are different ways to resolve it. I recently faced this error and for a while I was ta...

SQL SERVER Finding if Current Week is Odd or Even Script

Journey to SQL Authority with Pinal Dave, December 7, 2014
Views: 1 | Hits

Here is an interesting question I received from my friend who is working in Bank as a DBA. “Pinal, We have a requirement in bank that every 2nd and 4th week we keep more cash in our bank where as we c...

SQL SERVER Reverse String Word By Word

Journey to SQL Authority with Pinal Dave, December 6, 2014
Views: 1 | Hits

Earlier I wrote a blog post where I have reversed the entire string which was passed to the function. You can read that over here User Defined Functions (UDF) to Reverse String. In that blog post I wr...

Silverlight Application with Management Entity Framework and WCF Service

The Code Project Latest Articles, December 5, 2014
Views: 1 | Hits

A guide to constructing an application using Expression Blend and Silverlight for the front-end which obtains data from a WCF service and SQL Server back-end...

SQL SERVER FIX: Error 5161 An Unexpected file id was Encountered

Journey to SQL Authority with Pinal Dave, December 5, 2014
Views: 1 | Hits

Recently I was planning to give a demo about increasing tempdb files and its performance benefit. So while making the demo at home, I was doing multi-tasking. Talking to my daughter, having food and m...

SQL SERVER The Basics of the SSIS Data Flow Task Notes from the Field #057

Journey to SQL Authority with Pinal Dave, December 4, 2014
Views: 1 | Hits

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

SQL SERVER Beginning with SQL Server Security Aspects

Journey to SQL Authority with Pinal Dave, December 3, 2014
Views: 1 | Hits

SQL Server Security Aspects This article is the high-level overview of the SQL Server security best practices and aspects. Ensuring SQL Server security is an important task that may be successfully so...

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

Journey to SQL Authority with Pinal Dave, December 2, 2014
Views: 1 | Hits

One of the most popular questions I find still coming to via email is how to enable or disable all the constraint for single table or database. Well, in this blog post we will not discuss the reasons ...

Using Entity Framework With an Existing Database: Data Access

Simple Talk, December 1, 2014
Views: 1 | Hits

Pre-existing SQL databases, particularly if complex, can often pose problems for software developers who are creating a new application. The data may be in a format that makes it hard to access or upd...

SQL SERVER How to Learn SQL Server 2014 Video Tutorial

Journey to SQL Authority with Pinal Dave, December 1, 2014
Views: 1 | Hits

As December begins the realization is that Year 2014 is about to come to an end. The month of November was a travel month for me. I have travelled to 6 different cities, 2 countries and 3 different co...

Optimizing Push Framework for the Web: Use of Websocket, SSL, Json, AngularJs and MySQL

The Code Project Latest Articles, November 30, 2014
Views: 1 | Hits

Websocket, SSL, Json, MySQL are all combined together with Push Framework to produce a C++ server that interacts with an Angularjs web front-end. The application shows the ease of implementing CRUD....

SQL SERVER Inside Temp table Object Creation Part II

Journey to SQL Authority with Pinal Dave, November 30, 2014
Views: 1 | Hits

After my previous article on Inside Temp table object creation, I had a number of people ask me more about this topic. There seems to be a need for understanding these basic fundamentals that we have ...

SQL SERVER Customization of New Query in SQL Server Management Studio

Journey to SQL Authority with Pinal Dave, November 29, 2014
Views: 1 | Hits

Recently I was working with one of my friends who handles production server databases as a senior DBA. He told that recently one of the Jr. DBA was fired from his company because he has run a drop tab...

SQL SERVER Identifying T-SQL Missing Parameter Data Types with SQL Server

Journey to SQL Authority with Pinal Dave, November 28, 2014
Views: 1 | Hits

I like challenges and when we are faced with a challenge I just cannot sleep. I am in constant search for solution. More importantly I look forward for the learning experience these bring to me. Rece...

SQL SERVER Beginning with SQL Server Security Aspects

Journey to SQL Authority with Pinal Dave, November 27, 2014
Views: 1 | Hits

SQL Server Security Aspects This article is the high-level overview of the SQL Server security best practices and aspects. Ensuring SQL Server security is an important task that may be successfully so...

SQL SERVER Inside Temp Table Object Creation

Journey to SQL Authority with Pinal Dave, November 27, 2014
Views: 1 | Hits

When I wrote the article around tempdb like normal database, I had a number of people asked me how it is so simple to understand? Well, they were asking how are the tables created? How will same table...

SQL SERVER Proof of Concepts with Windows Azure Notes from the Field #056

Journey to SQL Authority with Pinal Dave, November 27, 2014
Views: 1 | Hits

[Note from Pinal]: This is a 56thepisode of Notes from the Fields series. If you are DBA and Developer there is always a situation when you want to prove yourself by building a smallproof of concepts ...

SQL SERVER Maintenance Plan Maintenance Cleanup Task not Deleting Files

Journey to SQL Authority with Pinal Dave, November 26, 2014
Views: 1 | Hits

I am always notified by my blog readers whenever they see something unusual and I try to help them so that I can learn something new. Recently, one of my blog reader told that his drive is getting fil...

SQL SERVER FIX The database model is marked RESTORING and is in a state that does not allow recovery to be run

Journey to SQL Authority with Pinal Dave, November 25, 2014
Views: 1 | Hits

The best way one can learn SQL Server is by trying out things on their own and I am no different. I constantly am trying to explore the various options one can use when working with SQL Server. In the...

Create SQL CLR Function with Visual Studio 2013 Database Project

The Code Project Latest Articles, November 24, 2014
Views: 1 | Hits

Learn how quickly you can create and deploy SQL CLR function using integrated features of visual studio 2013....

SQL SERVER SSMS Trick Generating CSV file using Management Studio

Journey to SQL Authority with Pinal Dave, November 24, 2014
Views: 1 | Hits

In my previous blog I talked about using SQLCMD to generate a comma separate files for the table data. Some blog readers reported that why we should use SQLCMD or BCP to generate the file when the sam...

SQL SERVER FIX The term Invoke-Sqlcmd is not recognized as the name of a cmdlet

Journey to SQL Authority with Pinal Dave, November 23, 2014
Views: 1 | Hits

Its always a fun to learn and share new thing which I learn about any technology. So I decided to spend my weekend at home quietly, so I could learn some scripting using PowerShell and SQL Server. My ...

SQL SERVER How to use Procedure sp_user_counter1 to sp_user_counter10

Journey to SQL Authority with Pinal Dave, November 22, 2014
Views: 1 | Hits

There are many performance counters available in SQL Server which can be used to monitor various parameters of SQL Server engine. Have you ever been into a situation where you want to see value in per...

SQL SERVER Fix : Msg 230, Level 14, State 1 The SELECT permission was denied on the object, database, schema Part II

Journey to SQL Authority with Pinal Dave, November 21, 2014
Views: 1 | Hits

A couple of days back I wrote the blog on Msg 230 and thought it was one of the simplest implementations of access control on the system. To continue with the code in this blog, please make sure you r...

Please sp_help My System Stored Procedure

Simple Talk, November 20, 2014
Views: 1 | Hits

SQL Server provides a large number of built-in stored procedures that can tell us all sorts of useful information about what’s going on in our SQL Server databases. For example, the sp_help* set of sy...

Generic Insert for Dapper

The Code Project Latest Articles, November 20, 2014
Views: 1 | Hits

Dapper offers fast database handling with custom SQL strings. This wrapper simplifies life by taking generic POCO objects and create necessary SQL strings on the fly, and it is still very fast!...

SQL SERVER Common Sense Data Security Notes from the Field #055

Journey to SQL Authority with Pinal Dave, November 20, 2014
Views: 1 | Hits

[Note from Pinal]: This is a 55th episode of Notes from the Fieldseries. Common sense is not as much as common as we think. I am sure you agree with it from your real world experience. However, when i...

SQL SERVER Is tempDB behaving like a Normal DB?

Journey to SQL Authority with Pinal Dave, November 20, 2014
Views: 1 | Hits

The more I work with SQL Server, more I am baffled with the way SQL Server works. In all these interactions, I have seen DBAs and Developers think about TempDB as something totally different from a us...

SQL SERVER SQLCMD to Build Comma Separated String

Journey to SQL Authority with Pinal Dave, November 19, 2014
Views: 1 | Hits

We have an active usergroup in Bangalore called SQLBangalore. Whenever I get a chance to attend the local usergroup sessions (which happens often trust me), I get to learn something every single time...

Bitwise Operations in T-SQL

Simple Talk, November 18, 2014
Views: 1 | Hits

How can you, in T-SQL, get a list of columns that have changed within a trigger? How can you see what bits are set within a varbinary or integer? How would you pass a bitmap parameter to a system stor...

SQL SERVER Restricting Access to Contained Databases using Logon Triggers

Journey to SQL Authority with Pinal Dave, November 18, 2014
Views: 1 | Hits

When I wrote the article on A Simple Example of Contained Databases lesser did I know how people might be planning to use this capability? Having said that, there are environments where people want to...

Using Stored Procedures to Provide an Applications Business-Logic Layer

Simple Talk, November 17, 2014
Views: 1 | Hits

When faced with a complex business application that had to be delivered with minimum staffing, on-time and within budget, Dwain's team chose to encapsulate and implement most of an applications busine...

Using a Database With Your Android* App

The Code Project Latest Articles, November 17, 2014
Views: 1 | Hits

In this article we will take a look at Android* SQLite API and helper classes for database creation and maintenance....