Latest Blog Posts
Do you ever copy query results out of SQL Server Management Studio, paste them into your text editor, and then perform gold-medal find + replace gymnastics to create T-SQL scripts?
Do you ever need to copy a small amount of data from one SQL server to another, but don’t want… Read more
Ah, an interesting week for registrations. We’ve jumped to 426 registered, making my goal of 500 doable. The jump is in part due to timing, in part due to only having mailed to the “already registered” list only last week (a goof on my part). This week we’ll have two… Read more
This is part of a series of tips for speakers to make your presentations better.
Please, please, please, learn how to set up your machine to look good on screen.
This is the fourth post in the “Parameterization” series. In the previous post I wrote about parameter sniffing, and I mentioned that this method can be a good thing in some cases, but it can also be quite a bad thing in other cases.
One case in which parameter sniffing… Read more
I spent the last couple days at Flowcon 2014, a conference that is bringing people together to talk about growing their organizations with continuous delivery and design, and lean product development.
It does some of that, but it wasn’t what I expected. The attendees for the most part were people… Read more
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time to dig out some old posts and find out if there are any undiscovered finds there. In this post, I’m bringing up some of my old posts to… Read more
This month I’m very grateful because I was given the opportunity to present at DevLink in Chattanooga. I got to meet a lot of new people and see presentations by people that just don’t hang around SQL Server specific events. It was great. I’m going to apply next year (depending… Read more
Partitions are a great feature in Analysis Services that allow you to split measure groups in to separate physical files. All measure groups by default have one partition but by splitting that partition you will gain improved query and processing performance.
Partitions can be split in any way you see… Read more
I wrote Titles Matter – Part 2 based on lessons learned the hard way not long ago. Titles matter because they help the rest of the team understand where you fit in. Titles are the ultimate elevator pitch – this is what I do. I was pleased to see one… 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
- Automated Source Control: A Librarian For Your Database Objects, Part 1
- Automated Source Control: A Librarian For Your…
|SQL Sat Puerto Rico|
I’m sure most of you have looked at the control options of the SQL services right? Start an instance, stop an instance, pause an instance. Start, stop, pause. Wait just a minute! Is this SQL Server or an mp3? (I just want to point out I started with a record,… Read more
Sometime, We caught in a situation where we need to run SQL server in single user mode. Issues like Master DB restore, Sysadmin locked out etc.
Steps to start SQL Server in Single User Mode :-
1) Stop SQL Server Services
2) Add [-m] startup parameter in SQL Services from… Read more
1. What is ADO.Net?
I will be given a webinar on how to audit SQL Server through MSSQLTips.com.
Don’t become a statistic. With the numerous data breaches and internal data theft, securing your SQL Server environment can help keep your company out of the news. Unfortunately, a… Read more
With all of the work on a deployment pipeline and Continuous Integration (CI) and Continuous Delivery (CD) I’ve worked on, I thought it would be instructive to go see how the software developers build their product better. A few months ago I noticed that FlowCon 2014 was coming to San… Read more
No, this is not about politics. It’s about your WHERE clause… and your JOIN criteria… and your HAVING clause. It’s about a canard that still makes the rounds occasionally. Please, help me put this statement to sleep for once and all:
A function on the left side of the equals…