(Marcin Policht) In the first few installments of our series dedicated to SQL Server 2005 Express Edition, we have presented an overview of its main characteristics that distinguish it from Compact, Workgroup, Standard, and Enterprise-level products, documented its basic installation process, and de
Other News
LINQ to SQL (Part 8 – Executing Custom SQL Expressions)
(Scott Guthrie) One of the questions a few people have asked me since doing these posts has been “what if I want total control over the SQL expressions used by LINQ to SQL – but I don’t want to use SPROCs to-do it?” Today’s blog post will cover that – and discuss how you can use custom SQL expressi
sys.dm_db_index_operational_stats
(Louis Davidson) This object provides very useful stats on how many times an index has been used, locked, waited on, etc. An index in this context can mean several things: a clustered index, heap, index, or a partition of either of these. The grain of the function is down to the partition level, so
How Do I… Restore a SQL Server database to a new server?
(Steven Warren) As a DBA, I have been in many situations where I had to move databases to a new server due to old hardware, failed hardware, failed drives, etc. You have two options you could use to carry out this task: SQL Server Management Studio (GUI) T-SQL (Command line)
Debug SQL stored procedures with IBM Database Add-ins for Visual Studio 2005, Part 3: Debug C# applications and DB2 SQL stored procedures with IBM Database Add-ins for Visual Studio 2005
(Eric Johnson) Combine debugging C# applications with SQL stored procedures, in Part 3 of this series. Parts 1 and 2 of this series were about debugging SQL stored procedures on their own. (R)
Getting to Know the SQL Server 2005 Compact Edition Tools
(Prashant Dhingra and Trent Swanson) One main limitation of the SQL CE 2.0 database released in 2002 was the need to manage the database either using a query analyzer tool on mobile devices or by running a program to manipulate data on a device. To allow rapid application development, Microsoft has
Heading to SQL Server Connections in Vegas in November?
Catch the Latest Weekly SQL Server Show Here Watch SelectViews, posted Friday, with another episode posting tomorrow. Watch here. Featured Article(s) Standard Operating Procedure I alluded to SOPs or Standard Operating Procedures in an article earlier and Sean Maloney was kind enough to mention that this is really something that I could expand on. In short, anyone could pick up […]
Legacy SQL Server Application Upgrades
Featured Article(s) Tips for using SQL Server 2005 Merge Replication (Part 2) Here are some helpful tips to performance tune and optimize SQL Server 2005 Merge Replication. I Can Hear the Users Now: "We Want (More) Reports!" Egad. Building reports and writing the applications to produce them, get them to the users and let them tweak them with parameters and […]
ScriptManager Enables AJAX In Your Web Apps
(Ben Rush) Today the consumer of a Web site can be as responsible for its content, direction, and success as the publisher. Social networking sites, blogs, online photo journals, and wikis are just a few of the new styles of Web sites springing up every day, and it’s just the beginning. Your Web sit
TechTip: Handling SQL Return Codes, Part II
(Sam Lennon) In a previous TechTip, I encouraged you to do stringent error-checking on SQL return codes. In this TechTip, I suggest a standard error-handling routine for those SQL return codes you don’t expect. I also provide template program SQL_SKELR, which you can clone as a beginning for many of