SQL Server 2012 (“Denali”): T-SQL Enhancements
SQL Server 2012 has a number of new T-SQL features. Listed below are all of the new features, along with...
2012-02-15
5,149 reads
James Serra's Blog
SQL Server 2012 (“Denali”): Contained Databases
A problem that has plagued SQL Server for a long time is that a database is not very portable. Sure,...
2012-02-15 (first published: 2012-02-13)
2,915 reads
SQL Azure
SQL Azure is a cloud-based service from Microsoft that uses a special version of SQL Server as its backend. SQL Azure...
2012-02-10
2,428 reads
What is Microsoft Connect?
Microsoft Connect (blog, twitter) is a site where you can post feedback to improve the quality of many Microsoft products and...
2012-02-08
747 reads
SQL Server 2012 (“Denali”): Data Quality Services
Data Quality Services (DQS) is a brand new feature in SQL Server 2012. In short, DQS enables you to build a...
2012-02-09 (first published: 2012-02-06)
2,698 reads
Slowly Changing Dimensions
When designing a data warehouse, how you handle changes to dimensional data over time is the most important decision to make. It...
2012-02-03
1,224 reads
Need to create a time dimension down to the millisecond?
Ok, I know that creating a time dimension down to the millisecond is extremely rare. After all, we are talking...
2012-02-01
1,262 reads
Complex reporting off a SSAS cube
While using a cube in SSAS is usually a great source for reporting, it is not always the best choice....
2012-01-30
2,340 reads
SSAS fact table dilemma
Here is a situation I ran into recently concerning using a fact table in SSAS. This experience may help you out if...
2012-01-27
1,276 reads
Improving cube processing time
As your SSAS cube gets bigger, cube processing time will become a problem. This is especially true as more and...
2012-01-25
11,346 reads
Blogs
Monday Monitor Tips: The Jobs Report
By Steve Jones
A customer wanted a report they could email to their boss about jobs, something...
Automating SQL Maintenance: How DevOps Principles Reduce Downtime
By Chris Yates
In the world of modern data infrastructure, SQL databases remain the backbone of enterprise...
From Couch-Potato to Triathlete – and What This Means for Your SQL Server
Do you know if your SQL Server is really running at its best? To...
Forums
Single User SQL Server on Linux
Comments posted to this topic are about the item Single User SQL Server on...
All the Costs of Downtime
Comments posted to this topic are about the item All the Costs of Downtime
How Well Does the MSSQL Extension in VSCode Work?
Comments posted to this topic are about the item How Well Does the MSSQL...
Question of the Day
Single User SQL Server on Linux
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers