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?
For a limited time, you can download this 10-chapter e-book: Introducing Microsoft SQL Server 2008 R2, by Ross Mistry and Stacia Misner.
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.
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
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.
Today we have a guest editorial from Andy Warren that asks about your hobbies, and would you trade your job for one of them?
Windows PowerShell v2 introduces self-contained “modules,” making it easier to share scripts with reusable functions, custom format views or type extensions.
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.
A new technique to help anonymize medical research data has been developed, and could help with other types of data, but there is an issue.
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
Comments posted to this topic are about the item A Fun Computer Quote
I've read a few posts regarding what we use to design DB models and...
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers