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
3 Mar 2015 at 1:16pm
SSIS: Password Policy Rules Not Met When Creating Catalog
Last week I was at a client site showing them how to set up the Integration Services Catalog. We were walking through the steps in how to create it and we input the password into the Create Catalog configuration screen. It was a strong password, that...
3 Mar 2015 at 1:00pm
Interview with Brad Botz on Business Analysts
I recently met Brad Botz in a professional Facebook group we both belong to and found we we have much in common. I really like databases and development, and Brad likes to read user’s minds. Well not really, but see Brad is a Business Analyst...
3 Mar 2015 at 1:00pm
Submit Your Feedback On BI Features In SQL Server V.Next
Following on from last month’s post on ideas for new features in SSAS Multidimensional, if you are interested in telling Microsoft what features you think should be added to the on-prem SQL Server BI tools in the next version you can do so here: http...
2 Mar 2015 at 11:51pm
Why do We Have to Be at Risk? Enough is Enough!
When Do We Say Enough Is Enough? Recently Anthem Blue Cross Blue Shield announced that the ‘private’ information of up to 80 million customer was stolen. It wasn’t anything about medical history taken, just all their customer’s...
2 Mar 2015 at 3:05pm
ICYMI: the Halloween Problem and DBCC CheckConstraints – SQL Server Performance
Don’t miss these great articles on SQLPerformance.com from the industry’s top experts: A Look At DBCC CHECKCONSTRAINTS and I/O Erin Stellato ( b | t ) of SQLskills takes a deep look into the SQL Server performance impact, especially I/O, of...
2 Mar 2015 at 2:57pm
SQLBits XIV – Welcome to the UK
A number of you will have heard of SQLBits before. It’s Europe’s largest conference dedicated to SQL Server. What was something just for people from the UK has been transforming into something much larger, more multicultural and more engaging as the community...
2 Mar 2015 at 1:00pm
SQL Judo’s Monthly Challenge – March 2014 – Powershell something
Every month SQL Judo (Russ Thomas) ( b / t ) challenges us to do his Monthly DBA Challenge . I’ve decided it would be fun (and good practice) to do them. Another major benefit is that it will force me to move out of my normal comfort zone. For example...
1 Mar 2015 at 5:11pm
What You Need to Set Up the SSAS Connector in the Power BI Preview
Welcome to part 2 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...
1 Mar 2015 at 12:07am
What is it? MergeUi is a addin (VSPackage) for Visual Studio / Sql Server Data Tools projects. It is a ui to create and edit T-Sql merge statements in pre and post deployment scripts. In this screen shot you can see the merg statement that is generated...
27 Feb 2015 at 6:28pm
Impact Series – Part 2
It’s that time again to add another impact player to the roster; this time for the month of February. This month the nod goes to none other than Jason Strate ( Blog | Twitter ). A few years back I sat in on one of Jason’s sessions at PASS Summit...
27 Feb 2015 at 1:00pm
Friday Followup For February 27, 2015
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 Building (for FREE) a Virtual Server for SQL Demos...
26 Feb 2015 at 9:15pm
Gimme A Break! Taking Mental Health Days
Reading Time: 3 minutes Do you feel like this when you get to work? Burnout! You have been stressing over the big project you have to get done. You get in early Monday morning, pour yourself a mug of coffee and stumble to your desk. You start...
26 Feb 2015 at 9:15pm
Adding a User to Multiple Databases
Everyone seems to have their own version. Mine is as simple as I could make it. Make sure you create the LOGIN first, and set the @User variable in the code below. Assumes you have already created a login named @User . set nocount on declare @User sysname...
26 Feb 2015 at 4:19pm
Operational Data Store (ODS) Defined
I see a lot of confusion on what exactly is an Operational Data Store (ODS). While it can mean different things to different people, I’ll explain what I see as the most common definition. First let me mention that an ODS is not a data warehouse...
Michael J. Swart
26 Feb 2015 at 3:06pm
When Parameter Sniffing Caused Deadlocks
Last week I was asked to troubleshoot some deadlocks in production. I was surprised to find out that parameter sniffing was one of the causes. I describe the investigation below. Parameter Sniffing SQL Server does this neat trick when you give it...
About Toad World
Ads and Emails
Toad World is Sponsored by
Copyright © 2015 Dell Software Inc.
Translation provided by