Bob Duffy's Blobby Blog

SQL Server | BI | Dot.Net | Office | Sharepoint | MCE | Database Stuff

Browse by Tags

Tagged Content List
  • Blog Post: Using a SAN to Initialize Replication

    I've chatted to a few customers about the possibnility of using a SAN based snapshot to initialise transactional replication. This can be fantastic when you are using a replica to provide "near real time" reporting. Up until now, documentation has been a bit light on the ground on this apporoach,...
  • Blog Post: Dimensional Modelling and Cube Building 101

    Thanks to everyone who came to the Dublin SQL users Group session on Tuesday. I hope that we addressed some aspects of “cube fear” that is common in even very experienced relational professionals. For me just being comfortable building that first cube is a great feeling. We got some great feedback...
  • Blog Post: Why Not to Sysprep SQL Server

    If you do a lot of installs its a good idea to have an automated process for provisioning SQL Server. A lot of people try to use "sysprep" Here's a few reasons why not to use sysprep. Its not supported by Microsoft CSS. SQL will not work properly until it is "renamed". If you have...
  • Blog Post: Troubleshooting SQL 2008 Installation (Access Denied)

    I have to say that the improvements in the SQL 2008 installation have been pretty good to me. We have a Hyper-V lab with automated SQL installation based on configuration templates which works really well. We can get a box provisioned with SQL 2008 in under 20 minutes. We can do it in a few minutes using...
  • Blog Post: Configuring Max Worker Threads in SQL 2005

    One of the changes in SQL 20005 is that the default value of Max Worker Threads has changed from 255 to zero, meaning that SQL Server now automatically determines the optimum number of threads. You can determine the maximum number of threads SQL Server has actually configured and how many it is currently...
  • Blog Post: Last Exam to Go on SQL Ranger 04!!

    Out last written exam tomorrow!!! There was definitely a sense of the end of a long journey when we finished the last class today (VLDB scenario). I don't think people will be jumping for the pub on Friday as everyone will be flopping down in bed ;-) The SQL ranger team and centre of Excellence folk...
  • Blog Post: What Does Lock Pages in Memory Do

    I thought I would post some clarification on what the famous "Lock Pages in Memory" policy setting does and does not do. 1. It prevents the operating system from stealing the buffer pool (see previous blog on buffer pool), thus shrinking the working set. 2. It is NOT available on Standard Edition...
  • Blog Post: How to set MAX_SERVER_MEMORY

    OK I'm on a roll here blogging as my brain is full up on the MCA course. Here's a good tip on how to calculate the MAX_SERVER_MEMORY a) calculate worker threads (assuming set correctly, as default max 255 may be too low for huge beasts) select max_workers_count from sys.dm_os_sys_info b) Figure out thread...
  • Blog Post: SQL Server Memory Architecture. Myth Busting and how sad is AWE/32 bit.

    I have a little picture below to show how memory is broken up in the SQL Server Working set. Some key Myths to dispel: a) The Max Memory Setting only sets the target memory for the buffer pool not for the whole of SQL Server working set. So do not set it as high as the MEM you think SQL has to play with...
  • Blog Post: The SQL Server Disaster Game

    I have been doing a great course with Paul Randal on disaster recovery for SQL Server. He has a great blog on just about everything to do with DBCC and disk structures and recovery. See http://www.sqlskills.com/blogs/paul/default.aspx Here is a little flow chart I made up for some fun:   The art...
  • Blog Post: Mid Way Through Ranger 03

    I've just survived week 3 of the SQL Ranger Rotation 04 here in Redmond. Whats its been like: a break neck sprint through level 300-500 content on SQL nearly every aspect of SQL. Man I thought I was good on SQL Server until Paul Randal started explaining low level on Disk Structures - or Gert Drapers...
  • Blog Post: Managing SQL Server for MOSS

    There is a new white paper available on managing SQL Server for MOSS environments. http://go.microsoft.com/fwlink/?LinkId=111531&clcid=0x409 Great tips on Index defragging and use of DBCC. One thing that I'm not sure I entirely agree with is the adding a proc to the user database to support index...
  • Blog Post: Off to Ranger/MCA Training

    I'll be off to the states for the four week MCA:Database training. http://www.microsoft.com/learning/mcp/architect/database/default.mspx Speaking to people who have been on the course before this is really exciting. We get to spend four weeks in training with folks from the product team, and some pretty...
  • Blog Post: My Trip to the land of XML Messaging

    Sorry I've been off the radar a while. I've been working as a Solution Architect on a large telco solution. I'm very happy with the results, We managed to make good use of lots of SQL Server programmability features such as XML, service broker, SQL CLR, new error handling, UDF's and also integrate nicely...
  • Blog Post: Do I Need 64 Bit SQL Server

    When moving to SQL 2005 from 2000, some customers are asking what real benefit 64 bit brings. The short answer is : - 64 bit is the future - rumours are abound that future releases of SQL Server might not even have a 32 bit sku (except developer editions, etc). - Virtually No OEM is making servers which...
  • Blog Post: Improving SQL Disk Performance #2 Windows Stripe Size

    There are some urban legends around the Windows stripe size that you should set for SQL Server. I have seen recommendations of 64k for both data and log internally at Microsoft by some heavy hitting data Dudes, so that is good enough for me ;-) Generally a Storage Area Network will have a 64k block size...
  • Blog Post: Improving SQL Disk Performance #1 Partition Alignment

    There is a great article that you should read before configuring a disk subsystem for SQL Server. Predeployment I/O Best Practices . As mentioned, one of the common pitfalls is not ensuring that the offset of the first block is "64k" or a multiple thereof. Longhorn Server and Vista resolve...
  • Blog Post: SQL 2008 Questions from Users Group

    Thanks to everyone who attended the SQL Ireland Users group. We discussed some of the main new features in SQL 2008: compression encryption business continuity Resource Governor Entity Data Model Synchronisation Framework DWH Improvements Change Data Capture New Data Type Overall the favourite feature...
  • Blog Post: Why Should I use SQL Enterprise Edition?

    A lot of customers have been asking me if they need to use Enterprise Edition. the basic answer is that EE is sold mainly on the enhanced features which can be compared at: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx You will need to look at EE for sure if you require: Three...
  • Blog Post: 2008 Launch Tour

    I've been a bit off radar: up to my neck in a large  sql server / dot.net project and some time off for Christmas. Believe it or not I managed to get my thumb trapped in a Transformer on Christmas day and an ensuing infection - so if you see a consultant with a black thumb that might be me ;-) Anyway...
  • Blog Post: JDBC: When Good Prepared Statements go Bad

    I've been doing some performance comparisons of JDBC from Java with ADO.Net from Dot.net. One key thing that jumps out at me is JDBC tends to make more use of prepared statement, even to the point of abusing the poor thing.  I see some mid-tier manufacturer making bland claims like "Our SQL...
  • Blog Post: The Irish Java Technologies Conference

    The Irish Java Technologies Conference is running in Parnell Cinemas from wed 7th Nov to Fri 9th November. There is some pretty heavy hitting speakers on all things to do with Java, and the venue is excellent - beer, snacks comfy chairs and you can maybe sneak in to a movie... http://ijtc.firstport...
  • Blog Post: Whassup with my SQL Server

    Technorati tags: SQL SQL Server 2005 includes some great new dynamic management views and functions to help find out what is going on. These three in particular work quite well together. View/function Type Description sys.dm_exec_requests Dynamic Management View Returns...
  • Blog Post: Smart Indexing Part II - Conditional Rebuilding

    The Maintenance plan Wizard in SQL Server 2005 allows us to create an SSIS package that ReIndexes all Indexes. This is great for smaller systems, but on larger systems (over 10GB or so), the re-indexing can take a long time reducing the maintenance window and hammering the poor disks. The most elegant...
  • Blog Post: Smart Indexing Part I - Analyzing Indexes

    Introduction There are three items that any SQL Server maintenance plan should cover at a minimum: Backup, DBCC and ReIndexing. Indexes much like your old laptop disk drive will become fragmented. As data is inserted a “page split” may put data in a different part of the disk which will ultimately...
Page 1 of 2 (26 items) 12