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

Latest Blog Posts

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

I assume that by now you’ve tried the script from Part 1, and have seen how easy it is to script out your database objects using Powershell.  The resulting scripts are the standard DDL scripts that you can generate from Management Studio, and for most of us, are just… Read more

0 comments, 2,648 reads

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

Parameterization Part 2: Seven Ways to Execute Your Query

This is the second post in my series on parameterization. In the first post I wrote about plan caching and about the phases that each batch goes through before execution. I ended the previous post with a query example that demonstrates the importance of parameterization. For this post I’m going… Read more

5 comments, 4,068 reads

Posted in Guy Glantser on 25 August 2014

Speaking at SQLSaturday #336 Holland

I received some great news this week, my session about wait statistics is selected for SQLSaturday #336 in Utrecht, Holland!

This will be my first SQLSaturday as a speaker and I am really looking forward to it!

There are more than 160 sessions submitted by great SQL Server experts around… Read more

0 comments, 112 reads

Posted in DotNine SQL Server and more on 23 August 2014

Security Updates released in MS14-044, and An Approach Microsoft’s Incremental Servicing Model

On August 12th, 2014, another infamous ‘patch-Tuesday,’ Microsoft released a series of Security Updates for multiple versions of SQL Server, to deal with potential Denial of Service attacks and an exploit in Master Data Services. After attempting to make my way through hundreds of instances already, and all… Read more

0 comments, 145 reads

Posted in The Database Hive for SQL Server DBAs on 22 August 2014

Reblog: August 15 to August 21

Photo credit – Mike Lynch

A good cure to a creepy doll is a good old post that is still useful. In this post, I’m going back over some of the posts that came out in this week in previous years. Having looked over these from time to time, I’m… Read more

1 comments, 129 reads

Posted in StrateSQL on 22 August 2014

SQLSaturday Orlando Marketing Plan-Part 38

I just checked in again on our LinkedIn campaign, had a couple days with good impression counts. We can still only tie 1 registration to all of the LinkedIn effort so far. Keep going, or ? I think I’m going to see if I can change the URL to a… Read more

0 comments, 98 reads

Posted in SQLAndy on 22 August 2014

The ALS Ice Bucket Challenge

A few friends challenged me yesterday, including Grant Fritchey and Aaron Bertrand. Last night, when I got to the Denver SQL Server User Group meeting, Todd Kleinhans was ready to take the challenge and asked if I’d participate.

I was speaking, but happy to do it afterwards. Here we… Read more

1 comments, 606 reads

Posted in The Voice of the DBA on 22 August 2014

Odds and Ends To Think About

Got this in morning email from Khan Academy. Not sure if I agree that we all can learn anything, but I love the video anyway because the best lesson to learn is that learning takes time, effort, and stumbles. I watch my own kids struggle with this, and think how… Read more

0 comments, 104 reads

Posted in SQLAndy on 22 August 2014

Friday Followup For August 22, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Cheating DBCC To Fix Index Corruption
  • Don’t Get Slimed By Bad Parameter Sniffing
  • Do You Need A Log…

Read more

0 comments, 89 reads

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

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, 627 reads

Posted in The Scary DBA on 21 August 2014

SQLSat Birmingham: SQL Server Admin Best Practices with DMVs

Thanks for attending my session today SQL Server Admin Best Practices with DMVs at 8AM!

Here's the link to a .zip file to download the slide deck and all sample files: http://1drv.ms/VH3mda

Read more

0 comments, 81 reads

Posted in SQL Tact on 21 August 2014

SQLSat Birmingham: SQL Server Permissions and Security Principals

Thanks for attending my session today, SQL Server Permissions and Security Principals at 9:15AM!

Here's the link to a .zip file to download the slide deck and all sample files: http://1drv.ms/VH3lpx

Read more

0 comments, 75 reads

Posted in SQL Tact 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, 139 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, 109 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

1 comments, 3,770 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, 364 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, 120 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, 103 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, 87 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, 136 reads

Posted in SQLAndy on 20 August 2014

Newer posts

Older posts