SQLSaturday #144 SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held July 28, 2012 from 8am to 6pm at: University of Phoenix 2860 Gateway Oaks Dr Sacramento, CA 95833 Admittance to this event is free, all costs …Continue reading →
If you happen to encounter this error when installing SQL Server 2012 Master Data Services, you may have missed an IIS prerequisite feature, or you may not be using the right Windows user for the MDS application pool identity.
I have already begun using the new SSIS Project Deployment Model where I am able. I did not know it was coming, but I have wished that SSIS deployment could work this way for a long, long time. …this brief introduction into the capabilities of Project Deployment Model should give …Continue reading →
Looks useful for data warehouse applications… The Release of SQL Server 2012 introduces the sequence object to the world of SQL Server. A sequence is a user defined, schema bound object that will generate a sequence of numeric values (in ascending or descending order) according to specification. Unlike identity columns, a sequence …Continue reading →
My migration to SQL Server 2012 has actually been going rather smoothly. The other issues apart from the one I discussed earlier have been relatively minor, although some were time consuming to work out and some were annoying. Here is what I have run into so far:
I originally wrote about this issue in 2010, I continue to see it from time to time, after something “disturbs” Visual Studio. It starts with an alert something like this appearing upon opening Visual Studio or BIDS:
Welcome to Megan’s Sql2Go.com. You’ll find a brief introduction to me and this website here. See the Services and About pages for information about my availability and services offered. Comodo SSL Organization Validated
Moving to a new version of SQL Server is always interesting, and this version is proving to be no exception. It has been a lot of fun so far, and I hardly know where to start, but I will start with CLR assemblies.
My SSIS Batch Geocoder for SSIS 2008 R2 is now available on Codeplex. It’s a free SSIS Data Flow component that converts address data to latitude and longitude. This can be very useful when using the Map features of SSRS 2008 R2.
When you begin to use the Visual Studio 2005/8 ReportViewer web control (to view SQL Server Reporting Services reports) you are likely to find that it presents an extra set of scroll bars within the web page, making it hard to use. This is normal and there are several ways to …Continue reading →