Hyper-V Guests
To what extent should a hypervisor company support other software? Will this have implications for cloud computing, or services used in software? Steve Jones comments.
Linqpad and StreamInsight
Slightly before the announcement of StreamInsight being available for Linqpad I downloaded it from here. I had seen Roman Schindlauer demonstrate it at Teched and it looked a really good tool to do some StreamInsight dev. You will need .Net 4.0 and StreamInsight installed.
Notes from Mirroring Deep Dive Session with Mohammed Sharaf: Microsoft Premier Engineer (I can never learn enough about Mirroring :)
One thing I have gotten wrong before, or not elaborated on before in presentations on mirroring, although Roman Rehak mentioned...
Wait statistics, or please tell me where it hurts
How many times have you walked up to a SQL Server that has a performance problem and wondered where to start looking?
We Are Not a Meritocracy
Today Steve Jones reminds us that talent and technical skills are not necessarily enough to advance your career and that you ought to remember to work on other types of skills that you may want to improve.
Do IF statements cause recompiles?
I heard this one over at SSC a while back. “Avoid IF statements in stored procedures as they result in...
Upgrading Data Tier Applications in SQL Server 2008 R2
Changes are inevitable and like many other things in life your application will change over time. The question is how to upgrade an already deployed Data Tier Application to a newer version; what are the different methods available for upgrade and what considerations should you take?
SQLServerCentral Webinar Series #6: Gathering and Interpreting Server Metrics including SQL Monitor
In this webinar, MVP and noted author, Grant Fritchey shows you how to better keep track of what is happening on your instances by gathering information on performance from SQL Monitor and then using that to interpret the impact on your databases. Dec 14, 2010.
The Low End
Today Steve Jones talks about those products we consider "low-end." Products like Access or VB. Are they a problem for us?
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
TempDB Facts I
Comments posted to this topic are about the item TempDB Facts I
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers