img by Coba

Results tagged “SQL Server”

A Comparison of SQL Server Pricing Through the Years

- by Scott Whigham on November 12, 2009 6:02 AM
Recently Microsoft announced the new SQL Server 2008 R2 pricing and a lot of people wondered, "Why such big price increases?" There are the new "premium" editions - Datacenter and Parallel Data Warehouse - which are priced at more than $50,000 per processor but what caught my eye is the...
0
comments
read postarrow
Tagged As: , , , , ,

How is anyone supposed to know how to use trace flag 4621?

- by Scott Whigham on March 18, 2009 1:33 PM
I'm helping a client work through some TokenAndPermUserStore performance issues and we're investigating using the new trace flag 4621 that was introduced in Service Pack 3 for SQL Server 2005. Oh wow is this not easy stuff to wade through... Here's a little background: in SQL Server 2005, there is...
0
comments
read postarrow
Tagged As: , ,

CU4 for SQL Server 2008 RTM Is Out

- by Scott Whigham on March 18, 2009 8:31 AM
First, let's get the acronyms out of the way: "RTM" stands for "Release To Manufacturing" and it is the software as it was originally shipped (no service packs or hotfixes). "CU" is the "Cumulative Update" and this is many hotfixes rolled into a single installer (but not so many that...
0
comments
read postarrow
Tagged As: , ,

Should I Install SQL Server on a Virtual Machine (such as Hyper-V or VMWare)?

- by Scott Whigham on March 13, 2009 3:19 AM
It's pretty rare that an amazingly awesome whitepaper comes out but one just hit the net. The article is written my Mark Pohto, a senior systems engineer in Microsoft IT with help from both Jimmy May and Ward Pond. This whitepaper is very, very much worth your time. Do you...
1
comments
read postarrow
Tagged As: ,

How to Find the Truncated Mean in SQL

- by Scott Whigham on February 6, 2009 5:34 AM
The truncated mean is an average over a set obtained after you actually ignore the highest and lowest numbers. For example: given a set of the three numbers 100, 200 and 300, the "average" would be 200. We would add 100, 200, and 300 then divide by the number of...
2
comments
read postarrow
Tagged As: , ,

How to Implement Landing Page Hit Tracking in ASP.NET (Part 4)

- by Scott Whigham on January 23, 2009 10:50 AM
In Part 1 we talked about the goals of the project and the two base tables. In Part 2 we talked about the LandingPageHit table. Part 3 covered the classes, LandingPage and WebsiteUtilities. In Part 4 of this long series about how to do conversion tracking with ASP.NET and...
0
comments
read postarrow
Tagged As: , ,

How to Implement Landing Page Hit Tracking in ASP.NET (Part 3)

- by Scott Whigham on January 23, 2009 10:30 AM
In Part 1 we talked about the goals of the project and the two base tables. In Part 2 we talked about the LandingPageHit table Now that we have the base structures, the next (and near-final) database-driven piece would be the stored procedures to audit the hit, verify a...
0
comments
read postarrow
Tagged As: , ,

How to Implement Landing Page Hit Tracking in ASP.NET (Part 2)

- by Scott Whigham on January 23, 2009 9:45 AM
In Part 1 of this series, we created our database and two tables. In Part 2, we'll create the classes and wire them up to a page... Step 2: Create/open website project and add references Step 1: Create the tables Step 2: Create/open website project and add references For...
0
comments
read postarrow
Tagged As: , ,

How to Implement Landing Page Hit Tracking in ASP.NET (Part 1)

- by Scott Whigham on January 23, 2009 8:57 AM
In this series, I will show you how to implement page tracking using a SQL Server and ASP.NET system. This will work for any version of SQL Server and any version of the .NET Framework as well as C# or VB. This tutorial requires: SQL Server, Visual Studio (or...
1
comments
read postarrow
Tagged As: , ,

A SQL Server Security Hole “Could Allow Remote Code Execution”

