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,963 reads
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,963 reads
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,578 reads
Junk dimensions are dimensions that contain miscellaneous data such as flags and indicators. When designing a data warehouse, you might...
2011-12-19
1,373 reads
A factless fact table is a fact table that does not have any measures. It is essentially an intersection of...
2011-12-16
2,637 reads
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,064 reads
A table that does not have a clustered index is referred to as a Heap. While a lot has been written about index fragmentation and how to defrag indexes, there is not much that talks about how to defrag a heap table.
2011-12-13
5,779 reads
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,702 reads
A table that does not have a clustered index is referred to as a Heap. While a lot has been...
2011-12-09
7,124 reads
If you are using Visio 2010 and creating tables via the Database Model Diagram template, you may be surprised to...
2011-12-07
2,324 reads
The SQL Server 2012 Developer Training Kit has been updated with a bunch of new content (download it here). This...
2011-12-05
1,129 reads
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
Disclosure: this post may contain links to books as an affiliate link. If you...
By Vinay Thakur
Google has contributed a lot of stuff/enhancement on its portfolio, google is no longer...
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
Comments posted to this topic are about the item No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers