Archives: January 2015
By Steve Bolton
…………In the last three installments of this amateur series of mistutorials on finding outliers using SQL Server, we delved into a subset of standard detection methods taken from the realm of statistical hypothesis testing. These are generally more difficult to apply to tables of thousands of… Read more
Let’s just start with the last three years have been fantastic! This blog post is a slight deviation from the technical content on my blog. We’re going to focus on career and professional development for a minute.
In 2011 I was thrust into the world of consulting…accidentally. Accidentally you… Read more
James recently published part 3 of his PowerShell and Windows Forms series for creating your own SQL Tools. In this post, he guides you through the process of adding tab controls. Enjoy!
Originally posted on JamesDataTechQ:
Using Tab Controls can help you organize and define your work…
I am pleased to announce that I have an upcoming preconference training session on Friday, February 27th, the Friday before SQL Saturday Phoenix.
Virtualization for SQL Server DBAs
Session Information: Microsoft MVP, VMware vExpert, and SQL Server performance expert David Klee leads this full-day introduction to enabling and… Read more
I’m traveling next week to the SQL Konferenz in Germany, and then on to Red Gate in the UK.
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
- Don’t Get Slimed…
Well, it was only a few days ago that I blogged about some major Azure SQL Database enhancements. Primarily, in that post,I was referring to new features that were made available in the new V12 preview portal, specifically for moving “On Prem” database to Azure SQL… Read more
Recently I wrote an article about Capturing Online Index Operations. In that article, I discussed a problem that I had encountered. Well, there were multiple problems. One was an issue with a vendor app that had some hidden module that was performing online index defrags that was causing corruption… Read more
A quick post, and a good reminder of something that can be a pain. I had to do a quick search for the solution, and wanted to write about it in the hopes it will help me remember the issue.
Opening the wrong program
I was working with some XML… Read more
As you probably know, SQL Server allows only one default instance per server. The reason is not actually something special to SQL Server, but it has to do with the way TCP/IP endpoints work.
In fact, a SQL Server default instance is nothing special compared to a named instance: it… 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
I am sharing the response and question which I received on my mail based on past post : “Configure search topology in scale out mode in SharePoint 2013” .
What I received is “If we are using index partition and replica, then why we are not creating Search…
This month’s T-SQL Tuesday #62, the first of 2015, hosted by yours truly, (invitation to Healthy SQL here), asked that you all blog about your T-SQL Resolution, and describe what it is that you will do this year to make sure your SQL Servers are healthy provide… Read more
I’ve used placeholders to ensure I don’t run out of space on my machines. That’s worked well, and usually I can delete a placeholder when I have an emergency, and then clean up the drive.
However I got a low warning today when trying to do an iOS upgrade.
I’d… Read more
Never forget, we’re making buggy whips. And everybody we know drives little buggies and they need our buggy whips. We’ve got a special talent, a unique knowledge set, and it’s fulfilling a defined need. So we’re all set, right?
Well, other than that Stanley Steamer over there. And maybe that… Read more