Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server   (RSS)
Saturday, October 03, 2009 7:57 PM

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.
Posted by davele | 0 Comments
Saturday, September 26, 2009 11:14 PM

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
Posted by davele | 0 Comments
Wednesday, September 23, 2009 1:26 PM

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
Posted by davele | 0 Comments
Filed under: ,
Tuesday, September 22, 2009 1:16 AM

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
Posted by davele | 1 Comments
Monday, September 21, 2009 12:54 PM

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
Posted by davele | 0 Comments
Sunday, September 20, 2009 12:00 AM

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
Posted by davele | 0 Comments
Saturday, September 19, 2009 12:27 AM

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.
Posted by davele | 0 Comments
Wednesday, September 16, 2009 11:55 PM

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
Posted by davele | 0 Comments
Saturday, September 12, 2009 2:29 PM

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
Posted by davele | 0 Comments
Filed under: ,
Saturday, August 22, 2009 3:23 PM

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
Posted by davele | 3 Comments
Tuesday, May 19, 2009 11:18 AM

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
Posted by davele | 1 Comments
Tuesday, April 21, 2009 3:59 AM

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
Posted by davele | 2 Comments
Tuesday, April 21, 2009 3:56 AM

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
Posted by davele | 2 Comments
Tuesday, April 21, 2009 3:51 AM

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
Posted by davele | 1 Comments
Monday, April 20, 2009 9:36 PM

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
Posted by davele | 2 Comments
More Posts Next page »
 
Page view tracker