Writing Simple Select Statements - Part 2
In this second part video from Kathi, she covers how to write T-SQL in much more indepth. She covers how to handle NULLs and many more items in this video.
Reporting Services 2005 101 using Web Client
Continuing with his series on different aspects of Reporting Services, Asif Sayed examines the next installment with a step by step tutorial demonstrating the power of locally processed Reporting Services with the ASP.NET Web Client.
Dealing with Database Concurrency Conflicts in the Real World
Database concurrency conflicts are somewhat of a plague in software development because they're hard to predict and handle. Unfortunately, they're also hard to prevent.
Stress Testing SQL Server
Properly sizing your SQL Server hardware and testing application loads against them is a complex and difficult topic. Anthony Bressi brings us a great new article that gives you a systematic approach to performing your own stress test.
Executing predictions from the SQL Server relational engine
This tip shows you how to execute and use the results of prediction queries in multiple ways within the SQL Server relational database engine.
Self Eliminated Parameters
Optional parameters are easily handled with NULL values in T-SQL, but there are cases where this doesn't always work. Alex Grinberg brings us a new technique to allow your stored procedures to be structured to deal with this situation without dynamic SQL.
Small business tool makes SQL backup fast, simple and economical
Red Gate Software is releasing a low-cost version of its best-selling SQL Backup tool that makes data protection for small businesses fast and simple.
SQL Server 2005 Large Value Data Types
Microsoft has come to the rescue for managing large text fields in SQL Server 2005, by creating a few new large value data types. This article explores these new data types.
Managing DTS packages - Editing, Scheduling, and Viewing Package Logs
In the second of a series of articles that targets the DBA new to an organization, this article looks at how to manage DTS packages.
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
SQL Art, Part 2: New Year Fireworks in SSMS
Comments posted to this topic are about the item SQL Art, Part 2: New...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers