Search SQL Server
in the community
Website Updates & Feedback
Like us on Facebook
from expert resources
on a platform
Code Tester for Oracle
SQL Optimizer for IBM DB2
SQL Optimizer for Oracle
SQL Optimizer for SQL Server
SQL Optimizer for Sybase
Spotlight on DB2 LUW
Spotlight on Oracle
Spotlight on SQL Server
Spotlight on Sybase
Toad Business Intelligence
Toad Data Modeler
Toad Data Point
Toad Decision Point
Toad Extension for Eclipse
Toad for Apache Hadoop
Toad for IBM DB2
Toad for MySQL
Toad for Oracle
Toad for SQL Server
Toad for Sybase
Toad Mac Edition
SQL Server Community
Blog - Monthly Archive List
Microsoft SQL Server
SQL Server 2012
21 Nov 2014 at 4:00pm
Reblog: November 14 to November 20
Photo credit – JStove Old posts are like unicorns. You might see them just once, but it’d sure be nice to have them come back around every not and then. This connection might not make that much sense, but face it… there’s no...
21 Nov 2014 at 3:00pm
Have We Devalued SQL Server Consulting?
Have we given too much away? SQL Server has an amazing community. It freely provides information and training of SQL Server technologies via the internet and even in person events like SQL Saturday’s. Has the value of SQL Server Consulting Diminished...
21 Nov 2014 at 1:00pm
Friday Followup For November 21, 2014
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 Using Encryption To Protect Your Data From Alien...
20 Nov 2014 at 3:00pm
Exam Prep 70-463: More about Dimensions
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 Today we’re...
20 Nov 2014 at 12:51pm
Combining Data From Multiple Excel Workbooks With Power Query–The Easy Way!
If there’s one feature of Power Query that’s guaranteed to get Excel users very, very excited indeed it’s the ability to combine data from multiple workbooks into a single table. The bad news is that this is something that Power Query can’t do through...
19 Nov 2014 at 3:00pm
Fast Track Data Warehouse Reference Architecture for SQL Server 2014
I have previously blogged about the Fast Track Data Warehouse, a reference configuration optimized for data warehousing (see Microsoft SQL Server Reference Architecture and Appliances ). That was version 3.0 of the reference configuration that was for...
19 Nov 2014 at 2:00pm
How to change the schema of a table
The other day I set out to performance tune a database deployment. The company was getting ready to implement almost a year’s worth of database schema drift where major restructuring had occurred. One of the first things that I noticed was that...
19 Nov 2014 at 1:00pm
You don’t really need ORDER BY do you?
You see dozens of blog posts and articles about how the order of a result set is not guaranteed without an ORDER BY clause and here is my contribution to the subject. You all know I love examples so without further ado here we go: Using data from...
19 Nov 2014 at 10:48am
Improved Online Operations in SQL Server 2014
Online indexing rebuilding was a major breakthrough from SQL Server to support users re-indexing while the clustered index (or table) and other indexes are available during the index rebuild operation. However, in real world there are multiple issues...
19 Nov 2014 at 10:47am
Returning Error Messages As Well As Results In Power Query
Back in September I wrote a post on handling situations where the data source for your Power Query query was unavailable. The great thing about that technique is that instead of seeing an error message when you refresh your query, instead you get an empty...
18 Nov 2014 at 6:50pm
Changing Delay Between Responses for SQL Alerts with Powershell
So you have read that you should have alerts for severity levels 16 to 24 and 823,824 and 825 on SQLSkills.com or maybe you have used sp_blitz and received the Blitz Result: No SQL Server Agent Alerts Configured and like a good and conscientious DBA you...
Kendal Van Dyke
17 Nov 2014 at 7:06pm
2014 PASS Summit 2014 Board Q&A Notes
As has occurred in previous years at the PASS Summit the PASS Board of Directors held an open Q&A session on the final day. I was able to attend most of the session but had to leave a few minutes early for my scheduled presentation. I didn't count...
17 Nov 2014 at 6:44pm
Vital Statistics and Health Checks
This post has nothing, absolutely nothing, to do with SQL Server. It does, however, relate to your career as a deskbound, stressed-out IT professional. With that disclaimer out of the way, you may continue reading if you’d like. A couple of things...
17 Nov 2014 at 4:00pm
Last Weeks Top “Reading” Links #109
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” ( so exciting ), follow me on twitter ( @StrateSQL ). And see these throughout the day as I tweet out links of things I find interesting...
17 Nov 2014 at 3:00pm
Exam Prep 70-463: Tables and Schemas
Well, the PASS Summit has come and gone and it was *awesome*. What a difference from my first Summit experience, when I went to every session I could and then went back to the hotel. This time around there was something going on every evening and I...
About Toad World
Ads and Emails
Toad World is Sponsored by
Copyright © 2014 Dell Software Inc.
Translation provided by