2012-12-25
924 reads
Articles
SQLServerCentral Best Practices Clinic: Part 1
We exposed the SQLServerCentral cluster for monitoring with SQL Monitor. Just like other companies, we have constraints on resources, and we have more work that needs to be done. Help us configure SQLServerCentral’s database servers with your suggestions on what is the highest priority for a website database back end.
2012-12-25 (first published: 2011-03-07)
22,863 reads
Free ebook: Troubleshooting SQL Server: A Guide for the Accidental DBA
Merry Christmas from SQLServerCentral. We spend much of our working life helping solve SQL Server-related performance problems, hands-on, during consulting, or on online forums. We've seen a few weird-and-wonderful issues but, mainly, it’s the same problems and misconceptions time-and-again. This is our attempt to describe, diagnose, and solve the most common problems with SQL Server 2005, 2008, and 2008 R2. And it's free.
2012-12-25 (first published: 2012-10-30)
18,171 reads
Can a Table Really Have a Clustered Index?
A table doesn't so much "have" a clustered index as a table "is" a clustered index.
2012-12-24
8,377 reads
Making the Case for a SQL Server Platform Refresh
With the release of Windows Server 2012, SQL Server 2012, and the new generation of Sandy Bridge Xeon processors, your organization is likely to get many tangible benefits from upgrading your current database infrastructure with a complete platform refresh.
2012-12-24
2,579 reads
Rudolph The Red-Nosed Tester and Other Festive Arrangements
A Christmas poem and a contest from Simple Talk.
2012-12-24
2,442 reads
Some tips for working with big data models
The main goal of this article is to present some tips to help professionals that need to work with complex, big, and hard to understand database models that anyone may came across some day.
2012-12-21 (first published: 2011-03-03)
28,857 reads
Setting up a Data Science Laboratory
There is no better way of understanding new data processing, retrieval, analysis or visualising techniques than actually trying things out. In order to do this, it is best to use a server that acts as data science lab, with all the basic tools and sample data in place. Buck Woody discusses his system, and the configuration he chose.
2012-12-21
3,335 reads
Eleven Challenges in Unifying Reference Data
Unifying the reference data across an enterprise can be a bigger job than expected. This article describes one approach to doing so.
2012-12-20
3,614 reads
PASS Data Architecture VC presents James Serra on Introduction to Master Data Services
On Thursday August 20th 12PM noon Central, James Serra will discuss how companies can consolidate their enterprise data with the new feature of SQL Server 2012 Master Data Services.
2012-12-20 (first published: 2012-12-18)
2,340 reads
Blogs
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers