Category SQL

Retiring Exams, Get your Trika for 40% off!

by Christopher Kusek (PKGuild) Certification, Christopher Kusek, Informational, Microsoft, SQL, Trika!

You heard it here! A number of exams which are retiring (March 31, 2009) are being offered at a 40% reduction! by my math that looks to be $50.00 off!

All the details can be found here –

Price reduction on retiring exams (and VS/SQL upgrade exams)

But for those who don’t want to click and link off, I’ll copy the best bits!

Here are the exams with reduced price:

So, check it out especially if your certification happens to align with skill-set.

And if not – give a shout out to Trika over at her blog!

CWUG Olympics this Monday!!! (In Downers Grove!)

by Christopher Kusek (PKGuild) Certification, Christopher Kusek, CWUG, Hyper-V, Informational, Microsoft, SQL, Windows Server

That’s right! I’m actually telling you about the CWUG when it ISNT the day of the event!

And lo and behold, there will be some great things going on this Monday in Downers Grove!

We bring you the CWUG Geek Olympics, with prizes of sorts, food as always and more Points to help secure your place in winning the Laptop at the end of the year!

I’d highly encourage you to register for this event, but don’t hesitate to email or call me if you find that registration is full… I might be able to pull some strings! ;)

This will be a very special event, with beasts! …definitely Geek Trivia, Competition and Prizes!

image

Don’t wait! Sign up now! (And most importantly, show up)

Agenda:

Monday

5PM-6PM – Food, Networking, etc
6PM-9PM – Competition, Trivia, Prizes, Education, Technology, insanity!

So, come on down! I’ll seeeeeeee you there!

SQL City! 2 More 2008 Beta Exams (71-450) (71-452)

by Christopher Kusek (PKGuild) Baltimization, Certification, Christopher Kusek, Informational, Microsoft, SQL

I know you’re tired of all of these MCTS SQL Beta Exams

Which means now it is time for the PRO SQL 2008 Beta Exams!

SQL Server 2008 Exam Beta: 71-450: PRO: Microsoft SQL Server 2008, Designing, Optimizing, and Maintaining a Database Administrative Solution

Registration begins: August 15, 2008
Beta exam period runs: August 18, 2008– September 16, 2008
Promo Code: 239F4

SQL Server 2008 Beta Exam: 71-452: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008

Registration begins: August 8, 2008
Beta exam period runs: August 13, 2008– September 10, 2008
Promo Code: 3568C

Registration Information
To register in North America, please call:
· Prometric: (800) 755-EXAM (800-755-3926)
Outside the U.S./Canada, please contact:
· Prometric: http://www.register.prometric.com/ClientInformation.asp

So, get down with your fairly straight-forward self, get out there:

sign up, register and test! test! test!

Special thanks to our good friends at the Certification Beta Blog for these postings.

SQL Server 2008 RTM’ing it up the place!

by Christopher Kusek (PKGuild) Baltimization, Christopher Kusek, General, Informational, Microsoft, NetApp, SQL

image

The word is out!

It’s official! SQL Server 2008 has gone RTM!

And I expect in short-order a full support for SQL 2008 with SMSQL – as things are certainly inline with this paper published in February of this year:

MICROSOFT SQL SERVER 2008:

DECISION SUPPORT WORKLOADS -1TB DATA WAREHOUSE ON IA64

So, coming soon to a test lab near me (at home) I’ll be upgrading to SQL 2008 with RTM, instead of the RC0 release I’ve been running!

Good luck upgrading, planning and sizing your environments!

When security best practices collide (Crippling iSCSI in Windows)

by Christopher Kusek (PKGuild) Baltimization, Christopher Kusek, Informational, Microsoft, NetApp, SQL, Storage, Windows Server

As a security guy, I can tell you – There are a lot of really good security best practices to be applied across all systems, applications, servers and a world over. But when implemented unchecked – Problems will arise.

What I am talking about specifically is this little doozy – EnablePMTUDiscovery

Value name: EnablePMTUDiscovery
Key: Tcpip\Parameters
Value Type: REG_DWORD
Valid Range: 0, 1 (False, True)
Default: 1 (True)

The following list describes the parameters that you can use with this registry value:

  • 1: When you set EnablePMTUDiscovery to 1, TCP attempts to discover either the maximum transmission unit (MTU) or then largest packet size over the path to a remote host. TCP can eliminate fragmentation at routers along the path that connect networks with different MTUs by discovering the path MTU and limiting TCP segments to this size. Fragmentation adversely affects TCP throughput.
  • 0: It is recommended that you set EnablePMTUDiscovery to 0. When you do so, an MTU of 576 bytes is used for all connections that are not hosts on the local subnet. If you do not set this value to 0, an attacker could force the MTU value to a very small value and overwork the stack.

    Important Setting EnablePMTUDiscovery to 0 negatively affects TCP/IP performance and throughput. Even though Microsoft recommends this setting, it should not be used unless you are fully aware of this performance loss.

    That little excerpt taken from:
    How to harden the TCP/IP stack against denial of service attacks in Windows 2000

    This KB article is still used and is applicable to the Windows 2003 space, but what does this do exactly?

    This will drop all transmissions over TCP/IP down to 576 byte packets. Oh and this is a global setting.
    So, you go to connect up to an iSCSI LUN, and it connects up just fine.
    Your host is working, your storage is working everything is all doozy.

    When you start to try to actually -use- that connection for storage though, you’ll begin to experience exponential latency. This latency will translate into IOPS problems and access to the disk, masking this making it appear to be a disk issue. This effectively cripples your application, yet is hidden so well from the system as a problem without sniffing or using something like mturoute you’d never know it is happening.

  • MTURoute is your friend and will help you determine your current MTU

    With that said, on any systems with iSCSI connectivity, I strongly encourage you to NOT disable this setting, ensuring that EnablePMTUDiscovery is always set to 1

    Thanks for your time!