Latest Blog Posts
It’s been a great a busy week.
On Wednesday, I presented my session, “Query Progress Tracking in SQL Server” at SQLRally in Copenhagen.
On Thursday, I presented my session, “The Data Loading Performance Presentation”, at SQLBits in London.
Thanks to everyone who attended my sessions. I had a lot of… Read more
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012. So far, we’ve covered:
- Tables and Schemas in the data warehouse
- Dimensions and Slowly Changing Dimensions
- Fact tables and measures
This Thursday I will be joining an open discussion with Tegile Systems and the Lincoln SQL Server Users Group on the challenges for the DBA when it comes to handling large amounts of data. Everything from storage to CPUs and virtualization will be discussed, and both OLTP and BI systems… Read more
Bad news: SQL Code Guard v2.7 is not working with SSMS from SQL Server 2008R2 (and below).
Good news: I know about this issue, already fixed it in my development environment and will release fix in nearest possible future.
Bad news (again) : integration will not work with…
I don’t know how to get started.
Pretty simple. There are a number of free blogging sites out there. Personally I use WordPress. All you need to do is go to http://www.wordpress.com and sign up for a free space.
I have a blog but setting it up seems like a…
Anyone know if it's possible to configure PowerPoint 2013 to use speaker mode but then go back to duplicate displays on exit?
— Adam Machanic (@AdamMachanic) March 4, 2015
A very interesting question, as I… Read more
When we heard “Kill” then first impression of this word is very bad. We always scare with this word.
In real world we never want this action from anyone but in SQL Server case it is very helpful and help us many times.
This feature we can use but very… Read more
I am pleased to be presenting a highly interactive session tomorrow evening that is a full end-to-end setup and management demonstration on SQL Server AlwaysOn Availability Groups for the Omaha SQL Server Users Group.
During our November meeting, we took a quick non-scientific poll of some of the topics… Read more
Traditionally, we want our Clustered Index to have the following attributes:
- Narrow: So that our clustered index and the non-clustered indexes that point to it will be as slim as possible
- Static: So that we don’t generate fragmentation in the clustered index and we don’t have to update the non-clustered…
That’s right I’m cashing in on the “50 Shades” franchise and twisting it to meet my own sordid needs to tell you about something that is critically important to every business. But why Shades of Brown if it is critical? Everybody knows that it’s red alerts that signify things are… Read more
In December, I was asked to write an article(s) on Database Refactoring. It started as 2 topics, but then consolidated into one. I really wanted to talk about the database design issues I see with a development department. Please give some time to reading the article and comment. First, I… Read more
You all know that checking our databases for corruption regularly is a must. But what about tempdb? Do you need to check it as well?
The maintenance plans that come with SQL Server do not run DBCC CHECKDB on tempdb, which is a strong indicator that it’s a special database… Read more
Don’t miss these great articles on SQLPerformance.com from the industry’s top experts:
A number of you will have heard of SQLBits before. It’s Europe’s largest conference dedicated to SQL Server. What was something just for people from the UK has been transforming into something much larger, more multicultural and more engaging as the community grows. Now we find that quite a large… Read more
Sjor Takes (b|t) has just barely started blogging, but he’s got a great post about a discussion he had with a colleague. It’s worth a read. When you get done, I’ll provide my answer to the question posed at the start and conclusion of his post.
I had… Read more
Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be fun (and good practice) to do them. Another major benefit is that it will force me to move out of my normal comfort zone. For… Read more
Greetings! If you are local, or in the NY/Central NJ area, mark you calendars for WED. MARCH 11, 2015 @ 6:00PM, in Iselin, NJ's Microsoft Office, hosted by the Central New Jersey SQL Server User's Group (CNJSSUG), where Kevin S. Goff, goes well beyond the basics of… Read more