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 SAP ASE
Spotlight on DB2 LUW
Spotlight on Oracle
Spotlight on SQL Server
Spotlight on SAP ASE
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
29 May 2015 at 3:25pm
Tip # 7 – Disaster Recovery Plans – Top 10 Tips for SQL Server Performance and Resiliency
This article is part 7 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is not all inclusive. Most common mistake #7: Disaster Recovery Plans Often people hear disaster recovery...
29 May 2015 at 2:30pm
005 – Antiques Roadshow - WaterOx Consulting
Reading Time: 4 minutes Are You Running An Antiques Roadshow? In WOxPod!, episode # 005 –... The post 005 – Antiques Roadshow appeared first on WaterOx Consulting .
29 May 2015 at 12:33pm
Using OFFSET and FETCH with the ORDER BY clause
In this article we explore the OFFSET and FETCH clauses. OFFSET and FETCH are used in conjunction with the SELECT statement ORDER BY clause to provide a means to retrieve a range of records. The starting row to return is determined by the OFFSET value...
28 May 2015 at 9:20pm
42 Things You Should Never, Ever Say To a DBA
As a parent of two soon-to-be-asking-for-the-car-keys tweens, I came across this post the other day and found it struck a chord with me. I’ve gotten the eye-rolls from my daughter for everything on that list by now. My son is younger but I am certain...
28 May 2015 at 3:21pm
SQL Server Performance and Resiliency Session
You might have been following along with my recent series of posts related to a number of resiliency tips for SQL Server. I have compiled these tips based off my observations over the last 20 or so years. Over the summer I have the opportunity to present...
28 May 2015 at 1:00pm
Multiple Windows Groups with different default databases
A question came up at work the other day, mostly as a mind game, but you never know it might actually come up at some point. So here is the idea. UserA is a member of Group1, Group2 and Group3. Group1 is set up as a server principal with a default...
28 May 2015 at 1:00pm
Microsoft Azure SQL Databases – Power and Performance
By David Postlethwaite On the Database Scale page we can decide on the performance level that we want our database to have. There are three performance levels Basic, Standard and Premium Basic is best suited for a small size database, supporting one single...
28 May 2015 at 12:31pm
Microsoft Virtual Labs for SQL Server 2016
If you want have experience about SQL Server 2016, Microsoft Virtual Labs provides it for you. There are seven labs up to now. https://technet.microsoft.com/en-us/virtuallabs http://dbfriend.blogspot.com/feeds/posts/default?alt=rss
28 May 2015 at 3:44am
Microsoft Releases First Public Preview of SQL Server 2016
The first public preview of Microsoft's SQL Server 2016 database is available, and testers can opt for faster, more frequent updates to it. Microsoft is making available to anyone who wants to kick the tires a first public preview release of its coming...
27 May 2015 at 8:42pm
SQL Server 2016 CTP 2 Preview Now Available
Back in the beginning of May, Microsoft announced SQL Server 2016 and the massive amount of new features that are going to be released. Combining this with all of the Power BI enhancements and Azure enhancements that are being released, it is a great...
27 May 2015 at 4:00pm
How an MPP appliance solution can improve your future
Massive parallel processing ( MPP ) is the future for data warehousing. So what is MPP? SQL Server is a Symmetric Multiprocessing (SMP) solution, which essentially means it uses one server. MPP provides scalability and query performance by running...
27 May 2015 at 3:30pm
SQL F.A.D. – CSV List of Columns - WaterOx Consulting
Reading Time: 2 minutes I had a project once that was using change data capture (CDC)... The post SQL F.A.D. – CSV List of Columns appeared first on WaterOx Consulting .
27 May 2015 at 1:00pm
Store Optional Connection Parameters in SQL Server Management Studio
About six months ago I wrote about the challenges of using the Always-On Availability Group Listeners with SSMS . At the time, I had presented three problems and only solutions for two of them. At this time, I am happy to announce that Microsoft has responded...
27 May 2015 at 9:00am
SQL Server 2016 CTP2 now available
The official Community Technical Preview 2 (CTP2) release build for Microsoft SQL Server 2016 is available for public download here . One week ahead of schedule ! Any feedback is greatly valued and can be submitted here . Enjoy !!
27 May 2015 at 5:34am
Shopping Basket Analysis in SQL Server
A famous super market chain in USA once observed that men who are buying beer for weekend tend to buy nappies for their kids. This revelation enabled the chain in increase sales volume and revenue by placing the items in close proximity to each other...
About Toad World
Ads and Emails
Toad World is Sponsored by
Copyright © 2015 Dell Software Inc.
Translation provided by