DotNetShoutout - Stories tagged with SQL

SQL

atom rss
2
Shouts
spam Shout it Mute it

Microsoft SQL Server Developer Certification Paths
posted by eralpereralper 1114 days, 12 hours, 10 minutes ago
Tuesday, June 01, 2010 11:22:24 AM GMT
Microsoft SQL Server Developer Certification Paths If you are a Microsoft SQL Server T-SQL developer, you might want to show your skills and knowledge on MS SQL Server development. One way is to take a Microsoft SQL Server development exam like 70-433, 70-451 or 70-454 in order to gain credits to Microsoft SQL Server 2008 Development certifications. There are two Microsoft certifications for candidates who want to walk on the SQL Server 2008 Database Development path. First certification is MCTS... (more)
category: Data | clicked: 1 | comment | | source: www.kodyaz.com
tags: 70-433, certification, SQL Server 2008, exam, SQL, MCTS
4
Shouts
spam Shout it Mute it

Optimising wildcard prefixed LIKE conditions | AdaTheDev
posted by AdaTheDevAdaTheDev 1114 days, 13 hours, 15 minutes ago
Tuesday, June 01, 2010 10:17:19 AM GMT
An overview on how to use indexed computed columns to optimise the performance of wildcard-prefixed LIKE conditions within an SQL query. (more)
category: Data | clicked: 0 | comment | | source: www.adathedev.co.uk
tags: SQL, Performance, SQL-Server
6
Shouts
spam Shout it Mute it

Daily tech links for .net and related technologies - June 1-3, 2010 - Sanjeev Agarwal
posted by sanjeevanasanjeevana 1114 days, 16 hours, 35 minutes ago
Tuesday, June 01, 2010 6:56:59 AM GMT
Solution Architecture For The Masses. Step 4: Design Your Presentation Layer – Part I & Part II- Alikl , C#5 and Meta-Programming - Patrick Smacchia , 9 Rules about Constructors, Destructors, and Finalizers - Mohammad Elsheimy , Piracy in .NET Code – Part 2 – Even when the code is obfuscated - Naveen , C# Dynamic Type - Richard Carr , C#: Using a dictionary instead of if statements - Mark Needham , Architecture Review: Mock-Driven Three-Layer Architecture - James Shore , Code Contracts Part 4 – Objec... (more)
category: Web Dev | clicked: 0 | comment | | source: weblogs.asp.net
tags: Silverlight, SQL, Web Service, Architecture, Ajax
6
Shouts
spam Shout it Mute it

Daily tech links for .net and related technologies - May 26-29, 2010 - Sanjeev Agarwal
published 1119 days, 11 hours, 1 minute ago posted by sanjeevanasanjeevana 1120 days, 13 hours, 55 minutes ago
Thursday, May 27, 2010 12:30:52 PM GMT Wednesday, May 26, 2010 9:37:04 AM GMT
Porting MVC Music Store to Raven: StoreController - Ayende , Building a Store Locator ASP.NET Application Using Google Maps API - Scott Mitchell , Anti-Forgery Request Recipes For ASP.NET MVC And AJAX - Dixin , How to Localize an ASP.NET MVC Application - Michael Ceranski , Tekpub ASP.NET MVC 2 Starter Site 0.5 Released - Rob Conery , How to use Google Data API in ASP.NET MVC. Part 2 - Mahdi , jQuery.validate and Html.ValidationSummary playing nice together - simonince , Automatic Fluent Validati... (more)
category: Web Dev | clicked: 0 | comment | | source: weblogs.asp.net
tags: SQL, Web Service, Agile, Architecture, Ajax
5
Shouts
spam Shout it Mute it

SQL SERVER – Simple Example of Snapshot Isolation – Reduce the Blocking Transactions « Journey to SQL Authority with Pinal Dave
published 1120 days, 13 hours, 13 minutes ago posted by pinaldavepinaldave 1120 days, 22 hours, 12 minutes ago
Wednesday, May 26, 2010 10:18:44 AM GMT Wednesday, May 26, 2010 1:20:25 AM GMT
To learn any technology and move to a more advanced level, it is very important to understand the fundamentals of the subject first. Today, we will be talking about something which has been quite introduced a long time ago but not properly explored when it comes to the isolation level. Snapshot Isolation was introduced in SQL Server in 2005. However, the reality is that there are still many software shops which are using the SQL Server 2000, and therefore cannot be able to maintain the Snapshot Isolatio... (more)
category: Data | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
7
Shouts
spam Shout it Mute it

BCP and SQL Azure - SQL Azure Team Blog
published 1124 days, 10 hours, 25 minutes ago posted by iftekharahmedamitiftekharahmedamit 1125 days, 10 hours, 38 minutes ago
Saturday, May 22, 2010 1:07:01 PM GMT Friday, May 21, 2010 12:54:33 PM GMT
BCP is a great way to locally backup your SQL Azure data, and by modifying your BCP based backup files you can import data into SQL Azure as well. In this blog post, we will learn: How to export data out of tables in SQL Azure server into a data file by using BCP andHow to use the BCP utility to import new rows from a data file into SQL Azure tables.What is BCP? The bcp utility is a command line utility that ships with Microsoft SQL Server. It bulk copies data between SQL Azure (or SQ... (more)
category: Data | clicked: 0 | comment | | source: blogs.msdn.com
tags: SQL, SQL Azure, Azure
9
Shouts
spam Shout it Mute it

Using transactions with LINQ-to-SQL
published 1124 days, 10 hours, 25 minutes ago posted by http://jalpesh.blogspot.com/http://jalpesh.blogspot.com/ 1127 days, 3 hours, 31 minutes ago
Saturday, May 22, 2010 1:07:01 PM GMT Wednesday, May 19, 2010 8:01:39 PM GMT
Today one of my colleague asked that how we can use transactions with the LINQ-to-SQL Classes when we use more then one entities updated at same time. It was a good question. Here are the my answer for that.For ASP.NET 2.0  or higher version have a new class called TransactionScope which can be used to manage transaction with the LINQ. Let’s take a simple scenario we are having a shopping cart application in which we are storing details or particular order placed into the database using LINQ-to-SQL. The... (more)
category: Web Dev | clicked: 0 | comment | | source: jalpesh.blogspot.com
tags: SQL, Transactions, ASP.NET
6
Shouts
spam Shout it Mute it

SQL SERVER – Find Most Expensive Queries Using DMV « Journey to SQL Authority with Pinal Dave
published 1128 days, 7 hours, 44 minutes ago posted by pinaldavepinaldave 1129 days, 12 hours, 40 minutes ago
Tuesday, May 18, 2010 3:48:19 PM GMT Monday, May 17, 2010 10:52:19 AM GMT
The title of this post is what I can express here for this quick blog post. I was asked in recent query tuning consultation project, if I can share my script which I use to figure out which is the most expensive queries are running on SQL Server. This script is very basic and very simple, there are many different versions are available online. This basic script does do the job which I expect to do – find out the most expensive queries on SQL Server Box. SELECT TOP 10 SUBSTRING(qt.TEXT, (qs.statement_sta... (more)
category: Data | clicked: 2 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
5
Shouts
spam Shout it Mute it

CornerstoneDB Tools Beta Signup
posted by http://vistadb.myopenid.com/http://vistadb.myopenid.com/ 1132 days, 8 hours, 24 minutes ago
Friday, May 14, 2010 3:08:24 PM GMT
We have officially launched the CornerstoneDB site!  Beta signup limited to 100 developers You can signup right now to be eligible for the beta on each of the tools.  We are seeking feedback from .Net data developers.  Give us your input and we will enter you for a chance to win free copy of each tool as they launch.  100 Developers will be chosen to take part in the Beta program for each tool.  Signup today if you are interested in getting early access to these great tools.What is CornerstoneDB? Corne... (more)
category: Data | clicked: 1 | comment | | source: infinitecodex.com
tags: SQL Server, CornerstoneDB, VistaDB, SQL, mysql, Database
5
Shouts
spam Shout it Mute it

Installing WordPress on SQL Server - Zach Skyles Owens
published 1131 days, 11 hours, 20 minutes ago posted by iftekharahmedamitiftekharahmedamit 1132 days, 11 hours, 49 minutes ago
Saturday, May 15, 2010 12:12:16 PM GMT Friday, May 14, 2010 11:43:02 AM GMT
Before you read this article, please note: the easiest way to install WordPress on SQL Server or SQL Azure is to use the Getting Started page. If you’re still having trouble or want more details, read on! These instructions assume you’re installing WordPress on Windows 7 or Windows Server 2008 or 2008 R2. If you’re installing WordPress in a Windows share hosting environment, many of these same concepts apply. Here’s a summary of the steps:Install the PrerequisitesConfigure a DatabaseDownload the WordPr... (more)
category: Data | clicked: 0 | comment | | source: wordpress.visitmix.com
tags: SQL Server, SQL, Wordpress
8
Shouts
spam Shout it Mute it

Identifying currently running SQL queries
published 1133 days, 14 hours, 8 minutes ago posted by sonukapoorsonukapoor 1135 days, 10 hours, 36 minutes ago
Thursday, May 13, 2010 9:24:37 AM GMT Tuesday, May 11, 2010 12:56:06 PM GMT
This article is taken from the book SQL Server DMVs in Action. The author discusses a routine that identifies the SQL queries that are currently running, which is useful for debugging. (more)
category: Data | clicked: 0 | comment | | source: dotnetslackers.com
tags: sp_who2, SQL, dmv
5
Shouts
spam Shout it Mute it

SQL SERVER – Get Latest SQL Query for Sessions – DMV « Journey to SQL Authority with Pinal Dave
posted by pinaldavepinaldave 1140 days, 22 hours, 42 minutes ago
Thursday, May 06, 2010 12:49:46 AM GMT
In recent SQL Training I was asked, how can one figure out what was the last SQL Statement executed in sessions. The query for this is very simple. It uses two DMVs and created following quick script for the same. SELECT session_id, TEXT FROM sys.dmexecconnections CROSS APPLY sys.dmexecsqltext(mostrecentsqlhandle) AS ST While working with DMVs if you ever find any DMV has column with name sqlhandle you can right away join that DMV with another DMV sys.dmexecsqltext and can get the tex... (more)
category: Data | clicked: 1 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
7
Shouts
spam Shout it Mute it

MongoDB vs. SQL Server 2008 Performance Showdown
published 1146 days, 12 hours, 34 minutes ago posted by http://mkennedy66996693.myopenid.com/http://mkennedy66996693.myopenid.com/ 1147 days, 4 hours, 47 minutes ago
Friday, April 30, 2010 10:58:27 AM GMT Thursday, April 29, 2010 6:45:13 PM GMT
This article is a follow up one I wrote last week entitled “The NoSQL Movement, LINQ, and MongoDB - Oh My!”. In that article I introduced the NoSQL movement, MongoDB, and showed you how to program against it in .NET using LINQ and NoRM. I highlighted two cornerstone reasons why you might ditch your SQL Server for the NoSQL world of MongoDB. Those were 1. Ease-of-use and deployment 2. Performance For ease-of-use, you’ll have to w... (more)
category: Data | clicked: 7 | comment | | source: www.michaelckennedy.net
tags: OpenSource, SQL, MongoDB, ASP .NET, Linq, DevelopMentor, NoSQL
8
Shouts
spam Shout it Mute it

SQL SERVER – GUID vs INT – Your Opinion « Journey to SQL Authority with Pinal Dave
published 1147 days, 12 hours, 24 minutes ago posted by pinaldavepinaldave 1148 days, 20 hours, 13 minutes ago
Thursday, April 29, 2010 11:08:29 AM GMT Wednesday, April 28, 2010 3:19:37 AM GMT
Take your side. State your case. Learn the reality. (more)
category: Data | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
7
Shouts
spam Shout it Mute it

Using SQL CLR Stored Procedure Track IP Address
published 1150 days, 15 hours, 51 minutes ago posted by http://prashantmx.myopenid.com/http://prashantmx.myopenid.com/ 1152 days, 5 hours, 40 minutes ago
Monday, April 26, 2010 7:40:49 AM GMT Saturday, April 24, 2010 5:52:18 PM GMT
Recently I was asked by one of my friend how to call a web service directly from a stored procedure. He needs to track IP addresses using a stored procedures so, I suggested him two ways to call a web service using the SQL Procedure.Using SP_OACREATE with MSXML Create an assembly using SQL CLR using C#. I personally tried using the first way to call a web service but was not successful. Then I learnt about SQL CLR programming with Visual Studio and C# and get it done in a first go. As a good friend I c... (more)
category: Data | clicked: 1 | comment | | source: www.midnightprogrammer.net
tags: C#, SQL, Clr procedures, Stored Procedure
8
Shouts
spam Shout it Mute it

The NoSQL Movement, LINQ, and MongoDB - Oh My!
published 1152 days, 13 hours ago posted by http://mkennedy66996693.myopenid.com/http://mkennedy66996693.myopenid.com/ 1154 days, 2 hours, 3 minutes ago
Saturday, April 24, 2010 10:32:07 AM GMT Thursday, April 22, 2010 9:29:38 PM GMT
Maybe you’ve heard people talking about ditching their SQL Servers and other RDBMS entirely. There is a movement out in the software development world called the "No SQL" movement and it’s taking the web application world by storm. “Insanity!” you may cry, “for where will people put their data if not in a database? Flat files? Tell me we aren’t we going back to flat files.” No, but in the relational model, something does has to give. The N... (more)
category: Architecture | clicked: 1 | comment | | source: www.michaelckennedy.net
tags: OpenSource, SQL, MongoDB, Linq, NoSQL, ASP.NET
6
Shouts
spam Shout it Mute it

SQL SERVER – Create Primary Key with Specific Name when Creating Table « Journey to SQL Authority with Pinal Dave
published 1153 days, 12 hours, 23 minutes ago posted by pinaldavepinaldave 1154 days, 6 hours, 10 minutes ago
Friday, April 23, 2010 11:09:19 AM GMT Thursday, April 22, 2010 5:22:31 PM GMT
It is interesting how sometimes the documentation of simple concepts is not available online. I had received email from one of the reader where he has asked how to create Primary key with a specific name when creating the table itself. He said, he knows the method where he can create the table and then apply the primary key with specific name. The attached code was as follows: (more)
category: Data | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
3
Shouts
spam Shout it Mute it

Free Second Shot Offer for Microsoft Certification Exam Takers using Exam Vouchers
posted by eralpereralper 1155 days, 2 hours, 20 minutes ago
Wednesday, April 21, 2010 9:12:24 PM GMT
Take your free second shot offer for Microsoft Certification exams using exam vouchers. As I wrote in my previous certification blog post, I have been invited to take part in Microsoft Learning Rewards Program which enables me distribute free exam vouchers to my network, including friends and Kodyaz.com visitors. Here is the first free Microsoft exam voucher for readers of this blog. Microsoft Certification Exam Voucher 920535CJSZ for Second Shot valid in United States. Another free... (more)
category: Web Dev | clicked: 0 | comment | | source: www.kodyaz.com
tags: certification, exam, SQL, Microsoft, vouchers, ASP.NET
9
Shouts
spam Shout it Mute it

Free eBook Download – Introducing Microsoft SQL Server 2008 R2 « Journey to SQL Authority with Pinal Dave
published 1155 days, 12 hours, 7 minutes ago posted by pinaldavepinaldave 1156 days, 11 hours, 36 minutes ago
Wednesday, April 21, 2010 11:25:35 AM GMT Tuesday, April 20, 2010 11:56:33 AM GMT
Microsoft Press has published FREE eBook on the most awaiting release of SQL Server 2008 R2. The book is written by Ross Mistry (@rossmistry) and Stacia Misner. Ross is my personal friend and one of the most active book writer in SQL Server Domain. When I see his name on any book, I am sure that it will be high quality and easy to read book. Ross has written many other books, which I am big fan of as well. The details about the book is here: Introducing Microsoft SQL Server 2008 R2, by Ross Mistry and... (more)
category: Data | clicked: 2 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
4
Shouts
spam Shout it Mute it

Daily tech links for .net and related technologies - Apr 15-18, 2010 - Sanjeev Agarwal
posted by sanjeevanasanjeevana 1161 days, 13 hours, 29 minutes ago
Thursday, April 15, 2010 10:02:45 AM GMT
Guarding against CSRF Attacks in ASP.NET MVC2 - Scott Kirkland, Same Markup: Writing Cross-Browser Code - Tony Ross , Introducing Machine.Specifications.Mvc - James Broome, ASP.NET 4 - Breaking Changes and Stuff to be Aware of - Scott Hanselman , JSON Hijacking in ASP.NET MVC 2 - Matt , Easy And Safe Model Binding In ASP.NET MVC - Justin Etheredge , MVC Portable Areas Enhancement - Embedded Resource Controller - Steve Michelotti (more)
category: Web Dev | clicked: 1 | comment | | source: weblogs.asp.net
tags: Silverlight, SQL, Web Service, Architecture, Ajax
Previous 1 2 3 4 5 6 7 8 9 10 Next