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 2008
SQL Server 2012
16 Mar 2014 at 3:08pm
When is a Data Management Gateway Needed in Power BI?
Recently I've been chatting with some fellow BI professionals about the Data Management Gateway (DMG) in Power BI and when exactly it's required to be used. Before we answer this question, let's go through a quick bit of background... What...
15 Mar 2014 at 1:04pm
Session review – Brent Ozar at RSSUG
Yesterday (Friday, March 14th, 2014) Richmond, VA’s SQL Server user group was fortunate enough to have Brent Ozar ( @BrentO | BrentOzar.com ) stopped by and present a 101 level session on SQL Server Internals. I made the 4 hour round trip drive...
14 Mar 2014 at 11:38pm
User-Defined Conditional Logic In M
Here’s a short follow-up to my last post on conditional logic in M . After that post went live, Ehren Vox of the Power Query team made a good suggestion on Twitter : rather than hard-code the list of conditions and values inside the query, why not take...
14 Mar 2014 at 4:00pm
Reblog: March 7 to March 13
Photo credit – Travis 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...
14 Mar 2014 at 3:09pm
PowerShell to list the packages stored in Integration Services SQL2008/SQL2008R2
PowerShell to list the packages stored in Integration Services SQL2008/SQL2008R2; I will come up with a SQL 2012 version soon. # Get SSIS Package List from a Integration Services Server # Created by - Vinoth N Manoharan # Version 1.0 # Date - 14/02/2014...
14 Mar 2014 at 2:31pm
SQL for Everybody
I read a terribly excited blog this morning by a guy who had just discovered Alt-F1 in SSMS. (If you don’t know, it runs sp_help on the highlighted object.) My very, very first instinct – I’m ashamed to say – was to think “Who...
14 Mar 2014 at 1:00pm
Steel City SQL Users Group–March 18, 2014– @SteelCitySQL
Next Tuesday, I’m loading up Big Blue, and driving over to Birmingham to present at the Steel City SQL Users Group. I’ll be talking about the Agile DBA. Should be fun! http://www.steelcitysql.org/ Featured Presentation The Agile DBA...
14 Mar 2014 at 12:00pm
Friday Followup For March 14, 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 The Phoenix Project: a DBA rises from the ashes ...
13 Mar 2014 at 11:31pm
SQL Server XQuery: MORE deleting nodes using .modify()
So after my last post, my developer friend came back to me and noted that I hadn’t really demonstrated the situation we had discussed; our work was a little more challenging than the sample script I had provided. In contrast to what I previously...
13 Mar 2014 at 3:00pm
Real-time query access with PDW
The Parallel Data Warehouse (PDW) officially supports Analysis Services as a data source, both the Multidimensional model (ROLAP and MOLAP modes) and the Tabular model (In-Memory and DirectQuery modes). The big benefit of using ROLAP or DirectQuery is...
13 Mar 2014 at 1:00pm
:CONNECT in SSMS
Those people who are familiar with SQLCMD will recognize this command. It is used to connect to an instance from within a SQLCMD script. What they may not realize is that this command (and other SQLCMD commands) can be used in a query window by turning...
13 Mar 2014 at 7:55am
Quick tip: Querying AD with xp_logininfo
We all have blind spots in our knowledge. We don’t know they are there and when we are thinking through an issue our mind quickly rejects some plans because of these blind spots. This happened to me recently when I was tasked with doing a security...
Basit A. Farooq
13 Mar 2014 at 12:46am
Tables without Clustered Indexes?
Today, we experienced performance issues with some of the SSRS reports that were deployed as part of the latest application/database release. While investigating this performance problem, I realized that the underlying tables for these report queries...
12 Mar 2014 at 7:20am
Inside SQLSaturday: Jonathan Allen & SQLSaturday Exeter
In the first of a new and ongoing series of Inside SQLSaturday posts, which I hope will give you an insight into the phenomena known as SQLSaturday, I would first like to introduce you to Jonathan Allen ( blog | twitter ) who currently runs the SQL South...
11 Mar 2014 at 10:39pm
SQLSaturday Portugal: Why I'm going for the third year in a row!
Going to SQL Saturday Portugal? It is an excellent event, run by SQL Server MVP and European Community Tech Leader Niko Neugebauer and his awesome team. If you haven't been before, it is a great event for international attendees as well as Portugese...
About Toad World
Ads and Emails
Toad World is Sponsored by
Copyright © 2013 Dell Software Inc.
Translation provided by