SQL Server consolidation: Why it's an optimization
SQL Server consolidation benefits are high availability and lower licensing costs. Here's what to expect for hardware needs, system monitoring and SQL licensing.
The Financial Crisis
With the economy slowing the the world facing a financial crisis, Steve Jones polls the man on the street this Friday.
The Financial Crisis
With the economy slowing the the world facing a financial crisis, Steve Jones polls the man on the street this Friday.
The Financial Crisis
With the economy slowing the the world facing a financial crisis, Steve Jones polls the man on the street this Friday.
Big and Small
A great company will be big enough and small enough. Steve Jones talks about finding that balance.
Fixed Cost IT Management
One of the ways that some companies deal with the lack of a DBA is with remote DBA services or perhaps part time consulting. Robert Pearl brings us a short article explaining what these services can do for you.
SQL Server 2008 SSMS Enhancements - Debugging Support
Continuing on with his series on SQL Server 2008, MVP Jacob Sebastian brings us a look at the debugger, which has returned in SQL Server 2008.
Basic Set Functions: The BottomCount() Function, Part I
Isolate worst / lowest performers from the member population at large, and perform sophisticated analysis with BottomCount(). Join MSAS Architect Bill Pearson in the first of a pair of articles focusing upon the powerful BottomCount() function, where we experience “hands-on” some of the possible ways it can offer multi-perspective decision support.
Importance of Database Backups and Recovery Plan
As a DBA you need to ensure that the databases you manage are backed up regularly. This article details the importance of database backups and a recovery plan
Moving to the Heartland
With companies like Microsoft and Google building data centers in small towns, Steve Jones has some comments about how this might affect IT jobs.
Blogs
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...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
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