- by Scott Whigham on December 23, 2008 6:36 AM
The skinny: apparently back in April, SEC Consult notified the MSFT team of a vulnerability in the sp_replwritetovarbin system stored procedure. Microsoft has thus far declined to create a patch and so, for whatever reason, SEC Consult decided to release the vulnerability publicly. You can view the scripts to reproduce...
0
comments
read postarrow
Tagged As: , ,

CU1 for SQL Server 2005 SP3 Already Out!

- by Scott Whigham on December 21, 2008 4:38 PM
FIVE days after the release of SP3 we already have CU1. Give me a break... Timeline is simple: Dec 15: SP3 released. Dec 20: CU1 released. I haven't installed it but what do you want to bet that CU1 requires me to stop/restart my SQL Server?! Argggghhhhhh. This follows on...
0
comments
read postarrow
Tagged As: , , ,

Recommendations For Using the SQL Server 2005 Best Practices Analyzer

- by Scott Whigham on December 19, 2008 8:47 AM
The SQL 2005 BPA can be found here: SQL Server 2005 Best Practices Analyzer Do: Take full, differential, and/or log backups (whichever is appropriate) before running the analyzer (so you don't get warnings/information messages that clutter the report) Prior to running the BPA, run DBCC CHECKDB commands on your DBs...
0
comments
read postarrow
Tagged As: , ,

Should you install SQL Server 2005 Service Pack 3? Not so fast...

- by Scott Whigham on December 18, 2008 5:55 AM
I just read an interesting piece over on Aaron Bertrand's blog about how the overlap of Cumulative Updates 10 and 11 (CU 10 and CU 11) overlap with Service Pack 3. It's a good read - check it out here....
0
comments
read postarrow
Tagged As: , ,

Good bookmark: How the SQL Server developers update SQL Server

- by Scott Whigham on December 16, 2008 3:55 PM
Here's a good read: How the SQL Server team releases updates. Okay - so that's not the official title (the official title is the overly officious An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems) but I think my title is something...
0
comments
read postarrow
Tagged As: , ,

How to Speed up SQL Server Management Studio in SQL Server 2005

- by Scott Whigham on December 11, 2008 8:31 AM
Have you ever launched SQL Server Management Studio (SSMS) and had to wait over 60 seconds before you could even login? I have - all too often! It's annoying - and thankfully there's an easy fix. Launch Internet Explorer Browse to Tools -> Internet options -> Advanced tab Uncheck the...
0
comments
read postarrow
Tagged As: , , ,

How to Customize SQL Server Management Studio via Switches

- by Scott Whigham on December 10, 2008 6:58 AM
SQL Server Management Studio (SSMS) can be customized by using "switches" - little things added after the executable in the path to the file. Technically these are called "command line switches" and they are very common in most applications. Here's a great one for SSMS: Right click on your shortcut...
0
comments
read postarrow
Tagged As: , , ,

How to slipstream SQL Server 2005's Books Online Update

- by Scott Whigham on December 10, 2008 6:34 AM
Delete the original ...\SQL Server x86\Tools\Setup\SqlServer2K5_BOL.msi Rename the downloaded SqlServer2K5_BOL_Jul2006_v2.msi (or whatever the latest version is) to SqlServer2K5_BOL.msi and copy it to the ...\SQL Server x86\Tools\Setup folder. Run setup. Thanks to John Paul Cook, a SQL Server MVP out of Houston, TX, for pointing this out. John Paul Cook...
0
comments
read postarrow
Tagged As: , , ,

SQL Server 2005 Peer-to-Peer Replication (A peek inside Microsoft)

- by Scott Whigham on December 10, 2008 6:32 AM
Peer to Peer Replication made its SQL Server debut in SQL Server 2005 and just got even stronger in 2008. I found an interesting article recently that talks about how MSFT uses peer-to-peer internally and thought I would share: http://www.microsoft.com/technet/technetmag/issues/2006/07/InsideMSFT/default.aspx. It talks about how Peer-to-Peer replication with SQL Server 2005...
0
comments
read postarrow
Tagged As: , , ,
1
authors
scott whigham
grant moyle
chad weaver