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,146 reads
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,146 reads
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,913 reads
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,425 reads
Microsoft Connect (blog, twitter) is a site where you can post feedback to improve the quality of many Microsoft products and...
2012-02-08
743 reads
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,694 reads
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,216 reads
Ok, I know that creating a time dimension down to the millisecond is extremely rare. After all, we are talking...
2012-02-01
1,260 reads
While using a cube in SSAS is usually a great source for reporting, it is not always the best choice....
2012-01-30
2,333 reads
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,271 reads
As your SSAS cube gets bigger, cube processing time will become a problem. This is especially true as more and...
2012-01-25
11,333 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers