Servefault.com - Latest published stories in SQL

SQL

atom rss
3
votes
spam Shout it! Mute it

Using NHibernate order-by attribute to sort names history
published 71 days, 20 minutes ago posted by gpeipmangpeipman 74 days, 18 hours, 2 minutes ago
Thursday, December 31, 2009 10:54:04 AM GMT Sunday, December 27, 2009 5:11:09 PM GMT
Using NHibernate order-by attribute to sort names history
I am writing application that besides other cool things lets users insert information about business contacts. My system is able to keep names history of contacts. In this posting I will show you how to use NHibernate mappings to keep names ordered logically. (more)
category: SQL | clicked: 1 | comment | | source: weblogs.asp.net
tags: NHibernate, sorting
5
votes
spam Shout it! Mute it

Using SQL Server 2008 Reporting Services with the.NET Framework Data Provider for Teradata
published 130 days, 1 hour, 1 minute ago posted by Webhost4lifeWebhost4life 135 days, 6 hours, 14 minutes ago
Monday, November 02, 2009 10:12:27 AM GMT Wednesday, October 28, 2009 4:59:41 AM GMT
Using SQL Server 2008 Reporting Services with the.NET Framework Data Provider for Teradata
This article discusses the connectivity and usage of Teradata database servers and the .NET Framework Data Provider for Teradata with Microsoft SQL Server 2008 Reporting Services (SSRS). For Teradata users that are new to working with Reporting Services, this article aims to present tips that can help make the most of SQL Server Reporting Services. For Reporting Services users that are new to using Teradata as a data source, the article serves as an introduction to working with different data types and c... (more)
category: SQL | clicked: 0 | comment | | source: msdn.microsoft.com
tags: .Net Framework, SQL Server Reporting Services
3
votes
spam Shout it! Mute it

Visual Web Developer Team Blog : Dev10 Beta2, Import from web.config file and other changes for DB deployment UI
published 136 days, 5 hours, 24 minutes ago posted by HostgatorHostgator 138 days, 17 hours, 38 minutes ago
Tuesday, October 27, 2009 5:49:54 AM GMT Saturday, October 24, 2009 5:36:01 PM GMT
Visual Web Developer Team Blog : Dev10 Beta2, Import from web.config file and other changes for DB deployment UI
Dev10 Beta2, Import from web.config file and other changes for DB deployment UI Dev10 Beta2 DB Deployment property page has some changes from Beta1.  Please provide your valuable feedback for us to make it better for you.  Thanks. Tab page name changed from “Deploy/SQL” To “Deploy SQL” Customer can use “Import from Web.config” button to import all the connection strings defined in root web.config to the database entries list.  For example, if web.config contains the following connection strin... (more)
category: SQL | clicked: 0 | comment | | source: blogs.msdn.com
tags: SQL, Web.config
3
votes
spam Shout it! Mute it

SQL 2008 for Hosters : Database Servers : Configuring Servers : The Official Microsoft IIS Site
published 136 days, 5 hours, 24 minutes ago posted by HostgatorHostgator 138 days, 21 hours, 36 minutes ago
Tuesday, October 27, 2009 5:49:54 AM GMT Saturday, October 24, 2009 1:37:44 PM GMT
SQL 2008 for Hosters : Database Servers : Configuring Servers : The Official Microsoft IIS Site
The SQL Server 2008 for Hosters Guidance Video provides an overview of SQL Server 2008 for hosters. It is an introduction to the various editions of SQL Server, in particular the Web edition. The video gives guidelines to determine which editions are right for which scenarios. It highlights key features such as policy-based management, PowerShell, data warehousing, resource governor, transparent data encryption, auditing, backup, Hyper-V and SQL licensing, migration and upgrades, SQL Server driver for PH... (more)
category: SQL | clicked: 0 | comment | | source: learn.iis.net
tags: PHP, SQL Server, SQL Server 2008
4
votes
spam Shout it! Mute it

Open SQL Port for specific IP by ASP.NET Website - Hannes Preishuber
published 138 days, 17 hours, 29 minutes ago posted by GodaddyGodaddy 148 days, 17 hours, 28 minutes ago
Saturday, October 24, 2009 5:44:33 PM GMT Wednesday, October 14, 2009 5:45:17 PM GMT
Open SQL Port for specific IP by ASP.NET Website - Hannes Preishuber
We run a public SQL Server on Windows Server 2008 and had a lot of dictionary attacks in the past. To prevent that, do following 1) disable sa user 2) enable Windows Firewall, set a inbound rule ( here named sql) and lock the port 1433, then add the external IP’s ( scope tab) which needs access from extern   Now you are save. New problem is, what happens when you have dynamic IP address on client and need access by SQL Manager or Visual Studio Server Manager. Take really long time to solve that pro... (more)
category: SQL | clicked: 1 | comment | | source: weblogs.asp.net
tags: SQL Manager, SQL Server, Visual Studio, Windows Firewall, Windows Server 2008
2
votes
spam Shout it! Mute it

SharePoint Hosting and Development : Upgrading SharePoint SQL Servers to SQL Server 2008.
published 138 days, 17 hours, 29 minutes ago posted by Webhost4lifeWebhost4life 148 days, 3 hours, 12 minutes ago
Saturday, October 24, 2009 5:44:33 PM GMT Thursday, October 15, 2009 8:01:29 AM GMT
SharePoint Hosting and Development : Upgrading SharePoint SQL Servers to SQL Server 2008.
Upgrading SharePoint SQL Servers to SQL Server 2008 SQL Server 2008 is now released and is supported by WSS 3.0 and MOSS 2007 SP1 and above although we probably won't see a supportability statement anytime soon due to resource constraints with the content folks. I will let you know when the official supportability statement is released. [Update] - Support has been annouced. See http://technet.microsoft.com/en-us/library/cc262485.aspx for MOSS and http://technet.microsoft.com/en-us/library/cc288751.a... (more)
category: SQL | clicked: 0 | comment | | source: blogs.msdn.com
tags: Microsoft, MOSS 2007, SQL Server, SQL Server 2008, WSS 3.0
4
votes
spam Shout it! Mute it

A Tool For Querying Multiple Databases
published 151 days, 1 hour, 13 minutes ago posted by HostgatorHostgator 152 days, 4 hours, 57 minutes ago
Monday, October 12, 2009 10:01:00 AM GMT Sunday, October 11, 2009 6:16:31 AM GMT
A Tool For Querying Multiple Databases
A Tool For Querying Multiple Databases I recently blogged about different multi-tenant data architectures, comparing and constrasting the Separate Databases and Shared Database, Shared Schema architectures, as well as noting what sorts of questions to ask when trying to ascertain which model to use. One of the disadvantages of the Separate Databases approach is that it can be difficult to view data aggregated across the databases: Viewing data aggregated across the databases is difficult. I've touched ... (more)
category: SQL | clicked: 0 | comment | | source: scottonwriting.net
tags: Architectures, Databases, Query, Shared Database
4
votes
spam Shout it! Mute it

Reporting Service “features” | SQLServerPedia
published 151 days, 1 hour, 13 minutes ago posted by HostgatorHostgator 152 days, 4 hours, 26 minutes ago
Monday, October 12, 2009 10:01:00 AM GMT Sunday, October 11, 2009 6:47:34 AM GMT
Reporting Service “features” | SQLServerPedia
I've been a proponent of Microsoft's SQL Server Reporting Services (SSRS since 2005) since it was first released in beta for SQL 2000. I thought the product was a natural, combining a report writer with the database. I especially loved the ease of deploying individual reports. The first product was rough, but I figured it would improve with time. By the time SSRS 2005 came out it was a stable product, but it lacked some features, like rich textbox formatting and exporting to MS Word. SSRS 2008 added thos... (more)
category: SQL | clicked: 0 | comment | | source: sqlserverpedia.com
tags: SQL 2000, SQL Server Reporting Services, SSRS, SSRS 2005, SSRS 2008
4
votes
spam Shout it! Mute it

