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
17 Apr 2015 at 8: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 3: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 2: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 12: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 4: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 4: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 3: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 3: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 1: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...
15 Apr 2015 at 6:39pm
Display Fragmentation on All Indexes in Current Database
This code displays the fragmentation on all indexes in the current database. (It excludes empty tables.) -- SQL Server 2005+. Show index fragmentation on all tables on current database. set nocount on declare @DbId smallint set @DbId = db_id() select...
15 Apr 2015 at 6:35pm
Display Stale Index Statistics
This query displays all the index statistics in the current database that are more than 'n' days old. -- When were Statistics last updated on all indexes more than 7 days ago? select o.name as 'Table Name' , i.name as 'Index Name'...
15 Apr 2015 at 3:00pm
Types of NoSQL databases
A NoSQL database provides a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases. NoSQL is often interpreted as Not-only-SQL to emphasize that they may also support SQL -like...
15 Apr 2015 at 2:30pm
Quickly Check If SSL For SQL Is Enabled
Reading Time: 2 minutes To quickly check SSL is configured on your SQL Server you can run the following query. SELECT session_id, encrypt_option FROM sys.dm_exec_connections This query dumps the information about the connections to your SQL Server and...
15 Apr 2015 at 1:00pm
How to Write Queries – Understand your Database Table’s Meanings and Relationships – Step 1
This is the second 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...
14 Apr 2015 at 4:33pm
CMS: Find All Databases in all Servers that don't have a Specified Table
This code is for CMS (Central Management Servers), and displays all the databases on all the servers that don't have a specified table. -- For all user databases in all servers, which ones don't have a "Customer" table? set nocount...
About Toad World
Ads and Emails
Toad World is Sponsored by
Copyright © 2015 Dell Software Inc.
Translation provided by