Please don’t Tweet this, but…
Brad worries that with the advent and growth of social media, has come an increasing concern that today's private conversation may turn into tomorrow's world-wide Tweet.
TSQL Challenge 38 - Calculate SQL Stars awarded to the Winners of TSQL
This challenge involves parsing a delimited string and applying some logic to perform some calculations based on the position of tokens within the string.
Rebuilding Indexes using the SSMS Database Maintenance Wizard
Index fragmentation can cause problems with query performance. Indexes therefore need to be occasionally rebuilt. the Rebuild Index task of the SSMS Database Maintenance Wizard drops and rebuilds every index in a database. It is effective but an off-line activity that is resource-intensive, so it not always the best way of avoiding index fragmentation in a production database. Brad explains..
Introduction to SQL Server Statistics
A free virtual chapter presentation by Andy Warren on Sept 7, 2010 at 12:00EDT. This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more!
Sending scheduled SQL query results via HTML e-mail using SSIS
Send SQL query results as HTML-formatted e-mail using SQL Server Integration Services.
SQLBits - The 7 Wonders of SQL
Last day for early bird registration for the next SQLBits conference on Sept 30th-Oct 2, 2010 at York University. SQLServerCentral has a discount code if you'd like to attend.
Automatic Restart of SSIS packages after Failover or Failure
SSIS makes it possible to minimize work lost by starting after the last successfully executed control flow task upon restarting a failed package. From there, one challenge many seek to overcome is automatically restarting that package at that point without any manual intervention. This would make it possible for your SSIS packages to be running, your cluster to failover, and your SSIS packages to restart and complete without you having to respond to the failover and restart them.
SQL or MDX query trace in SSRS - trick of imagination or a real thing?
I sometimes have ghost memories - I remember some things that had never in fact happened. And I was wondering if ...
SQL Saturday #50 - East Iowa
Come to a SQL Saturday in Iowa City on Sept 18, 2010 and get a free day of training from the SQL community.
Blogs
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
Forums
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Secure Communications
Comments posted to this topic are about the item Secure Communications
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers