SQL Server upgrade paths: What to do before, during, after upgrading
Creating SQL Server upgrade paths from one version to another is a task that every database administrator is eager to...
2013-08-06
762 reads
Blog Posts
Understanding Data Normalization
Normalization, which is the key part of the OLTP databases logical design process, is a design requirement for OLTP databases....
2013-08-06
567 reads
Up or out? Deciding on SQL Server scalability
Scalability is the ability of a system to support an increased workload by adding incremental system resources without fundamentally changing...
2013-08-06
566 reads
Why use a SSAS cube?
What are the advantages of using SSAS Cubes over a regular data warehouse for reporting? Note I’m not asking why...
2013-08-06
1,675 reads
Windows Phone Security Advisory - Weakness in Security Protocol
If you're using a Windows phone, versions 7.8 or 8, there is a new security advisory out with respect to...
2013-08-06
629 reads
August 2013 – Monthly SQL Server Checklist
I can’t believe it’s already August. I had planned to get to the lake more this year, spend more time...
2013-08-05
589 reads
Be Cautious Offering Guidance
Guidance is hard.
Seriously, you’d think it would be easy. You’d think you say things like, don’t shrink your database, most...
2013-08-05
2,332 reads
Best Practices to Deliver BI Solutions Presentation
I will be presenting a brand new session entitled “Best Practices to Deliver BI Solutions” tomorrow, August 6th, at 11am...
2013-08-05
834 reads
Continue Package Execution After Error in SSIS
When it comes to ETL, I’m a pessimist. Until proven otherwise, I assume that all data is bad, all connections...
2013-08-05
2,064 reads
Custom Navigation controls in SharePoint 2010
There are several ways to create a custom navigation control in SharePoint. In the below image you can see the...
2013-08-05
944 reads
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