The Afternoon Whistle
Today we have a guest editorial from Andy Warren. Balancing work and life is a challenge, and today Andy looks at one way that has helped him to manage his hours and learn to get away from work.
DBA.Sleep(8hrs)
I have been pondering recently what helps me to sleep at night. Or, conversely, what prevents me from sleeping at...
Striping SQL Server Database Backups
As databases get larger, the time for database backups to complete grows as well. Unfortunately, the time window for your backups may not increase. It could very well be the case that you reach a point where your backups will not finish in a specified amount of time.
Import Excel Spreadsheet to Database Tables
Importing Excel Spreadsheets is something that we often do with SQL Server. However it's not as easy as you would like as we move to the 64 bit platform. Peter He brings us a method that will work on all platforms.
The R2 Penalty
An interesting point was made by a reader about the price of SQL Server licenses when R2 is released. Steve Jones comments about a penalty that some of you may find if you look to build a SQL Server 2008 server later this year.
Database Level Auditing with Microsoft SQL Server 2008
MAK shows us how easy it is to create a database level audit, test the audit and retrieve the audit records in Microsoft SQL Server 2008.
Managing Analysis Services Deployment - Part 1
In part 1 of this series, Shahfaisal Muhammed brings us one method of deploying your SSAS projects to a new server. The rest of the series will cover other methods.
Professional Microsoft SQL Server Analysis Services 2008 with MDX - Sample Chapter
A sample chapter from a new book on Analysis Services. Check it out and see if this is the book for you.
The Average Joe
Most of us, by definition, are average. That's fine most of the time, but when you want a new job, standing apart from the average Joe is a good idea. Steve Jones talks about working on standing apart from the crowd.
President's Day 2010
A holiday in the US has Steve Jones on the slopes. A short reminder of patches released last week is the editorial today.
Blogs
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers