Personal Privacy
A new technique to help anonymize medical research data has been developed, and could help with other types of data, but there is an issue.
Sending HTML Newsletters in a Batch Using SQL Server
Sending a large volume of emails can put a strain on a mail relay server. However many people using SQL Server will need to do just that for things like newsletters, mailing lists, etc. Satnam Singh brings us a way to spread out the load by sending newsletters in multiple batches instead of one large process.
Using dates, and times in SQL Server: a workbench approach
In this workbench, Robyn Page provides a gentle introduction to the use of dates in SQL Server. In this new version of her article, it is brought up to date with the newer Datetime features in SQL Server 2005 and 2008.
SQL Connections 2010
This year SQLServerCentral is sponsoring another track at the SQL Connections conference in Las Vegas.
Time Bomb Design - A Longer Fuse
In a sequel to his first article on Time Bomb Design, David Poole examines the issues we find between development environments and production ones.
SQL Server MasterClass with Kimberly Tripp and Paul Randal
If you will be in London on June 17th, this is an event you do not want to miss.
Working with Spatial Data Part IV - Developing a Geospatial Dashboard (GIS)
In Part IV of the Geo-Spatial series, an interactive dashboard is developed to present and interact with the data.
Query-generated Column Expressions
A technique from Bill Nicolich that allows you to target columns by data type for the same custom expression and easily build complex queries.
The Death March
Are you working too hard? Is it worth it? Steve Jones says that it is not and that you should push back.
Showplan Operator of the Week – BookMark/Key Lookup
Fabiano continues in his mission to describe the major Showplan Operators used by SQL Server's Query Optimiser. This week he meets a star, the Key Lookup, a stalwart performer, but most famous for its role in ill-performing queries where an index does not 'cover' the data required to execute the query. If you understand why, and in what circumstances, key lookups are slow, it helps greatly with optimising query performance.
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
Forums
BCA KCP Pluit Samudra No. Telp:083831617937
Whatsapp.083831617937 Jl. Pluit Samudra No. 9 Blok N Kav. 5 Jakarta Utara, DKI Jakarta,...
BCA KCP Pluit No. Telp:083831617937
Whatsapp. 083831617937 Jl. Pluit Timur Blok L Barat Kav. 41-42 No.12A-14 Jakarta Utara, DKI...
BCA KCP Prima Sunter No. Telp:083831617937
Whatsapp.083831617937 Ruko Prima Sunter, Jl. Danau Sunter Utara No.A2-A3 Jakarta Utara, DKI Jakarta, Indonesia...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers