|
|
-
|
|
SQL Server Data Tools (SSDT) is a Business Intelligence Development Studio (BIDS) replacement, meaning it has a suite of Visual Studio 2010 add-in tools for building Integration Services (SSIS), Analysis Services (SSAS) & Reporting Services (SSRS) solu...
|
|
-
|
|
Data Quality Services (DQS) is a brand new feature in SQL Server 2012. In short, DQS enables you to build a knowledge base, and use that knowledge base to perform a variety of critical data quality tasks such as correction, enrichment, standardization and de-duplication of your data. DQS enables a......
|
|
-
|
|
All the videos for this popular conference are online or will be soon (69 of them). Take a look at the recorded sessions at http://sqlbits.com/content/Event10. All are free to watch!
...
|
|
-
|
|
The SQL MERGE statement was introduced in SQL Server 2008 and allows you to modify data in a target table based on data in a source table in one easy statement, replacing lots of messy code. I use it frequently when building a data warehouse.
In short, th...
|
|
-
|
|
In Master Data Services (MDS), you can use the Master Data Manager Web User Interface “UI” to copy a version of a model and create a new version of it (via the Version Management screen). However, you may find the “Copy” icon on th...
|
|
-
|
|
All the videos for the sessions at 24 Hours of PASS (Fall 2012) are available for free. Check the session schedule for a complete list. Enjoy!
...
|
|
-
|
|
As a 1099 consultant, I usually use a placement firm to find a contract job. I always ask the placement firm what rate they are billing the client. They usually tell me. When they don’t, it’s a sure sign that their markup is excessive (but note sometime...
|
|
-
|
|
Behind the scenes in SSIS, the data flow engine uses a buffer-oriented architecture to efficiently load and manipulate datasets in memory. The benefit of this in-memory processing is that you do not need to physically copy and stage data at each step of the data integration. Rather, the data flow ......
|
|
-
|
|
With CTP3 for SQL Server Denali available, a lot of us want to play with all the new cool features, as well as the new tools, such as Crescent and Juneau. The steps below are what I took to create a virtual machine to install all the products needed to create an environment where I can play with ev......
|
|
-
|
|
If you are the decision maker in your company and you are tasked with purchasing one or more servers to be used solely for SQL Server and solely as a data warehouse, be aware there are options outside of the usual ordering a server and internally installing the hardware, OS, and SQL Server.
Fast Tr......
|
|