Communaut .NET Montral - Nov 17 2008 Meeting - SQL Server 2008 New Features for Developers
http://www.dotnetmontreal.com
Sujet: SQL Server 2008 New Features for DevelopersConfrencier: Michelle GutzaitNote: cette prsentation sera en anglais
Microsoft recently released a new version of its flagship database server: SQL Server 2008. With each new version comes a set of new features ......
SQL Server 2008 Error: `Saving changes is not permitted.`
Tonight I ran into the following error message when using a freshly installed version of SQL Server 2008 in a new project.
Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re......
SQL Server Matrix Workbench
In this workbench, Robyn Page and Phil Factor decide to tackle the subject of Matrix handling and Matrix Mathematics in SQL. They maintain that 'One just needs a clear head and think in terms of set-based operations'...Did you know that DotNetSlackers also publishes .net articles written by top kno......
Register Today for MSDN Events
Join MSDN Events for the latest tips, tools, and technical information you need to build powerful applications and engaging user experiences using SQL Server 2008, Visual Studio Tools for Office, and Silverlight 2....Did you know that DotNetSlackers also publishes .net articles written by top known......
SQLAuthority News - RML Utilities - Usage and Additional Help
Yesterday I wrote about SQLAuthority News - Download RML Utilities for SQL Server. I received many emails where different developers requested how to find additional help regarding RML Utilities. Few users reported that they are not able to install RML Utilities because of some reporting service pr......
SQLAuthority News - Download RML Utilities for SQL Server
The RML utilities allow you to process SQL Server trace files and view reports showing how SQL Server is performing. For example, you can quickly see:Which application, database or login is using the most resources, and which queries are responsible for thatWhether there were any plan changes for a......
Create XML from an Array
Passing arrays as arguments to stored procedures is not currently possible in SQL Server, but you can use XML to accomplish this....Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silve......
SQL SERVER - Delete Backup History - Cleanup Backup History
SQL Server stores history of all the taken backup forever. History of all the backup is stored in msdb database. Many times older history is no more required. Following Stored Procedure can be executed with parameter which takes days of history to keep. In following example 30 is passed to keep his......
The Estrangement of LINQ to SQL
Tim Mallalieu, PM of LINQ to SQL and LINQ to Entities, recently announced: as of .NET 4.0 the Entity Framework will be our recommended data access solution for LINQ to relational scenarios. Tim later tried to clarify the announcement in a carefully worded post: We will continue make some investme......
Three-Pane MGrammar Development in Intellipad
Roger Alsing has posted a discussion of how Intellipad's support for MGrammar development makes writing DSLs easier but showing you what parsers and how as you update the input file and the grammar file itself.
Personally, I'm a huge fan of seeing something work as I type. Think of it as "holi......
ASP.NET Dynamic Data Web projects templates
Since Visual Studio 2008 SP1 you may have noticed 2 projects template for dynamic data: So what is the difference ? Dynamic Data Web Site / Dynamic Data Web Application: Uses a LINQ to SQL model and LinqDataSource controls. Dynamic Data Entities Web Site / Dynamic Data Entiti......
SQL SERVER - Check Database Integrity for All Databases of Server
Today we will see quick script which will check integrity of all the database of SQL Server.EXEC sp_msforeachdb ‘DBCCCHECKDB(”?”)’ Above script will return you lots of messages in resultset. If there are any errors in resultset they will be displayed in red text. If everything is black text there i......
SQLAuthority News - SQL Server 2008 Book Online Updated in October 2008
SQL Server 2008 Books Online is updated on 31 October 2008. I always bookmark latest BOL for my easy reference.Getting Started: New and Updated Topics (31 October 2008)Analysis Services - Multidimensional Data: New and Updated Topics (31 October 2008)Database Engine: New and Updated Topics (31 Octo......
Unit testing ASP.NET data caching
A class for unit testing ASP.NET data caching when using SQL Server...Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.
...
SQL SERVER 2008 - Connect Visual Studio 2005 Patch Download
It was not possible to connect SQL Server 2008 to Visual Studio 2005 so far. Microsoft has released Service Pack once it is installed SQL Server 2008 can be connected to Visual Studio 2005.Download Microsoft Visual Studio 2005 Service Pack 1 Update for Microsoft SQL Server 2008 SupportFor connectin......
The Future of LINQ to SQL and EF
Ever the avoider of controversy, I've kept my head down for the past week so I could
finish getting my book into the hands of the copy editor. Of course, now I'm preparing
for next week's presentations at DevConnections,
including a full day of EF on Monday.
Which is why I haven't really said any......
Laptop Rebuild Essential Apps
When we last saw our hero, he had fallen victim to an evil plot to disable his computers ability to boot up. After great efforts at recovery, eventually he was forced to concede defeat to Vista and reinstall everything from scratch. Lets return now to see whats in store in the next chap......
SQL SERVER - Refresh Database Using T-SQL
Yesterday I received following questions on blog. Ashish Agarwal asked following question.Hi Pinal,Can we refresh a database (like we do by right clicking database node in object explorer and clicking on refresh) thru SQL Query?If yes, can you please tell me the query?Thanks,Ashish AgarwalAnswer to......
TDE: Under The Hood With TempDB
The latest in John's fascinating blog series on Data Encryption in SQL Server 2008 talks about the automatic encryption of the tempdb system database and explains how the non-TDE enabled user databases might interact with tempdb....Did you know that DotNetSlackers also publishes .net articles writ......
Installing databases using Wix
Have you ever wanted to install a SQL Server database as part of a software deployment? Brian Donahue makes it all look simple, but admits that a lot pf problems can be fixed by using SQLPackager....Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We......
SQLAuthority News - 5 Millions Visitors - 2 Anniversary - Authors Note on Economy Slow Down and Job Opportunity - SQL Server
I just received following screen shot from one of the regular reader of SQLAuthority.com blog. He pointed out important milestone for our blog. We have crossed 5 millions visitors. In less than 2 years SQLAuthority.com blog has been visited by 5 millions visitors. I even missed the anniversary our ......
Connect WebSphere and Java applications to SQL Server
FYI: The MS JDBC Driver is completely tested by IBM for use with WebSphere App Server v6.1 and v7.0. From the IBM Announcement for WebSphere Application Server v7.0: WebSphere Application Server V7.0 does not include the WebSphere Connect JDBC driver that had been provided in WebSphere Applic......
Converting Flat, Comma-Delimited Values Into a Normalized Data Model
In my job as an independent software developer I help a lot of small businesses enhance their existing company website or internal web applications to
include new features or adopt best practices. Many of these businesses have vital line of business applications that were created many years ago by......
How to save data from DataSet into T-SQL table?
This article tells you about saving data from DataSet into T-SQL tables....Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.
...
SQL SERVER - Clear Drop Down List of Recent Connection From SQL Server Management Studio
Quite often it happens that SQL Server Management Studio’s Dropdown box is cluttered with many different SQL Server’s name. Sometime it contains the name of the server which does not exist or developer does not have access to it. It is very easy to clean the list and start over.Delete mru.dat file ......
Split parameter string from comma seperator in SQL IN clause
Many time we face problem in SQL Query when performing operation with IN clause to check values seperated by ,(commas) in a parameter....Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including ......
SQL SERVER - Fix : Error: 4064 - Cannot open user default database. Login failed. Login failed for user
I have received following question nearly 10 times in last week though emails. Many users have received following error while connecting to the database. This error happens when database is dropped for which is default for some of the database user. When user try to login and their default database......
SQL Server Data Warehouse Cribsheet
It is time to shed light on Data Warehousing and to explain how SSAS, SSRS and Business Intelligence fit into the puzzle. Who better to explain it all then Robert Sheldon....Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 arti......
SQLite Membership, Role, and Profile Providers
Complete, production-ready Membership, Role, and Profile providers for SQLite. Includes instructions for migrating data between SQL Server and SQLite....Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categ......
Test Center review: Deep dive into SQL Server 2008
SQL Server 2008, aka "Katmai," gives SQL Server shops plenty of reasons to get excited. The best SQL Server release to date, it sports more nice new features than you can count, and the improvements extend to both performance and manageability. In a few cases, such as the Resource Governor, you'll ......
Understanding Date and Time Functions and Operations in SQL Server
Date and Time manipulation is a very common and useful act which deals with database tables and routines. In this article, Abhishek describes the important functions and operations for working with dates and time in SQL Server. The article includes date and time value extraction procedures and sear......
Using SqlCache dependencies with the new WCF WebCache attribute (REST Starter KIT)
Let's begin from a hypothetical example that we want to publish a simple product catalog as an ATOM feed. The product table schema in our database was initially designed as follows,
The first step is to enable the SQL notification for the products database, that can be done with the following com......
SQL SERVER - Fix : Error : Login failed for user UserName. The user is not associated with a trusted SQL Server connection
Recently I have got two desktop computers at home and both of them are very powerful machine.Machine 1 : Windows Vista SP1 with SQL Server 2008Machine 2 : Windows 2003 with SQL Server 2005 with SP2When I was trying to connect from SQL Server 2008 to SQL Server 2005 using Windows Authentication I wa......
Ask Kathleen: Control Exceptions
Take control of casting exceptions, determine whether parent records have children in LINQ to SQL, and resolve cref references in XML comments....Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories i......
Fixing DevelopmentStorages database cannot be found problem on Windows Azure
This could be a common problem who are not using SQL Express. If you run an Azure application you may find it seeks for SQL Express instance in your machine if you do not have already. You may also find "An error occurred while processing this request." error due to this reason while you try [...].......
In defense of the data programmability team
During the PDC the following statement came out of the data programmability team: "We're making significant investments in the Entity Framework such that as of .NET 4.0 the Entity Framework will be our recommended data access solution for LINQ to relational scenarios. We are listening to cus......
ASP.NET MVC Flexigrid sample
How to create an ASP.NET MVC sample using LINQ to SQL, Flexigrid for JQuery and Json...Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.
...
SQL Server - DECLARE Multiple Variables in One Statement
Just a day ago, while I was enjoying mini vacation during festival of Diwali I met one of the .NET developer who is big fan of Oracle. While discussing he suggested that he wished SQL Server should have feature where multiple variable can be declared in one statement. I requested him to not judge w......
Should enterprises reconsider the cloud?
With support for three of the major pillars of application development and deployment -- Oracle 11g, Microsoft SQL, and open source MySQL -- under its belt, Amazon.com appears to be anticipating a major move by the enterprise into the cloud. ...Did you know that DotNetSlackers also publishes .net ......
SQLAuthority News - Download Microsoft SQL Server Management Pack for Operations Manager 2007
The SQL Server Management Pack provides the capabilities for Operations Manager 2007 to discover SQL Server 2000, 2005 and 2008 installations and components and to monitor them, primarily from the perspective of availability and performance. The availability and performance monitoring is done using......
SDS and Ruby
A couple of months ago my good buddy Ryan Dunn contacted me about writing some Ruby samples for the new SQL Data Services that is part of the recently announced Windows Azure. (at the time it was called SSDS). I completed the samples about a month or so ago but we had to wait to announce them until......
SQLAuthority News - Download SQL Server 2005 Service Pack 3 - CTP
The CTP version of SQL Server 2005 Service Pack 3 (SP3) is now available. You can use these packages to upgrade any of the following SQL Server 2005 editions:EnterpriseEnterprise EvaluationDeveloperStandardWorkgroupFor a summary list of What’s new in SQL Server 2005 SP3 CTP, review the What’s New d......
Lack of practice makes imperfect
Apparently it's been too long since I've played with SQL Server databases. I say this because I made a boneheaded mistake today that obliged me to spend some quality time in the debugger. Someone asked me whether I could convert the good ol' cascading drop-down example from using an Access database......
Operations Manager: A Big Tinker Set
To illustrate the great possibilities of Systems Center Operations Manager 2007, Thomas shows how to create a Custom Monitor for SQL Agent Jobs, and concludes that Operations Manager is nothing more than a big tinker set with all the pieces available to make your working life easier....Did you know......
Early Notes from the PDC 2008 KeyNote
Here are some random and early notes from the first half of the PDCs keynote this morning, mostly about Azure. Windows Azure Cloud service operating system Part of the new cloud computing services platform (Azure Services Platform) New blog for Cloud Computing ......
Telerik is Live from PDC
PDC is in full force at the LA Convention Center. The keynote was somewhat bland, but the big news of the day is Windows Azure. Microsoft's cloud services offering, Azure promises to allow developers to host and manage their applications in the cloud, scaling storage and computing resources on dema......
The Oslo Developer Center: Letter from the Editors
Welcome to the "Oslo" Developer Center, your one-stop shop for all things "Oslo." Do you need to learn how M works (or what the heck it is?)? Do you want to sprinkle some of that repository stuff into your SQL Server? Do you need a quick video tutorial on the "Oslo" SDK tools? Then you've come to t......
Constraint Yourself!
In his first article for Simple-Talk, Joe Celko demystifies the use of Constraints, and points out that they are an intrinsic part of SQL and are a great way of ensuring that a business rule is done one way, one place, one time....Did you know that DotNetSlackers also publishes .net articles writt......
SQL SERVER - Simulate INNER JOIN using LEFT JOIN statement - Performance Analysis
Just a day ago, while I was working with JOINs I find one interesting observation, which has prompted me to create following example. Before we continue further let me make very clear that INNER JOIN should be used where it can not be used and simulating INNER JOIN using any other JOINs will degrad......
Reasons to Deprecate
Tony is happy to see features and services of SQL Server deprecated by Microsoft if it is for a good reason. Good reasons include conformance with SQL Standards or rejection by the community of users; He doesn't consider Microsoft's commercial convenience to be a good reason....Did you know that Do......