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
5 May 2015 at 9:30am
Improving Power Query Calculation Performance With List.Buffer()
I saw an interesting post the other day on the Power Query Technet forum which showed how the List.Buffer() function could be used to improve calculation performance. This is something I’d seen hinted at in other places so I thought it was worth a bit...
5 May 2015 at 6:43am
SQL Server 2016 public preview coming this summer
Satya Nadella, CEO of Microsoft, announced SQL Server 2016 , an intelligent platform for a mobile first, cloud first world. The next major release of Microsoft’s flagship database and analytics platform provides breakthrough performance for mission critical...
5 May 2015 at 2:40am
Microsoft DataZen Mobile Platform Available to SQL Server Enterprise Customers for Free
Last month Microsoft announced that they had acquired the DataZen mobile BI platform and were adding it to their enterprise BI product suite. This is very exciting news that rounds out the Microsoft BI capabilities of their entire product portfolio...
4 May 2015 at 8:13pm
TechEd is now Microsoft Ignite
In case you were wondering what happened to the TechEd conferences, Microsoft is now bringing together the best of previously individual events – the Management Summit, the Exchange, SharePoint, Lync, Project, and TechEd conferences – and then taking...
4 May 2015 at 4:00pm
Monday Morning SQL Break – May 4, 2015
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you don’t already, follow me on twitter ( @StrateSQL ). This is a good chance to catch up on data platform technology and career related information...
4 May 2015 at 1:00pm
Building a job to monitor other jobs
The other day Tom Roush ( b / t ) and Tim Radney ( b / t ) were having a discussion on twitter about using scheduled windows tasks to run SQL Processes. Now why would you ever want to do this? Well if you are running SQL Server Express then this may be...
4 May 2015 at 2:00am
SSMS Tools Pack 22.214.171.124 is out with a NEW feature, a few improved features and various bug fixes.
The new feature is called Global Replacement Texts . It gives you the ability to add custom replacement texts to your scripts in four different features. Licensing now gives you the ability to upgrade your existing license from the previous major version...
2 May 2015 at 7:46am
Which relational DBMS is best for your company?
There are lot of databases around you. What should I select from them. Lot of parameters you need to think. Database expert Craig S. Mullins examines the top relational database management system software to determine which best fits your organization...
1 May 2015 at 1:08pm
Announcing Minion Enterprise: the new SQL Server Management Solution
A company with more than one SQL Server instance has no built-in way to gather and report on maintenance, backup, and configuration data across those instances. Even more, there is no good way to push standardized settings out to the enterprise. The database...
30 Apr 2015 at 1:56pm
Microsoft Introduces Azure SQL Data Warehouse
Microsoft today announced a new service in its Azure database lineup during its Build developer conference keynote today. The Azure SQL Data Warehouse, which will go into public preview in June, is meant to give businesses access to an elastic petabyte...
30 Apr 2015 at 11:09am
Using Function.InvokeAfter() In Power Query
Last year I blogged about how to introduce a delay between web service requests in M code. Since then a new function has been added to Power Query which makes this a lot easier: Function.InvokeAfter(). This function doesn’t seem to be documented anywhere...
30 Apr 2015 at 8:45am
Finding Locks on Tables
Recently I needed to find a stored procedure that was creating a lock on a table and updating the table regularly. So my starting point was the table name, but I needed to find where the commad was coming from that was locking the table, and what stored...
29 Apr 2015 at 8:17pm
Troubleshooting Azure Connectivity: Ports and Endpoints
It was a simple enough question, or so I thought. One I felt should be either a simple “yes” or “no”. “Do we block remote desktop connections here?” Sure enough, I got back the quick and simple answer I expected, along with a question for myself. “Nope...
29 Apr 2015 at 3:30pm
They Can Do What? – SHUTDOWN
Reading Time: 1 minutes Many times the DBA is faced with the dilemma of granting excessive access to an application or user so it can ‘just work’. This can cause a lot of problems. There are commands that can be given from T-SQL that can...
29 Apr 2015 at 2:00pm
How to Write Queries – Write the Query – Step 3
This is the fourth of four articles in a series explaining the three simple steps I take to writing complex SQL statements. The series starts with this introductory article . All the examples for this lesson are based on Microsoft SQL Server Management...
About Toad World
Ads and Emails
Toad World is Sponsored by
Copyright © 2015 Dell Software Inc.
Translation provided by