iAwaaz-News-by-People - Stories tagged with SQL Server

SQL Server

atom rss
1
Awaaz
spam Awaaz Up Awaaz Down

Building a plug-in model to load VistaDB
posted by nancynancy 83 days, 12 hours, 58 minutes ago
Friday, June 18, 2010 3:28:32 AM GMT
Building a plug-in model to load VistaDB
In this article I will explain how to build an application that uses VistaDB and Microsoft?s SQL Server, without being hard bound against their providers directly. Many companies desire to offer the choice from several database providers in a single product or API. (more)
category: Technology | clicked: 0 | comment | | source: infinitecodex.com
tags: Plugin, SQL Server, VistaDB
1
Awaaz
spam Awaaz Up Awaaz Down

Just in Time Debugging CLR Procs
published 80 days, 22 hours, 3 minutes ago posted by attitudeattitude 83 days, 12 hours, 59 minutes ago
Sunday, June 20, 2010 6:23:49 PM GMT Friday, June 18, 2010 3:28:14 AM GMT
Just in Time Debugging CLR Procs
This topic comes up frequently when users are writing CLR Procs and Triggers. (more)
category: Technology | clicked: 0 | comment | | source: infinitecodex.com
tags: Clr procedures, Debugging, SQL Server, VistaDB
1
Awaaz
spam Awaaz Up Awaaz Down

T-SQL Enhancements in SQL 2008
published 86 days, 21 hours, 52 minutes ago posted by nancynancy 88 days, 19 hours, 46 minutes ago
Monday, June 14, 2010 6:34:58 PM GMT Saturday, June 12, 2010 8:40:34 PM GMT
T-SQL Enhancements in SQL 2008
Seth Phelabaum explains his favorite TSQL programmability enhancements added in SQL Server 2008. (more)
category: Technology | clicked: 0 | comment | | source: beyondrelational.com
tags: Database, developer, Programmability, SQL Server, TSQL
1
Awaaz
spam Awaaz Up Awaaz Down

6 Useful SQL Sever Scripts
posted by attitudeattitude 165 days, 11 hours, 17 minutes ago
Sunday, March 28, 2010 5:09:48 AM GMT
6 Useful SQL Sever Scripts
This is a post we had on the short live blog.tboda.com. People seemed to find it useful so I thought I?d give it a second chance at life. It contains a few useful scripts to use in SQL Server. (more)
category: Technology | clicked: 0 | comment | | source: lukencode.com
tags: script, SQL Server
1
Awaaz
spam Awaaz Up Awaaz Down

SSIS 2008 Variables 101
posted by nancynancy 167 days, 13 hours, 16 minutes ago
Friday, March 26, 2010 3:11:03 AM GMT
SSIS 2008 Variables 101
SSIS 2008 Variables (more)
category: Technology | clicked: 0 | comment | | source: dbalink.wordpress.com
tags: BI, dts, etl, SQL Server, SSIS
1
Awaaz
spam Awaaz Up Awaaz Down

Tabs Studio adds advanced tabs to Microsoft SQL Server Management Studio 2008 IDE
posted by nancynancy 171 days, 17 hours, 30 minutes ago
Sunday, March 21, 2010 10:56:50 PM GMT
Tabs Studio adds advanced tabs to Microsoft SQL Server Management Studio 2008 IDE
Tabs Studio add-in adds experimental support for multiple tab rows and tab grouping in SSMS 2008 IDE. (more)
category: Technology | clicked: 0 | comment | | source: tabsstudio.wordpress.com
tags: Database, SQL, SQL Server, ssms
1
Awaaz
spam Awaaz Up Awaaz Down

