SQL Server

SQL Server Community

SQL Server Blogs

Melissa Coates
Follow /24 Apr 2014 at 11:57am / SQL Server

Whatcha Bringin' To the PASS BA Conference?

I'm seriously super excited for the PASS BA Conference coming up the first week of May. Last year I wasn't able to go, and I was a very sad girl. So instead of living vicariously through tweets & blog posts, this time I'll be there. Here's...
569 0 /
Michael J. Swart
Follow /23 Apr 2014 at 2:20pm / SQL Server

Removing Comments from SQL

Check out the following deliberately crazy SQL Script: create table [ /*] /* -- huh? */ ( "-- --" integer identity , -- /* [ */ ] varchar ( 20 ) /* -- */ default '*/ /* -- */' /* /* /* */ */ */ ...
52 0 /
John Sterrett
Follow /23 Apr 2014 at 1:50pm / SQL Server

Learn High Availability and Disaster Recovery with SQL Server in a Day!

If you are near Pittsburgh, PA on May 22, 2014 catch the following all-day training session from 8:30 AM to 4:00 PM (EDT)  Do you need to build a High Availability (HA) and/or Disaster Recovery (DR) strategy for SQL Server Databases? If so, you will...
47 0 /
SQLDBAPros
Follow /23 Apr 2014 at 1:27pm / SQL Server

6 Essential Tips for Managing SQL Server

Earlier this month, Dell sponsored a webcast titled, “Essential Tips for Managing SQL Server.” We welcomed Jason Strate, Solution Architect, Pragmatic Works as a co-host, along with our very own Peter O’Connell, Product Manager of SQL...
60 0 /
Richard_RP
Follow /23 Apr 2014 at 10:54am / SQL Server

SQL Server Partitioning 101

I’ve worked with partitioning for quite some time now, and though it has been around for quite some time and lots has been written about the concept I recently presented an example of partitioning to a few people within a team and felt it was worth...
53 0 /
Gethyn Ellis
Follow /23 Apr 2014 at 8:00am / SQL Server

SSMS Queries on Function Keys

By David Postlethwaite At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn’s blog about the bits I didn’t manage to cover. If you have simple queries or functions that you use regularly...
41 0 /
David Dye
Follow /22 Apr 2014 at 11:51pm / SQL Server

10 Reasons to Attend #SQLSat Atlanta

With just over a week and a half left it is time to register for SQL Saturday Atlanta and here are 10 reasons that you should attend. 1. Rafael Salas , twitter , ETL Architecture Chekup: Avoiding Costly Mistakes This session is an encore from SQL Saturday...
0 0 /
WaterOx
Follow /22 Apr 2014 at 7:30pm / SQL Server

2014 SQL Server Editions – Overview

2014 is the latest edition of SQL Server available[/caption] SQL Server 2014 was officially released in April 4th, 2014. You can download the 120 day Enterprise edition trial version here: http://technet.microsoft.com/en-US/evalcenter/dn205290 As...
68 0 /
Jason Strate
Follow /22 Apr 2014 at 3:00pm / SQL Server

Last Weeks Top “Reading” Links #80

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...
44 0 /
Ayman El-Ghazali
Follow /22 Apr 2014 at 1:02pm / SQL Server

SQL Server Internals Presentation Double Time!

I’ll be doing double time over the next two weeks with Two Presentations on SQL Server Internals. It is essentially just a repeat of the same presentation but with two chances to attend :) Here are the details of the timings for both presentations...
56 0 /
Rohit Garg
Follow /22 Apr 2014 at 12:46pm / SQL Server

How to install SQL Server Failover Cluster from SQL Server 2008 onwards ?

Steps to install SQL Server Failover Cluster from SQL Server 2008 onwards :- 1) Open SQL Server Installation Center > Go to Installation from Left > Click on New SQL Server Failover installation from right 2) Click RUN to start setup 3...
56 0 /
Chris Yates
Follow /22 Apr 2014 at 12:13pm / SQL Server

Communication – is it key?

Communication is easier now than it has ever been. Whenever we need to get in touch with somebody, we can call, e-mail, or text, regardless of where we are and where they are. Geography isn’t an issue; we can instantly send a message to somebody halfway...
46 0 /
sqlbischmidt
Follow /22 Apr 2014 at 11:09am / SQL Server

DAX: Always get the Latest date for a slicer

You’ve done it. After some development, your Power Pivot model has some awesome-sauce, has a slicer for the day/month/year, and is ready to do some serious data insight. You set your slicer to the current moment in time, deploy it to a Power Pivot gallery...
52 0 /
Gethyn Ellis
Follow /22 Apr 2014 at 10:00am / SQL Server

SQL Server Training – Spring 2014

I have just returned from a trip to Washington DC where I was delivering course 2105 – SQL Server 2012 DBA skills upgrade class in an onsite class to one of Learning Tree’s clients. For those of you that don’t know, a Learning Tree onsite is event is...
49 0 /
David Dye
Follow /21 Apr 2014 at 6:46pm / SQL Server

10 Reasons to Attend #SQLSat Costa Rica

SQL Saturday Costa Rica is less than one week away. There is still time to register and if you haven’t yet here are some reasons to get you motivated. 1. Andy Leonard , twitter , Using BIML as an SSIS Design Patterns Engine If you work with SSIS and...
46 0 /