Contract Coding: Ensuring your Client pays up
Damon Armstrong learned the hard way about the consequences of not having a clearly defined project scope or work contract
SQL Server Spotlight on Jerome Halmans
The SQL Server memory manager is one of the more complicated parts of SQL Server and we had the chance recently to talk to the person that ensures it runs as smoothly as possible. Get to know the man behind the SQLOS.
Calculating financial values in SQL Server
SQL Server 2000 and 2005 do not include much in the way of financial functions, but there are many sources for the formulas for financial calculations. In this tip, I present the present value (PV) and future value (FV) functions, both of which are scalar UDFs.
Writing Simple Select Statements - Part 3
In this video, Kathi continues her T-SQL series and exands how to use the WHERE clause.
Get Your SQL Server Standard Electronically
We've moved the subscriptions for the SQL Server Standard to it's own site and just completed the November issue. Read on for how to access your subscriptions or subscribe today.
Last Chance to Save
This is the last week to register for the PASS 2006 Summmit in Seattle and save $300. Read on about what you'll be missing if you don't get up there.
SQL Server DATE/TIME Workbench
The definitively "hands-on" guide to handling dates and times in SQL Server
Data Warehouse Loading
Data warehousing is becoming more and more popular, especially as companies seek to leverage the information stored in various systems to improve their business processes. Warehousing expert Vincent Rainardi brings us the next installment of his series on data warehousing, examining the issues of loading data.
Introducing Actions in Analysis Services 2005
In this and the related articles, we will overview Actions in Analysis Services 2005. Much as they did in the previous version of Analysis Services, Actions allow information consumers to go beyond the robust OLAP perspective offered by Analysis Services, and to "step outside" for related information, or to generate commands or initialize programs, without leaving their current analysis focus.
Indexes and Fragmentation in SQL Server 2000 Part 1
How do your indexes perform under different fragmentation levels in SQL 2000? Joe Doherty brings us part 1 of his look at this topic with an examination of how your data is stored and a detailed analysis of DBCC SHOWCONTIG.
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers