SQL Server 2012 (“Denali”): Master Data Services
SQL Server Master Data Services (MDS) has a number of enhancements in SQL Server 2012:
Improved web user interface – If you...
2011-12-28
1,829 reads
James Serra's Blog
SQL Server 2012 (“Denali”): New Security Features
SQL Server 2012 has many new security features, and three of the bigger new features are: Default Schema for Windows Groups,...
2011-12-23
1,948 reads
SQL Server 2012 (“Denali”): AlwaysOn
AlwaysOn is a new integrated high availability (HA) and disaster recovery (DR) solution that provides redundancy within a datacenter and across datacenters...
2011-12-21
1,567 reads
Junk dimensions
Junk dimensions are dimensions that contain miscellaneous data such as flags and indicators. When designing a data warehouse, you might...
2011-12-19
1,350 reads
Factless fact table
A factless fact table is a fact table that does not have any measures. It is essentially an intersection of...
2011-12-16
2,593 reads
TechNet Virtual Labs
There is an excellent site called TechNet Virtual Labs that enables you to quickly and easily evaluate Microsoft’s newest products and...
2011-12-14
1,058 reads
Top SSAS white papers
These are my favorite SSAS white papers released by Microsoft, with many from SQLCAT. I’ll keep this post updated with new...
2011-12-12
5,683 reads
Reduce heap table fragmentation
A table that does not have a clustered index is referred to as a Heap. While a lot has been...
2011-12-09
7,082 reads
Create SQL Server scripts with Visio 2010
If you are using Visio 2010 and creating tables via the Database Model Diagram template, you may be surprised to...
2011-12-07
2,270 reads
SQL Server 2012 Developer Training Kit
The SQL Server 2012 Developer Training Kit has been updated with a bunch of new content (download it here). This...
2011-12-05
1,119 reads
Blogs
How to Learn SQL Without Quitting Your Day Job
Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest...
Friday Flyway Tips: Chaining Commands for State-based Deployments
By Steve Jones
One of the cool things I’ve seen with the new Flyway CLI is that...
A New Word: Querinous
By Steve Jones
querinous – adj. longing for a sense of certainty in a relationship; wishing there...
Forums
What approach should I take in getting two databases to work together?
At work I am rewriting an old application which no longer builds. It was...
standard deviation function doesnt seem to be behaving like an aggregate
hi i have 6 statistical populations in my overall data set. They run across...
SQL Server Data...is it encrypted?
Hi Suppose someone gained unauthorized access to the physical SS data stored on my...
Question of the Day
SQL in an Azure VM Backup
If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)
See possible answers