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.
Beginning SQL Server 2005 Reporting
In Part 1 of this article, we looked at the basics of SQL Server Reporting Services 2005 (SSRS). We built one report with the Report Wizard, and one report using the Report Designer. In Part 2, we are going to look in more depth at the features that you can use everyday as an SSRS developer.
Blogs
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
Forums
Rethinking How We Approach Assignment Help
Assignments aren’t just tasks to submit—they’re opportunities to build understanding, discipline, and problem-solving skills....
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers