Sharing Your Scripts - Made Easy
Windows PowerShell v2 introduces self-contained “modules,” making it easier to share scripts with reusable functions, custom format views or type extensions.
2010-05-28
2,789 reads
Articles
SQL Saturday #22 - Pensacola
A free one day training event from SQL Saturday and the Pensacola SQL Server groups. Come join Steve Jones and Brad McGehee if you are in the area on Jun 5, 2010.
2010-05-28 (first published: 2010-05-10)
2,335 reads
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.
2010-05-27
9,655 reads
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.
2010-05-27
5,598 reads
SQL Connections 2010
This year SQLServerCentral is sponsoring another track at the SQL Connections conference in Las Vegas.
2010-05-26
165 reads
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.
2010-05-26
10,633 reads
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.
2010-05-26
2,090 reads
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.
2010-05-26
2,913 reads
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.
2010-05-25
8,674 reads
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.
2010-05-25
2,537 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers