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

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

SQL SERVER SSMS Trick Generating CSV file using Management Studio

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

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: 70 | 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: 61 | Hits 3

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

Generic Insert for Dapper

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

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: 62 | Hits 5

[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: 60 | Hits 7

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

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: 51 | Hits 4

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: 54 | Hits 3

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: 47 | Hits 5

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

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

SQL SERVER How to Chang Audit Location?

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

The auditing capability inside SQL Server is a hidden gem and not known to many in my opinion. If you have a requirement to audit your SQL Server environment and want to keep track of the activities s...

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

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

Being a DBA is one of the most rewarding experience because you control the server as well as the way the permissions are given to each and every individual users. In my career I have often seen peopl...

SQL SERVER User Defined Audit with SQL Server

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

Talk to any financial institution or bank they will be super paranoid when it comes to security and auditing policies applied to their organizations. In a recent session to one of our customers, I had...

SQL SERVER Filtering CPU Bound Execution Plans with Extended Events

Journey to SQL Authority with Pinal Dave, November 14, 2014
Views: 63 | Hits 2

Let me take a tour to what are we talking here from a scenario point of view. Prior to SQL Server 2012, tracing the execution plan is an all or nothing approach. In profiler, if we select execution pl...

SQL SERVER FIX Msg 4864, Level 16, State 1 Bulk load data conversion error

Journey to SQL Authority with Pinal Dave, November 13, 2014
Views: 52 | Hits

Working with SQL Server is such rewarding and most of the times, I get a chance to revisit and explore more into some of these errors. Long time ago, I had written a blog post to read data from CSV/te...

SQL SERVER Validation Rules: Code or Database? Notes from the Field #054

Journey to SQL Authority with Pinal Dave, November 13, 2014
Views: 57 | Hits 2

[Note from Pinal]: This is a 54th episode of Notes from the Fieldseries. Where do we blame for a mistake or error in the system? Well, developer blames DBA and DBA blame developers. Sometimes there is...

SQL SERVER What is Hypothetical Indexes?

Journey to SQL Authority with Pinal Dave, November 12, 2014
Views: 57 | Hits 9

If you ever thought this is some sort of trick to bring you to the blog, well you are wrong. This infact is something worth a look and interesting thing to know. Before I start to explain you the fine...

Slaying the beast

Simple Talk, November 11, 2014
Views: 67 | Hits 3

SQL Compare is the industry standard for comparing and deploying SQL Server database schemas, and is used by 71% of Fortune 100 companies. Like all mature products, however, its code base has been gro...

SQL SERVER FIX Error: One or more files do not match the primary file of the database

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

Writing about SQL Server for close to 8 years, almost every single day means I get a lot of questions from people on a daily basis. Though I try to answer as many as possible (via email, blog, twitter...

SQL SERVER Take the Quiz for a chance to win a Quadcopter Drone

Journey to SQL Authority with Pinal Dave, November 10, 2014
Views: 95 | Hits 3

It has been a long time since we ran quiz. So let us get ready for a quiz. The quiz has two parts. You have to get both the parts correctto win Quadcopter with Camera (we will call it drone). We will ...

SQL SERVER FIX: ERROR : Msg 3136, Level 16, State 1 This differential backup cannot be restored because the database has not been restored to the correct earlier state

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

During my recent visit to customer site for a session on backups, they asked me to find the cause of the error while restoring a differential backup. Though this seemed to be completely an admin relat...

SQL SERVER FIX: ERROR : Msg 3023, Level 16, State 2 Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized

Journey to SQL Authority with Pinal Dave, November 9, 2014
Views: 110 | Hits 2

Errors are the best way to learn how SQL Server works and as DBAs we are bound to see many of them from time to time. One of the primary functions of a DBA would include creating backups and most impo...

SQL SERVER Fix Error 5058, Level 16, State 1 Option cannot be set in database

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

Of late I have been writing about errors quite a bit because I seem to have been digging these from my email archives based on interaction with multiple DBAs over the past 6-7 years. These are interes...

SQL SERVER Performance Counter Missing: How to Get Them Back?

Journey to SQL Authority with Pinal Dave, November 7, 2014
Views: 67 | Hits 3

Of the thousands of mails I receive every day about SQL Server problems, I was recently pinged by a friend who reported a weird problem. He started with a simple question. He said that he wants to mon...

SQL SERVER Msg 1206, Level 18, State 118 The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction

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

The saga of working with error messages continues. Here is an error that was shared at one of the User group meetings by a member. While working via linked server to do data manipulation they reported...

Questions About Using TSQL to Import Excel Data You Were Too Shy to Ask

Simple Talk, November 5, 2014
Views: 48 | Hits 4

It is easy to import Excel data into database tables via TSQL, using OLEDB, either by the OPENROWSET function or linking to the spreadsheet as a server. The problem is that there are certain things th...

SQL SERVER Using Bitwise And (&) Instead of a Junction Table Notes from the Field #053

Journey to SQL Authority with Pinal Dave, November 5, 2014
Views: 102 | Hits 8

[Note from Pinal]: This is a 53rdth episode of Notes from the Fieldseries.Everyday I get 100s of emails and most of the emails have a similar request. Everyone wants to get maximum performance, but th...

SQL SERVER Table Space Allocation Details using DMV

Journey to SQL Authority with Pinal Dave, November 5, 2014
Views: 63 | Hits 3

Understanding SQL Server from inside-out is always something I have loved to learn from time to time. Recently, I was asking my good friend Balmukund on how are pages allocated inside SQL Server and w...

SSIS 2012 Projects: Setup, Project Creation and Deployment

Simple Talk, November 4, 2014
Views: 52 | Hits 4

It used to be that SQL Server Integration Services (SSIS) packages had to be deployed individually. Now, they can be all deployed together from a single file by means of the Project Deployment Model ...

SQLAuthority News Get My Two Books FREE at #SQLPASS

Journey to SQL Authority with Pinal Dave, November 4, 2014
Views: 46 | Hits 2

Every year when I visit SQLPASS, I do book signingwhere I give away my books for free. This year there are two opportunities when I am going to give away my books for free. Though the books are in gre...

SQL SERVER Unable to Restore From Backup After Detach Operation

Journey to SQL Authority with Pinal Dave, November 4, 2014
Views: 93 | Hits 2

While doing community work I travel a lot, speak at various conferences and get a chance to meet many new faces. The best part is that I get a chance to hear a variety of issues which people face whil...

SQL Authority News Presenting Session at #SQLPASS on November 5, 2014

Journey to SQL Authority with Pinal Dave, November 3, 2014
Views: 56 | Hits

I will be attending SQLPASS 2014 this year in Seattle. I have attended SQLPASS 5times before and this is my sixth times for the event. I love this event and that is why every single year I attend the ...

SQL SERVER PowerShell way of Restarting SQL Server Service

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

I learn a lot when I go for conferences all around the world. There are styles, content and cultural differences that I get a chance to learn and enjoy as part of my trips. Most of these trips I make ...

SQL SERVER What are my Trace Flags Enabled on SQL Server?

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

In one of my recent interactions with a DBA friend of mine, I had to dig into one of the simplest yet a capability which is available inside SQL Server. SQL Server from time to time has an uncanny req...

SQL Authority News 8th Year Anniversary Thank You!

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

Today is very special day in my life. Exactly 8 years ago today, I had started writing this blog. When I started writing a blog post, I really had no idea what exactly I am starting and where exactly ...

SQL SERVER Why my Database is in Restoring Mode After Taking Backup?

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

Once upon a time there was a SharePoint consultant named Pepper. She wanted to learn about SQL Server Administration/DBA work. While she was a master SharePoint consultant at her office in Bethel she ...

Azure: Announcing New Real-time Data Streaming and Data Factory Services

ScottGus Blog, October 31, 2014
Views: 67 | Hits 5

The last three weeks have been busy ones for Azure.  Two weeks ago we announced a partnership with Docker to enable great container-based development experiences on Linux, Windows Server and Micr...

SQL SERVER Answer to Puzzle ISNUMERIC and Unexpected Results

Journey to SQL Authority with Pinal Dave, October 31, 2014
Views: 93 | Hits 4

Earlier I blogged aboutPuzzle ISNUMERIC and Unexpected Results SQL in Sixty Seconds#076and it is one of the most popular blog posts. Lots of people answered the question correctly. In the blog post ...

SQL SERVER Beginning Table Valued Constructors Notes from the Field #052

Journey to SQL Authority with Pinal Dave, October 30, 2014
Views: 85 | Hits

[Note from Pinal]: This is a 52th episode of Notes from the Fieldseries.I am very happy that the journey which we started one year ago is a amazing milestone. In this 52 episode in the entire year we ...

SQL SERVER Puzzle ISNUMERIC and Unexpected Results SQL in Sixty Seconds #076

Journey to SQL Authority with Pinal Dave, October 29, 2014
Views: 79 | Hits 2

It has been a long time since I have asked, puzzled on this blog so let us have fun time together with ISNUMERIC function. If you get the correct answer to this question, I will give you one month fre...

Run SQL Queries on MongoLab

MongoLab - MongoDB Hosting, October 28, 2014
Views: 66 | Hits 3

This is a guest post by John A. De Goes, CTO of SlamData. SlamData is the commercial company behind the open source project of the same name. John is the original author and an active contributor to t...

MySQL cant specify target table for update in FROM clause

The Code Project Latest Articles, October 28, 2014
Views: 75 | Hits

How to fix the error "MySQL can't specify target table for update in FROM clause" while executing an update query....

SQL SERVER Exploring SQL Auditing with SQL Compliance Manager

Journey to SQL Authority with Pinal Dave, October 28, 2014
Views: 134 | Hits 2

As database administrators, we are constantly quizzed by our superiors to answer questions such as: how secure is our network, how secure is our data, is data secure at rest, is data secure in transit...

SQL Authority News Embarcadero DB PowerStudio Promotion & Savings

Journey to SQL Authority with Pinal Dave, October 27, 2014
Views: 95 | Hits

If you are regular readers of this blog, you may be aware of that I use many different tools in my daily routine. One of them is DB PowerStudio for Embarcadero. The team has recently announced special...

Full Stack Development on Google App Engine

The Code Project Latest Articles, October 26, 2014
Views: 76 | Hits 9

Effective way to develop and operate full stack web Apps and APIs on Google App Engine, including front end app & UI, restful web services and persistence layer as NoSQL database on Google Cloud Platf...

SQL SERVER How to Flip Value of Bit Field in SQL Server? Part 2

Journey to SQL Authority with Pinal Dave, October 26, 2014
Views: 88 | Hits 4

Yesterday I wrote a blog post aboutSQL SERVER How to Flip Value of Bit Field in SQLServer?. Lots of good suggestions I have received in response of the same. Here are a few different methods to flip ...

SQL SERVER How to Flip Value of Bit Field in SQL Server?

Journey to SQL Authority with Pinal Dave, October 25, 2014
Views: 125 | Hits 8

How do you flip bit field in SQL Server? Well, if you search for this question on internet, you will find many different answers, today we will see my favorite method to flip value for the bit field. ...

The Simple-Talk Magazine

Simple Talk, October 24, 2014
Views: 46 | Hits 2

This year, the Simple-Talk team have produced a magazine. Its been great fun, and a little stressful (deadlines for things to go to print always come too quickly), but we got there in time for SQL in ...