via Jen Stirrup’s Business Intelligence Blog: Microsoft SQL Server 2012 Latest Announcements: Hekaton, Service Pack 1 and PDW.
Another Stop-Gap Solution for the SQL Server 2012 Identity Crisis – SQLServerCentral. SQL Server 2012 generating non-sequential identity values? In my coding I never assume the value of a new identity field, which sometimes makes for extra work and could slow down high-volume code, but evidently some applications do assume. If yours … Continue reading →
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 →
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: … Continue reading →
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. … Continue reading →
For years I have been relying upon the Web for quick answers about how to do things in SQL Server and ASP.NET (among other things), and it has saved me a huge amount of time not having to reinvent the wheel. This is my attempt to return the favor: I … Continue reading →
Last week I began to prepare to migrate from SQL Server 2005 to 2008 (x64) by clearing off my staging server and installing SQL Server 2008. I didn’t get far. Based on what I saw, and what I have been reading on the MSDN forums, this is what happened: