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 2008
SQL Server 2012
21 Aug 2014 at 4:10am
New Database Backup Options in SQL Server 2014
Short article on database backup options in SQL Server 2014. http://dbfriend.blogspot.com/feeds/posts/default?alt=rss
20 Aug 2014 at 10:16pm
Solutions, Action, Results: Jenkon Dramatically Reduced Resolution Times
As a busy DBA, you are constantly pressed for time. You feel the pressure from your manager to work faster and more efficient—everyday. What would you think if we told you that you could reduce your resolution time by 70 percent? Sounds awesome...
20 Aug 2014 at 3:00pm
ISPACs – Got To Love Em
Being a DBA and working with various teams, I have become accustomed to deploying SSIS packages. I’ll even go back further and, dare I say, DTS packages (I hope everyone did not just fall on the floor while reading that). Now-a-days this Database...
20 Aug 2014 at 2:00pm
Scripting Objects with PowerShell
The ability to script out the definitions of objects is valuable to any DBA. Most of us are intimately familiar with SQL Server Management Studio’s capabilities in this regard. Simply right-click on your object and navigate to the “Script...
20 Aug 2014 at 1:00pm
Two years ago today I began my blog with a post about the DEFAULT keyword . I set out with the goal of building a blog I could be truly proud of in three years. One that was well liked and provided value to the community. Little did I imagine how much...
20 Aug 2014 at 12:35pm
Create and connect to a SQL Database on Windows Azure
Azure , is one of the fastest growing cloud platform by Microsoft. In this simple post, I will create and connect to a SQL Database on Microsoft Azure. To get started logon to the Microsoft Azure Management Portal , navitage to SQL Database and click...
19 Aug 2014 at 3:00pm
Export a SSMS Query Result Set to CSV
Once you have a query that is returning the data you like in SSMS you have a few options to move the result set into a format that you can use in other tools. The simplest way is to select all results and then copy & paste them into whichever other...
19 Aug 2014 at 3:19am
HOW TO: Find Currently Running Long SQL Agent Jobs
A while ago I had posted a script to help find jobs that were currently running longer than expected. Since I’ve been sharing some scripts recently , I decided to verify that this script still works for finding long running jobs in SQL Agent for...
18 Aug 2014 at 8:08pm
And Just Like That….Three Years
Time is a constant. Anything and everything requires time it seems, and with that said I received a reminder today that three years have passed since I first started this adventure called blogging. With this blog you will not find perfection, instead...
18 Aug 2014 at 7:05pm
Managing a Technical Team: Building Better
Heard a great podcast the other day from the team at Manager Tools , entitled “THE Development Question”. I’m sorry to say that I can’t find it on their website, but it did show up in Podcast Addict for me, so hopefully you can pick it up and give...
18 Aug 2014 at 4:00pm
Last Weeks Top “Reading” Links #97
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” ( so exciting ), follow me on twitter ( @StrateSQL ). And see these throughout the day as I tweet out links of things I find interesting...
18 Aug 2014 at 2:51pm
SQLSaturday Precon Cost Structure
Many of you may already know that I am a PASS regional mentor for the South Central region of the United States. My role is to help user group leaders obtain the tools they need to have successful groups and provide an open platform to discuss challenges...
18 Aug 2014 at 1:00pm
Generating a restore script
In order to speed up our backups on a large database our team decided to stripe the backup files. In case you weren’t aware of this particular backup feature it his means that a single backup is written to multiple files which can dramatically speed...
18 Aug 2014 at 11:20am
Removing Punctuation From Text In Power Query
In one of my first posts on Power Query (and still my favourite) I found the top 100 words in the complete works of Shakespeare . As always when you’re learning a new tool, though, I look back at what I wrote then and realise there are better ways of...
18 Aug 2014 at 10:27am
How To Split Non-Empty Partitions When A Clustered Columnstore Index Exists on The Table
Another pithily titled blog post, but this one revisits the feature of SQL Server 2014 that piqued my interest the most: Clustered Columnstore Indexes. I’ve been working with Clustered Columnstore Indexes for the past few months and recently a colleague...
About Toad World
Ads and Emails
Toad World is Sponsored by
Copyright © 2013 Dell Software Inc.
Translation provided by