Tag | SQL Server Posts

With most of our systems pre-configured with SQL server, it was only today that I ran into this issue with my fresh installation instance of SQL Server 2008 R2. I had just created a new SandBox DB to experiment with some aspects of Entity Framework 4.0, but as I was saving foreign key changes to tables I had already created I got the following error: Figure 1 - Unable to save table schema changes error With some research, I found my answer in SQL Books Online: Any Schema changes made to a table would ...
Back in April I began to work with Oracle again after a multiple year absence from doing so. So naturally I decided I would install Oracle on my home system so I could reacquaint myself with it. That proved to be more difficult than I expected. I was able to get Oracle 10g Express downloaded and installed but could not connect to it. So, to save someone else some of the grief I went through let me go through the final sequence of steps that resulted in a solid working Oracle development environment. ...
[Source: http://geekswithblogs.net/E... * This post is pure speculation, not based on any special insider knowledge, so don't get too excited * BizTalk 2010 has RTM'd, and the Developer Edition is now free. It seems an unusual move to give it away, with the price point of other BizTalk licences. Enterprises who actively use BizTalk will have an IT budget that will probably stretch to MSDN subscriptions for their dev team; conversely, SMBs who aren't prepared to spend £500-odd on a Developer ...
On Sept 29th, Microsoft made SQL Server 2008 SP2 available for download. Here are the KB article with a description of the fixes and the links to download SP2. KB 2285068 : List of the bugs that are fixed in SQL Server 2008 Service Pack 2. SQL Server 2008 SP2 SQL Server 2008 SP2 Express SQL Server 2008 SP2 Feature Packs SQL Server 2008 SP2 SSRS Add-in for Microsoft SharePoint Technologies SQL Server 2008 SP2 Upgrade Advisor ...
Here’s how we migrated our TFS 2008 to TFS 2010. This is not an in-place migration. What is generally recommended as upgrade path is to backup the TFS 2008 DBs, restore them in the new TFS data tier and then install TFS 2010. This will migrate all the projects at once. However, we wanted to keep the TFS 2008 environment running for a while, so this path did not do. We first set up a new machine (and a new domain, but that is a whole other story) with TFS 2010 and WSS 3.0. The database tier was on ...
[Source: http://geekswithblogs.net/E... I've had a need on a couple of projects for a monitoring system to record progress of a long-running transaction. Enter Heartbeat - a library which does just that. It's a project of mine on github: Heartbeat progress monitor. The typical use-case is for monitoring a lengthy batch load, where Heartbeat will record progress at set intervals. The intervals can be time-based, or progress-based or both - so you can have an overnight process which writes ...
I've never seen this before, a BT update on Windows Update: Update for BizTalk Server 2009 (KB2252691) This update fixes an issue that prevents the ENTSSO service from starting, after installing .NET Framework 4. The registration of an assembly used by the Enterprise Single Sign-On Service to access SQL Server does not specify the correct version of the .NET Framework. When .NET Framework 4 is installed, the assembly will try to use the newer framework and then fail to load ...
By default, SQL Server Management Studio (SSMS) will not let you save changes to the designs of your tables. When you attempt to do so, it wants you to drop and re-create the table. You will typically see a dialog similar to the following: However, SSMS will actually let you perform such a change without have to drop the table and re-create it. To enable this feature, you need to select Tools / Options from the Menu. Then, navigate to Designers / Table and Database Designers and uncheck the option ...
I am hanging recently around a lot in the MS SQL Server Forums where I have a lot of fun. One of the interesting questions that popped up today was about how to execute several operating system commands that span multiple lines. Besides, even though the job step editor presents you with a text box, this is not the same as writing a batch file. All the editor does it sees the first command statement. What to do? Some people resorted to writing subsequent commands in the next job step, but this sounded ...
I returned just last night from a short trip to Redmond. While I was there, I learned some news that I wanted to share, but I wasn’t permitted to. But today the news was made public: Oslo, once destined to be a full fledged-wave of Microsoft technologies that would facilitate and promote model driven-development, is dead. The Oslo name summons Shakespearean images of King Hamlet slaying his Norwegian foe. But even without such literary context, the fall of Oslo is quite dramatic And it’s important ...
Update: I have now placed the zip containing the source for the end result of part 1 and 2 of this service template here. I decided to write a pair of posts on making it easier to create Windows Services in C# (and in .NET in general). This is the first post that talks about how to make a Windows Service debuggable (the default visual studio template does not allow the service to be easily debugged), and then next week’s post will discuss making the Windows Service self-installing. Now, these posts ...
The BizTalk Server team announced today that BizTalk Server 2010 has RTMd. That's a relief, as my reputation was on the line regarding RTM before the end of the month. Just this Tuesday I confidently told a prospective customer to expect an imminent announcement. I've been playing with BTS 2010 for a little while now. It has been my constant companion while writing several chapters for the forthcoming BizTalk Server 2010 Unleashed. It looks great. As well as bringing BTS up to date with Visual Studio ...
So it's official. Don Box has blogged an update on SQL Server Modelling. As widely rumoured, he has confirmed that Quadrant is dead. The shock is that the model repository has expired as well. M is still hanging on in there, but we don't know anything more about what the future holds. For some time, the official word has been that it would arrive in conjunction with a future SQL Server release. I detect a possible change here, in that Don simply says 'We are continuing our investment in this technology ...
Problem As the DBA, you need to determine if there are any databases in your production environment which have not had a full backup in the last 24 hours. In this tip we cover the step by step process for setting up a policy to identify all the databases which are not backed up in the last 24 hours. Solution Database Administrators can use Policy Based Management (PBM) to identify databases which have not backed up in the last 24 hours. You can follow the below steps to create and evaluate the policy. ...
Model Functionality · Support for Enums for property types from lookup tables · Allow default date = DateTime.Now - The only way to set a default date in the entity data model is to put a hard date in there, a string. If you have a known default date (e.g. 1900-01-01) this is fine. But often we want NOW to be the default and there's no way to indicate that in the model. · Support for System.IO.Stream instead of Byte[] for varbinary type of fields · Support GUID as Entity Key -http://leedumond.com/blog/... ...
For those that didn’t know, I have recently left a long run at Thomson Reuters (which is a great company BTW) for a new gig as CIO of Swank Motion Pictures. This company works in the movie distribution business to cruise ships, trains, universities, and more. Some links if you are interested: http://www.onboardmovies.com/ http://www.swank.com/colleg... https://www.swankhealth.com http://www.k12digitalmovies... http://www.swank.com/digita... and more more more …. The thing is that ...
For those who haven’t come across it, PowerPivot is Microsoft’s Excel- and SharePoint-based self-service BI tool. Essentially, it allows power users to build their own SQL Server Analysis Services cubes, except that they don’t need to be familiar with cube concepts and they won’t even notice that SSAS is involved. The other exception from the Microsoft BI norm is that these cubes use a new columnar, in-memory storage engine, called VertiPaq, rather than Analysis Services’ traditional MOLAP (Multidimensional ...
This is a quick post … after a lot of challenges with a recent deployment of BizTalk Server 2009, it is important to keep the following very much in mind. BizTalk Server 2009 and SQL Server 2008 R2 are not the best match, work with SQL Server 2008 with SP1. .NET 4.0 has the ability of breaking a not yet configured BizTalk deployment. Where? Enterprise SSO configuration will refuse to talk to the SSODB (mind you, the process will create the DB). There are fixes for this last one, just make sure you ...
August for some reason has been the busiest month I recall in a while. It has had a good doze of the products I love to work with, and it has given me the opportunity to get into one more, Azure. There has been BizTalk Server, SharePoint, SQL Server and Team Foundation Server and the surrounding tools. But I have been enjoying working with Azure. It’s a nice complexity full of good stuff (so far). In working with a client’s deployment the task came to needing to monitor the implementation. And since ...
I’m not pretty sure how many users are using the standard SQL Server Management Studio (SSMS) 2008 R2 to manage your SQL Azure database. I was one of them until I found the Houston project provided by Microsoft in its SQL Azure Labs. SQL Azure Labs is a place where we can try the latest CTP features of the SQL Azure. They might not be included in the production SQL Azure but I think most of them will be launched in the future. So it’s a good place for us to play with the newest stuff of SQL Azure. ...
SSMS Tools Pack is an add-in for Microsoft SQL Server Management Studio (SSMS) 2005, 2008, 2008 R2 and their respective Express versions. It contains a few upgrades to the SSMS IDE that I thought were missing. The current features include: •SQL Snippets •Window Connection Coloring •Query Execution History and Current Window History •Format SQL •Search Table, View or Database Data •Run one script on multiple databases •Copy execution plan bitmaps to clipboard or file •Search Results in Grid Mode •Generate ...
Just had a SQL Server 2005 database completely becoming unavailable after the drive on which its files were residing on completely ran out of space (thanks god in development). Freeing some space turned out to be a more or less strait-forward step. Now the recovery stage. Interestingly, out of a dozen databases (all in SQL 2000 compatibility mode) only one became affected. When I started to figure out what is wrong I checked the SQL Server log first and could see that another database’s log file ...
A few weeks ago my local TFS server stopped responding to Visual Studio because of this error: “TFS Service not available: HTTP Error 503”. So this morning while I was waiting for the kids to finish getting ready for school I uninstalled (yes, I lost my existing repository) and started with scorched earth. I received a new error during this installation: TF254043. Here’s a link to a post that fixes a few problems if you are upgrading, using SQL R2, or just can’t get Basic to run the verifications ...
This summer Inmeta ASA, a leading Norwegian IT company, bought Osiris Data. It means we’re now more than 150 consultants, up from 30 as we were. It means a lot for us, as we now can take on larger projects, more projects and with even more colleagues we will have better competency on more areas. It is also very exciting to be in a larger company, be “exposed” to more projects and more opportunities. Osiris Data was founded late autumn 1996, and started operation in January 1997, with 3 people. The ...
This past Wednesday, Beta 1 of Visual Studio LightSwitch (VSLS) was be made available to MSDN Subscribers. On Monday, it will be made available to the general public, at http://www.msdn.com/lightsw... Even in advance of Monday, that site is already making useful content available. Specifically, a Channel 9 video called “Visual Studio LightSwitch - Beyond The Basics” is well worth the viewing time. In it, Beth Massi (Program Manager on the Visual Studio Community Team) interviews Joe Binder (a Program ...
The road to learning is such an awesome thing! Yesterday, while browsing the MSDN Forums, I came across some people having frustration with SQL Server Express, Visual Web Developer 2010 and the Web Installer. The Issue After installation, if you create a New Website with VWD 2010, follow the steps below: Access the Web Site Administration Tool (Solution Explorer Toolbar) Click on Provider Configuration (Once the Web Site Admin Tool opens) Click on Select a single provider for all site management ...
TechEd 2010 Australia is approaching at a rapid pace and this year I have a speaking position. I will be talking on the topic of "PowerPivot: How, Why & When" doing some contrasting between PowerPivot and SSAS. And giving my opinions on where PowerPivot should be positioned in the Microsoft BI landscape. This will be happening at 3.30pm next Thursday. Even if you don't manage to catch my talk you should be able to find me hanging around the SQL Server area in the exhibition hall ...
Long Island Expressway...painless dentistry...dry wine...educational television. Inventing oxymorons like these is a wonderful party game; what others can we come up with today? How about: airline food...random order...House Ethics Committee...Service-oriented business intelligence.... That last phrase does seem like an oxymoron, at first glance. Service-Oriented Architecture (SOA) and Business Intelligence (BI) appear to be very different animals in enterprise architecture: Their purposes are very ...
I needed to dynamically configure log4net – outside of the web.config file. Here is my solution: 1. All that configuration of log4net in web.config? Forget it. 2. Create a separate log4net.config file (name it whatever you want), with the usual configuration content in it defining whatever appenders you want. For example if you want a rolling file log: <log4net> <appender name="RollingLogFileAppender" type="log4net.Appender.Roll... <param name="File" value="C:\\Temp\\mylog.txt" ...
In this blog and in my column, I’ve written a lot lately about new technologies from Microsoft that seek to make software development easier. Technologies like ASP.NET Web Pages, Razor and WebMatrix, Access Web Databases and Visual Studio LightSwitch. Each of these technologies, I believe, is bringing much needed accessibility to programming on the Microsoft platform. I’ve also written about Windows Phone 7 which, despite extreme skepticism in the press and analyst communities, has the potential ...
En el artículo anterior se definieron los conceptos de la Nube y Cloud Computing, y se repasó rápidamente la evolución de tecnologías que favorecieron el surgimiento de dicho paradigma. En el presente artículo se definirán los diferentes conceptos “*aaS” relacionados con el concepto de cloud computing (SaaS, PaaS, IaaS, etc.). SaaS digamos que ya es un término hasta cierto punto conocido, pero ¿y los demás? Eso es lo que se aclarará en este artículo. Los servicios de computación en la Nube, así como ...
[Source: http://geekswithblogs.net/E... In my previous post, Cloud Services and Command-Query Separation: Part 2, I walked through a sample Command-Query Separated service bus solution using readily available cloud services for communication. In this one, I'll look at some of the implications of shifting systems integration to the cloud, compared to an on-premise ESB. The focus here is mainly on Amazon Web Services, but I'll cover Azure with a dedicated sample project. Cost & Non-Functional ...

Came across this excellent demos and HOLS here  for SQL Server 2008 R2
Enjoy

Ever need to parse SQL Syntax using .NET without actually executing the SQL? Pretty sweet because you can actually do this with built in sql server options. Works out pretty well. Executing a statement with a syntax error, referencing an object that doesn’t exist, a stored procedure with parameters that has no parameters, etc produces a SqlException with an appropriate error message. 1: static void ParseQuery(string sql) 2: { 3: SqlConnection connection = new SqlConnection("some_connect... ...
At VSLive today, I had the pleasure of introducing Microsoft Corporate VP Jason Zander. And he had the pleasure of introducing Visual Studio LightSwitch. Pleasure is a theme here, because the product, to me at least, looks great. LightSwitch is a .NET based environment, hosted in Visual Studio, that allows developers to build business apps. Quickly. It harkens back, with pride, to tools of old, like VB6 and FoxPro, that made data, and data maintenance UIs, first class citizens. These tools also treated ...
Introduction Let’s pretend you are being interviewed for the DBA or T-SQL Programmer job and are asked a question like this: What is the precision of the GETDATE() and/or SYSDATETIME() function? If your answer is …: Well, GETDATE() function returns DATETIME data type so the precision is 3.33 ms, the SYSDATETIME() function returns DATETIME2 data type so the precision is 100 ns. …read on to find out if you are correct. Testing precision of GETDATE()… In order to find out what the correct answer should ...
CTP1 of Microsoft® Project Code-Named “Houston” is now available. This is a lightweight and easy to use database management tool for SQL Azure databases. It enables you to swiftly develop, deploy, and manage data-driven applications in the cloud. Project “Houston” provides a web-based database management tool for basic database management tasks like authoring and executing queries, designing and editing a database schema, and editing table data. All implemented in Silverlight. Getting Started For ...
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; ...
I recently received an email from a self-described “old school” developer who had attended one of our Visual FoxPro classes from a number of years back (2001?). He had some questions about working with SQL Server 2008 and T-SQL. He asked about a number of built in VFP/xBase functions that don’t have a counterpart in T-SQL, specifically some that deal with dates and strings. I too went through that migration waaaaay back when and have since created some UDFs that reproduce some familiar and very useful ...
A while back it was clear: Roses are red, violets are blue … if you are a dev you use Visual Studio. Now: Roses are blue, violets can be red … if you do SharePoint,Visual Studio is the right tool for you. I am not a poet, nor do I pretend to be one on TV. But I have invested time in fine tuning virtual machines and physical deployments in figuring out what goes where and what is needed. We see dependencies of every type, in every place and every product pretty much. If you are doing SQL Server 2008 ...
Today I put out a new release for PowerSSAS. This release adds the following new cmdlets: backup-ASDatabase clear-ASCache get-ASConnection get-ASRole restore-ASDatabase It also includes a Powershell v2 .psd1 module file and includes the option to just download a zip file which can be copied into a folder your modules folder. So you can now install PowerSSAS without needing to have admin privileges. There are instructions on installing PowerSSAS as a v2 module here. I have also done some preliminary ...
I was at a client location the other day and there was a need to configure PowerShell to back-up the SharePoint 2010 Farm after getting my commands ready and executing them it boomed out on me with the following errors Verbose: [Database_Name] SQL command timeout is set to 1.00 hours. Warning: [Database_Name] Cannot open backup device 'e:\etekglobalinc\backups\s... Operating system error 3(The system cannot find the path specified.). The path seemed right but the .bak file didn’t ...
Normal 0 false false false EN-US JA X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans... ...
Arnie Rowland (a SQL Server MVP and an amazing individual) has come up with a a great challenge for anyone who happens to be unemployed or under-employed (as he puts it). The challenge? Well, go on an read about it The original post: http://sqlblog.com/blogs/ar... An update, now joined by other MVPs (I see Ted Malone, another one of those great dudes I have had the joy of working with): http://sqlblog.com/blogs/ar... ...
In this Issue: Jim Jackson(-2-), Alex Golesh, Dustin Horne, Sl.ayer, xprblog, Mike James, and David Anson. Shoutouts: John Papa is on Deep Fried Bytes: Silverlight 4 Tools and RIA Services as Heard on Deep Fried Bytes Jaime Rodriguez has some help up for those that are having problems moving from the CTP to Beta bits: Tips for uninstalling the Windows Phone Developer Tools CTPs and moving to beta Koen Zwikstra reports an update: Document Toolkit 2 Release Candidate ... check out the feature list ...
When we look at how our database deployments are happening, we identify an ever growing number of servers and instances all servicing important services or why not? Custom applications. What is it? It is a combination of elements, those elements will allow for us as administrators interested in keeping a view of the health of the environment to connect to the system and check resource utilization. The elements that come into play are: Utility Control Point Health Policies Utility Explorer Each one ...
This week, Scott Guthrie, Corporate Vice President at Microsoft’s Developer Division, announced, via blog post, the early Beta release of a new tool called WebMatrix. WebMatrix is a free developer tool that enables Web development geared toward what might I might call Markup-and-Script developers (more on that in a minute). And although WebMatrix draws upon technologies already, or soon to be, present in the fuller ASP.NET Web development platform and the Visual Studio integrated development environment ...
Microsoft has recently released the first beta version of WebMatrix. What is it? Taken from the WebMatrix official site: "WebMatrix is everything you need to build Web sites using Windows. It includes IIS Developer Express (a development Web server), ASP.NET (a Web framework), and SQL Server Compact (an embedded database). It streamlines Web site development and makes it easy to start Web sites from popular open-source apps. The skills and code you develop with WebMatrix transition seamlessly to ...

The microsoft sql server product team has increased the Database Size limit for SQL Server 2008 R2 Express from 4 GB to 10 GB. So if you have any  SQL Server Express database that is close to the 4 GB Limit
Its time to upgrade to R2 Express.

Enjoy for free!!!!!!!!!

Normal 0 false false false EN-US ZH-CN X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; ...