INCLUDE_DATA

Posts Tagged ‘sql server’

Baltimore SQL Server Users Group 5/4

April 23rd, 2009

Last night at the Frederick .NET user group Jeremy Kadlec of Edgewood Solutions (one of the founders of the Baltimore SQL Server Users group, was a speaker.  I didn’t realize that this group met so close to where I work here in Columbia.  After checking out the website I was excited to learn that they met on the first Monday of the month.  Tuesdays and Thursdays, which seem to be popular days for most of the other user groups in the area are not an option for me since I handle the kids those nights while my wife tutors.

So, I’ll be checking out the group for the first time on Monday May 4th.

Presenter: Jack Richins of Microsoft

Title – SQL Server 2008 Security

Abstract – SQL Server 2008 introduced three new security features – Transparent Data Encryption, Enterprise Key Management, and SQL Audit. With increased concerns about privacy and data thefts, security remains a “must have” business feature even with constrained budgets. Come learn how to use these features to better secure your database applications and met business compliance regulations.

Learn how to:
* Protect your data at rest
* Use 3rd party key management systems to encrypt data in SQL Server with keys stored outside of SQL Server
* Keep an audit record of access to sensitive data without tanking your performance

Learn more about their meeting schedule here.  If you’re in the area and are interested in the topic, stop by!

SQL Server 2008 SP1 Final Released?

April 1st, 2009

We’ve had an open support ticket with Microsoft due to some bugs we’re seeing with SQL Server Reporting Services 2008.  After Microsoft saying that the Update Pack 4 for SQL Server 2008 (released back in mid-March) would fix our problems, they sent us an email this week letting us know that the final version of Service Pack 1 for SQL Server 2008 would be released yesterday, March 31, 2009.

Unfortunately so far the links they’ve provided don’t go anywhere.  I’ll be checking these links through the day and the rest of the week and will post any further updates if I actually do find the “real” links.

According to our internal document, below is the information about SP1:

Microsoft SQL Server 2008 Service Pack 1

Release date: March 31, 2009

How to obtain

To obtain SQL Server 2008 SP1, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19

To obtain Microsoft SQL Server 2008 Feature Pack, April 2009, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=b33d2c78-1059-4ce2-b80d-2343c099bcb4

To obtain Microsoft SQL Server 2008 Express Edition SP1, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=01af61e6-2f63-4291-bcad-fd500f6027ff

It should be released on March 31, 2009.

Cumulative update package 3 for SQL Server 2008

January 30th, 2009

Since we have been developing with SQL Server 2008 here at work on my latest project I have been keeping an eye on its available updates and fixes (at least until they come out with Service Pack 1). Cumulative Update Package 3 has been made available now.

Per Microsoft:

A supported cumulative update package is now available from Microsoft. However, it is intended to correct only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems. This cumulative update package may receive additional testing. Therefore, if you are not severely affected by any of these problems, we recommend that you wait for the next SQL Server 2008 service pack that contains the hotfixes in this cumulative update package.

After scanning down the list it seems that we could benefit from at least two or three fixes listed:

  • FIX: You may encounter a deadlock scenario when you use table variables in SQL Server 2005 or in SQL Server 2008
  • FIX: When you use a ReportViewer control to view a SQL Server 2008 Reporting Services report that contains two pages, the formatting for the second page is lost
  • FIX: When you print a report by using the SQL Server 2008 Reporting Services Client-Side Printing functionality, the spacing is too small or too large

I would probably take Microsoft’s advice and hold off installing this update if you’re not specifically seeing any of the issues mentioned in the fix list.

You can download Cumulative update package 3 for SQL Server 2008 here.

SQL Server (2008) Performance Tuning Resources

December 23rd, 2008

Here is a (running) list of some SQL Server Performance Tuning resources that I’ve compiled over the past week or so.  These have been helpful in educating me on the black art of database performance tuning.  I realize the title states SQL Server 2008, but really most of these probably apply for SQL Server 2005 and 2008.  I, particularly am working with 2008, which is why I’ve put them into that category.

General

Missing Indexes

Duplicate Indexes

Unused Indexes/Index Usage

Re-indexing

Inefficient Queries

Performance Counters

Performance Data Collector

Database Engine Tuning Advisor

Updating Statistics

Deadlocks