Latest Blog Posts
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
In my last article (TIP 87) I wrote about PWDENCRYPT. I forgot to write few details but thanks to all my talented friends & blog readers who guided me by providing there feedback on post.
I respect their inputs and always interested to get more inputs. Thanks… Read more
By Steve Bolton
…………This is the last of six articles I’ve segregated in this middle of my mistutorial series on identifying outlying values with SQL Server, because they turned out to be difficult to apply to the typical use cases DBAs encounter. After this detour we’ll get back on… Read more
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.
Posts That Were Popular This Week
- Building (for FREE) a Virtual Server for SQL Demos
- Cheating DBCC To Fix Index Corruption
- Do You Need…
You have been stressing over the big project you have to get done.
You get in early Monday morning, pour yourself a mug of coffee and stumble to your desk.
You start up your system,… Read more
March 4 – Charleston PASS, Charleston, SC
What Admins Absolutely Must Know About SQL Server Security
There are so many security tips out there for SQL Server. Almost all of them are rated as a best practice. What do you listen to? What do you focus on? In this… Read more