sqlservercurry.com
SQL Server Tutorials and TipsSQL, SQL Server, Business Intelligence
http://www.sqlservercurry.com/
SQL, SQL Server, Business Intelligence
http://www.sqlservercurry.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Thursday
LOAD TIME
0.1 seconds
16x16
32x32
SUPROTIM AGARWAL
A9●●04
KARI●●●● SOC
P●E , MAH, 410029
IN
View this contact
GOOGLE, INC.
GOOGLE TEAM
1600 AMP●●●●●●●● PARKWAY
MOUN●●●●VIEW , CA, 94043
US
View this contact
GOOGLE, INC.
GOOGLE TEAM
1600 AMP●●●●●●●● PARKWAY
MOUN●●●●VIEW , CA, 94043
US
View this contact
BUY YOUR DOMAIN
17
YEARS
4
MONTHS
4
DAYS
ENOM, INC.
WHOIS : whois.enom.com
REFERRED : http://www.enom.com
PAGES IN
THIS WEBSITE
19
SSL
EXTERNAL LINKS
83
SITE IP
74.125.207.121
LOAD TIME
0.141 sec
SCORE
6.2
SQL Server Tutorials and Tips | sqlservercurry.com Reviews
https://sqlservercurry.com
SQL, SQL Server, Business Intelligence
sqlservercurry.com
Resolving CREATE DATABASE Permission denied in database 'master' error on Vista and SQL Express
http://www.sqlservercurry.com/2008/04/resolving-create-database-permission.html
Resolving CREATE DATABASE Permission denied in database 'master' error on Vista and SQL Express. Have you encountered the error 'CREATE DATABASE Permission denied in database 'master' even though you are logged into Windows Vista with administrator privileges. Reason for the error :. Windows Vista users that are members of the Windows Administrators group are not. Automatically granted permission to connect to SQL Server, and they are not automatically granted administrative privileges. For nine times in...
Copy a table from one database to another in SQL Server 2005
http://www.sqlservercurry.com/2008/03/copy-table-from-one-database-to-another.html
Copy a table from one database to another in SQL Server 2005. If you have a table in a database and you would like to copy the table to another database, use this query:. SELECT * INTO AdventureWorks.dbo.CustomersTemp FROM Northwind.dbo.Customers. Just remember that using this query will only transfer the schema and data. It does not transfer the indexes, foreign keys, statistics etc. Transfer both schema and data. Suprotim Agarwal, MCSD, MCAD, MCDBA, MCSE, is the founder of DotNetCurry. Get in touch wit...
SQL Server Stored Procedure Recursion Limit
http://www.sqlservercurry.com/2015/03/sql-server-stored-procedure-recursion.html
SQL Server Stored Procedure Recursion Limit. In order to save you from a performance penalty, SQL Server has a hard limit set for recursion levels for Stored Procedures, Functions, Triggers and Views. The limit is 32 levels and you can’t change it programmatically. Here is a simple example demonstrating this limit:. CREATE PROCEDURE recurseProc (@cnt int) AS BEGIN PRINT @cnt; SET @cnt = 1; EXEC recurseProc @cnt; END; GO EXEC recurseProc 1;. A CTE allows up to 100 levels of recursion. There is no recursio...
SQL Server 2014 - InMemory Tables, Indexes and Stored Procedures
http://www.sqlservercurry.com/2013/09/sql-server-2014-inmemory-tables-indexes_30.html
SQL Server 2014 - InMemory Tables, Indexes and Stored Procedures. In this article, we will explore how to create memory optimized Tables, Indexes and Stored Procedures introduced in Microsoft SQL Server 2014. SQL Server 2014 as of this writing is in CTP1. The in-memory structures does not have separate tools and a query language. This feature is fully integrated into SQL Server and thus you will use the same tools and language [T-SQL] for querying the data. For demonstrations in this article, I am using ...
SQL Server Database Unit Testing using SQL Server Data Tools [SSDT]
http://www.sqlservercurry.com/2013/11/sql-server-database-unit-testing-using_16.html
November 16, 2013. SQL Server Database Unit Testing using SQL Server Data Tools [SSDT]. In this article, we will see how to Unit Test SQL Server database using SQL Server Data Tools [SSDT]. For this demonstration, I am using SQL Server 2012 and Visual Studio 2013. But you can also use Visual Studio 2010 or Visual Studio 2012. Stored Procedures –. Please have a closer look on the script which is shown here –. CustomerID NVARCHAR(10) CONSTRAINT PK CUSTOMERS PRIMARY KEY,. UnitPrice DECIMAL(8,2),. P ContactN...
TOTAL PAGES IN THIS WEBSITE
19
Me & My Little Techie.......: April 2009
http://dotnetvj.blogspot.com/2009_04_01_archive.html
Me and My Little Techie. A place to learn from Little Techie. Little Techie who is Microsoft Most Valuable Professional (MVP), Most Valuable Contributor (MVC), Most Valuable Member (MVM), Member of the Year. Thursday, April 30, 2009. How to Add Identity to Existing Column. This article is in continuous with the previous article on " Adding Identity to an existing table in SQL Server. Back ground is I want to add IDENTITY column to the which is already exisitng with valid data. Step 5: Rename the Column.
Me & My Little Techie.......: March 2009
http://dotnetvj.blogspot.com/2009_03_01_archive.html
Me and My Little Techie. A place to learn from Little Techie. Little Techie who is Microsoft Most Valuable Professional (MVP), Most Valuable Contributor (MVC), Most Valuable Member (MVM), Member of the Year. Tuesday, March 31, 2009. SQL Server Articles - March. DEFAULT value in SQL Server. Http:/ www.dotnetvj.com/2009/03/default-value-in-sql-server.html. MERGE in SQL Server 2005. Http:/ www.dotnetvj.com/2009/03/merge-in-sql-server-2005.html. Create Table Using Select in Sql Server. Http:/ www.dotnetv...
ShinyLight Development » Sources of Knowledge
http://www.shinylight.com/sources-of-knowledge
Web Development and Other Goodness in the World of a Software Engineer. Thought I'd share with everyone all my sources of knowledge. I sift through these daily on my iPhone. I try to cover the "competitive requirements" in my web design entry. My sources of knowledge are from:. My primary source of news. I check these out on my iPhone via Newstand. Adobe ColdFusion Developer Center: Recent tutorials. Alagad Technical Team Blog. Ben Nadel ColdFusion And Web Development Feed @ BenNadel.com. Dare Obasanjo a...
Test Emails in ASP.NET without a Mail Server
http://www.devcurry.com/2011/03/test-emails-in-aspnet-without-mail.html
Test Emails in ASP.NET without a Mail Server. Element configures the local directory for a Simple Mail Transport Protocol (SMTP) server. The. Is a directory where the application saves e-mail for later processing by the SMTP server. Make sure the directory exists before using it. That’s it. Test this setting using the following code:. This is a test mail". Cool ain’t it! Just make sure that if you are using IIS, it should have read-write permissions to this folder. Will you give this article a 1? Read yo...
Simple Image SlideShow using jQuery
http://www.devcurry.com/2010/03/simple-image-slideshow-using-jquery.html
Simple Image SlideShow using jQuery. I have seen a lot of users requesting for simple jQuery scripts for SlideShows. I saw a couple of them, but the scripts assumed that the number of image tags has to be fixed beforehand. The code given below is taken from my eBook “ 51 Recipes with jQuery and ASP.NET Controls. This code was written when jQuery 1.3.2 was the latest version available. Currently we have jQuery 1.4.2 available. Http:/ www.w3.org/1999/xhtml". Simple Image SlideShow /. Cnt = imgs.length;.
ASP.NET GridView Tips and Tricks Collection
http://www.devcurry.com/2010/11/aspnet-gridview-tips-and-tricks.html
ASPNET GridView Tips and Tricks Collection. ASPNET GridView is the most commonly used Data Control in the ASP.NET Control Toolkit. The forums are flooded with questions about using the GridView control. I thought of starting a new series of articles on the ASP.NET GridView control to help out fellow developers. I will be updating this page with new tips as frequently as possible. I plan to write 100 GridView tips. Covering the most frequently asked questions on the ASP.NET GridView. So Subscribe to RSS.
Write For Us
http://www.dotnetcurry.com/WriteForUs.aspx
JQuery and ASP.NET. Visual Studio and TFS. Download .NET Magazines. NET and JavaScript Tools. Guidelines for writing Articles on DotNetCurry.com. Please note that articles that involve guest posting with the the purpose of link exchanges/posting etc will not be considered. This is an educational website and the purpose is to spread knowledge and not to get involved in link baits. 1 Use this Template as a Starting point. It already uses the Title and Heading 1 styles. Use 9pt Font Consolas. 3 You provide ...
What is the AntiForgeryToken and why do I need it? - ASP.NET MVC 101 series
http://www.devcurry.com/2013/01/what-is-antiforgerytoken-and-why-do-i.html
What is the AntiForgeryToken and why do I need it? ASPNET MVC 101 series. This article is from our ASP.NET MVC 101 Tutorial Series. When we get started with projects, often our core focus is Domain and Business logic. We often slack up on the nitty gritty of securing our web input and sometimes it continues till a disaster strikes and at that point, it becomes a major PR as well as legal headache. Well today, we will look at a type of security breach in a web application that is called. How does it work?
TOTAL LINKS TO THIS WEBSITE
83
sqlserverconsulting.blogspot.com
SQL Server Stuff
Thoughts, opinions, prejudices and occasionally a useful tip or bit of code. Friday, January 25, 2013. There is really no point in having a blog if I am going to ignore it for years at a time. However, most of my writing time is taken up in writing my monthly SQL newsletter ( Get your FREE subscription here. And the occasional article for SQL Server Pro magazine. I have an archive of useful SQL Articles here. I am also putting up a new site, sqlperformancetuning.com. It will be on-line soon. There is onl...
sqlservercoolness.blogspot.com
SQL Server Coolness
I love SQL Server. As of Oct. 2010, I am also an MCITP:DBA for 2005! This is TSQL, SSIS, vbscript, and powershell code I've implemented. For professional SQL Server developers only. Tuesday, October 23, 2012. TSQL - Returning Random Numbers. Someone was updating a table with test data, and asked me how to fill a column with random numbers. I was sure rand() would do it. I was wrong:. It turns out that rand() generates only one number per statement, not per record. Boo. Crypt gen random (. You want to set...
sqlservercore.com
SQL Server Administration
Monday, August 26, 2013. Login failed for user 'Admin' with SQL 18456 State 5. A client receives error when running MS Access application and querying tables linked via ODBC. The error is:. SQL Server Error: 53. SQL Server Error: 17. Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. What shows up in the SQL log is:. Login failed for user 'Admin'. [CLIENT: xx.xx.xx.xxx]. Error: 18456, Severity: 14, State: 5. Change from 1 to 0. Thursday, June 21, 2012. That's for 2 re...
SQLServerCowboy « Dedicated to my SQL Server and VMware Adventures
Virtualization – Hyper-V , VMware and SQL Server. Dedicated to my SQL Server and VMware Adventures. Virtualization – Hyper-V , VMware and SQL Server. Short Tutorials Concepts Simplified. September 17, 2013 4:16 pm. Continuing from my previous blog post about icons! We shall now delve into another helpful topic series –. This is not your regular e-books. They have been crafted in a very lucid manner. One of the two favorites is from @ Syncfusion. 8216;s ebook library are. Windows Store Apps Succinctly.
SQL Server Tutorials and Tips
August 08, 2015. Memory Optimized Tables and Transactions in SQL Server 2014. Saturday, August 08, 2015 Posted by Pravinkumar Dabade. Labels: SQL Server 2014. In one of our previous articles “ SQL Server 2014 – InMemory Table, Indexes and Stored Procedures. 8221;, we saw how to create in-memory tables and indexes. We also saw how to use stored procedures to interact with these tables. There are number of Isolation Levels supported by transactions as described below –. 183; Snapshot Isolation. 8211; In th...
SQL Server - Dah
SQL Server - Dah. Wednesday, April 15, 2009. SSIS: from Flat File Source to OLE DB destionation, everyday problems. And Invalid character value for cast specification. Let’s, first, fight the truncation problem. So, I have a simple flat file TEST1.txt:. The file has 4 rows; the 1st row contains the field names; the “” symbol is a field separator; carriage return is a row separator; there are no values in row 3, column ‘BBB’, and no value in row 4, column ‘AAA’. And same for a column “BBB”). Error: 0xC020...
My daily SQL Server blog
My daily SQL Server blog. Thursday, January 10, 2008. January 10, 2008. Could not locate text information records for the column "SUBJECT", ID 9 during command construction. Source: MSSQLServer, Error number: 18773). The Log Reader Agent failed to construct a replicated command from log sequence number (LSN) {0001af22:0003gwae:002a}. Back up the publication database and contact Customer Support Services. (Source: MSSQLServer, Error number: 18805). Http:/ support.microsoft.com/kb/933519. January 8, 2008.
Security Certificate SSL
SQL Server Data SSL Certificate Coverage. You have arrived here from a Starfield Technologies certified site. This Multiple Site SSL certificate is assigned to SQLServerData.com and then provided for SqlServerData.com clients. Founded in 2003 Starfield Technology provides SSL certificates and is is an innovator in the field of Internet foundation services, providing advanced software and Internet solutions critical to the building of a strong online presence. What is an SSL Certificate? Symbolizes that t...
SQL Server 2008 Database Corrupted – Try SQL Server Database Recovery Tool
SQL Server Database Repair Tool Built to Perfection. SQL Server database repair application is amongst the most technically structured yet in-demand tools in the present time. Using this SQL Recovery. Excellence Featuring Attributes of SQL Server Database Recovery Tool. A wide range of highly qualitative properties have been featured in the SQL Recovery application. Have a look at the excellence of recovery the tool serves via these attributes in the following list of features:. Post the SQL Server datab...
SQL Server Database Recovery Tool to Restore, Retrieve and Repair SQL Database
SQL Server Database Recovery. Recover Safe and Secure SQL Server Database. Repair SQL server MDF file in short time. Retrieve SQL Database Completely and Quickly. SQL Server Disaster Recovery Software Supports all versions of SQL. SQL Server Database Recovery – Served The Way You Want. SQL Server Disaster Recovery Tool: Servicing Varied Assistance. O Bounds Regarding Size:. Has a strong capability of recovering corrupt database of any size ranging between MB, GB, and even TB which is a property owned by ...
SOCIAL ENGAGEMENT