iAwaaz-News-by-People - Stories tagged with SQL

SQL

atom rss
1
Awaaz
spam Awaaz Up Awaaz Down

Shrink, MDF, NDF and Reader's Opinion - What's Yours?
published 78 days, 44 minutes ago posted by amit_it7amit_it7 80 days, 15 hours, 39 minutes ago
Sunday, June 20, 2010 6:23:49 PM GMT Friday, June 18, 2010 3:28:36 AM GMT
Shrink, MDF, NDF and Reader's Opinion - What's Yours?
Blog Reader and SQL Expert Imran has wonderful explanation of how Shrinking, MDF and NDF works. What is your opinion? (more)
category: Technology | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
2
Awaaz
spam Awaaz Up Awaaz Down

Using SQL CLR Stored Procedure Track IP Address
published 126 days, 17 hours, 42 minutes ago posted by attitudeattitude 132 days, 15 hours, 46 minutes ago
Monday, May 03, 2010 1:25:29 AM GMT Tuesday, April 27, 2010 3:22:21 AM GMT
Using SQL CLR Stored Procedure Track IP Address
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: Technology | clicked: 0 | comment | | source: www.midnightprogrammer.net
tags: c#, Clr procedures, SQL, Stored Procedure
1
Awaaz
spam Awaaz Up Awaaz Down

Daily tech links for .net and related technologies - Apr 15-18, 2010 - Sanjeev Agarwal
posted by attitudeattitude 141 days, 10 minutes ago
Sunday, April 18, 2010 6:58:07 PM GMT
Daily tech links for .net and related technologies - Apr 15-18, 2010 - Sanjeev Agarwal
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: Technology | clicked: 0 | comment | | source: weblogs.asp.net
tags: Ajax, Architecture, Silverlight, SQL, Web Service
1
Awaaz
spam Awaaz Up Awaaz Down

Sql Server error message
published 149 days, 20 hours, 11 minutes ago posted by attitudeattitude 150 days, 20 hours, 56 minutes ago
Friday, April 09, 2010 10:56:55 PM GMT Thursday, April 08, 2010 10:11:55 PM GMT
Sql Server error message
If your Sqlserver gives error like (more)
category: Technology | clicked: 0 | comment | | source: praveenbattula.blogspot.com
tags: SQL
1
Awaaz
spam Awaaz Up Awaaz Down

Sample T-SQL Cursor Example Code
posted by attitudeattitude 157 days, 21 hours, 55 minutes ago
Thursday, April 01, 2010 9:13:24 PM GMT
Sample T-SQL Cursor Example Code
T-SQL Cursor Example Code Here is a T-SQL cursor example code created for looping selecting a list of email addresses for emailing. The select query in the definition of the example t-sql cursor returns the ex... (more)
category: Technology | clicked: 0 | comment | | source: www.kodyaz.com
tags: cursors, SQL, syntax, T-SQL
2
Awaaz
spam Awaaz Up Awaaz Down

Download SQL Server 2008 R2 Developers Training Kit
posted by attitudeattitude 157 days, 21 hours, 55 minutes ago
Thursday, April 01, 2010 9:12:56 PM GMT
Download SQL Server 2008 R2 Developers Training Kit
With the t-sql enhancements and t-sql improvements introduced with MS SQL Server 2005 and with MS SQL Server 2008, coding in t-sql is enabling many difficult tasks to be implemented easier in less code. (more)
category: Technology | clicked: 0 | comment | | source: www.kodyaz.com
tags: SQL, SQLServer, SQLSERVER2008, Training
1
Awaaz
spam Awaaz Up Awaaz Down

Daily tech links for .net and related technologies - Mar 26-28, 2010 - Sanjeev Agarwal
posted by attitudeattitude 162 days, 13 hours, 58 minutes ago
Sunday, March 28, 2010 5:09:56 AM GMT
Daily tech links for .net and related technologies - Mar 26-28, 2010 - Sanjeev Agarwal
Creating Rich View Components in ASP.NET MVC - manzurrashid, Diagnosing ASP.NET MVC Problems - Brad Wilson, Templated Helpers (more)
category: Technology | clicked: 0 | comment | | source: weblogs.asp.net
tags: Ajax, Architecture, c#, MVC 2, Silverlight, SQL, Web Service
1
Awaaz
spam Awaaz Up Awaaz Down

Daily tech links for .net and related technologies - Mar 23-25, 2010 - Sanjeev Agarwal
posted by nancynancy 166 days, 17 hours, 30 minutes ago
Wednesday, March 24, 2010 1:38:19 AM GMT
Daily tech links for .net and related technologies - Mar 23-25, 2010 - Sanjeev Agarwal
Introducing Browsers Providers in ASP.NET 4 - osbornm, ASP.NET 4.0 Part 14, More Control Over Session State - hmobius, Editable MVC Routes (Apache Style) - nberardi, ASP.NET Performance Framework - karlseguin, Silverlight 4 RIA Services - Ready for Business: Localizing Business Application - Brad Abrams, Make your Silverlight applications Speak to you with Microsoft Translator and Simulate Geo Location in Silverlight Windows Phone 7 emulator - Tim Heuer, Styles for XAML (Silverlight (more)
category: Technology | clicked: 0 | comment | | source: weblogs.asp.net
tags: Ajax, Architecture, Silverlight, SQL, UI, Web Service
1
Awaaz
spam Awaaz Up Awaaz Down

Tabs Studio adds advanced tabs to Microsoft SQL Server Management Studio 2008 IDE
posted by nancynancy 168 days, 20 hours, 11 minutes ago
Sunday, March 21, 2010 10:56:50 PM GMT
Tabs Studio adds advanced tabs to Microsoft SQL Server Management Studio 2008 IDE
Tabs Studio add-in adds experimental support for multiple tab rows and tab grouping in SSMS 2008 IDE. (more)
category: Technology | clicked: 0 | comment | | source: tabsstudio.wordpress.com
tags: Database, SQL, SQL Server, ssms
1
Awaaz
spam Awaaz Up Awaaz Down

Updated CTP for SQL Azure Database includes complete feature set for PDC 2009! - SQL Azure Team Blog
posted by nancynancy 168 days, 20 hours, 11 minutes ago
Sunday, March 21, 2010 10:56:47 PM GMT
Updated CTP for SQL Azure Database includes complete feature set for PDC 2009! - SQL Azure Team Blog
Updated CTP for SQL Azure Database includes complete feature set for PDC 2009! A few short weeks ago we announced the SQL Azure Database August CTP. Since the announcement, tens of thousands in the community have signed up for the service and have provided us with a tremendous amount of positive feedback. Today, the SQL Azure Database October CTP (CTP 2) update is another major milestone as we get ready for the Professional Developers Conference (PDC) on November 17th - 20th, 2009. We are also excited t... (more)
category: Technology | clicked: 0 | comment | | source: blogs.msdn.com
tags: Azure, CTP, Database, PDC, PDC 2009, SQL, SQL Azure
1
Awaaz
spam Awaaz Up Awaaz Down

VS 2010 Beta 2 Read Me Items for Web Deployment - Vishal Joshi
posted by nancynancy 168 days, 20 hours, 11 minutes ago
Sunday, March 21, 2010 10:56:41 PM GMT
VS 2010 Beta 2 Read Me Items for Web Deployment - Vishal Joshi
There are some known issues/bugs related to VS 2010 Web Deployment features in VS 2010 Beta 2 Read Me? I can imagine reading the entire Beta 2 read me file can be daunting so I thought I can just copy paste the ones related to Web Deployment here? DB Deployment will fail if the Database Name is longer than 127 characters Description: If you are using latest VS 2010 Web Deployment Features and trying to deploy your database using the Deploy SQL property page then at times you might get error from VSMsDe... (more)
category: Technology | clicked: 0 | comment | | source: vishaljoshi.blogspot.com
tags: Database, DB, Deploy, Deployment, SQL, Visual Studio 2010, visual studio 2010 beta 2, VS 2010, VS2010
1
Awaaz
spam Awaaz Up Awaaz Down

Are You Using Scalable Shared Databases? - Ben Nevarez
posted by nancynancy 168 days, 20 hours, 11 minutes ago
Sunday, March 21, 2010 10:56:38 PM GMT
Are You Using Scalable Shared Databases? - Ben Nevarez
Did you know that you can share read-only databases between several instances of SQL Server? Scalable Shared Databases is a very interesting SQL Server feature that many of us seem to almost have forgotten about it. Available for the first time in SQL Server 2005 and originally described on the Microsoft KB article 910378, it was later fully documented on Books Online. This Enterprise edition-only feature allows a read-only database to be accessed at the same time by two or more SQL Server instances (ma... (more)
category: Technology | clicked: 0 | comment | | source: sqlblog.com
tags: Database, DB, SQL, SQL Server
1
Awaaz
spam Awaaz Up Awaaz Down

SSMS tab grouping with Tabs Studio
published 168 days, 18 hours, 59 minutes ago posted by nancynancy 168 days, 20 hours, 12 minutes ago
Monday, March 22, 2010 12:08:51 AM GMT Sunday, March 21, 2010 10:56:16 PM GMT
SSMS tab grouping with Tabs Studio
SQL Server Management Studio uses quite different scheme for tab names from Visual Studio. I?ve significantly improved SSMS support in the next Tabs Studio version. (more)
category: Technology | clicked: 0 | comment | | source: tabsstudio.wordpress.com
tags: Database, SQL, SQL Server, SQL Server Management Studio, ssms
1
Awaaz
spam Awaaz Up Awaaz Down

SQL SERVER ? Stored Procedure Optimization Tips ? Best Practices
published 168 days, 18 hours, 59 minutes ago posted by nancynancy 168 days, 20 hours, 12 minutes ago
Monday, March 22, 2010 12:08:51 AM GMT Sunday, March 21, 2010 10:56:02 PM GMT
SQL SERVER ? Stored Procedure Optimization Tips ? Best Practices
We will go over how to optimize Stored Procedure with making simple changes in the code. Please note there are many more other tips, which we will cover in future articles. Include SET NOCOUNT ON statement: With every SELECT and DML statement, the SQL server returns a message that indicates the number of affected rows by that statement. This information is mostly helpful in debugging the code, but it is useless after that. By setting SET NOCOUNT ON, we can disable the feature of returning this extra i... (more)
category: Technology | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: Database, pinaldave, SQL, SQLAuthority, SQLServer
1
Awaaz
spam Awaaz Up Awaaz Down

Resize Image In Asp.Net And Upload To Databse
published 168 days, 18 hours, 59 minutes ago posted by nancynancy 168 days, 20 hours, 12 minutes ago
Monday, March 22, 2010 12:08:51 AM GMT Sunday, March 21, 2010 10:55:59 PM GMT
Resize Image In Asp.Net And Upload To Databse
In this example i am going to describe how to resize image and upload to ms sql database in asp.net. For this i am using FileUpload control to upload the image in datbase after resizing. I am also displaying the Image in Gridviw after uploading to database. (more)
category: Technology | clicked: 0 | comment | | source: csharpdotnetfreak.blogspot.com
tags: ASP.NET, Database, grid View, SQL
1
Awaaz
spam Awaaz Up Awaaz Down

Architecture: The Harmony of Mathematical Precision... : Moving your SQL Server Database to the Clouds? Try the SQL Azure Migration Wizard
published 169 days, 12 hours, 18 minutes ago posted by amit_it7amit_it7 169 days, 13 hours, 25 minutes ago
Sunday, March 21, 2010 6:49:55 AM GMT Sunday, March 21, 2010 5:42:39 AM GMT
Architecture: The Harmony of Mathematical Precision... : Moving your SQL Server Database to the Clouds? Try the SQL Azure Migration Wizard
Moving your SQL Server Database to the Clouds? Try the SQL Azure Migration Wizard Thinking about kicking the tires on SQL Azure? Wondering what tools are out there to help automate the process and save some time? (more)
category: Technology | clicked: 0 | comment | | source: blogs.msdn.com
tags: SQL, SQL Azure, SQL Script, SQL Server
1
Awaaz
spam Awaaz Up Awaaz Down

Visual Web Developer Team Blog : Dev10 Beta2, Import from web.config file and other changes for DB deployment UI
published 169 days, 12 hours, 18 minutes ago posted by amit_it7amit_it7 169 days, 13 hours, 26 minutes ago
Sunday, March 21, 2010 6:49:55 AM GMT Sunday, March 21, 2010 5:41:48 AM GMT
Visual Web Developer Team Blog : Dev10 Beta2, Import from web.config file and other changes for DB deployment UI
Dev10 Beta2, Import from web.config file and other changes for DB deployment UI Dev10 Beta2 DB Deployment property page has some changes from Beta1. (more)
category: Technology | clicked: 0 | comment | | source: blogs.msdn.com
tags: SQL, web.config
1
Awaaz
spam Awaaz Up Awaaz Down

Daily tech links for .net and related technologies - Mar 18-21, 2010 - Sanjeev Agarwal
posted by amit_it7amit_it7 171 days, 13 hours, 31 minutes ago
Friday, March 19, 2010 5:36:34 AM GMT
Daily tech links for .net and related technologies - Mar 18-21, 2010 - Sanjeev Agarwal
TDD kata for ASP.NET MVC controllers (part 2) -David, Take Control Of Web Control ClientID Values in ASP.NET 4.0 - Scott Mitchell, Inside the ASP.NET MVC Controller Factory - Dino Esposito, Microsoft, jQuery, and Templating - stephen walther, Cross Domain AJAX Request with YQL and jQuery - Jeffrey Way, T4MVC Add-In to auto run template -Wayne...... (more)
category: Technology | clicked: 0 | comment | | source: weblogs.asp.net
tags: Ajax, Architecture, Silverlight, SQL, WCF
1
Awaaz
spam Awaaz Up Awaaz Down

SQL SERVER ? Interview Questions
published 171 days, 12 hours, 10 minutes ago posted by amit_it7amit_it7 171 days, 13 hours, 32 minutes ago
Friday, March 19, 2010 6:58:17 AM GMT Friday, March 19, 2010 5:35:57 AM GMT
SQL SERVER ? Interview Questions
About an year ago, I had posted SQL Server related Interview Questions and Answers. It was very well received in community. I have received many comments, suggestions and emails on this subject. I am planning to upgrade the Interview Questions and Answers and take it to next level. Here, I need your help. Please your comments, suggestions, expectation or potential interview Question (along with answer) here. Your input will be very valuable. As time goes by we all learn and get better. There were few th... (more)
category: Technology | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
1
Awaaz
spam Awaaz Up Awaaz Down

Entity Framework 4.0: Optimal and horrible SQL
published 171 days, 12 hours, 10 minutes ago posted by amit_it7amit_it7 171 days, 13 hours, 35 minutes ago
Friday, March 19, 2010 6:58:17 AM GMT Friday, March 19, 2010 5:32:58 AM GMT
Entity Framework 4.0: Optimal and horrible SQL
Lately I had Entity Framework 4.0 session where I introduced new features of Entity Framework. During session I found out with audience how Entity Framework 4.0 can generate optimized SQL. After session I also showed guys one horrible example about how awful SQL can be generated by Entity Framework. In this posting I will cover both examples. (more)
category: Technology | clicked: 0 | comment | | source: weblogs.asp.net
tags: entity framework 4.0, OR/M, SQL
1
Awaaz
spam Awaaz Up Awaaz Down

SQL SERVER ? Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE
published 170 days, 20 hours, 18 minutes ago posted by amit_it7amit_it7 171 days, 13 hours, 36 minutes ago
Friday, March 19, 2010 10:49:40 PM GMT Friday, March 19, 2010 5:32:14 AM GMT
SQL SERVER ? Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE
Today, we are going to discuss about something very simple, but quite commonly confused two options of ALTER DATABASE. The first one is ALTER DATABASE ?ROLLBACK IMMEDIATE and the second one is WITH NO_WAIT. Many people think they are the same or are not sure of the difference between these two options. Before we continue our explaination, let us go through the explanation given by Book On Line. ROLLBACK AFTER integer [SECONDS] | ROLLBACK IMMEDIATE Specifies whether to roll back after a specified numb... (more)
category: Technology | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
4
Awaaz
spam Awaaz Up Awaaz Down

FREE online training sessions on ASP.NET, ADO.NET, SSRS, SQL Server
published 180 days, 22 hours, 14 minutes ago posted by attitudeattitude 184 days, 17 hours, 30 minutes ago
Tuesday, March 09, 2010 8:54:09 PM GMT Saturday, March 06, 2010 1:37:56 AM GMT
FREE online training sessions on ASP.NET, ADO.NET, SSRS, SQL Server
Greetings from DotNetFunda.Com !!!. We are happy to inform that DotNetFunda.Com has brought online training sessions on OOPS, ASP.NET, ADO.NET, Sql Server and SQL Server Reporting Services exclusively for DotNetFunda.Com members in the month of February and March 2010. Please visit to nominate yourself. (more)
category: Screencast | clicked: 1 | comment | | source: www.dotnetfunda.com
tags: ADONET, ASPNET, SQL, SSRS, Training
1
Awaaz
spam Awaaz Up Awaaz Down

SQL SERVER ? Rollback TRUNCATE Command in Transaction
published 180 days, 22 hours, 14 minutes ago posted by attitudeattitude 184 days, 17 hours, 42 minutes ago
Tuesday, March 09, 2010 8:54:09 PM GMT Saturday, March 06, 2010 1:25:37 AM GMT
SQL SERVER ? Rollback TRUNCATE Command in Transaction
This is very common concept that truncate can not be rolled back. I always hear conversation between developer if truncate can be rolled back or not. If you use TRANSACTIONS in your code, TRUNCATE can be rolled back. If there is no transaction is used and TRUNCATE operation is committed, it can not be retrieved from log file. TRUNCATE is DDL operation and it is not logged in log file. Update: (Based on comments of Paul Randal) Truncate IS a logged operation, it just doesn?t log removing the records, ... (more)
category: Technology | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer