Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Promised Links from SQL Saturday 119 Presentations

If you attended one of the sessions I promised to post the links we discussed here. I have done my best to include everything we talked about but we covered a lot of ground. If you notice a link that I promised to share is missing then please let me… Read more

10 comments, 544 reads

Posted in Adventures in SQL on 19 May 2012

SQL University Troubleshooting Week: Having a Plan for Every Situation

Today’s SQL University post will highlight the need to have a methodology to address issues that we as IT professionals may encounter in the course of our day. We will start off by looking at why we need to have a plan for every situation, and then we will dig… Read more

0 comments, 385 reads

Posted in Adventures in SQL on 27 May 2011

SQL University Troubleshooting Week: Keeping an Open Mind

Office politics during a major event can be dangerous. It pays to be seen as contributing to solving the problem rather than being seen as a part of it. We may have the best intentions and know our systems inside and out but if we refuse to look into something… Read more

0 comments, 389 reads

Posted in Adventures in SQL on 26 May 2011

SQL University Troubleshooting Week: Communication

It should come as no surprise that the first topic I am covering this week is communication because the first thing I think anyone should do is communicate that they are troubleshooting an issue. This post will cover why we should communicate then dig into how to put together an… Read more

1 comments, 740 reads

Posted in Adventures in SQL on 24 May 2011

SQL University Troubleshooting Week Syllabus

Welcome to SQL University Troubleshooting Week. For anyone unfamiliar with SQL University, it is a project created by Jorge Segarra (Blog|Twitter) to give people a free way to learn SQL Server from the ground up. The professors at SQL University are bloggers with one or more… Read more

0 comments, 380 reads

Posted in Adventures in SQL on 23 May 2011

SQL University Troubleshooting Week: Syllabus

Welcome to SQL University Troubleshooting Week. For anyone unfamiliar with SQL University, it is a project created by Jorge Segarra (Blog|Twitter) to give people a free way to learn SQL Server from the ground up. The professors at SQL University are bloggers with one or more… Read more

3 comments, 460 reads

Posted in Adventures in SQL on 23 May 2011

SQL Saturday 67 Slides Are Now Available

I recently debuted a new presentation, “What To Do When It All Goes So Wrong”. The presentation is designed to give Database Administrators a basic overview of the skills they need to handle virtually any crisis that may arise. While the target audience is DBAs, I feel that most IT… Read more

0 comments, 316 reads

Posted in Adventures in SQL on 20 April 2011

Looking Up Email Addresses with PowerShell

A week or so ago Aaron Nelson (Blog|Twitter) put out a call for help on Twitter looking for anyone that could help with adding autocomplete for looking up an email address to a PowerShell forms application. The original request was to look up the user in… Read more

0 comments, 2,260 reads

Posted in Adventures in SQL on 20 January 2011

Making It Right

Last week Jonathan Kehayias (Blog|Twitter) used his blog to publicly call out Thomas LaRock (Blog|Twitter). I am not going to rehash the whole episode here. It is safe to say that while Jonathan made points he felt were correct he went about… Read more

0 comments, 328 reads

Posted in Adventures in SQL on 11 January 2011

Would You Like To Play A Game?

Do you have a favorite line from a holiday movie? Can you change it around slightly to make it SQL related? If so then this is the game for you. Starting this morning and going until we get bored or run out of ideas we will be playing #tsqlHolidayMovieLines on… Read more

1 comments, 425 reads

Posted in Adventures in SQL on 20 December 2010

Certificate Based Application Roles

What if I told you that you could sign an assembly that your Windows application uses with a certificate, load that certificate into SQL Server and then define rights on that user-assembly combination? The perfect world where a user would have different rights based on the application they are running… Read more

0 comments, 727 reads

Posted in Adventures in SQL on 30 November 2010

Using DMVs to Find the Ports that SQL Server is Listening On

The other day I was asked to provide the port number that a SQL Server instance was listening on. As luck would have it, the log file from the last time SQL Server started had rolled off so I was left with either using remote desktop to log onto the… Read more

15 comments, 1,374 reads

Posted in Adventures in SQL on 29 November 2010

How Do I Change SSRS Report Credentials with Powershell?

Today’s script took a long time to write. The concepts are fairly simple and the resulting script is quite trivial but the lack of easy to find documentation on Reporting Services administration via scripts meant I got to spend a lot of time with my good friend intellisense. In fact,… Read more

0 comments, 1,317 reads

Posted in Adventures in SQL on 24 November 2010

Careful with the New MCM Requirements

Ever since I first heard about the Microsoft Certified Master program I have been interested. The prestige of the certification and the promise of future riches are what draw many people in but for me the big selling point is the challenge. One of the big obstacles I had to… Read more

3 comments, 336 reads

Posted in Adventures in SQL on 23 November 2010

Want to Make Your SQL Server Run Faster for Free?

I know I do!

The trick is to properly manage your VLFs.

What are VLFs? The short anser is that VLF stands for virtual log file. SQL Server database log files are made up of many smaller virtual log files that make it easier for SQL Server to manage the… Read more

4 comments, 1,081 reads

Posted in Adventures in SQL on 19 November 2010

Get Drive Space Including Mount Points

Today’s post is a quick one that came out of a conversation on Twitter. To make a long story short, somebody was having trouble with mount points filling up because they were not being caught by their current monitoring script. I offered to look up how my monitoring was doing… Read more

2 comments, 1,179 reads

Posted in Adventures in SQL on 15 November 2010

Troubleshooting SQL Server Error: 18456, Severity: 14, State: 16

I recently had to track down a rogue process that was failing to log in on one of my servers. It took a bit of fiddling, but eventually I found that you can trace login failed due to missing database errors with Profiler. The trick is to look for User… Read more

0 comments, 494 reads

Posted in Adventures in SQL on 12 November 2010

A Brute Force Way to Compress a Database

There are a handful of scripts out there to compress all of of the objects in your SQL 2008 database using Row, Page or a smart combination of both compression types. This is not one of those scripts.

This script is written to compress all tables in a database without… Read more

9 comments, 1,080 reads

Posted in Adventures in SQL on 5 November 2010

When is that Restore Going to Finish?

I spent a good portion of last weekend restoring databases from backup due to a large release. Nothing went wrong, luckily, but I was practicing in case something did. It goes without saying that I spent a ton of that time sitting in front of my PC wondering when the… Read more

0 comments, 399 reads

Posted in Adventures in SQL on 27 October 2010

Stop Forgetting the DAC

From time to time I hear of DBAs that had to restart the SQL Server service on a 2005 or 2008 server because it had stopped accepting new connections. The thing is that most times those servers did not have to be restarted. If the DBA had logged in via… Read more

4 comments, 405 reads

Posted in Adventures in SQL on 6 October 2010

Older posts