SQLRally is a week away. Are you ready? It’s going to be a good time to learn and freshen up your SQL Server skills. You’ve probably looked at the schedule and picked out a few sessions that are a must see. Networking But are you prepared to take advantage of the opportunity to network with … Continue reading SQLRally–Don’t Forget Your Business Cards?
Earlier today, Thomas LaRock (Blog | @SQLRockstar) tagged me for his Meme Monday post. The question for today is: how many things can go wrong with a database server that are NOT related to a disk drive? Here are my 9 items… Unchecked parallelism Unmanaged security Code that works, not performs Disbelief in clustered indexes … Continue reading Meme Monday – "I got 99 problems but a disk ain't one"
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts of interest that you may want to check out are: The Power of N (4/22/2010) – Viewing data in other character sets. What is the size of your index? (4/23/2009) – The title kind of … Continue reading Re-blog – April 22-28
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts of interest that you may want to check out are: Analyze This – Your Indexes Analysis – Part 1 (4/19/2009) – Query that combines existing index statistics and missing indexes into a single output. Analyze … Continue reading Re-Blog – April 15-21
I’ve been counting down the days until I get the score from my second attempt at the SQL Server MCM written exam. When I last took it, I knew there were some areas that I didn’t know the answers. But for the vast majority of the exam I felt good. In fact, I felt that … Continue reading MCM: To pass, or not to pass
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts of interest that you may want to check out are: Wait Stat Report (4/13/2010) – Report that can be used to do your own wait stat analysis. FileSystemHelper SQL Server CLR – Codeplex (4/14/2010) – … Continue reading Re-Blog – April 8-14
Over the last couple months, I’ve been trying to figure out what to do with some of my old posts. Ones that I thought were pretty decent that have been lost to the time. Some of them have pretty decent content, in my opinion, and don’t deserve to live solely in the moment that they … Continue reading Re-Blogging Posts
It’s that time of the month again… again. Time for T-SQL Tuesday! This month’s event is being hosted by Matt Velic (Blog | @mvelic). The topic that he chose for this month is the APPLY operator. This is a great topic. I like it because, often, when I am presenting I ask the question, “who … Continue reading T-SQL Tuesday #17 – APPLY Knowledge
I’m going to SQL Rally! Are you going to SQL Rally? Have you heard of SQL Rally? What’s SQL Rally? I’m glad you asked. SQL Rally is a new two day PASS conference. It’s a great cross between the PASS Summit and a SQL Saturday. For a couple days, you can come together with a … Continue reading I Got Registered!
Use extended events; they work - and make you appear magical. -- "Write a SQL blog post in 11 words or less" via Thomas Larock (Blog | @SQLRockStar)
Strate SQL 