|
|
SSMS
-
Posted Wednesday, December 14, 2011 3:00 AM |
I would be deafened by the chorus of DBA's shouting "It depends" at me after a question like that in person, I somehow feel safer from the far side of Live Writer. I have recently been looking at the number of indexes in one of my databases and have found 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 Thursday, October 20, 2011 3:00 AM |
Most DBAs will have at least a couple of servers that have SQL Agent jobs that are scheduled to do various things on a regular basis. There is a whole host of supporting configuration settings for these jobs but some of the most important are notifications. Read More
|
-
Posted Tuesday, October 11, 2011 3:00 AM |
At the SQL Relay event last week all the UK user group leaders did a combined session - The A to Z of SQL - where we all took two letters of the alphabet and gave a 2 minute (it was strictly timed) talk on something SQL related beginning with those letters. Read More
|
-
Posted Monday, September 12, 2011 3:00 AM |
I am wholly showing my age with the title of this blog post. The title of this post is quote that may or may not mean anything to you. It will, sadly, mean even less to you if you were not in the UK during the 1980's. Apologies for that but on with the Read More
|
-
Posted Tuesday, August 23, 2011 3:00 AM |
I'm moving a SQL Server off old hardware at the moment and one thing that makes life easier if to have the same schedules on the new server, all ready to pick from the UI when you are creating new jobs.
Having to create a new schedule in the middle 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 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
|
-
Posted Thursday, October 14, 2010 2:08 PM |
(written by Louis Davidson (@DRSQL) and Tim Ford(@SQLAgentMan), published by Simple Talk Publishing 2010) Firstly, this is a review of a book that I have only partly read. At the time of writing I am in the middle of chapter 4. There are lots Read More
|
-
Posted Sunday, September 26, 2010 3:24 PM |
I have mentioned putting comments in your code previously on this blog - Encouraging Comments - but I have just happened across a blog where there is a function that does date manipulation and could be handy for a project I am working on. There isn't Read More
|
-
Posted Thursday, September 02, 2010 7:55 PM |
Every good DBA/developer writes their code with some comments/instructions at the top. Now in many cases this is important to have visible when running the code as it may give advice on the results or what certain column values will mean. Now you can Read More
|
|
|