SQL Saturday #91: Omaha – I will be presenting
Quick Tip: Error: 18456, Severity: 14, State: 38.
Saturday, August 27th, in Omaha, NE, we are hosting a SQL Saturday event that is promising to be a great time. This is a free event ($10 lunch fee if you want lunch on us) that helps promote our local SQL PASS chapter. Register here: http://www.sqlsaturday.com/91/eventhome.aspx I will be presenting on two topics: SSIS changes […]
SQL Server Future – Code Name “Denali” CTP1 Now Available!
When trying to investigate the SQL error, “Error: 18456, Severity: 14, State: 38.” it can be frustrating when not a single log on the system will tell you what the actual problem is. In the case of state 38 (16 or 27 prior to SQL 2008) this error means the database specified in the client […]
Be careful with sp_configure
The first public CTP of the next major version of SQL Server is now available. Go and get it, kick the tires, and let the team know about any bugs you may find. Some of the immediate changes to highlight in CTP1 are: SSMS is now based on Visual Studio, sequence generators, several new DMV/DMFs […]
SQL Server – Do you want to QUALIFY your results?
For those of you that work extensively with sys.dm_exec_query_stats and associated plan cache DMVs, be aware that altering the server’s ‘max degree of parallelism’ setting will flush the query plan cache. You may see this message in your server’s SQL Log file: “SQL Server has encountered 1 occurrence(s) of cachestore flush for the ‘SQL Plans’ […]
SSIS – SSISTalk.com Content
Teradata offers the ability to build a query, and then use a QUALIFY statement that filters the resulting resultset. This is especially handy when using a ROW_NUMBER function where you are partitioning on a natural key (or whatever it may be) and you want to return only the rows where the ROW_NUMBER value is 1, […]
Book Announcement – SQL Server MVP Deep Dives
If you have something that you’d like to see blogged here regarding SSIS and/or SQL Server, please let me know and I’ll see what I can do. Also, if you find a post here that you’re using to work on an issue in SSIS 2008, let me know if it isn’t working for you. It […]
A collection of 53 Microsoft MVPs (myself included) have wrapped up authoring one of the greatest SQL Server books yet to hit the shelves – SQL Server MVP Deep Dives. This book brings together the experience from all corners of SQL Server: Design & Architecture, Development, Administration, Performance Tuning & Optimization, and Business Intelligence. Each […]