Latest Blog Posts
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
Back in December I had the thought that it would be fun to do an email interview with someone. As I thought about it Thomas LaRock (b/t) sounded like a good choice since he has been working in the community for quite a while and is… Read more
I had the pleasure to speak at SQL Saturday 360 in Israel. It was such a great event! We had two tracks, one for SQL Server and one for BI. There were more than 160 people who enjoyed free training, great food, networking and fun. There was even a beer… Read more
Recently I’ve become quite interested in the latest incarnation of Azure SQL Database.
For those that are unaware of some of the latest developments of this product, there was a new preview portal opened up towards the end of 2014.
This latest offering – know as version… Read more
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later. Much of the content will be a result of my daily interactions with business users and other BI devs. In order to not… Read more
I’m excited that I’ve been asked to be back involved for another year in the Friends of Red Gate program. This program allows influential community members, community bloggers, MVP’s and intuitive minds an inside track on helping with pre-existing and existing utilities that Red Gate has in their arsenal.
I… Read more
It’s official, I am in Friends Of Redgate for 2015!
Ok, the last few months have been an absolute whirlwind of activity for me. Back in October I was recognized by Microsoft by joining the ranks of the SQL MVPs out there, and now Redgate has added me to the… Read more
The secrete SQLFile.sql
We are all so used to clicking on the New Query icon (or the keyboard shortcut Ctrl+N). We know it will open a new query window in SSMS, an empty query window that is, but many of us never knew that something else was designed to happen… Read more
T-SQL – Find Number of Rows of Database(s) tables Using Undocumented Procedure – sp_MSforeachdb and sp_MSforeachtable
On Technet forum, Op was looking for a way to get table cardinality for all databases in an instance. There are many ways to get the result. This post gives you an idea and SQL in which undocumented SP’s being called “sp_MSforeachdb and sp_MSforeachtable”.
The above undocumented SP’s iterate through… Read more