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.
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.
This year SQLServerCentral is sponsoring another track at the SQL Connections conference in Las Vegas.
In a sequel to his first article on Time Bomb Design, David Poole examines the issues we find between development environments and production ones.
If you will be in London on June 17th, this is an event you do not want to miss.
In Part IV of the Geo-Spatial series, an interactive dashboard is developed to present and interact with the data.
A technique from Bill Nicolich that allows you to target columns by data type for the same custom expression and easily build complex queries.
Are you working too hard? Is it worth it? Steve Jones says that it is not and that you should push back.
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.
IBM has this tagline about a smarter planet and has a great video about the Internet of Things. Steve Jones looks at some of the issues we might have in actually using all this data.
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Comments posted to this topic are about the item Limit the Blast Radius
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers