A Google-like Full Text Search
Implementing searching in your database is always a challenge and MVP Michael Coles brings us a method of building a Google-like search for SQL Server.
Getting the Message
Regardless of the speed of your SQL routines there comes a time, for any server-based system, when you need to think "parallel" and "asynchronous". So why, Phil Factor wonders, does there seem to be so little interest in Service Broker?
Free e-book: Introducing Microsoft SQL Server 2008 R2
For a limited time, you can download this 10-chapter e-book: Introducing Microsoft SQL Server 2008 R2, by Ross Mistry and Stacia Misner.
Running SQL Server Jobs using a Proxy Account
Proxy accounts are a useful tool to enable teams to work independently allow users who do not have administrative access to SQL Server to run jobs.
TSQL Challenge 31 - Managing multiple overlapping date intervals.
This challenge is adapted from a budgeting system used in a large company to perform quarterly analysis of what kind of work will be done and where it will be done. Project Managers make plans and the estimated hours of work required from each employee each month end up in a central database. Top managers want to see a synthesis of this by department and profession
Transaction Log Growth, do you need it?
One of the most common questions asked about SQL Server has to do with the transaction log and why does it grow. James Rea brings us a good explanation here of what happens and what you should do about it.
Would You Do Your Hobby for a Living
Today we have a guest editorial from Andy Warren that asks about your hobbies, and would you trade your job for one of them?
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.
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.
Blogs
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers