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
24 Dec 2014 at 7:06pm
5 Ways To Avoid Having To Write a Christmas Blog Post
Yes, it’s that time of year again, when every blogger takes time out of the schedule to produce a post about Christmas or whatever Happy Holiday you celebrate. Truth be told I spent the past two weeks trying to think of something I could write about...
24 Dec 2014 at 2:00pm
Failing over AlwaysOn Availability Groups
Merry Christmas Eve! A few weeks ago I posted on Availability Group fail-over tests with PowerShell . That post covered the basics of how to check the Availability Group’s state and perform the commands for conducting a zero data loss fail over...
23 Dec 2014 at 9:20pm
SQL – How to Find Missing Sequence in a table
Problem statement:- A table with identity column have ‘n’ rows in that few rows are deleted. How to find which rows are deleted? Solution:- create table test (a int); insert into test values (7001); insert into test values (7002...
23 Dec 2014 at 8:49pm
How To Better Break Down Information Silos
It all started with a simple question. “What’s a table?,” my nine-year-old daughter asked me during a session I was giving at SQL Saturday #184 last year. Now, being my daughter, I know that she has the innate ability to ask questions just for the sake...
23 Dec 2014 at 1:00pm
What is the Difference between Truncate and Delete in SQL Server?
In SQL Server there are a couple a ways you can delete rows from a table. You can use either the TRUNCATE or DELETE command. Though the end result of both commands is the same, there are very important differences you should know about. The TRUNCATE...
23 Dec 2014 at 12:04pm
Twas 2 Days Before Xmas or Thank you SQLFamily
Twas 2 days before Xmas & all through the office, not a creature was stirring not even old Maurice. With merriment going on outside of his window There sat a bearded DBA without much to do No changes can be made through the holiday season We...
22 Dec 2014 at 5:49pm
Blink – Year is gone
As the door begins to knock I start to wonder who it can be. As I begin to open it the person on the other side asks if he can talk to Perfection. No, I replied, perfection isn’t here and will never be here. That same concept is what this blog...
22 Dec 2014 at 3:00pm
Viewing Error Messages For All Rows In Power Query
One of the great features of Power Query is the way you can view any rows that contain error values when you load data. However, even if you can see the rows that have errors you can’t see the error messages easily – without writing a little bit of M...
22 Dec 2014 at 1:00pm
DBTA – Big Data and Microsoft SQL Server HDInsight
It’s time to follow up with a discussion of Microsoft’s cloud-centric approach to big data using HDInsight. MICROSOFT SQL SERVER AND BIG DATA IN THE CLOUD HDInsight is a 100% Apache Hadoop service, currently at v2.2, available through Microsoft’s...
22 Dec 2014 at 4:14am
Use of RPC in Cluster
Today, My one of friend come back from SQL DBA interview & share his review. One question about which he is looking for was “What is the use of RPC in cluster” ? The Remote Procedure Call (RPC) [http://support.microsoft.com/kb/832017] system service...
20 Dec 2014 at 10:14pm
Big Changes - What You Need to Know About the Power BI Public Preview
Yesterday Microsoft released a Public Power BI Preview for customers to evaluate new features in Power BI. This newly redesigned platform offers many familiar components, as well as some new and unique features. Which means you may be asking yourself...
20 Dec 2014 at 9:52pm
New Power BI stand-alone Designer, Dashboards, APIs & iOS App
This week Microsoft announced the availability of Power BI Dashboards and the browser-based dashboard designer. What is it and why is it important? The most significant thing about it is that report and dashboard users do not need to have...
19 Dec 2014 at 5:27pm
First Ask “Why”, then Ask “How”
A common refrain we hear when presenting at technical conferences and training events is “How can I get promoted into IT management?” We hear this so often that we’ve worked out a sort of mental flowchart for the subsequent dialog. (We are IT people after...
19 Dec 2014 at 4:07pm
I am joining SQLskills
I am no longer just a SQLskills Insider, I am now a SQLskills employee. I have accepted an offer to join an incredible team of SQL Server professionals and continue growing in my SQL career. I am very excited to be working with some of the best in the...
19 Dec 2014 at 4:00pm
Reblog: December 12 to December 18
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...
About Toad World
Ads and Emails
Toad World is Sponsored by
Copyright © 2014 Dell Software Inc.
Translation provided by