Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL » Application Development   (RSS)
Wednesday, September 16, 2009 1:41 PM

SQL Server Connection Leak Simulation Tool

Sometimes it’s necessary to test application performance in low available resource situations… I’ve seen tools that simulate low available memory, do network throttling, etc., but I have not come across one that simulates a lot of SQL Server connections
Posted by irenak | 0 Comments
Attachment(s): SQLConnectionLeak.zip
Sunday, August 05, 2007 5:06 PM

SYSK 359: How to Purge Workflow Tracking Data Inserted By SqlTrackingService

To my great surprise, after doing a search for a script that would delete the events logged by the almighty SqlTrackingService service, I didn’t find one… So, I quickly created it (see below), and it seems to do the job just fine given the current table
Posted by irenak | 1 Comments
Friday, January 26, 2007 5:02 AM

SYSK 275: Pagination in SQL – Easy!

Unfortunately, it’s still a common case that the pagination logic resides in UI… Why I say ‘unfortunately’? Because by making this design choice, you have: Used up bandwidth transmitting the data that may never be seen by the end user. Potentially, are
Posted by irenak | 6 Comments
Monday, October 16, 2006 5:32 AM

SYSK 219: Solution for SQL Reporting Services Problem Described in SYSK 203

In http://blogs.msdn.com/irenak/archive/2006/09/22/766164.aspx post, the following problem was described: if you have a SSRS report parameter that is multi-value and of one of the label s in the “available values” list exceeds 25 characters , the dropdown
Posted by irenak | 5 Comments
Friday, September 29, 2006 5:27 AM

SYSK 208: Slow Running SQL Queries? Here are possible reasons…

There are several reasons that could cause a query or updates to take longer then expected. This could be due to network issues or it could even be due to the database design itself, but most of the time slow running queries are caused due to: Network
Posted by irenak | 0 Comments
Friday, September 22, 2006 6:50 AM

SYSK 203: Mind That Label Length in SQL Reporting Services

Another possible (but unconfirmed) bug in SQL 2005 Reporting Services: If you have a SSRS report parameter that is multi-value and of one of the label s in the “available values” list exceeds 25 characters , the dropdown list with values for this parameter
Posted by irenak | 1 Comments
Thursday, August 31, 2006 7:02 AM

SYSK 189: The Footprint of SQL Everywhere

The message is everywhere -- need an in-proc relational database for your “occasionally connected” mobile or desktop application, capable of query processing, transactions, persistence, and much more? Then consider using SQL Everywhere Edition of Microsoft
Posted by irenak | 2 Comments
Monday, August 14, 2006 5:55 AM

SYSK 177: Formatting Numeric Data with Comma and Decimal Separators in SQL

The other day I was asked whether it’s possible to format numeric data to have commas every three digits to the left of the decimal point, and two digits to the right of the decimal point using SQL Server, e.g. 5000.125 to 5,000.13. The solution is quite
Posted by irenak | 1 Comments
Friday, August 04, 2006 6:26 AM

SYSK 171: MSDE Will Not Be Supported on Vista

Yes, it is true – Microsoft SQL Server 2000 Desktop Engine (MSDE) will not be supported on Windows Vista. So, if you’re using MSDE in your applications, consider migrating to SQL Server 2005 Express Edition (SQL Express) at the earliest opportunity. You
Posted by irenak | 5 Comments
Thursday, July 27, 2006 6:33 AM

SYSK 165: Are You Encrypting Your Stored Procedures?

If you’re concerned about unauthorized users looking at the business logic implemented in SQL stored procs (e.g. deploying database to client computers or using a shared SQL server), this blog is for you. SQL Server can encrypt the following components:
Posted by irenak | 4 Comments
 
Page view tracker