Get this book from Amazon.com, written by members of the DotNetNuke Core Team. Shaun Walker, Patrick Santry, Joe Brinkman, Scott Willhite, Dan Caron, Scott McCulloch, Bruce Hopkins
Order your copy now at Amazon.com
Steve Walcher
In FULL recovery mode it is possible to do a point-in-time restore of a database. It is thankfully a rare event. Tony explains what's involved
Revisiting his very popular article on the running total and ordinal rank problems, MVP Jeff Moden brings us a detailed analysis of how you might want to implement a solution in T-SQL.
In this tip, we will see how to build a report which shows the cumulative sales amount for the current month, current quarter (QTD) and current year (YTD) in a single crosstab (tablix) report, which makes it easy to compare the data.
Do you use or need a database process framework? Read on to see if this is something that might help you build better database software processes.
A robot's reaction may be a little different from yours or mine.
Every so often, the question comes up on forums of how to pass a list as a parameter to a SQL procedure or function. Phil Factor provides some examples using XML, and tests them against other popular methods.
Examines the proxy subsystem, which allows job steps to impersonate another user account in order to perform tasks as a user other than the SQL Server Agent service account. This is especially useful when you want jobs to run as lower privileged users of your SQL Server.
I recently encountered a situation where the drive hosting Sharepoint Databases in a Staging environment ran out of space. I logged onto the server and found that the msdb database has itself occupied 38 GB of the total disk space. Msdb database generally contain maintenance information for the database such as backups, log shipping and so on.
We'd like to better understand the kinds of database related development tasks that you perform, so that we can ensure our tools are helping you to be more productive.
Come see Brad McGehee, Grant Fritchey, Steve Jones, and more SQL Server speakers at the SQL Server Connections conference in Las Vegas this spring. Get away from the cold on Mar 26, 2011 and learn about the new version of SQL Server.