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 2012
22 Oct 2014 at 3:13pm
Backup testing with PowerShell
This week I released a two part blog series on testing your backup files and reporting on the results in an automated fashion. Many elements of PowerShell, SMO, T-SQL, and SQL Server Reporting Services are covered. Abstract Once your organization...
22 Oct 2014 at 12:00pm
Force only certain values to be unique
I thought of something rather interesting the other day while answering a question asking for help with some table structures . In a similar situation to the questioner let’s say we have a Baseball team. There are teams and players. A player can...
21 Oct 2014 at 6:01pm
SQL Server Upgrade Preconference at PASS Summit 2014
Please join me and my associates for an all-day SQL Server Upgrade workshop on November 3rd If you are planning an upgrade to a newer version of SQL Server, you won’t want to miss this all-day, preconference workshop. Join John Martin, Sr. Technology...
21 Oct 2014 at 1:00pm
So, in my last post, I described the financial pressures of community building; two companies benefit from building a community organization. I’ve tried to stay away from assumptions, but I am assuming that their influence must factor into the Board...
20 Oct 2014 at 5:12pm
Minion Reindex arrives this Friday!
The MidnightDBA team is announcing the release of a new, free index maintenance solution for SQL Server: Minion Reindex by MidnightDBA. We designed Minion Reindex to solve all of the reindexing headaches we’ve experienced at dozens and dozens of client...
20 Oct 2014 at 3:00pm
Last Weeks Top “Reading” Links #105
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” ( so exciting ), follow me on twitter ( @StrateSQL ). And see these throughout the day as I tweet out links of things I find interesting...
20 Oct 2014 at 1:10pm
#SQLPASS–Who’s Making It Rain?
As promised in my previous post ( #SQLPASS–Good people, bad behavior… ), I’d like to start diving in to some of the controversies that have cropped up in the last year and critically analyze what I consider to be “bad decisions”. This...
20 Oct 2014 at 12:56pm
Add Database File on Database invloved in DB Mirroring
Database Mirroring works on transaction logs. It applies transaction logs from Principle to Mirror. But Operation like addition of file is no log operation because of that file not be added to Mirror automatically. Steps to Add Database File on Database...
20 Oct 2014 at 12:00pm
Update to “The clustered index columns are in all of the non clustered indexes.”
I certainly hadn’t planned on creating a part two of this post but in the comments Jeremy Hughes pointed out that my understanding was if not incorrect, incomplete. So I did some additional testing, confirmed a few things with Paul Randal ( b /...
20 Oct 2014 at 10:38am
Future Decoded – I’m speaking on machine Learning
I’m speaking at Future Decoded, at the same event as Professor Brian Cox , Sir Nigel Shadbolt (Co-founder & Chairman, ODI Open Data Institute), Or Arbel, (CEO, Yo), Michael Taylor (IT Director, Lotus F1 Team), Kenji Takeda, Microsoft Research...
19 Oct 2014 at 10:37pm
Sentiment Analysis In Excel With Azure Machine Learning And Power Query
You may have seen Joseph Sirosh’s blog post last week about the ability to publish Azure Machine Learning models to the Azure Marketplace, and that MS have published a number of APIs there already. There’s a new Excel add-in that can be used with these...
17 Oct 2014 at 5:53pm
Script to Create Multiple, Same-Sized Tempdb Files
This script will take a tempdb database with one database file, and create a set of equally-sized files. You can set how much total space you want the files to use, and how many files to have (in total). From BOL, as a general guideline, create one data...
17 Oct 2014 at 4:00pm
Reblog: October 10 to October 16
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...
17 Oct 2014 at 2:00pm
Untrusted Foreign Keys
What is a Foreign Key? Do you trust your foreign keys? A foreign key is a link between 2 tables that is used to enforce referential integrity in the database. For example, if you have an order and a customer table, there is probably a logical relationship...
17 Oct 2014 at 12:00pm
Friday Followup For October 17, 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 Invite for #TSQL2sday #59 – My Hero! Using...
About Toad World
Ads and Emails
Toad World is Sponsored by
Copyright © 2014 Dell Software Inc.
Translation provided by