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

Latest Blog Posts

Silliness for an Important Cause

I don’t mind saying that amyotrophic lateral sclerosis (ALS), also known as Lou Gehrig’s disease, scares me. A degenerative disease that takes away the minds ability to control the body, leaving the mind intact… words fail me. Add to that the fact that there is no known cure, and that… Read more

0 comments, 29 reads

Posted in The Scary DBA on 21 August 2014

Notes on the August 19, 2014 Pinellas SQL Group Meeting

  • Busy week, should have blogged about it before the event
  • Did a remote presentation on securing credit card data
  • First time using Lync for remote, not hard to use, but not good to try 10 minutes before hand either (my fault)
  • Camera in the room was nice, had a sense…

Read more

0 comments, 62 reads

Posted in SQLAndy on 21 August 2014

Reviewing the PASS 2015 Budget

I just spent a few minutes reviewing the 2015 PASS budget, things that I noticed:

  • Anticipating a change in revenue of 1.1 million. That seems…optimistic
  • IT spend is now $550k, up $150k over 2014. Probably good, but what are we doing with that? Ah, the budget doesn’t say
  • Chapter…

Read more

0 comments, 44 reads

Posted in SQLAndy on 21 August 2014

Stupid me #4 – The login is from an untrusted domain

After quite a while it has finally returned: another Stupid Me™®©! A reminder:

Every time I do something “stupid”, which happens from time to time, I’ll do a little blog post on what happened and how I solved it. The reason for this is twofold: I’ll have a solution online… Read more

0 comments, 36 reads

Posted in Koen Verbeeck on 21 August 2014

Automated Source Control: A Librarian For Your Database Objects, Part 1

One of the biggest headaches in most development groups that do any sort of SQL Server work is that of source control.  There are some commercial products that attempt to solve this headache, and from what I understand, some of them do a pretty decent job.  The only one that… Read more

0 comments, 59 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 21 August 2014

Monitor the Number of Deleted Rows in a Clustered Columnstore Index

In some of my previous posts, I have talked about how to create Columnstore indexes. Now I’d like to discuss one maintenance detail that you need to keep an eye on. I’m talking specifically about the number of “deleted rows” in a clustered Columnstore index.

One of the great…

Read more

0 comments, 44 reads

Posted in Everyday SQL on 21 August 2014

VMworld 2014 Is Next Week

Can you believe that this year’s VMworld conference is just around the corner? It’s next week – August 24 – 28 – at the Moscone Center in San Francisco!

If you have never been to VMworld before, it’s an amazing event. VMware has a great guide for first-timers on… Read more

0 comments, 55 reads

Posted in Technobabble by Klee from @kleegeek on 20 August 2014

SQLSaturday Orlando Marketing Plan-Part 37

I’m continuing to experiment with the messaging. Without A/B testing (and maybe even with, given the small list size) it’s hard to know what works, or doesn’t. If nothing else we’ll poll on it post event. I have some guidelines:

  • Message every Tuesday. If they read them all good,…

Read more

0 comments, 43 reads

Posted in SQLAndy on 20 August 2014

Being a Volunteer Leader Is Hard

I’ve been thinking about this topic for a few weeks, maybe longer. It’s based on the three years I served on the PASS Board, and observations of others who served before during, and after that time. I’m trying to look at behaviors and patterns, not people and personalities, though surely… Read more

0 comments, 69 reads

Posted in SQLAndy on 20 August 2014

Still a Need for a SQL Server Specific Organization

If you haven’t already, please read Denise McInerney’s post about why PASS no longer stands for the Professional Association for SQL Server.

The Growth of an Organization

If you’ve been involved with PASS lately, you’ve probably seen this change coming. When I read the post, I wasn’t surprised. PASS… Read more

0 comments, 81 reads

Posted in Databases – Infrastructure – Security on 20 August 2014

Updating tsqlt

I was looking to write a new test with the tsqlt framework recently. I wanted to isolate a stored procedure’s logic and planned on using the FakeFunction procedure available in tsqlt.

I wrote my test, using a template from the Pluralsight course on tsqlt and the documentation. I tried to… Read more

0 comments, 69 reads

Posted in The Voice of the DBA on 20 August 2014

The End of The Professional Association Of SQL Server? It Should Be More Than Just An Acronym

I read with a bit of despair this post by Denise McInerney this morning. Going forward, it’s just “PASS”. Somehow we’ve transitioned to being a data organization, which I think means big data, Power Query, Sharepoint, Excel, and everything else.  I always thought the SQL Server community was plenty big… Read more

3 comments, 72 reads

Posted in SQLAndy on 20 August 2014

The Red Gate Way…

As companies go, Red Gate is a little different. That is readily apparent in our tools and the philosophy behind them, ingeniously simple. But, we do a lot of other things too. There’s the Simple-Talk web site where we publish serious articles on all aspects of development and database administration… Read more

2 comments, 66 reads

Posted in The Scary DBA on 20 August 2014

Two years!

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

4 comments, 82 reads

Posted in SQLStudies on 20 August 2014

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, 87 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, 72 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

1 comments, 82 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, 126 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, 57 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, 123 reads

Posted in Vivek's SQL Notes on 18 August 2014

Older posts