SQL-Server-Tutorial - SQLServerPedia
published 151 days, 1 hour, 13 minutes ago posted by HostgatorHostgator 152 days, 4 hours, 23 minutes ago
Monday, October 12, 2009 10:01:00 AM GMT Sunday, October 11, 2009 6:51:00 AM GMT
SQL-Server-Tutorial - SQLServerPedia
SQL Server Tutorials Get in for nothing, get access to everything: we've got free SQL Server Tutorials in videos here at SQLServerPedia to explain how to peform common SQL Server tasks. (more)
category: SQL | clicked: 0 | comment | | source: sqlserverpedia.com
tags: SQL Server Pedia, SQL Server Tutorial
3
votes
spam Shout it! Mute it

Generating and Hosting a SQL Server Reporting Services Report Using SQL Server 2005 Business Intelligence Development Studio: ASP Alliance
published 151 days, 1 hour, 13 minutes ago posted by HostgatorHostgator 152 days, 4 hours, 31 minutes ago
Monday, October 12, 2009 10:01:00 AM GMT Sunday, October 11, 2009 6:42:45 AM GMT
Generating and Hosting a SQL Server Reporting Services Report Using SQL Server 2005 Business Intelligence Development Studio: ASP Alliance
Introduction Reporting is one of the most important activities of an organization because it provides a specialized and customized view of the data of various forms that live in databases or are stored in archives. The report is useful in making business decisions, scheduling business campaigns or assessing the competition. The report itself may be required in hard copy in several document formats such as DOC, HTML, PDF, etc. Often times it is also required in an interactive form for retrieving data ... (more)
category: SQL | clicked: 1 | comment | | source: aspalliance.com
tags: .Net 2003, SQL Server 2005, SQL Server Reporting Services
3
votes
spam Shout it! Mute it

Microsoft SQL Server 2008: Reporting
published 151 days, 1 hour, 13 minutes ago posted by HostgatorHostgator 152 days, 4 hours, 24 minutes ago
Monday, October 12, 2009 10:01:00 AM GMT Sunday, October 11, 2009 6:49:18 AM GMT
Microsoft SQL Server 2008: Reporting
Overview Microsoft SQL Server 2008 Reporting Services provides a complete, server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed across the entire enterprise. Top New Features Design reports with any structure by using the new unique layout capabilities of Flexible Report Layout Benefit from enhanced performance and scalability to reach all users throughout the enterprise Render reports into Microsoft Office Word... (more)
category: SQL | clicked: 1 | comment | | source: www.microsoft.com
tags: Flexible Report, Microsoft Office Word, Microsoft SQL Server 2008
4
votes
spam Shout it! Mute it

Generating tables for MySql providers
published 152 days, 49 minutes ago posted by HostgatorHostgator 157 days, 44 minutes ago
Sunday, October 11, 2009 10:24:50 AM GMT Tuesday, October 06, 2009 10:29:59 AM GMT
Generating tables for MySql providers
While using MySQL connector/Net V6 and it's membership provider, the provider doesn't create tables it requires automaticly. After searching through internet, I got the solution. An extra attribute should be specified in order to create the schema automaticly. The key here is the "autogenerateschema" attribute which is set to true. This indicates that the MySQL membership provider should create the database schema required. The database s... (more)
category: SQL | clicked: 0 | comment | | source: blog.nirandas.com
tags: Mysql, V6
2
votes
spam Shout it! Mute it

