|
|
How To
To include items that explain a process or technique
-
Posted Tuesday, January 10, 2012 7:00 AM |
The most common T-SQL command in use has to be the SELECT statement, it is the bedrock of any SQL Professional's day. Sometimes it's used to snatch some data from a table or two while some quick investigation is done, other times it is at the heart of Read More
|
-
Posted Monday, January 02, 2012 3:00 AM |
Many people reflect on their diet at this time of year and decide to make changes and I would suggest that all DBAs should do the same. This is not because I think any DBA is over-weight (although I'd like to be a bit lighter than I am) but because they Read More
|
-
Posted Monday, December 05, 2011 3:00 AM |
or: How I Learned to Stop Worrying and Love the Bomb Word* Microsoft Office Word is useful. There, I have confessed it, it's useful to me while I am working with TSQL. It's possibly only the search and replace function that I like but it's wrapped in Read More
|
-
Posted Wednesday, November 09, 2011 11:00 AM |
I have recently upgraded to Office 2010 at work and there are a few things that are a real problem for me. As a T-SQL developer and SQL Server DBA I copy and paste code to and from various applications and if Word gets involved it can has disastrous consequences. Read More
|
-
Posted Tuesday, November 08, 2011 3:00 AM |
I have covered SQL Server Alerts (Alerts are good, arent they?) on this blog before and I more recently did a post regarding Notifications (Are your Jobs talking to you) and how they should be configured. Now we need to check that these things are linked Read More
|
-
Posted Monday, October 10, 2011 3:00 AM |
A very quick post to say how proud and happy it made me to be involved with these two events. I was a helper and speaker at SQL Bits and, as I am a user group leader, one of the organisers of the SQL Relay event. My code samples and test data for the Read More
|
-
Posted Thursday, March 31, 2011 2:00 PM |
LiveJournal Tags: tsql,comments,tips and tricks,how to This blog entry is not one of mine. I have the pleasure of sitting back and letting someone else do the work! Ladies and gentlemen, this blog is written by ..... my wife! I have recently changed Read More
|
-
Posted Tuesday, March 08, 2011 3:00 AM |
LiveJournal Tags: TSQL,How To,Tips and Tricks,DMV,File Usage I'm not asking what makes you mad - that's what grinds your gears; I am asking what activities on your servers make your hard drive spindles get spinning. Do you know which files are the busiest Read More
|
-
Posted Monday, February 28, 2011 3:00 AM |
LiveJournal Tags: how To,ssms,tips and tricks,tsqlThis is in follow up to my last post How to make sure you see the truth in Management Studio which explained that the time that you see at the bottom of a Management Studio window cannot be believed to Read More
|
-
Posted Wednesday, February 23, 2011 9:00 AM |
LiveJournal Tags: TSQL,How To,SSMS,Tips and TricksDid you know that SQL Server Management Studio can mislead you with how your code is performing?
I found a query that was using a scalar function to return a date and wanted to take the opportunity Read More
|
-
Posted Monday, January 24, 2011 3:00 AM |
LiveJournal Tags: How To,SQL Server,Tips and Tricks,TSQL,Reporting Services
A little while ago I wrote a piece about finding database objects that rely on other objects that no longer exist - OK, I have my database ready, now what's missing? . This is Read More
|
-
Posted Tuesday, January 04, 2011 3:00 AM |
I was using SSIS for the first time on an instance the other day and came across this error when I executed a package Package migration from version 3 to version 2 failed with error 0xC001700A. The version number in the package is not valid. The version Read More
|
-
Posted Wednesday, December 29, 2010 3:00 AM |
During the life of any database there will be times when the development makes a change that breaks functionality of an object somewhere else in the database. SQL Server does a good job in some places of making this impossible, or at least really difficult, Read More
|
-
Posted Monday, December 20, 2010 3:00 AM |
OK, pretty much any DBA worth their salt has read Brent Ozar's (Blog | Twitter) blog about getting a baseline of your server's performance counters and then getting the same counters at regular intervals afterwards so that you can track performance trends Read More
|
-
Posted Thursday, November 25, 2010 3:00 PM |
LiveJournal Tags: How To,SSMS,Tips and tricks,Execution Plans This is a quick tip that I hope will help you use SQL Sentry's Plan Explorer tool. It's a really great tool for viewing Execution Plans - something that SSMS isn't too great at. If you Read More
|
|
|