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
20 Apr 2015 at 9:46pm
In-Memory OLTP: Part 3 – Checkpoints
This post follows on from In-Memory OLTP: Part 2 – Indexes So far in this blog series memory optimised tables have been created with the durability option of SCHEMA_ONLY meaning that data will not be retained. However there is another durability...
20 Apr 2015 at 4:19pm
Find Orphaned MDF, NDF and LDF Files on All Drives
Sometimes you run across a server that for one reason or another is full of MDF, NDF, and LDF files that look to be months or years old. Of course, you can't go by the Date Modified timestamp of these files in Windows Explorer, but still, when you...
20 Apr 2015 at 3:30pm
SQL Saturday 413 news from the front
It is a lot of work to plan a SQL Saturday, and also a lot of fun. The third edition of SQL Saturday in Denmark will be no exception. The team is already putting a lot of effort in finding and contacting sponsors, which luckily are often more than willing...
20 Apr 2015 at 1:00pm
T-SQL HOST_ID and HOST_NAME
HOST_ID and HOST_NAME Included in T-SQL for SQL Server is a functions that returns the workstation information that executes a SQL statement. You can use this to record what workstation the transaction came from in your application or business intelligence...
20 Apr 2015 at 1:00pm
The hidden security of msdb
To be fair it’s not actually hidden, just not so well known. Have you ever wondered how to grant permissions to create/modify jobs? How about SSIS packages? Every database has the following built in roles: db_accessadmin db_backupoperator...
20 Apr 2015 at 3:45am
Microsoft Halts SQL Server 2014 SP1 Downloads
A bug surfaces soon after the release of SQL Server 2014's first service pack, forcing Microsoft to temporarily disable downloads of the update. Microsoft's attempt at squashing SQL Server 2014 bugs ran into a bug of its own. The company released...
17 Apr 2015 at 9:25am
Building A Reporting Solution Using Power Query
The video of my SQLBits conference session “Building a reporting solution using Power Query” is now available to view (for free) on the SQLBits website: http://sqlbits.com/Sessions/Event14/Building_A_Reporting_Solution_Using_Power_Query It’s not your...
16 Apr 2015 at 4:25pm
SQL Server 2014 SP1 released, and revoked
Just a brief note today to point to an article by Time Ford on SQLMag.com announcing that SQL Server 2014 SP1 has been released, and then pulled almost immediately: The problem is there was a problem with the patch. I can’t go into details until...
16 Apr 2015 at 3:00pm
Exam Prep 70-463: Master Data Services Models
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012. So far, we’ve covered: Tables and Schemas in the data warehouse Dimensions and Slowly...
16 Apr 2015 at 1:00pm
Adding, altering or removing multiple columns from a table
I was recently asked to do some fairly heavy modifications to a table. It involved adding 6 new columns, removing 4 old ones, renaming 4 and then altering the datatype for those 4. I find these kinds of requests rather entertaining in a simplistic sort...
16 Apr 2015 at 5:13am
SQL Server 2014 Service Pack 1 is now available
One year ago, Satya Nadella spoke in San Francisco to launch SQL Server 2014 . Today, Microsoft has to announced the release of SQL Server 2014 Service Pack 1 (SP1). The Service Pack is available for download on the Microsoft Download Center . As part...
16 Apr 2015 at 5:06am
The World According to DBAs
Database administrators (DBAs) are at the frontline of data management in most enterprises, identifying and often choosing to adopt new technologies. According to a new survey of DBAs, "While Hadoop and NoSQL are exciting new technologies,"...
16 Apr 2015 at 4:50am
Microsoft Announces GA of Azure DocumentDB Managed NoSQL Document Database Service
Microsoft has announced that the Azure DocumentDB database service is now generally available offering a fully managed NoSQL document database service that allows applications to query and process JSON data at scale. Microsoft has also released a new...
16 Apr 2015 at 4:47am
Microsoft To Kill SQL Server 2005 Support in 2016
Organizations running SQL Server 2005 will be cut off when it comes to official support next year, Microsoft announced this week. http://mcpmag.com/articles/2015/04/15/sql-server-2005-support.aspx http://dbfriend.blogspot.com/feeds/posts/default?alt=rss
16 Apr 2015 at 2:34am
Keeping Up with New Information with RSS, Twitter, and Read Later
I wanted a solution to view the RSS feeds of my favorite bloggers in the same place as the items I've tagged in my 'read later' app. This single place needs to be available on my Windows 8 device (a Surface Pro 3 which I dearly love), preferably...
About Toad World
Ads and Emails
Toad World is Sponsored by
Copyright © 2015 Dell Software Inc.
Translation provided by