Sql
When:
Wednesday, November 19, 2008 6:30 PM Eastern Time (US & Canada)
Who: Joe Healy, Jeff Barnes, and Russ Fustino
http://www.dotnettikihut.com/
Event Overview
Session 1 - What’s New in SQL Server 2008 for Developers - SQL
Server 2008 adds numerous new capabilities for developers – from
support for Spatial Data types to a storage mechanism for SQL BLOB data
using the NTFS file system, and much, much more. The new release also
delivers several improvements to development-related areas, from T-SQL
to SQLCLR to XML. This presentation will provide a technical dive into
the latest and greatest features you’ll find in SQL Server 2008, while
offering insight into how to effectively apply...
I have some sql 2005 databases I need to maintain on a web hosts sql server. I was able to connect to the sql server fine with sql management studio 2008 but when I tried to expand the databases like I got an error like this. I found this connect item which explains how to fix the issue http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=354291 This seems to be similar to SSMS Object Explorer issue discussed here:http://forums.microsoft.com/msdn/showpost.aspx?postid=3531315&isthread=false&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=0Please try using the following workaround and let us know if that helps:1) Bring Object Explorer Details window by selecting View -->...
The easiest way to upload a database to dotster is to use the sql hosting toolkit. Visual studio 2008 installs the sql hosting toolkit for you otherwise you need to download and install from the link.
Steps to do this
1) Create a database in the dotster control panel.
2) In the server explorer create a link to the database you want to upload.
3) Right click on the database and select publish to provider in the wizard make sure you select sql 2000 as the target database schema.
4) On the codeplex website they use to have a webpage available to use to help...
In this post we will create a local cache of the Northwind database. To start with lets create a new visual basic windows forms project in Visual Studio 2008. From the project menu select add a new item and select a new local database cache and name it northwind.
In the server connect select a connection to the northwind database.
Press the add button and select the product table. Press OK to close the dialog. Go ahead and create a table adapter for the product table. The drag the products table on to the form from the data source...
Sql Endpoint and DataGridViewSQL Server 2005 allows you to create webservices for accessing the data in a database. These webservices are call SQL End Points. Lets start by creating a stored procedure to get the contact name and there titles for all the customers in the northwind database.
Create PROCEDURE [dbo].[GetContacts]
AS
BEGIN
SET NOCOUNT ON;
SELECT [ContactName],[ContactTitle] FROM Customers ORDER BY [ContactName];
END
Now we can create the end point. Note for this example I am using port 88 for the end point to prevent errors if you have IIS installed.
CREATE ENDPOINT NW_Contacts
STATE = Started
AS HTTP
(
PATH = '/Contacts',
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR),
CLEAR_PORT = 88,
SITE = '*'
)
FOR SOAP
(
WEBMETHOD 'GetContacts'
(NAME...
SMO: Connect to Remote Server
Here is a simple example on connecting to a Remote SQL Server with the SMO class. In this example I use a secure string for the password.
Dim srv1 As New Server("ServerName")
srv1.ConnectionContext.LoginSecure = False
srv1.ConnectionContext.SecurePassword = GetSecureString("Password")
srv1.ConnectionContext.Login = "UserName"
Function GetSecureString(ByVal str As String) As Security.SecureString
Dim ss As New System.Security.SecureString
For Each c As Char In str.ToCharArray
ss.AppendChar(c)
Next
' prevent changes
ss.MakeReadOnly()
Return ss
End Function
SQLCLR: Create a custom function
I store a persons full name in the name field of one my sql express database which I wanted to sort by the last name. Well I could always try a query like this.
SELECT * FROM SPEAKERS ORDER BY SUBSTRING(NAME, PATINDEX('% %', NAME), LEN(NAME) + 1 - PATINDEX('% %', NAME))
Unfortuntely some of the names have a middle initial so this method was not fool proof. This is where SQLCLR came to the rescue. By creating a SQL Server Project you can create functions with VB.Net code. So lets create a Sql Server Project and right click on the Project Name...
SQL Server 2005 SP 1 help
From my partner Kelly Martins at KJM Solutions
If this error occurs here is what worked for me. I hope it may work for you but am not sure.
In my case I had SQL Express 2005 Installer on my system as well as I run both (one for development, one for production).
Shut down all SQL related services manually.
I set registry permissions on Software\Policies\Microsoft\Windows\Installer to include the account that is doing the install with Full Control. Click Advanced and make sure everything is selected.
I downloaded and ran the SQL Install Cleanup and...
SQL Everywhere
Microsoft will be removing the restrictions on sql sever 2005 mobile edition so it works in a desktop environment. Check out the SQL everywhere FAQ on Steve Lasker's blog
Sql Server 2005 Service Pack 1
I see there is a CTP for a Sql Server 2005 service pack available. Here is a link for anyone interested.
Full Sql Archive