Raw Materials - Disapproval
: "It is a narrow mind that cannot see things from more than one point of view." —George Eliot
Top 10 Index T-SQL Statements That SQL Server DBAs Should Know
Indexes speed retrieval of rows from database tables or views. Here are the top index-related T-SQL statements that SQL Server DBAs should know.
Cloud Barriers
I'd like to hear the thoughts of DBAs out there on Windows and SQL Azure, and the prospects of moving applications and databases into the clouds. How many DBAs work for companies that have done it or are seriously considering it? What are the deepest concerns?
Independence Day 2011
A holiday in the US has most people away from work. Steve Jones leaves you a few thoughts and humor from his vacation.
Remove HTML tags from strings using the SQL Server CLR
It is recommended that you remove all special characters and HTML formatting. This task can be handled in TSQL code, however in this case I have the opportunity to use .NET and the power of the regular expressions to manage the string. In this tip, I'll build a CLR function which cleans up a string of HTML tags and special characters. I'll use Visual Studio 2010 with C# as the programming language. Check out this tip for my solution.
SQL Server Service Broker Security
Arshad Ali examines the different types and different layers of security that SQL Server Service Broker provides during communication and while accessing Service Broker objects.
Sabbaticals
This editorial was originally published on Oct 25, 2005. Steve Jones talks about the idea of a sabbatical from work and the problems that might ensue if you haven't properly planned it.
SQL Overview Part 1
Monitoring your SQL Server instances and figuring out what's going on is important to keep an eye on your environment. David Bird brings us a new series that looks at how you might start setting this up with Integration Services.
SQL Server 2008 and 2008 R2 Integration Services - FTP Task
FTP Task lets you copy files across distributed, frequently incompatible systems.
A Little Interviewing Advice
This editorial was originally published on October 20, 2005. It is being reprinted as Steve is on vacation. I know there was a great uproar over the interview piece at the beginning of this week and I received lots of opinions on various parts of the article, good and bad to go over. But one […]
Blogs
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers