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 Intelligence Central
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
SQL Server Central
30 Mar 2015 at 2:00pm
Backups – They Are Needed, Who Knew?
Backups are essential for a successful business model. That statement may or may spark some topics for debate, but at the end of the day if the data professional does not have a form of backup in place for his/her business needs you may, no you will,...
30 Mar 2015 at 1:00pm
Port numbers and SQL Server
I made a mistake the other day. I’ll admit it. I was wrong. Now I know all of you are shocked, but it does happen on rare occasions. So what was I wrong about you might ask? One of the dev groups I support has been referring to their instances as...
30 Mar 2015 at 1:00pm
NaturalInnerJoin And NaturalLeftOuterJoin DAX Functions In Excel 2016
Continuing my series on new DAX functions in Excel 2016, here are two more: NaturalInnerJoin() and NaturalLeftOuterJoin(). Both do pretty much what you’d expect. Consider the following two tables in an Excel worksheet, called ColourFruit and FruitPrice...
30 Mar 2015 at 7:52am
How to install SharePoint 2013 on Windows 2012R2
If you want to jump straight to the condensed solution, then please feel free to go to the Condensed Installation instructions below. If you find this post useful or have any feedback then please leave me a comment so that I know my efforts were not wasted...
29 Mar 2015 at 1:16pm
SQL Server 2014 BI دورة تمهيدية شاملة في
الزملاء الأعزاء من العالم! السلام عليكم و رحمه الله و بركاته أقدم لكم دورة تمهيدية شاملة في SQL Server 2014 BI. وتقدم هذه الدورة التدريبية باللغة العربية، وتهدف إلى المساعدة فى التقديم للمفاهيم الأساسية للمهنيين المتخصصين فى قواعد البيانات عامه وبخاصه...
27 Mar 2015 at 6:55pm
Monitoring the SSAS Connector in the Power BI Preview
Welcome to part 3 of a 3-part series on using the SSAS Connector with the new Power BI Preview. This information is as of early March 2015 and is subject to change as the Power BI Preview evolves. Part I: Overview of Using Analysis Services Data in the...
25 Mar 2015 at 1:00pm
Clean out all bad characters from a string.
I have a customer who is having a problem with a load. He is getting a fair number of bad characters including some unicode characters. The unicode characters in particular are making it so those values won’t go into a varchar column. This isn’t...
25 Mar 2015 at 11:32am
Danish SQL User Group General Assembly
For many years, the Danish SQL Server User group (under the PASS umbrella) has been stagnating !! So much stagnating that other successful initiatives have started. Some of my fellow members and myself really want to reinvigorate this group, which had...
24 Mar 2015 at 11:00am
Use the WordPress Revision Counter to Keep Shipping Posts
I haven’t been at this blogging thing an extremely long time, and I certainly haven’t been as consistent as I’ve wanted to (working hard on this though – at least one post a week!). There is no getting around it – blogging...
23 Mar 2015 at 2:20pm
HOW TO: Find When SQL Server Wait Stats Were Last Cleared
For years I have found myself often needing these three pieces of information with regards to SQL Server: When was the last time the server was restarted? When was the last time the SQL instance was restarted? When was the last time the SQL Server wait...
23 Mar 2015 at 2:00pm
SQL Saturday #381 – Richmond, VA
Last Saturday I attended #SQLSATRVA , which was SQL Saturday #381 . It was a blast! The day started off with the usual registration process. Thankfully, I remembered to print out and cut my SpeedPass in advance. The line to use the scissors was ridiculous...
23 Mar 2015 at 2:00pm
Exam Prep 70-463: Executing packages in SSIS 2012
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...
23 Mar 2015 at 1:00pm
0 to Speaker
Recently the last day to submit a session for the 2015 Pass Summit rolled around. I mention this because I actually submitted a session. This is the first time I’ve ever submitted something for the summit and only the third time I’ve submitted...
23 Mar 2015 at 12:30pm
Benford’s Law And Power Query
Probably my favourite session at SQLBits the other week was Professor Mark Whitehorn on exploiting exotic patterns in data . One of the things he talked about was Benford’s Law, something I first heard about several years ago (in fact I’m sure I wrote...
21 Mar 2015 at 1:32pm
Parsing XML Child Nodes and Converting to DateTime with PowerShell
As part of my organiser role for SQLSaturday Exeter ( Training Day Information here and Saturday Information here ) I needed to get some schedule information to input into a database. I had read Steve Jones blog posts on Downloading SQL Saturday Data...
About Toad World
Ads and Emails
Toad World is Sponsored by
Copyright © 2015 Dell Software Inc.
Translation provided by