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 Sep 2014 at 4:17pm
Cumulative Updates – SQL Server 2012 SP1 CU12
As part of their Incremental Service Modelling , Microsoft have released SQL Server 2012 Service Pack 1 Cumulative Update #12. To apply this cumulative update package, you must be running SQL Server 2012 SP1. So it is pertinent for versions 11.0.3000...
22 Sep 2014 at 3:22pm
I want to thank the attendees, organizers and speakers at SQL Saturday #340 San Diego. This was an awesome event and it is always well worth the travel to attend such a great event. My presentation materials have been uploaded to the SQL Saturday...
22 Sep 2014 at 2:00pm
SYS.DM_EXEC_REQUESTS Changes Between Versions Of SQL Server
I was recently doing some work with a backup verification routine that is meant to run on various versions of SQL Server and came across some variations in the way the RESTORE VERIFYONLY command is reported by sys.dm_exec_requests between SQL Server 2005...
22 Sep 2014 at 1:00pm
Changing configuration settings with sp_configure
I was recently asked where to go in Configuration Manager to change the settings for xp_cmdshell. It was then that I realized that the existence of sp_configure is probably not universal knowledge. I was truly shocked. For some reason I had thought that...
22 Sep 2014 at 11:06am
Why I Support The PASS Name Change And Its Efforts To Expand Into The BA Community
Unless you take a close interest in the politics of PASS you may have missed the kerfuffle around it changing its name from the “Professional Association of SQL Server” to just PASS a month or so ago. Blog posts from Andy Warren and R. Brian Kelley seem...
22 Sep 2014 at 10:03am
SQL Server Cluster LooksAlive and IsAlive Check
Windows Cluster Service use the “heartbeat” process to check whether each node is alive at both the OS level and SQL Server level. Heartbeat signals works on UDP. Microsoft Windows Cluster service perform 2 health checks to perform node...
22 Sep 2014 at 4:30am
#0347 – SQL Server – Basics – A SELECT that does not fetch anything also does not SET anything
In today’s post, I go all the way back to the basics because of a logical bug I saw in production code recently. It is always said to be a good practice to initialize variables within procedures so that you know what the default value is and what are...
19 Sep 2014 at 7:57pm
Avoid Technology Debt
Can you afford to miss this free training class? See the end of this post on how to sign up. Have you ever been in a situation where you are working on implementing a SQL Server based solution and you need to make a decision about the technology that...
19 Sep 2014 at 5:00pm
Reblog: September 12 to September 18
Photo credit – Jenn and Tony Bot Sometimes old stuff is just as cool as new stuff. Over the past few years, I’ve written a few things that are worth a revisit from time to time. In this post, you’ll find a list of previous year’s...
19 Sep 2014 at 2:42pm
Wendy Pastrick and Grant Fritchey: Optimists in Action #passvotes
If I had a favorite kind of politician, it would be the kind that, when asked a question, sighs tiredly, and then regains their gleam of manic optimism as they begin to speak about the path ahead. Given that, my two favorite politicians right now are...
19 Sep 2014 at 2:30pm
EPM Framework v4 Released!
The Enterprise Policy Management Framework (EPMF) team is proud to announce the updated release of “Enterprise Policy Management Framework 4.0 for project EPMFramework. This is a major release with lots of performance tweaks and The EPM Framework...
19 Sep 2014 at 1:00pm
Friday Followup For September 19, 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 Don’t Get Slimed By Bad Parameter Sniffing...
18 Sep 2014 at 9:17pm
Handling Data Source Errors In Power Query
Recently I was asked an interesting question by Ondra Plánička in the comments of a blog post : how can you handle errors caused by unavailable or missing data sources in Power Query? Let’s imagine you are loading a csv file like this one into Excel...
18 Sep 2014 at 3:58pm
Tips for First-Timers Attending PASS Summit 2014
Are you attending PASS Summit 2014 ? If this is your first year at the conference and you’re not sure what to expect, then you are in luck! We are taking the stress and hard work out of conference prep with a simple snap shot of what you need to...
18 Sep 2014 at 3:45pm
Video: Walk & Talk #002 – RTO
Recovery Time Objective (RTO) What is it and why does it matter? I am actually walking this time! Join me to walk & talk through what the RTO (Recovery Time Objective) is with regards to SQL Server. Location: American Chestnut Land Trust –...
About Toad World
Ads and Emails
Toad World is Sponsored by
Copyright © 2014 Dell Software Inc.
Translation provided by