Browse by Tags

• 2005
• 2008
• access
• analysis
• Analysis Services
• application
• audit
• Backup
• best practices
• blocking
• clustering
• community
• connections
• cpu
• cubes
• cumulative
• database
• database mirroring
• databases
• dba
• dbcc
• developer
• Development
• Development &amp
• disks
• dmv
• Dynamic Management Objects
• dynamics
• edition
• enhancement
• enterprise
• error
• error log
• exception
• failover
• FAQ
• file
• fragmentation
• Hardware
• high availability
• i/o
• index
• indexes
• Integration
• jobs
• kba
• login
• management
• mdx
• memory
• Microsoft
• multiple
• network
• notification
• online
• package
• pae
• pass
• performance
• plan
• process
• processor
• profiler
• query
• recovery
• replication
• reporting
• Reporting Services
• security
• self
• server
• service pack
• service pack2
• services
• share
• sp2
• SQL 2008
• sql express
• SQL Server 2008
• ssas
• ssis
• SSMS
• ssrs
• statistics
• stored procedure
• table
• tables
• Team System
• tempdb
• transaction
• trigger
• tsql
• T-SQL
• tuning
• update
• upgrade
• version
• webcast
• windows
• x64

• Enabling Partition Level Locking in SQL Server 2008

  Author: Thomas Kejser Reviewers: Juergen Thomas, Sanjay Mishra, Stuart Ozer, Lubor Kollar, Kevin Cox, Kun Cheng In this blog, we will provide additional details on a well-hidden feature in SQL Server 2008 – partition-level locking. But before we illustrate Read More... Posted Thursday, March 04, 2010 9:54 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: sql, SQL Server, Data Warehouse, partitioning

• Quest DMV Breakfast Code – Disk IO

  For any of you who attended the Quest breakfast at PASS (and anyone else really) I wanted to go ahead and post the code and give a little wrap up/explanation. (I will post the stuff on perf counters later. They are cool, but this is really what I wanted...( Read More... Posted Thursday, November 05, 2009 3:52 AM from Louis Davidson | (Comments Off) Filed under: SQL Server, Dynamic Management, pass, SQL Tools, Speaking, SQL Techniques

• Fifth pillar - Secure

  As I have mentioned in all of the previous posts, basic functionality is the foundation of any system. So it goes without saying that if you have just implemented a payroll system, everyone is getting paid.  To meet the basic bar that EVERYONE agrees...( Read More... Posted Wednesday, October 07, 2009 9:52 AM from Louis Davidson | (Comments Off) Filed under: security, SQL Server, database design, Pillars

• SSAS: T-SQL Equivalent for a Many-to-Many relationship

  This question came a while ago now in this SSAS forum thread: What is wrong in my query and I thought it was something that may interest other people. Basically it boiled down to trying to find a T-SQL equivalent to the following MDX which is querying Read More... Posted Sunday, May 03, 2009 9:47 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: sql, Analysis Services, SQL Server, mdx, Many to Many

• Headed..South..To Atlanta for SQL Saturday

  Heading down to SQL Saturday ( www.sqlsaturday.com ) in Atlanta to give a 9:15 AM session on Database Design, with a greater than normal dose of normal thrown in. I hope there are more than 7 people to show up, because I would hate if everyone got some Read More... Posted Friday, April 24, 2009 12:55 PM from Louis Davidson | (Comments Off) Filed under: SQL Server, Speaking

• FAQ: SQL Server 2008 SP1 released, but how does the fix list relate to CU4 that was just released?

  I have received a ton of private mail on this, hence rather than just pasting the same answer in I’m going to take it on here. Interestingly enough I explained this problem, with a slightly different context, back when 2005 SP1 came out here , but lets Read More... Posted Wednesday, April 15, 2009 10:23 AM from Euan Garden's BLOG | (Comments Off) Filed under: SQL Server, Microsoft, SQL 2008

• Debugging SSIS ScriptTasks and ScriptComponents with Information Messages

  I recently had to do some simple debugging of some script tasks and components in SSIS and through I would share the simple technique that I was using. While this is only just above the level of debugging using MessageBoxes it can still be quite handy. Read More... Posted Sunday, March 29, 2009 8:28 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: SQL Server, integration services

• SQL Down Under Code Camp 2008 - Attribute Relationships Presentation

  At the recent SQL Down Under Code Camp my presentation was on Attribute Relationships and was sub titled - "You can choose your relatives, but you can't choose your friends". It covered Attribute Relationships, how they work, how to set them up and why Read More... Posted Friday, October 24, 2008 6:24 AM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: SQL Server

• SQL Server 2008, Reportbuilder RTMs

  Get it here Read More... Posted Tuesday, October 21, 2008 6:35 AM from Euan Garden's BLOG | (Comments Off) Filed under: SQL Server, Microsoft, SQL 2008

• Podcasts from the 2008 Microsoft BI Conference

  The B-eye-network website is hosting a series of podcasts from the Microsoft BI Conference. I have not had a chance to listen to any of them yet, but there are quite a number of senior Microsoft people on the list so they should be interesting. http://www.b-eye-network.com/podcast/archive/index-new.php?show_id=35&show_year=200 Read More... Posted Friday, October 10, 2008 10:35 AM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, SQL Server

• High performance loading in SSIS for Oracle and Teradata

  While SSIS has always been able to load SQL Server at high speed it doesn't use any of the high speed Oracle APIs that are available. Well there is now a new high performance loader for Oracle and another one for Teradata. Downloads are here. Read More... Posted Monday, October 06, 2008 1:55 PM from Euan Garden's BLOG | (Comments Off) Filed under: SQL Server, Microsoft

• Slipstreaming SQL Server Updates/Service Packs in SQL 2008, almost

  One of the most common asks for SQL Server related to servicing/patching (after uninstall of updates/SPs) is the production of slimstreamed media, ie where the Update/SP and the RTM are included together in a single plackage. Now there are a couple of Read More... Posted Wednesday, October 01, 2008 9:32 AM from Euan Garden's BLOG | (Comments Off) Filed under: SQL Server, Microsoft, SQL 2008

• SQL Down Under Code Camp 2008

  The SQL Down Under Code Camp for 2008 is on in a couple of weeks. Over the weekend of the 11th and 12th of October 2008 the cream of the Australian SQL Server community will gather at Charles Sturt University in Wagga Wagga . This is a free community Read More... Posted Tuesday, September 30, 2008 10:27 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, SQL Server

• TechEd: BI Power Tools

  For those of you who attended my talk or for any other interested parties, I have uploaded my slide deck from my MVP Theatre presentation at Tech.Ed Australia 2008 to my sky drive here: There is not too much to this deck as the presentation was mainly Read More... Posted Saturday, September 06, 2008 2:10 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: powershell, SQL Server, bi, Freeware, Open Source

• Invalid namespace - Running SSRS against a named instance

  I recently went to check the configuration of my SQL Server 2008 Reporting Services instance (which is a named instance called "SQL08") and it came up with a "connect" dialog and when I clicked on the "find" button I got an "invalid namespace" error. Read More... Posted Thursday, September 04, 2008 8:21 AM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Reporting Services, SQL Server, SQL Server 2008