|
|
|
|
The random ramblings and rantings of frazzled SQL Server DBA
Browse by Tags
All Tags » Miscellaneous (RSS)
-
If you follow me on twitter ( @SQLSarg ), you already know that this has been a week of big announcements for me. Wednesday afternoon Paul Randal ( Blog | Twitter ) announced that I joined SQLskills.com as a full time employee, and Thursday afternoon, Read More...
|
-
If you don’t know me, or you haven’t followed me for long, you might not know that I am a huge fan of documentation. I started out in my as a Application and Business Analyst and all I did was document problems, their scope, impact, and resolution. Read More...
|
-
It seems like every week I get hit up with some kind of “Its a view only for this specific report,” or “It is a simple change that the vendor would have made if they had access” type of request related to SQL Server. If you’ve never dealt with me, Read More...
|
-
SQL Server users love the new features inside of the platform and each new release brings more exciting enhancements that motivate end users towards upgrading from previous editions. However, one of the biggest gripes I see from the SQL Server Community Read More...
|
-
Brent Ozar ( Blog | Twitter ) and Tim Ford ( Blog | Twitter ) are putting on a new type of event in the month of August after SQL Saturday #40 in South Florida July, 31st , properly named SQLCruise . The concept is great, at least in my opinion, you pay Read More...
|
-
While working on a problem today I happened to think about what the impact to startup might be for a really large tempdb transaction log file. Its fairly common knowledge that data files in SQL Server 2005+ on Windows Server 2003+ can be instant Read More...
|
-
Robert Davis(blog/twitter) recently blogged The Toilet Analogy … or Why I Never Recommend Increasing Worker Threads , in which he uses an analogy for why increasing the value for the ‘max worker threads’ sp_configure option can be bad inside of SQL Server. Read More...
|
-
Every so often, a question shows up on the forums in the form of, “How do I prevent anyone from accessing my database schema, including local administrators and sysadmins in SQL Server?” I usually laugh a little shake my head when I read a question Read More...
|
-
This is somewhat of a continuation post to my previous blog post, “Some thoughts on Interviweing…” . Now that you survived the interview process, what do you do? This is a common area of discomfort for people interviewing for any kind of job, not just Read More...
|
-
At the beginning of the year I changed jobs, leaving a very stable position where I had the opportunity to learn under an amazing mentor (who happened to be a Oracle DBA and not a SQL DBA), to take on a job that I felt was much more challenging and had Read More...
|
-
This morning I was late to work because as I backed out of the driveway I noticed that my wife's car had a flat tire. This should be a pretty simple thing to fix, but it turns out that the spare tire was also flat. This too should have been Read More...
|
-
In the past I have advocated that when it comes to advice you need to consider its source before you actually use it. I still believe this today, but recently I got some advice that makes me add a caveat to this statement. You also need to Read More...
|
-
Here’s another use for the information captured by the default trace. Ever wonder what session created the tables that exist in tempdb? Well you can find it using the default trace and the sys.objects view in tempdb. Any time an object Read More...
|
-
Its funny to see this new technical note posted by the SQLCAT team today because we just recently had a discussion about this on Twitter. My good friend Sankar Reddy ( Blog / Twitter ) sent me an IM with the link to this page based on the twitter Read More...
|
-
New technology is always an interesting thing, at least to me. It doesn’t matter if it is SQL Server related or not, I tend to be fascinated by the changes that occur daily in technology. The last decade though, the changes have been coming Read More...
|
|
|
|
|
|