Are You Using Scalable Shared Databases? - Ben Nevarez
posted by nancynancy 171 days, 17 hours, 30 minutes ago
Sunday, March 21, 2010 10:56:38 PM GMT
Are You Using Scalable Shared Databases? - Ben Nevarez
Did you know that you can share read-only databases between several instances of SQL Server? Scalable Shared Databases is a very interesting SQL Server feature that many of us seem to almost have forgotten about it. Available for the first time in SQL Server 2005 and originally described on the Microsoft KB article 910378, it was later fully documented on Books Online. This Enterprise edition-only feature allows a read-only database to be accessed at the same time by two or more SQL Server instances (ma... (more)
category: Technology | clicked: 0 | comment | | source: sqlblog.com
tags: Database, DB, SQL, SQL Server
1
Awaaz
spam Awaaz Up Awaaz Down

SSMS tab grouping with Tabs Studio
published 171 days, 16 hours, 18 minutes ago posted by nancynancy 171 days, 17 hours, 31 minutes ago
Monday, March 22, 2010 12:08:51 AM GMT Sunday, March 21, 2010 10:56:16 PM GMT
SSMS tab grouping with Tabs Studio
SQL Server Management Studio uses quite different scheme for tab names from Visual Studio. I?ve significantly improved SSMS support in the next Tabs Studio version. (more)
category: Technology | clicked: 0 | comment | | source: tabsstudio.wordpress.com
tags: Database, SQL, SQL Server, SQL Server Management Studio, ssms
1
Awaaz
spam Awaaz Up Awaaz Down

Rectifying ?Database cannot be opened? Error in SQL Server - SQL Recovery | SQL Database Recovery | Recover SQL
published 172 days, 9 hours, 37 minutes ago posted by amit_it7amit_it7 172 days, 10 hours, 44 minutes ago
Sunday, March 21, 2010 6:49:55 AM GMT Sunday, March 21, 2010 5:42:53 AM GMT
Rectifying ?Database cannot be opened? Error in SQL Server - SQL Recovery | SQL Database Recovery | Recover SQL
Rectifying ?Database cannot be opened? Error in SQL Server Microsoft SQL Server is the most powerful and advanced RDBMS (Relational Database Management System), which offers excellent database solutions for all sizes of organizations. It provides several distinct and extraordinary features for effective management of your business-critical data. All of your valuable data is stored in MDF (Master Database File) in the form of tables. Although, SQL Server is considered as most reliable database management ... (more)
category: Technology | clicked: 0 | comment | | source: www.programmersheaven.com
tags: Database, SQL Server
1
Awaaz
spam Awaaz Up Awaaz Down

Simultaneous Execution of Two T-SQL Commands May Cause SQL Server Database Corruption - SQL Recovery | SQL Database Recovery | Recover SQL
published 172 days, 9 hours, 37 minutes ago posted by amit_it7amit_it7 172 days, 10 hours, 44 minutes ago
Sunday, March 21, 2010 6:49:55 AM GMT Sunday, March 21, 2010 5:42:52 AM GMT
Simultaneous Execution of Two T-SQL Commands May Cause SQL Server Database Corruption - SQL Recovery | SQL Database Recovery | Recover SQL
Simultaneous Execution of Two T-SQL Commands May Cause SQL Server Database Corruption If you work on Microsoft SQL Server, you must know the actual value of T-SQL (Transactional Structured Query Language) commands. These commands help you to access and alter the Master Database File (MDF) in an easy and effective fashion. Other useful features of such commands include absolute control on transactions, error handling and row processing. This is recommended not to use such commands concurrently on same SQL... (more)
category: Technology | clicked: 0 | comment | | source: www.programmersheaven.com
tags: SQL Server, T-SQL
1
Awaaz
spam Awaaz Up Awaaz Down

Insufficient Space While Upgrading Cause SQL Server Database Corruption - SQL Recovery | SQL Database Recovery | Recover SQL
published 172 days, 9 hours, 37 minutes ago posted by amit_it7amit_it7 172 days, 10 hours, 44 minutes ago
Sunday, March 21, 2010 6:49:55 AM GMT Sunday, March 21, 2010 5:42:46 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: Technology | clicked: 0 | comment | | source: www.programmersheaven.com
tags: SQL Recovery, SQL Server
1
Awaaz
spam Awaaz Up Awaaz Down

Architecture: The Harmony of Mathematical Precision... : Moving your SQL Server Database to the Clouds? Try the SQL Azure Migration Wizard
published 172 days, 9 hours, 37 minutes ago posted by amit_it7amit_it7 172 days, 10 hours, 44 minutes ago
Sunday, March 21, 2010 6:49:55 AM GMT Sunday, March 21, 2010 5:42:39 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? (more)
category: Technology | clicked: 0 | comment | | source: blogs.msdn.com
tags: SQL, SQL Azure, SQL Script, SQL Server
1
Awaaz
spam Awaaz Up Awaaz Down

SharePoint Hosting and Development : Upgrading SharePoint SQL Servers to SQL Server 2008.
published 172 days, 9 hours, 37 minutes ago posted by amit_it7amit_it7 172 days, 10 hours, 45 minutes ago
Sunday, March 21, 2010 6:49:55 AM GMT Sunday, March 21, 2010 5:41:56 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 (more)
category: Technology | clicked: 0 | comment | | source: blogs.msdn.com
tags: Microsoft, MOSS 2007, SQL Server, SQL Server 2008, WSS 3.0
1
Awaaz
spam Awaaz Up Awaaz Down

Open SQL Port for specific IP by ASP.NET Website - Hannes Preishuber
published 172 days, 9 hours, 37 minutes ago posted by amit_it7amit_it7 172 days, 10 hours, 45 minutes ago
Sunday, March 21, 2010 6:49:55 AM GMT Sunday, March 21, 2010 5:41:53 AM 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 (more)
category: Technology | clicked: 0 | comment | | source: weblogs.asp.net
tags: SQL Manager, SQL Server, Visual Studio, Windows Firewall, Windows Server 2008
1
Awaaz
spam Awaaz Up Awaaz Down

SQL 2008 for Hosters : Database Servers : Configuring Servers : The Official Microsoft IIS Site
published 172 days, 9 hours, 37 minutes ago posted by amit_it7amit_it7 172 days, 10 hours, 45 minutes ago
Sunday, March 21, 2010 6:49:55 AM GMT Sunday, March 21, 2010 5:41:51 AM 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: Technology | clicked: 0 | comment | | source: learn.iis.net
tags: PHP, SQL Server, SQL Server 2008
1
Awaaz
spam Awaaz Up Awaaz Down

Some Notes On SQL Saturday #44
published 173 days, 17 hours, 37 minutes ago posted by amit_it7amit_it7 174 days, 10 hours, 54 minutes ago
Friday, March 19, 2010 10:49:40 PM GMT Friday, March 19, 2010 5:32:47 AM GMT
Some Notes On SQL Saturday #44
Some Notes On SQL Saturday (more)
category: Technology | clicked: 0 | comment | | source: dbalink.wordpress.com
tags: sql free training, SQL Server, sqlsaturday
2
Awaaz
spam Awaaz Up Awaaz Down

Using windbg as a Sql profiler in .NET
published 182 days, 23 hours, 34 minutes ago posted by attitudeattitude 187 days, 14 hours, 53 minutes ago
Wednesday, March 10, 2010 4:52:34 PM GMT Saturday, March 06, 2010 1:33:49 AM GMT
Using windbg as a Sql profiler in .NET
Most of the times when I am debugging using Windbg, I end up debugging code which has (more)
category: Technology | clicked: 0 | comment | | source: bit.ly
tags: Debugging, SOS, SQL Server, WinDbg
1
Awaaz
spam Awaaz Up Awaaz Down

LiteSpeed Backup SQL Server Backup Compression Tool
published 183 days, 19 hours, 33 minutes ago posted by attitudeattitude 187 days, 15 hours, 1 minute ago
Tuesday, March 09, 2010 8:54:09 PM GMT Saturday, March 06, 2010 1:26:16 AM GMT
LiteSpeed Backup SQL Server Backup Compression Tool
LiteSpeed Backup SQL Server Backup Compression Tool In many companies SQL Server database administrators in IT departments prefer to use third-party SQL Server backup compression software and sql backup compr... (more)
category: Technology | clicked: 0 | comment | | source: www.kodyaz.com
tags: backup compression, data compression, LiteSpeed, sql backup, SQL Server, Tools
1
Awaaz
spam Awaaz Up Awaaz Down

SQL Server Backup Compression Software - SQL Backup Compression Tools
published 183 days, 19 hours, 33 minutes ago posted by attitudeattitude 187 days, 15 hours, 1 minute ago
Tuesday, March 09, 2010 8:54:09 PM GMT Saturday, March 06, 2010 1:25:55 AM GMT
SQL Server Backup Compression Software - SQL Backup Compression Tools
SQL Server Backup Compression Software - SQL Backup Compression Tools After the release of Microsoft SQL Server 2008, sql database administrators (DBA's) and sql developers have acquired a new tool for SQL Se... (more)
category: Technology | clicked: 0 | comment | | source: www.kodyaz.com
tags: backup, backup compression, Compression, data compression, sql backup, SQL Server, SQL Server 2008, SQL Server 2008 Backup