SqlServerKudos - Stories tagged with SQL Server 2008

SQL Server 2008

atom rss
1
kudos
spam Kudos Remove

Describe HA and DR strategy and win | SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP
published 433 days, 22 hours, 52 minutes ago posted by http://ghemant.myopenid.com/http://ghemant.myopenid.com/ 443 days, 17 hours, 39 minutes ago
Thursday, March 17, 2011 7:25:23 AM GMT Monday, March 07, 2011 12:38:14 PM GMT
Describe HA and DR strategy and win | SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP
Share Dear Readers, I am very please to made an announcement about the contest.  As you aware that I have wrote a book on SQL Server 2008 High Availability which was published on 24th January 2008 by Packt Publication. Now you have a chance to win a subscription worth £150 of digital library at Packt Publication, here is the information. Describe the best HA+DR solution you have designed or worked upon, especially in case of physically dispersed location, and the reason why? The best answer will win... (more)
category: News | clicked: 0 | comment | | source: www.sql-server-citation.com
tags: Book on SQL Server 2008, cluster resources, clustering, Database Administration, database mirroring, Hemantgiri S. Goswami, high availability, Log Shipping, replication, SQL Server 2008, SQL Server MVP
1
kudos
spam Kudos Remove

Make huge space savings by using SPARSE columns
published 514 days, 3 hours, 32 minutes ago posted by sasa 523 days, 6 hours, 12 minutes ago
Monday, December 27, 2010 2:45:24 AM GMT Saturday, December 18, 2010 12:04:54 AM GMT
Make huge space savings by using SPARSE columns
I’ve blogged before about Getting more than 1024 columns on a table , this is done by using sparse columns. Whilst this is potentially useful for people with insane table designs, sparse columns aren’t just for this. My experience over the past few years...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: Performance, SQL Server 2008, SQL Server 2008 R2, storage
1
kudos
spam Kudos Remove

Restricting logons during certain hours for certain users
published 528 days, 4 hours, 29 minutes ago posted by sasa 537 days, 6 hours, 4 minutes ago
Monday, December 13, 2010 1:48:26 AM GMT Saturday, December 04, 2010 12:13:11 AM GMT
Restricting logons during certain hours for certain users
Following a an email in a DL I decided to look at implementing a logon restriction system to prevent users from logging on at certain ties of the day. The poster had a solution but wanted to add auditing. I immediately thought of the My post on logging...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: Logon Triggers, Security, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2011
1
kudos
spam Kudos Remove

Trace Flag 610 – When should you use it?
published 544 days, 5 hours, 40 minutes ago posted by sasa 553 days, 8 hours, 20 minutes ago
Saturday, November 27, 2010 12:37:46 AM GMT Wednesday, November 17, 2010 9:57:27 PM GMT
Trace Flag 610 – When should you use it?
Thanks to Marcel van der Holst for providing this great information on the use of Trace Flag 610. This trace flag can be used to have minimal logging into a b tree (i.e. clustered table or an index on a heap) that already has data. It is a trace flag...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: Performance, SQL Server 2008, SQL Server 2008 R2, storage, Trace flags
1
kudos
spam Kudos Remove

Product Documentation aka 'BOL' web links for SQL Server 2008, 2008 R2 & Denali (CTP) versions
published 545 days, 5 hours, 45 minutes ago posted by sasa 554 days, 7 hours, 30 minutes ago
Friday, November 26, 2010 12:32:47 AM GMT Tuesday, November 16, 2010 10:47:29 PM GMT
Product Documentation aka 'BOL' web links for SQL Server 2008, 2008 R2 & Denali (CTP) versions
BOL - Book OnLine is a primary resource to get to know about the product in addition to the numerous blogs & resources on the web. As a best practice I always update my local copies of SQL Server Books Online for versions 2008, 2008 R2 & Denali (CTP). Though I still maintain books online for 6.5, 7.0 and 2000 versions too for a reference. If you are 'lazy' or do not have capability to upgrade the SQL BOL on your office machine/laptop then here are the links that will open up a web page for...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: 100, 105, 110, Books Online, ctp, Denali, Documentation, download, preview, SQL Server, SQL Server 2008, SQL Server 2008 R2, update, versions
1
kudos
spam Kudos Remove

How to Upgrade SQL Server | SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP
published 549 days, 6 hours ago posted by http://ghemant.myopenid.com/http://ghemant.myopenid.com/ 558 days, 22 hours, 23 minutes ago
Monday, November 22, 2010 12:17:13 AM GMT Friday, November 12, 2010 7:54:21 AM GMT
How to Upgrade SQL Server | SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP
Couple of days back I have wrote an article on common issues we face while upgrading, and two methods to follow while upgrading SQL Server, this article also gives you some basic steps we need to follow post upgrades.  Here is an excerpts of the article: Upgrading the SQL Server version can have a major impact the applications using the databses. For example, from SQL Server 2005 onwards you are required to use  col IS NULL instead of Col = NULL and so any applications using the later will break... (more)
category: News | clicked: 0 | comment | | source: www.sql-server-citation.com
tags: Hemantgiri S. Goswami, how to upgrade sql server, resolving upgrade issues, SQL Server 2008, sql server citation, sql server upgrade methods
1
kudos
spam Kudos Remove

Nullable parameters in SQL 2005 & SQL 2008 - Column, parameter, or variable #1: Cannot find data type Nullable`1
published 563 days, 7 hours, 1 minute ago posted by sasa 572 days, 10 hours, 41 minutes ago
Sunday, November 07, 2010 11:16:24 PM GMT Friday, October 29, 2010 7:36:15 PM GMT
Nullable parameters in SQL 2005 & SQL 2008 - Column, parameter, or variable #1: Cannot find data type Nullable`1
When writing CLR code for SQL you need to handle nulls. You can do this in two ways, either your data types are nullable or you configure your functions to always return null when a parameter is null. The last only works for some objects and so understanding...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: c#, SQL Server 2005, SQL Server 2008
1
kudos
spam Kudos Remove

How to downgrade Integration Services 2008 packages to 2005
published 571 days, 8 hours, 36 minutes ago posted by sasa 580 days, 11 hours, 5 minutes ago
Saturday, October 30, 2010 9:41:08 PM GMT Thursday, October 21, 2010 7:12:30 PM GMT
How to downgrade Integration Services 2008 packages to 2005
Courtesy of an unnamed source we have an app to downgrade a SSIS package from the 2008 version to 2005. Whilst it works with the common components any new components aren’t supported with the exception of the Lookup. 3rd party components are also not...(read more) (more)
category: News | clicked: 1 | comment | | source: sqlblogcasts.com
tags: SQL Server 2005, SQL Server 2008, SSIS - Integration Services, Tools and Components
1
kudos
spam Kudos Remove

SQL server 2008 Service Pack 2 available to download
published 592 days, 9 hours, 59 minutes ago posted by sasa 602 days, 9 hours, 51 minutes ago
Saturday, October 09, 2010 8:18:16 PM GMT Wednesday, September 29, 2010 8:26:22 PM GMT
SQL server 2008 Service Pack 2 available to download
As promised SQL Server release services has done it again, a great job in releasing SQL Server 2008 Service Pack 2 . Continung from SQL-2008-CU10 blog post here, it is recommended (I say MUST) to go through the SP2 release notes the download link confirms on : Service Pack 2 contains updates for SQL Server Utility, Data-Tier Application (DAC), as well as integration capability for Microsoft Reporting Services with the Microsoft SharePoint 2010 Technologies. Service Pack 2 introduces support for a...(read... (more)
category: News | clicked: 1 | comment | | source: sqlserver-qa.net
tags: best practice analyzer, Data, dbas, Documentation, release notes, service pack2, setup, SQL Server, SQL Server 2008
1
kudos
spam Kudos Remove

List of the bugs that are fixed in SQL Server 2008 Service Pack 2
published 593 days, 10 hours, 4 minutes ago posted by sasa 602 days, 10 hours, 56 minutes ago
Friday, October 08, 2010 8:13:20 PM GMT Wednesday, September 29, 2010 7:21:22 PM GMT
List of the bugs that are fixed in SQL Server 2008 Service Pack 2
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Notification Contents: New and Major Modifications List of the bugs that are fixed in SQL Server 2008 Service Pack 2 http://support.microsoft.com/kb/2285068/en-US New 9/29/2010 3:30:00 PM GMT The bugs that are fixed in this service pack For more information about the bugs that are fixed in SQL Server 2008 SP2, click the following article numbers to view the articles in the Microsoft Knowledge.... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: download, kba, service pack, SQL Server, SQL Server 2008
1
kudos
spam Kudos Remove

SpatialViewer Beta 3 – new release
published 648 days, 13 hours, 54 minutes ago posted by sasa 657 days, 14 hours, 20 minutes ago
Saturday, August 14, 2010 4:23:31 PM GMT Thursday, August 05, 2010 3:57:15 PM GMT
SpatialViewer Beta 3 – new release
Just released an updated version of the spatial viewer http://spatialviewer.codeplex.com   This is a C# app that allows you to draw shapes and then get the spatial representation for them in WKT format. It also allows you to manipulate shapes union...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: Codeplex, community, Spatial, SQL Server 2008
1
kudos
spam Kudos Remove

Creating a unique constraint on a column that allows nulls
published 654 days, 14 hours, 15 minutes ago posted by sasa 663 days, 16 hours, 59 minutes ago
Sunday, August 08, 2010 4:02:08 PM GMT Friday, July 30, 2010 1:18:30 PM GMT
Creating a unique constraint on a column that allows nulls
Primary keys, unique indexes and unique constraints all enforce uniqueness. The difference between the primary key and the unique index/constraint is that the primary key does not allow any NULL values. However whilst the unique index/constraints do allow...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: SQL Server 2005, SQL Server 2008, Tips and Tricks
1
kudos
spam Kudos Remove

SQL Server Installation : SMO related problems and client toosl issue - 'Microsoft.SqlServer.Management.Smo.Table.UrnSuffix' not found
published 677 days, 16 hours ago posted by sasa 686 days, 16 hours, 30 minutes ago
Friday, July 16, 2010 2:17:41 PM GMT Wednesday, July 07, 2010 1:47:09 PM GMT
SQL Server Installation : SMO related problems and client toosl issue - 'Microsoft.SqlServer.Management.Smo.Table.UrnSuffix' not found
A typical problem occurs when SQL Server client tools do have any issues. There is no easy way to say that SSMS (client tools) are corrupted, unless you can reproduce the same issue on other machine it cannot be assured. If it is a bug from tools you can easily file them on Microsoft connect site and preferably search for similar problem before posting a new one. Here is an interesting issue happened on my laptop and not on other desktop when I was trying to connect to a SQL intance (2008 version)....(re... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: client tools, corrupted, installallation, Maintenance, SMO, SQL Server, SQL Server 2008
1
kudos
spam Kudos Remove

SQL Server 2008 R2 setup error: SQLEngine: --SqlServerServiceSCM: Starting SQL via SCM (-mSqlSetup ………)
published 711 days, 18 hours, 32 minutes ago posted by sasa 720 days, 20 hours, 53 minutes ago
Saturday, June 12, 2010 11:45:32 AM GMT Thursday, June 03, 2010 9:24:39 AM GMT
SQL Server 2008 R2 setup error: SQLEngine: --SqlServerServiceSCM: Starting SQL via SCM (-mSqlSetup ………)
A bit of background on the installation setup of SQL Server 2008 (SP1) release onwards, that you need slipstream the installation. This is nothing but you could just install the SQL 2008 + Service Pack release as one time, which is a time-saving mechanism. Peter Saddow from SQL Server development team has shown example from the blog about how it looks when you install (see below): Coming back to the subject line I was presented with the error when trying to perform a slipstream installation of SQL...(rea... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: download, Installation, integration services, package, slipstream, SQL Server, SQL Server 2008
1
kudos
spam Kudos Remove

Scream if you want to go faster
published 727 days, 19 hours, 44 minutes ago posted by sasa 734 days, 22 hours, 12 minutes ago
Thursday, May 27, 2010 10:33:51 AM GMT Thursday, May 20, 2010 8:05:34 AM GMT
Scream if you want to go faster
My session for 24hrs of pass on High Performance functions will be starting at 11:00 GMT thats migdnight for folks in the UK. To attend follow this link https://www.livemeeting.com/cc/8000181573/join?id=N5Q8S7&role=attend&pw=d2%28_KmN3r The rest...(read more) (more)
category: News | clicked: 1 | comment | | source: sqlblogcasts.com
tags: PASS, Performance, Query Tuning, SQL Server 2005, SQL Server 2008, Tips and Tricks
1
kudos
spam Kudos Remove

SQL Server Certification - a database platform primer for your career path
published 734 days, 20 hours, 12 minutes ago posted by sasa 742 days, 22 hours, 31 minutes ago
Thursday, May 20, 2010 10:05:28 AM GMT Wednesday, May 12, 2010 7:46:08 AM GMT
SQL Server Certification - a database platform primer for your career path
When you need to upgrade your knowledge then training is required, at the same time certifications will help you to keep up on what you have learned! There is a big debate on the web about whether certifications are important in your career or not, the bottomline is if you do not know the stuff or unable to answer few basic technical questions, it does'nt matter how many certifications you have then you will not get the job, well I'm not starting the same discussion here. But in the recent times...(read ... (more)
category: News | clicked: 1 | comment | | source: sqlserver-qa.net
tags: Certification, path, real world, SQL Server, SQL Server 2008, SQL Server 2008 R2, study, technical
1
kudos
spam Kudos Remove

Spatial data in the UK
published 769 days, 22 hours, 52 minutes ago posted by sasa 779 days, 32 minutes ago
Thursday, April 15, 2010 7:24:59 AM GMT Tuesday, April 06, 2010 5:45:30 AM GMT
Spatial data in the UK
I am just loving the fact that the Ordance Survey has now released a huge amount of data that can be used freely. I’ve downloaded the Panorama (tm) data http://www.ordnancesurvey.co.uk/oswebsite/products/land-form-panorama-contours/index.html . which...(read more) (more)
category: News | clicked: 1 | comment | | source: sqlblogcasts.com
tags: Spatial, SQL Server 2008
1
kudos
spam Kudos Remove

Enabling super single user mode with SQL Server
published 779 days, 23 hours, 37 minutes ago posted by sasa 789 days, 6 minutes ago
Monday, April 05, 2010 6:40:30 AM GMT Saturday, March 27, 2010 6:11:02 AM GMT
Enabling super single user mode with SQL Server
I recently got an email from a fellow MVP about single user mode. It made me think about some features I had just been looking at and so I started playing. The annoyance about single user mode for SQL Server is that its not really single user, but more...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: SQL Server 2005, SQL Server 2008, Tips and Tricks
1
kudos
spam Kudos Remove

SQL Server Failover Cluster and Filestream feature enabled, issues surronding the failover and failback.
published 789 days, 16 minutes ago posted by sasa 798 days, 52 minutes ago
Saturday, March 27, 2010 6:01:01 AM GMT Thursday, March 18, 2010 5:25:06 AM GMT
SQL Server Failover Cluster and Filestream feature enabled, issues surronding the failover and failback.
At the first instance the error is clear that some problem with SQL resource that was allocated to the Cluster resource. Just a background on SQL Server Failover Clustering, that the server cluster consists of a failover cluster instance that runs under Cluster Services (MSCS). The instance of SQL Server might be hosted by Microsoft MSCS-based nodes that provide the Microsoft Server Cluster, say if problems exist on the nodes that host the server cluster, those problems may manifest themselves as...(read... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: Cluster, failover, filestream, kba, SQL Server, SQL Server 2008
1
kudos
spam Kudos Remove

SSIS - XML Source Script
published 795 days, 42 minutes ago posted by sasa 804 days, 1 hour, 20 minutes ago
Sunday, March 21, 2010 5:35:37 AM GMT Friday, March 12, 2010 4:57:12 AM GMT
SSIS - XML Source Script
The XML Source in SSIS is great if you have a 1 to 1 mapping between entity and table. You can do more complex mapping but it becomes very messy and won't perform. What other options do you have? The challenge with XML processing is to not need a huge amount of memory. I remember using the early versions of Biztalk with loaded the whole document into memory to map from one document type to another. This was fine for small documents but was an absolute killer for large documents. You therefore need a... (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: c#, SQL Server 2005, SQL Server 2008, SSIS - Integration Services, Tips and Tricks, XML
Previous 1 2 3 Next