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.
Personal Privacy
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.
Sending HTML Newsletters in a Batch Using SQL Server
Sending a large volume of emails can put a strain on a mail relay server. However many people using SQL Server will need to do just that for things like newsletters, mailing lists, etc. Satnam Singh brings us a way to spread out the load by sending newsletters in multiple batches instead of one large process.
Using dates, and times in SQL Server: a workbench approach
In this workbench, Robyn Page provides a gentle introduction to the use of dates in SQL Server. In this new version of her article, it is brought up to date with the newer Datetime features in SQL Server 2005 and 2008.
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCU PEKANBARU Telpon/wa:0821°8168°291
BCA KCU PEKANBARU Telpon/wa:0821°8168°291.Jl. Jend. Sudirman No.448, Tanah Datar, Kec. Pekanbaru Kota, Kota Pekanbaru,...
BCA Finance WTC Mangga Dua Call CSO; (+62 821°3111°179
Gedung WTC Jl. Mangga Dua Raya. 8 Lantai 6, Blok CL 001, RT.CL, Jl....
BCA KCP Taman Sari TLP/Wa 08216977749
Jl. Taman Sari Raya 47-47A, Taman Sari, Kec. Taman Sari, Kota Jakarta Barat, Daerah...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers