Learning SQL Server - Efficient Query Writing Strategy - Gift Book(blog.sqlauthority.com)

submitted by pinaldave(9662) 9 months, 23 days ago

Some people may push back on this next technique or misunderstand until getting to the very end. The goal is to have fewer errors as you write complex queries more quickly by making sure the easy stuff works first. read more...

2 comments |category: Database |Views: 80

tags: Database another

Find Nth Record Quickest Way in SQL Server(blog.sqlauthority.com)

submitted by pinaldave(9662) 10 months ago

A Very simple tutorial to find Nth Record. A Quick Tutorial. read more...

add a comment |category: Database |Views: 7

tags: Database another

Database Worst Practices – New Town and New Job and New Disasters(blog.sqlauthority.com)

submitted by pinaldave(9662) 10 months, 15 days ago

Instead of writing best practices, I am going to write about few of the worst practices which I have quite often seen in the real world. Some of them are really bad that I often wonder how those who still use them were able to continue on the job so far. Let us go over few of the worst practices I have observed in the industry. read more...

1 comment |category: Database |Views: 211

tags: SQLAuthority SQLServer SQL Database pinaldave another

Two Simple Puzzles - Tease Your Brain - Win Knowledge and Gift(blog.sqlauthority.com)

submitted by pinaldave(9662) 10 months, 27 days ago

Today I have two simple T-SQL Puzzle. You can answer them and win USD 25 Gift card. The gift card will be sent in email to winner. You will get choice of Gift Card brand based on your preference and country location. read more...

add a comment |category: Database |Views: 88

tags: SQLAuthority SQLServer SQL Database pinaldave another

SQL Puzzles and Interesting Solutions(blog.sqlauthority.com)

submitted by pinaldave(9662) 10 months, 29 days ago

List of all the interesting puzzles and interesting solutions on my blog. read more...

add a comment |category: Database |Views: 152

tags: Database SQLServer SQLAuthority SQL another

How to Securely Verify and Validate Image Uploads in ASP.NET and ASP.N(www.aaronstannard.com)

submitted by Aaronontheweb(1140) 11 months, 2 days ago

How do you verify that content that your users are uploading to your ASP.NET site are just harmless images and not something malicious? Use GDI+ to validate that images are images and nothing else! read more...

add a comment |category: ASP.NET |Views: 23

tags: ASP.NET another

Solution – Generating Zero Without using Any Numbers in T-SQL(blog.sqlauthority.com)

submitted by pinaldave(9662) 11 months, 6 days ago

Generate Zero without using any numbers. An Interesting Puzzle and its solution. read more...

add a comment |category: Database |Views: 149

tags: SQLAuthority SQLServer SQL Database pinaldave another

SELECT * gives error when executed alone but SELECT COUNT(*) does not.(blog.sqlauthority.com)

submitted by pinaldave(9662) 11 months, 26 days ago

Try running SELECT * it will throw an error. Try running SELECT COUNT(*) it will not throw an error. Why? Read, Learn and Participate! read more...

add a comment |category: Database |Views: 101

tags: SQLAuthority SQLServer SQL Database pinaldave another

Building a jQuery Plug-in to make an HTML Table scrollable(www.west-wind.com)

submitted by rstrahl(7226) 11 months, 29 days ago

Table displays in limited space require some rendering alternatives. While paging is a common way to address fixed size displays, it's not an end-all solution. Sometimes it's necessary to display larger amounts of data in a small fixed space on an HTML page. Scrollable list are fairly easy to do with most HTML structures, but HTML tables are notoriously difficult to manage when it comes to scrolling. In this post I describe a jQuery plug-in that attempts to make any table scrollable by decomposing and reassembling the table into two distinct areas. read more...

add a comment |category: ASP.NET |Views: 31

tags: jQuery html ASP.NET another

Copy Database from Instance to Another Instance – Copy Paste in SQL Se(blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year ago

SQL Server has feature which copy database from one database to another database and it can be automated as well using SSIS. Make sure you have SQL Server Agent Turned on as this feature will create a job. The same job will execute the task. Make sure that SSIS is properly configured as well with necessary security permissions. You can automate this process as well control error logging. Following are the steps to copy database from one instance to another instance. read more...

add a comment |category: Database |Views: 43

tags: SQLAuthority SQLServer SQL Database pinaldave another

Built-in GZip/Deflate Compression on IIS 7.x(www.west-wind.com)

submitted by rstrahl(7226) 1 year ago

IIS 7.x makes content compression via GZip very easy. Here's how compression on IIS works and how you can set it up on your server in a few simple steps. read more...

add a comment |category: ASP.NET |Views: 40

tags: ASP.NET another

Expression Blend Book(www.developingfor.net)

submitted by CharlieCalvert(7875) 1 year ago

In progress read more...

add a comment |category: Windows Presentation Foundation |Views: 8

tags: WPF another

ASP.NET GZip Encoding Caveats(www.west-wind.com)

submitted by rstrahl(7226) 1 year ago

GZip and Deflate compression is easy to use in ASP.NET applications, but there are a few caveats that you need to watch out for. This post reviews the basics of implementing compression in ASP.NET code and describes a couple of scenarios that can cause problems when using programmatic compression via Response.Filter. read more...

add a comment |category: ASP.NET |Views: 7

tags: ASP.NET another

Pluralsight On-Demand FREE for SQL Server Course(blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year, 1 month ago

Learning is always difficult. After learning how to apply your knowledge, learning in real life is even more difficult. Technology is moving faster than the speed of light and new technologies are always emerging – this is now the reality of the new technology world. Between all of this, I personally have very little time to learn new technology. I do not like eBooks (this statement warrants a whole new blog posts – some other time), I prefer regular books. It is becoming more and more difficult to carry around the books and read them with passion. It happened to me once that by the time I finished the book, there was a new version of the product out in the market. read more...

add a comment |category: Database |Views: 77

tags: SQLAuthority SQLServer SQL Database pinaldave another

Query to Recent Query on Server with Execution Plan Function(blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year, 1 month ago

A quick script to get recently ran query. read more...

add a comment |category: Database |Views: 210

tags: SQLAuthority pinaldave SQLServer Database SQL another

ASP.NET Routing not working on IIS 7.0(www.west-wind.com)

submitted by rstrahl(7226) 1 year, 1 month ago

Got caught be a difference in behavior between IIS 7.0 and IIS 7.5 with how module management to extensionless URLs are fired in IIS. Routing was working fine on my dev machine, but not on my live server. Here's what you need to watch out for. read more...

add a comment |category: ASP.NET |Views: 24

tags: ASP.NET another