The Breakfast Plan Goes Awry
A simple motivational plan goes sideways in this guest editorial from Andy Warren.
Performance Counter DMV sys.dm_os_performance_counters
By querying a single DMV, sys.dm_os_performance_counters to be precise, you can collect counter information that you would receive from PerfMon for the various SQL Server counters.
How the Resource Governor Helped Our Report Server
Trying to manage the load in a reporting server can be hard. Roy Ernest shows that Resource Governor might be a great solution that has worked in his environment.
Kudos to the Community
Steve Jones takes a day to thank everyone that donates their time to help others in the community.
The Great Forum Debate
Phil discusses the pros and cons of the traditional versus stack overflow-style model for forum debate, and wonders whether there is a database model that would support all these different forms of discussion, or cooperative work, so that we can simply fit the 'visualization' to the nature of the particular discussion.
TSQL Challenge 33 - Calculate list of bookings fully paid on the book
This problem is related to a reservation system where customers book a service and pay it in one or more transactions which may happen on different dates.
Operator of the Week - Lazy Spool
Continuing to illuminate the depths of SQL Server's Query Optimizer, Fabiano shines a light on the sixth major Showplan Operator on his list: the Lazy Spool. What does the Lazy Spool do that's so special, how does the Query Optimizer use it, and why is it so Lazy? Fabiano Amorim explains all.
The Phantom DBA
This week Steve Jones has a poll about the difficulties in getting the DBA position into companies. What's your current opinion of this profession?
SSAS: Explaining the State Transitions Viewer for Sequence Clustering
In SQL Server 2005 and SQL Server 2008, Microsoft has added some fantastic visualizations around data-mining algorithms. These visual aids allow us to see exactly what a particular algorithm is predicting or describing—making a difficult subject easier to understand.
Concurrent processing in SSIS – Part 2
The second part of a series that looks at two additional techniques for processing data in parallel in Integration Services.
Blogs
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
PowerShell Strikes Back: Know Your Quotes, Young Padawan
By gbargsley
This is Week 1 of PowerShell Strikes Back – a four-week May series for...
A Redgate Data Modeler Gotcha with Relationships
By Steve Jones
This happened to me recently after being busy with non-data modeling tasks for a...
Forums
BCA KCP Buaran Raya HUB.Tlpn.0821•3111•185
BCA KCP Buaran Raya HUB.Tlpn.0821•3111•185 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101,...
BCA KCP Pondok Bambu HUB.Tlpn.0821•3111•185
BCA KCP Pondok Bambu HUB.Tlpn.0821•3111•185 Pondok Bambu Center, Jl. Pahlawan Revolusi No.30 Blok A/5-6,...
BCA KCP Kramat Jati HUB.Tlpn.0821•3111•185
BCA KCP Kramat Jati HUB.Tlpn.0821•3111•185 Jl. Raya Bogor No.19, RT.1/RW.4, Wil, Kec. Kramat jati,...
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