DotNetSlackers Latest ASP.NET News in Category SQL

SQL SERVER A Puzzle Fun with NULL Fix Error 8117

Journey to SQL Authority with Pinal Dave — Thu, 24 May 2012 00:00:00 GMT

During my 8 years of career, I have been many times interviewer and quite often interview candidate myself. If I am interviewer I do ask many questions from easy to difficult one. When I am a candidate, I often get opportunity provided by interviewer to ask them question back.Irrespectiveof at what capacity I am attending [...]...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Presented By:

Thu, 24 May 2012 00:00:00 GMT

SQL SERVER Standard Reports from SQL Server Management Studio SQL in Sixty Seconds #016 Video

Journey to SQL Authority with Pinal Dave — Wed, 23 May 2012 00:00:00 GMT

SQL Server management Studio 2012 is wonderful tool and has many different features. Many times, an average user does not use them as they are not aware about these features. Today, we will learn one such feature. SSMS comes with many inbuilt performance and activity reports, but we do not use it to the full [...]...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

SQL SERVER SmallDateTime and Precision A Continuous Confusion

Journey to SQL Authority with Pinal Dave — Tue, 22 May 2012 00:00:00 GMT

Some confusion never go away. Here is the one of the ancient one. Precision of the SmallDateTime is the one concept/confusion I receive more than once a day everyday. Let me start the with question: What is the precision of the SMALLDATETIME datatypes? What is your answer – write down on notepad. Now if you [...]...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

SSIS Basics: Setting Up Your Initial Package

Simple Talk — Mon, 21 May 2012 00:00:00 GMT

When working with databases, the use of SQL Server Integration Services (SSIS) is a skill that often needs to be acquired quickly, from scratch. Up until now, it has been a curiously frustrating search to find out the basics, fast, in order to get up and running quickly. No longer, as Annette comes up with a simple introduction for the rest of us....

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Presented By:

Mon, 21 May 2012 00:00:00 GMT

Cannot connect to SQL Server

SQL Server DBA — Mon, 21 May 2012 00:00:00 GMT

Question: I cannot connect to Sql server remotely from management studio , It is the correct User name and password.Cannot connect to xxxx.xxxx.xxxx.xxxx===================================A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Presented By:

Mon, 21 May 2012 00:00:00 GMT

LINQ to SqlDataReader

The Code Project Latest Articles — Mon, 21 May 2012 00:00:00 GMT

This tip introduces how to query an SqlDataReader with Linq....

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Presented By:

Mon, 21 May 2012 00:00:00 GMT

SQL Server Prefetch and Query Performance

Simple Talk — Mon, 21 May 2012 00:00:00 GMT

Prefetching can make a surprising difference to SQL Server query execution times where there is a high incidence of waiting for disk i/o operations, but the benefits come at a cost. Mostly, the Query Optimizer gets it right, but occasionally there are queries that would benefit from tuning....

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Export data to Excel in Webmatrix

The Code Project Latest Articles — Mon, 21 May 2012 00:00:00 GMT

How to export data from a SQL Server CE database to an Excel sheet...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Presented By:

Mon, 21 May 2012 00:00:00 GMT

SQL SERVER Renaming Index Index Naming Conventions

Journey to SQL Authority with Pinal Dave — Mon, 21 May 2012 00:00:00 GMT

If you are regular reader of this blog, you must be aware of that there are two kinds of blog posts 1) I share what I learn recently 2) I share what I learn and request your participation. Today’s blog post is where I need your opinion to make this blog post a good reference [...]...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Presented By:

Mon, 21 May 2012 00:00:00 GMT

Export dato to Excel in Webmatrix

The Code Project Latest Articles — Sun, 20 May 2012 00:00:00 GMT

How to export data from a SQL Server CE database to an Excel sheet...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Using SQLite in a Metro style app

Method ~ of ~ failed — Sun, 20 May 2012 00:00:00 GMT

At the Developing Windows 8 Metro style apps with C++ event that happened on 18-May-2012, we saw and heard some very interesting things. If you were watching live then hopefully you didnt see how I tried to work through my presentation while my disk was suspiciously guzzling every last byte until it eventually ran out of space! But I digress During the keynote presentation by Herb Sutter, we brought up several customers that are well-known in the native code world to talk about their experiences...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

SQL SERVER New Look for CodePlexProject Hosting for Open Source Software

Journey to SQL Authority with Pinal Dave — Sun, 20 May 2012 00:00:00 GMT

Codeplex is my favorite site. CodePlex is Microsoft’s free open source project hosting site. You can create projects to share with the world, collaborate with others on their projects, and download open source software.It is great place to find so many open source project available to explore. All the softwares are free and open source. [...]...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Presented By:

Sun, 20 May 2012 00:00:00 GMT

SQL SERVER Saturday Fun Puzzle with SQL Server DATETIME2 and CAST

Journey to SQL Authority with Pinal Dave — Sat, 19 May 2012 00:00:00 GMT

Note: I have used SQL Server 2012 for this small fun experiment. Here is what we are going to do. We will run the script one at time instead of running them all together and try to guess the answer. I am confident that many will get it correct but if you do not get [...]...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

SQL SERVER Thinking about Deprecated, Discontinued Features and Breaking Changes while Upgrading to SQL Server 2012 Guest Post by Nakul Vachhrajani

Journey to SQL Authority with Pinal Dave — Fri, 18 May 2012 00:00:00 GMT

Nakul Vachhrajani is a Technical Specialist and systems development professional with iGATE having a total IT experience of more than 7 years.Nakul is an active blogger with BeyondRelational.com (150+ blogs), and can also be found on forums at SQLServerCentral and BeyondRelational.com. Nakul has also been a guest columnist for SQLAuthority.com and SQLServerCentral.com. Nakul presented a [...]...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Presented By:

Fri, 18 May 2012 00:00:00 GMT

Timeout occurred while waiting for latch: class `LOG_MANAGER`

SQL Server DBA — Thu, 17 May 2012 00:00:00 GMT

Question: This SQL Server Error message appears in the logs :Timeout occurred while waiting for latch: class 'LOG_MANAGER', id 000000001B8009F8, type 4, Task 0x0000000004ED9288 : 0, waittime 300, flags 0x1a, owning task 0x0000000B671882C8. Continuing to wait.How do I fix?Answer:1. Check for disk bottlenecks through Windows Perfmon during maintenance processing. Read Window Perfmon scripting, SQL Server perfmon and how to perfmon 2. Don't run heavy processing jobs in parallel with backup and db reindexing3....

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

SQLAuthority News SQL Server 2012 Upgrade Technical Guide A Comprehensive Whitepaper (454 pages 9 MB)

Journey to SQL Authority with Pinal Dave — Thu, 17 May 2012 00:00:00 GMT

Microsoft has just released SQL Server 2012 Upgrade Technical Guide. This guide is very comprehensive and covers the subject of upgrade in very much depth.This is indeed a great detailed white paper. Even writing a summary of the whitepaper would be over 100 pages. SQL Server 2012 is quite a important release from Microsoft.This white [...]...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Presented By:

Thu, 17 May 2012 00:00:00 GMT

SQL SERVER SQL in Sixty Seconds 5 Videos from Joes 2 Pros Series SQL Exam Prep Series 70-433

Journey to SQL Authority with Pinal Dave — Wed, 16 May 2012 00:00:00 GMT

Joes 2 Pros SQL Server Learning series is indeed fun. Joes 2 Pros series is written for beginners and who wants to build expertise for SQL Server programming and development from fundamental. In the beginning of the series author Rick Morelan is not shy to explain the simplest concept of how to open SQL Server [...]...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

SQL Server 2012 AlwaysOn

Simple Talk — Tue, 15 May 2012 00:00:00 GMT

SQL Server AlwaysOn provides a high-availability and Disaster-recovery solution for SQL Server 2012. It makes use of existing SQL Server features, particularly Failover Clustering, and provides new capabilities such as availability groups. Warwick Rudd explains the basics and shows you how to implement it....

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Telerik OpenAccess ORM - Using SQL Server 2012 LocalDB

the telerik blogs — Tue, 15 May 2012 00:00:00 GMT

Microsoft SQL Server 2012 is certainly an interesting upgrade for the SQL Server, offering lots of improvements and new features. There are many things that might tempt you to migrate to 2012 or at least to start your new projects based on it, but to name a few:

Enhancements for higher availability
New and improved version of the SQL Server Management Studio
Easier migration – the new Side-by-Side Migration option makes the migration from older versions of SQL Server safer and the rollback easier, which can be crucial. In the same time, you can do even an In Place migration (only if you are running 2005 or 2008 edition) or a full-blown data migration by configuring a new machine.

You will most probably want to take advantage of the new file-based version of SQL Express called LocalDB. It will be useful during the development phase of your application as you will not spend any time configuring the server - everything is configured out of the box. In the same time, as it is compatible with the SQL Server 2012 commercial editions, it will be easier to deploy your application to production servers. That means the ORM product you choose has to fully support both versions of the database, and to allow you to easily connect to and use LocalDB.

Let’s get our hands dirty and try all this with OpenAccess ORM - it fully supports LocalDB and SQL Server 2012 commercial editions. We can use the SQL Server Data Tools (SSDT) for creating and defining a LocalDB database, and then generate an OpenAccess Domain Model out of it using the simple Update from Database wizard. This component is available out of the box for Visual Studio 11 Beta, so we will use VS 11 to evaluate what is being offered. Those of you who would like to stick to VS 2010 can download and install .NET Framework 4.0.2 and optionally - SSDT (you can also use the old Server Explorer, it's totally fine).

Note that the Database First approach is the choice in this case since we would like to really familiarize with the database – for the scenarios where you don’t care about it so much, you can just create an empty Domain Model, add your entities and concentrate on the business logic rather than the database specifics.

1. Create a LocalDB database

First, you have to create the .mdf file which will represent your database. In order to add one to your project, choose a Service-based Database in the Add New Item dialog (under Data category):

After you click Add, a wizard will automatically offer you to create some model or a dataset matching the empty database. Cancel the wizard and we will get to creating the model later.

2. Access the database and define the schema

For database schema manipulations we will use the SQL Server Object Explorer - a shiny new addition to the Visual Studio:

Initially it will not have any servers presented, but if you click on Add New Server a familiar window pops up asking for connection details. Our problem now is how to specify the LocalDB here - we only know the file name and that's it!? Not so obvious, but after a short search it appeared that for getting started you can try writing "(localdb)\v11.0" as a server name and use Windows Authentication. As it turns out, while you can create Named Instances of LocalDB dedicated to one application only, an Automatic (public) one is available and it's named after the LocalDB version, in this case - v11.0.

After we add the Automatic instance, our file is shown as a database under it in the SQL Server Object Explorer. It's full path is used as a database name by default, so we have renamed it to something more readable:

The UI will somehow remind us for the SQL Server Management Studio, but it certainly has some new things to get used to. Adding a table is easy:

Just click Update, and after some additional dialogs showing you a preview of the database changes and asking you to confirm them (nice!), the table is added.

3. Auto-Generate the OpenAccess Domain Model

Now we can start the OpenAccess Add Domain Model wizard:

If you are not familiar how to work with the wizard, you can check out the dedicated Getting Started with Database First video available now in Telerik TV and you should be up to speed! Just select Microsoft SQL Server as a backend type and the connection to the LocalDB file we have added earlier should be available automatically. Just in case you need a connection string anyway, it should be something like:

Data Source=(LocalDB)\v11.0;AttachDbFilename="[path]\LocalDBTest.mdf";Integrated Security=True

Now we are ready - you have your Domain Model in the OpenAccess Visual Designer:

I hope this quick walkthrough has shown how easy is it is to enjoy the latest technologies with OpenAccess ORM. Stay tuned as Q2 2012 is approaching and we are implementing some long awaited features for it!

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Presented By:

Tue, 15 May 2012 00:00:00 GMT

The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time

SQL Server DBA — Tue, 15 May 2012 00:00:00 GMT

Question: This SQL Server Error message is appearing on a SQL Server Production Server Error Logs :The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions.How can I troubleshoot this error ?Answer: Each lock that SQL takes out uses up a small amount of memory. Upper limit on...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.