SQL Azure Explorer for Visual Studio : Misfit Geek
published 152 days, 49 minutes ago posted by Webhost4lifeWebhost4life 152 days, 19 hours, 49 minutes ago
Sunday, October 11, 2009 10:24:50 AM GMT Saturday, October 10, 2009 3:24:16 PM GMT
SQL Azure Explorer for Visual Studio : Misfit Geek
I found a cool project on CodePlex that I wanted to share with you. SQL Azure Explorer for Visual Studio lets you work with SQL Azure inside Visual Studio 2010 Beta 1. It tries to mimic the ordinary Server Explorer. Current Features: SQL Azure Explorer which contains: Databases Tables with columns Views with columns Stored procs with parameters Functions with parameters Context menues for: Open Sql Editor Window Select Top 100 Rows Script as C... (more)
category: SQL | clicked: 0 | comment | | source: misfitgeek.com
tags: Misfit Geek, SQL Azure, Visual Studio
3
votes
spam Shout it! Mute it

Microsoft Bob : A Wrapper for Running SQL Server 2008 Reporting Services Reports Anonymously
published 152 days, 49 minutes ago posted by IXWebHostingIXWebHosting 156 days, 8 hours, 36 minutes ago
Sunday, October 11, 2009 10:24:50 AM GMT Wednesday, October 07, 2009 2:37:08 AM GMT
Microsoft Bob : A Wrapper for Running SQL Server 2008 Reporting Services Reports Anonymously
A Wrapper for Running SQL Server 2008 Reporting Services Reports Anonymously With SQL Server 2008, Microsoft re-architected SQL Server Reporting Services (SSRS) to no longer have an IIS dependency.  It now relies directly on HTTP.SYS and handles web protocols independently.   This is a good thing, in a lot of respects (see http://msdn.microsoft.com/en-us/library/bb630410.aspx).  But, there is also a down-side for those of us who are used to utilizing the IIS framework for hosting SQL Server reports.  F... (more)
category: SQL | clicked: 1 | comment | | source: blogs.msdn.com
tags: Microsoft, SQL 2008 Reporting Services, SQL Server 2008, SSRS
6
votes
spam Shout it! Mute it

Whats New in SQL Server 2008 R2 CTP | SolidDotNet.com
published 160 days, 1 hour, 33 minutes ago posted by MicrosoftMicrosoft 166 days, 21 hours, 50 minutes ago
Saturday, October 03, 2009 9:40:20 AM GMT Saturday, September 26, 2009 1:23:26 PM GMT
Whats New in SQL Server 2008 R2 CTP | SolidDotNet.com
soliddotnet.com — Hi , this post is all about discussing the latest new features being embedded , released up with SQL SERVER 2008 R2 CTP . We are attaching the complete powerpoint presentation , that we had made to describe all the new features of this 2008 R2 CTP Release . If you do have any kind of querries regarding the same , feel free to ping us back and we will be more than happy to solve your querries (more)
category: SQL | clicked: 3 | comment | | source: www.soliddotnet.com
tags: CTP, SQL Server 2008
4
votes
spam Shout it! Mute it

Architecture: The Harmony of Mathematical Precision... : Moving your SQL Server Database to the Clouds? Try the SQL Azure Migration Wizard
published 165 days, 1 hour, 50 minutes ago posted by IXWebHostingIXWebHosting 166 days, 9 hours, 18 minutes ago
Monday, September 28, 2009 9:23:56 AM GMT Sunday, September 27, 2009 1:56:01 AM GMT
Architecture: The Harmony of Mathematical Precision... : Moving your SQL Server Database to the Clouds? Try the SQL Azure Migration Wizard
Moving your SQL Server Database to the Clouds? Try the SQL Azure Migration Wizard Thinking about kicking the tires on SQL Azure? Wondering what tools are out there to help automate the process and save some time?  Check out the SQL Azure Migration Wizard  at http://sqlazuremw.codeplex.com. The SQL Azure Migration Wizard helps you migrate your local SQL Server 2005 / 2008 databases into SQL Azure. The wizard walks you through the selection of your SQL objects, creates SQL scripts suitable for SQL Az... (more)
category: SQL | clicked: 0 | comment | | source: blogs.msdn.com
tags: SQL, SQL Azure, SQL Script, SQL Server
4
votes
spam Shout it! Mute it

Meta-Me : Tip 36 – How to Construct by Query
published 165 days, 1 hour, 50 minutes ago posted by BlueHostBlueHost 165 days, 9 hours, 38 minutes ago
Monday, September 28, 2009 9:23:56 AM GMT Monday, September 28, 2009 1:35:24 AM GMT
Meta-Me : Tip 36 – How to Construct by Query
Tip 36 – How to Construct by Query While writing my tips series and writing EF controllers for MVC I found that I regularly wanted to create and attach a stub entity. Unfortunately it isn’t quite that simple, you have to make sure the entity isn’t already attached first, otherwise you’ll see some nasty exceptions. To avoid these exceptions I often found myself having to write code like this: Person assignedTo = FindPersonInStateManager(ctx, p => p.ID == 5); if (assignedTo == null) {      a... (more)
category: SQL | clicked: 0 | comment | | source: blogs.msdn.com
tags: C#, EF, EF Internals, Entity Framework, entityframework, Expressions, Extension Methods, lambda, Tips, tricks
6
votes
spam Shout it! Mute it

Generating SQL Scripts using Windows PowerShell
published 165 days, 2 hours, 19 minutes ago posted by HostgatorHostgator 168 days, 6 hours, 36 minutes ago
Monday, September 28, 2009 8:54:29 AM GMT Friday, September 25, 2009 4:37:10 AM GMT
Generating SQL Scripts using Windows PowerShell
In a previous tip on SQL Script Generation Programmatically with SMO, you've seen how you can use SMO to generate SQL scripts programmatically. In this tip I will cover how to generate scripts using Windows PowerShell. Solution SQL scripting in SMO is controlled either by the Scripter object and its child objects, or the Script method on individual objects as highlighted in the previous tip. We will be using the same approaches to generate SQL scripts using Windows PowerShell. Using the Script() metho... (more)
category: SQL | clicked: 0 | comment | | source: www.mssqltips.com
8
votes
spam Shout it! Mute it

Insufficient Space While Upgrading Cause SQL Server Database Corruption - SQL Recovery | SQL Database Recovery | Recover SQL
published 165 days, 2 hours, 19 minutes ago posted by HostgatorHostgator 168 days, 6 hours, 38 minutes ago
Monday, September 28, 2009 8:54:29 AM GMT Friday, September 25, 2009 4:35:09 AM GMT
Insufficient Space While Upgrading Cause SQL Server Database Corruption - SQL Recovery | SQL Database Recovery | Recover SQL
Insufficient Space While Upgrading Cause SQL Server Database Corruption Every new version of a application or system software contains a number of added and advanced features. To gain benefit of these features, you might want to upgrade to newer version. The same thing applies of MS SQL Server. But in some situations, when you try to upgrade the SQL Server, the process may fail and some of the database tables or whole database might get damaged. This behavior of SQL Server renders all of your mission cr... (more)
category: SQL | clicked: 0 | comment | | source: www.programmersheaven.com
tags: SQL Recovery, SQL Server
6
votes
spam Shout it! Mute it

Damage Registry of SQL Server Agent Cause Database Corruption in SQL Server 2008 - SQL Recovery | SQL Database Recovery | Recover SQL
published 165 days, 2 hours, 19 minutes ago posted by HostgatorHostgator 168 days, 6 hours, 40 minutes ago
Monday, September 28, 2009 8:54:29 AM GMT Friday, September 25, 2009 4:33:36 AM GMT
Damage Registry of SQL Server Agent Cause Database Corruption in SQL Server 2008 - SQL Recovery | SQL Database Recovery | Recover SQL
Damage Registry of SQL Server Agent Cause Database Corruption in SQL Server 2008 Registry is the most important component of Microsoft Windows operating system. Whenever you install a software (such as Microsoft SQL Server 2008) or hardware on your computer, a new registry hive is created. But in case if the registry entries of Microsoft SQL Server gets damaged, the database corruption might occur and it may become inaccessible. In such situations, you encounter data loss circumstances and need to go for... (more)
category: SQL | clicked: 0 | comment | | source: www.programmersheaven.com
tags: SQL Server 2008
Previous 1 2 Next