Dave does Data

Tutorials, Performance Tuning, Tips & Techniques on SQL Server & its ecosystem.

Browse by Tags

Tagged Content List
  • Blog Post: "How To": Performance Tuning - High Frequency Queries - Test Harness

      If I had a month free I’d like to do a brain dump on how to Load Test, Bulk Up data, find problem queries, refactor them with confidence etc. Then deliver it in one comprehensive guide. But that is unlikely, so I’ve decided to deliver little bits at a time then write an index to pull it all together...
  • Blog Post: Handy Links for SQL 2008 R2 & .NET Development

    This post is not about a unique body of work, it is just a list of links to materials I’ve found useful. I hope it may make it easier for me to point people here rather than have them write down or remember URL’s If you are looking for SQL Add-in’s, Utilities, Sample Code & education, perhaps you...
  • Blog Post: Review: Programming MS SQL Server 2008 – Holistic coverage for an App Developer

    Following on from my review of my library. This week, Programming Microsoft SQL Server 2008. Summary: It appears to me that the authors started this book with the premise “There is a lot in SQL2008 that can dramatically change the way you architect solutions. Many features elegantly remove some of the...
  • Blog Post: Review: MS SQL Server 2008 Internals – Core knowledge for all DBA’s

    Following on from my review of my library. This week, Microsoft SQL Server 2008 Internals. Summary: This is not as the title might suggest, “special” information for elite DBA’s. It contains the base knowledge that all DBA’s need in order to understand what is happening under the covers. It may stop...
  • Blog Post: Tip: Avoiding REALLY hard to reproduce bugs in Production

    If everything is bug free in Development, Testing, User Acceptance Testing (UAT) how can it possibly go wrong in Production? The following post looks at how that can occur… Intermittently. Recommendation: Ensure that the Server Names & SQL Instance names of your Test servers have the same or more...
  • Blog Post: Tip SSMS: How to quickly find the line with the Syntax error

    When executing code in SQL Server Management Studio. Occasionally people make errors. If you find yourself counting thru your TSQL Batch up to “LINE 231” where your error is supposed to be, then this tip is for you.   Tip: Double Click on the Error message in the results pane. (In diagram below...
  • Blog Post: How to get Database Edition Power Tools to work on Visual Studio Team System 2008 Database Edition GDR

    If you want to compile sample code or write your own extensions for Visual Studio Team System 2008 Database Edition GDR (also known as DBPro or Datadude) this post will save you hours. Summary In Nov 08 when Microsoft shipped the GDR (General Distribution Release) for the Database Edition of VSTS . They...
  • Blog Post: Tip SSMS: Script your Entire Table including the Data – a hidden gem.

    Have you ever written a TSQL SELECT statement that builds INSERT Statements so you can script the entire table? Usually we do it to make it simple to create & load a “Reference or Lookup” table? Sure, Most DBA’s have. This Waay Cool little feature is buried in the options. You’ll never need to write...
  • Blog Post: Tip SSMS: How to BLOCK Select

    SQL Server Management Studio has so much capability, yet most people I meet don’t seem to have read the manual to discover it. So I thought I might post a few of features I find invaluable. This works for SQL 2005, SQL2008, SQL2008 R2 & Visual Studio. Summary: Tip 1: It is possible to “ALT + Select...
  • Blog Post: Review: MS SQL Server 2008 T-SQL Fundamentals – a must have for most people.

    At Tech-Ed Aust last week I had an interesting evening with a few people chatting about finding information & how hard it is to judge the value of textbooks when you are looking online. As I am an avid reader & have a huge library a few of my colleagues asked me to post my 2 cents about the books...
  • Blog Post: TSQL Tips: The correct way to write your Scripts – ALTER PROC, don’t DROP & CREATE PROC

    SQL Management Studio has a very nice Scripting feature that generates scripts to DROP & CREATE your stored procedures, tables & other objects. This is handy, but not good for production systems. Most people use it, … to their peril. This post highlights the potential issues & shows a much...
  • Blog Post: Using TSQL Variables: Subtle BUG when assigning values to Variables via a Query

    I’m unsure if this is a BUG or “By Design” but for me it is unexpected & likely to cause your application to hang if you aren’t aware of it. So one more article in my “TSQL Best Practise” or “Good TSQL Coding Standards” posts. Summary: If you assign a value to a variable using a SELECT statement...
  • Blog Post: More FREE training for Developers & DBA’s

    I tend to forget about this little gem, so this post more of a reminder to me, that I hope you will find handy too. Ramp Up: eLearning Site Official News I’m happy to announce that we’ve just launched 3 brand new learning tracks on Ramp Up * ( www.MyRampUp.com ): Web Development with ASP.NET Move from...
  • Blog Post: Get SQL Server 2008 for FREE: FREE Database, FREE Reporting Solution, FREE Spatial

    If you are a Student, Teacher or anyone on a budget, don’t feel pushed to use Open Source databases like MySQL just because they have an entry level offering for free. You may be one of many who expressed concern for its quality & design which suffered when SUN purchased MySQL. Who knows what will...
  • Blog Post: How do I get FREE Software from Microsoft?

    It is common to hear students & small start-up businesses state “I use Open Source because it is free” or they download pirate Microsoft from really dodgy, spyware prone sites to get it free. The irony is that many of these people qualify to get the software for FREE or at least heavily discounted...
  • Blog Post: SQL Server 2008: April 09 Updates – Handy links

    Scanning the Microsoft sites it might not be obvious that April 09 was a huge month for new releases from the SQL Team. Given that it is sometimes difficult to find everything in one place I thought I’d make it easier for you by creating this index. Beyond the links there is nothing in this post particularly...
  • Blog Post: Free Chart Controls for .NET: Windows and Web – Handy Links

    Even though its been available for more than 6 months, many people have overlooked this little gem. Those that are using it get terribly excited when they discover how easy it is to use the features & capability it offers. So if you need very powerful charts in your application, read on. Below are...
  • Blog Post: SQL Server 2008 SP1 - Released

    April 09: Service Pack 1 for SQL 2008 can now be downloaded Download SQL 2008 Service Pack 1 from here: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19 See the SQL Server New Blog for more details : http://blogs.technet.com/dataplatforminsider...
  • Blog Post: Tip: Make your Identity Keys go Further

    It is extremely common to use computer generated Primary Keys in a table. eg: OrderID INT PRIMARY KEY CLUSTERED IDENTITY ( 1 , 1 ) NOT NULL Most people set the seed to 1. I don’t know why. Perhaps because it is the default value, maybe they display their keys to end-users, possibly they’ve...
  • Blog Post: SQL Server NOLOCK Hint & other poor ideas.

    Frequently I see production code, created by professional development teams, peppered with NOLOCK & other TSQL Hints. While totally understandable, as it is a common recommendation by many internet posts & often found in their sample code, this is a really bad practice. It often results in very...
  • Blog Post: SQL Reporting "How to" - Conditional Color 1/4: The Basics. Report Expressions & Custom Code

    This "How to" guide provides ideas & code samples on using color to improve your users understanding of the data in your reports. It includes using gradients of color in your tables & charts. It also covers using color to represent a second dimension &/or multiple levels of data...
  • Blog Post: SQL Reporting "How to" - Conditional Color 2/4: Functions for Tables & Charts

    This "How to" guide provides ideas & code samples on using color to improve your users understanding of the data in your reports. It includes using gradients of color in your tables & charts. It also covers using color to represent a second dimension &/or multiple levels of data...
  • Blog Post: SQL Reporting "How to" – Conditional Color 4/4: Charts & Multi-Dimensional analysis

    Part 4 of 4: Continuous Color functions for Multi-Dimensional analysis (in charts) This "How to" guide provides ideas & code samples on using color to improve your users understanding of the data in your reports. It includes using gradients of color in your tables & charts. It also covers using...
  • Blog Post: SQL Spatial - How to get Spatial data. (FREE Maps 'n Demographics)

    This post lists ways to get spatial maps, some of them are Free. If you are in a hurry jump to the last link, it is so cool. Then check out the Free Map sites. Overview There are 3 ways to get the spatial data for your application:- Buy it Download it - FREE Build it Yourself - FREE but costs time I...
  • Blog Post: Resource Recommendations - Data Mining

    I'm often asked "what references should I have for ... <Insert Technology here>. " For Data Mining, the MUST HAVE "bible" text book is... Data Mining with SQL Server 2005 (See the link for ISBN & similar details) Why do I love this book? It walks thru each data mining algorithm...
Page 1 of 2 (37 items) 12