Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

SQL in the City 2014

It’s official, we have a couple 2014 SQL in the City events scheduled, covering two countries this fall. Both events are packed into a short time (less than two weeks), so Grant and I have quite a bit of travel ahead of us.
Once again we’ve divided up the…

Read more

0 comments, 54 reads

Posted in The Voice of the DBA on 19 August 2014

Joint oPASS/MagicPASS Meeting Scheduled for October 15, 2014- Featuring Mark Souza In Person!

Big news for us in Orlando! On October 15th Mark Souza, General Manager – Data Platform Group at Microsoft, is going to speak to a joint oPASS/MagicPASS chapter meeting. Just having a joint meeting is a big deal, but having Mark as the speaker – hard to believe! The… Read more

0 comments, 46 reads

Posted in SQLAndy on 19 August 2014

Getting the Word Out

A discussion that I’ve frequently had with organizers of SQL Saturday events, our own people here at Red Gate, authors, MVPs, pretty much anyone interested enough to listen for a few minutes, is summed up by “How do we get the word out about the opportunities that the SQL Server… Read more

0 comments, 54 reads

Posted in The Scary DBA on 19 August 2014

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… Read more

1 comments, 55 reads

Posted in WaterOx SQL on 19 August 2014

SQL Saturday Birmingham 2014

I'm looking forward to geauxing with a handful of Sparkhound colleagues and friends to speak at SQL Saturday Birmingham on August 23 at Samford University.

Fun trivia fact: This will be the first time I'll have spoken at a SQL Saturday east of Baton Roug

Read more

0 comments, 37 reads

Posted in SQL Tact on 19 August 2014

SQLTea - New SQL tutorial app in Google play store

SQLTea - Our new SQL Tutorial App on Google Play Store
We are happy to announce our new SQL tutorial app SQLTea  ( Native android app) for SQL learning which includes articles from this blog.

This application includes 

1) Articles for basic concepts like Normalization, Constrains, Joins, SQL Functions,…

Read more

0 comments, 94 reads

Posted in Vivek's SQL Notes on 18 August 2014

SQLSaturday Orlando Marketing Plan-Part 36

Just checked in on my LinkedIn campaign. This is the one that uses job titles. Not a ton of impressions, but I can live with that at this level of targeting. Going to send this off to the team, we might run this longer given the low weekly spend.

Tomorrow… Read more

0 comments, 58 reads

Posted in SQLAndy on 18 August 2014

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 and successes.  One… Read more

2 comments, 45 reads

Posted in Ryan Adams on 18 August 2014

Performance Counters: Why It Depends

When you’re working through some vague performance issues (e.g., “SQL Server seems slow today”), one of the common things to do is to collect some performance counters. If you are collecting performance counters for the first time on the server, you don’t have anything to compare them against. This usually…

Read more

Playing with Pivot

I’ve been working on some skills, trying to grow some of my T-SQL, and started to mess with the PIVOT operator. This is a T-SQL construct that helps you turn row data into column data. It’s part of the SELECT query, and comes about in the FROM clause. There… Read more

0 comments, 95 reads

Posted in The Voice of the DBA on 18 August 2014

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 up your backups and restores.… Read more

3 comments, 85 reads

Posted in SQLStudies on 18 August 2014

SQL Server Keyboard Shortcuts

SQL Server Keyboard Shortcuts for Management Studio

SQL Server Management Studio is filled with lots of optional settings that lets you maximize your development experience.  There are a few helpful settings and shortcut keys that will help you get the most out of the tool while working on database activities.… Read more

0 comments, 81 reads

Posted in Business Intelligence and Enterprise Architecture on 18 August 2014

SQL Code Guard v2.6 released

Today we released new version of SQL Code Guard, 2.6
Main changes:
1. Bug fixing
2. Small GUI and usability improvements
3. Fixed support of SQL2014
4. Changed behavior of some issues.


Read more

0 comments, 97 reads

Posted in SQL Code Guard on 18 August 2014

Parameterization Part 1: Plan Caching

Many times, when I perform query tuning, the problem that causes the query to perform badly is related, one way or another, to parameterization.

On one hand, parameterization is a fundamental subject in the heart of the query processor. It can affect query performance dramatically. On the other hand, it… Read more

0 comments, 62 reads

Posted in Guy Glantser on 18 August 2014

How to restore database backup in SQL SERVER

In this article, I am going to explain the process of  Database restoration using the SQL Server Management Studio. In this article, I will try to explain this process in a simple way so that a database developer having little knowledge of DBA can restore that database using the database…

Read more

0 comments, 79 reads

Posted in Vivek's SQL Notes on 17 August 2014

How to take Database backup in SQL SERVER

This article explain the simple way to take up the backup of a database which can be easily understandable by the database programmer having little knowledge of DBA. For taking the database backup, we need to follow the given step.

Step 1:- Open the SQL Sever Management Studio. For this…

Read more

0 comments, 64 reads

Posted in Vivek's SQL Notes on 17 August 2014

Database Creation using SQL Sever Management Studio (SSMS)

In the previous article (Database Creation using Create Database command), I explained the database creation using the Create database command. In this article, I am going to explain the steps of creation a database using SQL Sever Management Studio (SSMS) using SQL Server 2008 R2. These below database creation…

Read more

0 comments, 62 reads

Posted in Vivek's SQL Notes on 17 August 2014

Database Creation using Create Database command

In SQL Server, database can be created by 2 ways:-
  1.  Using Create Database command
  2.  Using SQL Sever Management Studio (SSMS).

In this article, I am going to explain the database creation using the command CREATE DATABASE.

Syntax for creating a database through Create database command is given below:-


Read more

0 comments, 93 reads

Posted in Vivek's SQL Notes on 17 August 2014

SQLSaturday Orlando Marketing Plan-Part 35

Quick update on registrations. We’re at 287 as of noon on August 15th, not bad. The blue part of the line is Kendal’s forecast. Realistic maybe, but I’m still working on getting to 500!


Read more

0 comments, 66 reads

Posted in SQLAndy on 15 August 2014

Notes From the August 14, 2014 ONETUG Meeting

  • ONETUG team graciously gave me time at the beginning of the meeting to talk about the upcoming SQLSaturday Orlando
  • Asked them to attend – I think people like to be asked, and we really do want them to attend!
  • Mentioned our paid seminars
  • Asked them to mention the event to…

Read more

0 comments, 105 reads

Posted in SQLAndy on 15 August 2014

Older posts