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
10 Jul 2014 at 3:49pm
How to Interact with a PivotTable in Power BI for Office 365
Being able to make a few quick changes to a PivotTable in the browser, without having to download the workbook, is a great feature. Initially when you view an Excel workbook in Power BI (and by this I mean in Office 365 via the browser rather than the...
10 Jul 2014 at 1:00pm
db_ddladmin and the SSMS table designer
If you want to grant a user the ability to create/alter/delete any table, SP, function etc in a database you have a several options. For example: You can grant all of the CREATE permissions either to the database itself or to all of the schemas. ...
10 Jul 2014 at 2:33am
VM Snapshots and Performance or: How I Learned to Love My Martian Data Center
It takes a radio signal just about 1.28 seconds to get to the Moon (about 239,000 miles away), and about 2.5 seconds for round trip communication between our secret moon base and Earth. So, therefore this common SQL Server error message number 833…...
8 Jul 2014 at 7:04pm
Tips Tuesday: Compression and Dedup
We all know one surefire way to avoid a SQL Server disaster is to be diligent about backups. Though, there is plenty of room for improvement when it comes to backup processes, especially since a typical backup on a standard SQL Server database puts a...
8 Jul 2014 at 6:36pm
Is your Team Willing to Take Control?
The calendar tells us that once again we have reached the second tuesday of the month. In the SQL Community, this means a little party as many of you may already know. This is the TSQL Tuesday Party. This month represents the 56th installment of this...
8 Jul 2014 at 4:49pm
SQL 2012 SP2 Quality Of Life Improvement
With the release of SP2 for SQL 2012, SQL Server Management Studio got a bug fix that results in a nice quality of life improvement. Since the initial release of SQL 2012, plain text in SSMS always showed up in teal, no matter what you set it to via the...
8 Jul 2014 at 1:00pm
T-SQL Tuesday #56: Assumptions
I assume that since it’s the second Tuesday of the month that it’s time for T-SQL Tuesday. And you can be certain that Dev Nambi( b / t ) has decided to make Assumptions the topic of the 56th T-SQL Tuesday. I generally like to start with...
8 Jul 2014 at 12:01am
Interested in helping SQLBits to craft the first ever SQLBits Wikipedia page?
Exciting DitBits news from the SQLBits camp today. We will be hosting a 'Wikipedia Edit-A-Thon' which will focus on gathering budding community authors, editors and reviewers together to create the first ever Wikipedia SQLBits page! I'm looking...
7 Jul 2014 at 10:14am
How to change TempDB system Database files location?
Steps to change TempDB system Database files location :- 1) Check current file location of TempDB Exec SP_helpDB TempDB You can use below query as well for file location details. SELECT name, physical_name AS CurrentLocation, state_desc FROM...
7 Jul 2014 at 9:30am
Optimising MDX Calculations With The Unorder() Function
The Unorder() function is probably one of the least used functions in the whole of MDX. It exists only as a query performance hint and, since I had never up to now found a scenario where it did improve the performance of a calculation I had pretty much...
4 Jul 2014 at 5:00pm
Reblog: June 27 to July 3
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...
4 Jul 2014 at 1:00pm
Friday Followup For July 4, 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 Dell Webcast Followup: Subqueries For Superheroes...
3 Jul 2014 at 5:37pm
Microsoft MVP 2014 – SQL Server Award
This past week, I was awarded with the Microsoft MVP 2014 for SQL Server award. This is my sixth award in a row and I am deeply appreciative for this recognition from Microsoft. If you aren’t familiar with the Microsoft’s MVP program , it is an...
3 Jul 2014 at 4:58pm
PowerShell- Monitoring Group Of Services on Group of Servers with Alternate Credentials
This script will allow you to read a list of computers from the input file and use credentials to connect to remote/DMZ server to get the required service status information only specified services. This post explains how to monitor a multiple services...
3 Jul 2014 at 4:58pm
PowerShell- Monitoring Group Of Services on Group of Servers with Alternate Credential
This post explains how to monitor a multiple services on a group of servers with alternate credentials. This script will allow you to read a list of servers from the input file and use credentials to connect remote/DMZ servers to pull service status...
About Toad World
Ads and Emails
Toad World is Sponsored by
Copyright © 2013 Dell Software Inc.
Translation provided by