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

SQLBalls

Bradley Ball is a MCITP SQL 2005 & MCTS 2008 DBA with over 10 years of IT experience. Bradley spent 8 years working as a Defense contractor for clients such as the U.S. Army and The Executive Office of the President of the United States. He is currently a Sr. Consultant for Pragmatic Works. He has presented at SQL Saturdays 62, 74, 79, 85, 86, 131, for the MAGICPASS & OPASS SSUG’s, SQL Rally 2011 & 2012, SQL Dev Connections 2012, the PASS Summit in 2011, and is scheduled for the PASS Summit 2012 and SQL Live 360 later this year. He recently finished Chapter 14 of Expert SQL Server Practices on Page & Row Compression and can be found blogging on http://www.sqlballs.com.

PASS DBA Virtual Chapter Deck and Demo's Live

Hello Dear Reader, I wanted to say a quick Thank You to the PASS DBA Virtual Chapter for having me  today.  My Deck and Demo's are up on the Resource Page.  Thank You to the 150 people who took the time to attend as well!  We couldn't do this…

Read more

1 comments, 245 reads

Posted in SQLBalls on 25 October 2012

PASS DBA Virtual Chapter Trimming Indexes, Getting Your Database in Shape

Hello Dear Reader!  Tomorrow at 12 noon eastern I’ll be presenting for the PASS DBA Virtual chapter, click here to sign up for the meeting.

If you aren’t a member of/or familiar with PASS it is the ProfessionalAssociation for SQL Server.  PASS put’s together great things for us…

Read more

4 comments, 271 reads

Posted in SQLBalls on 23 October 2012

DBA Study Guide


http://www.flickr.com/photos/caledonia09/4999119065/

 Hello Dear Reader, over here at Pragmatic Works we’ve been growing like weeds.  For the most part we are looking for Sr level people for Sr. Level positions.  Part of that process is interviewing.  Going for a job as a Sr. Consultant is a bit different than going…

Read more

3 comments, 1,330 reads

Posted in SQLBalls on 18 October 2012

SQL Saturday 151 Interview: Stacia Misner





Hello Dear Reader SQL Saturday 151 is just around the corner.  If you haven't registerd there is still time to sign up now, click here!

Tomorrow kicks off with our Full Day Pre-Con's at the with Kevin Kline(@kekline | Blog) of Quest Software and Stacia Misner (

Read more

0 comments, 481 reads

Posted in SQLBalls on 27 September 2012

Please VOTE for Me: PASS Summit 2012 Lightening Talks




http://www.flickr.com/photos/cyndydoty/2087680308/
Hello Dear Reader the PASS Summit is approaching and with that the program committee sent out a request for Lightening Talk Submissions.  Last year I was able to give a lightening talk, 24 a 5 minute Horror Story, about one of my worst on call shifts ever that…

Read more

0 comments, 295 reads

Posted in SQLBalls on 20 August 2012

SQL Saturday 151 BI Pre-con: Stacia Misner




Hello Dear Reader, SQL Saturday 151 Orlando is picking up steam.  The Pre-Con’s have been named and they are fantastic.  SQL Saturday Orlando is always a big event, the schedule has been posted, and the planning is well underway.  First stop the BI Pre-Con Featuring Stacia Misner(@StaciaMisner|Blog

Read more

1 comments, 345 reads

Posted in SQLBalls on 16 August 2012

Database Certificates and the X.509 Standard



 Hello Dear Reader, I came across an interesting discovery about a year ago and realized I’d never written about it.  I’ve done a lot of work with encryption and mainly Transparent Data Encryption.  I’ve got a presentation that I’ve given on the subject that I presented at SQL Saturday’s,…

Read more

2 comments, 360 reads

Posted in SQLBalls on 14 August 2012

Database Corruption, Transparent Data Encryption, and Trace Flag 5004


This one comes straight from the email bag.  A friend recently had a problem, they were placing TDE on a database and the encryption scan had stopped at state 2 percent_complete 0. I'm bouncing around the Charlotte NC airport facing some plane delays, and I thought what better time than…

Read more

0 comments, 1,182 reads

Posted in SQLBalls on 13 August 2012

How to Data Compress Varchar(MAX)



I talk a lot about compression.  I’ve blogged a pretty decent amount on it as well.  One of the things that often confuses people is what can and cannot be compressed.  There is a list of data types that can be Row Compressed.  That list is different between each SQL…

Read more

2 comments, 1,165 reads

Posted in SQLBalls on 8 August 2012

Book Review: On Writing A Memoir of the Craft by Stephen King




I just finished this book.  Literally.  Sitting on an airplane in route from Orlando to Charlotte NC.  I got up out of my seat, fetched my computer just so I could start writing.  It took me two weeks to finish.   I was busy, but I enjoyed every moment I could…

Read more

6 comments, 295 reads

Posted in SQLBalls on 7 August 2012

How to Find Bad Page Splits


http://www.flickr.com/photos/brickapolis/5474835288/


I was working with a friend last week, doing SQL related teaching and tune ups.  Earlier this week I had received an email from them regarding unusually high page splits they were receiving after deploying new code, upwards of 800 per second!

This sounds really bad at first glance,…

Read more

4 comments, 1,890 reads

Posted in SQLBalls on 6 August 2012

Differences in the Null Bitmap between SQL 2005 and 2012


Hello Dear Reader, I’ve been working on a series for BIDN.com, the Business Intelligence Developers Network, on how to read a Data Record.  I’ve always wanted to take the time to go rummaging around in the internals of SQL Data Records and this was my shot to do it. …

Read more

0 comments, 266 reads

Posted in SQLBalls on 5 July 2012

SQL 2000 TIPS AND TRICKS DECK AND DEMOS

Hello Dear Reader today I'm going to be presenting on SQL 2000 Upgrade tips and tricks for Pragmatic Works Training on the T's.  The slide deck and Demo's are live on the Resource Page so please head over there to grab them and let me know what you thought!

Thanks,

Read more

0 comments, 304 reads

Posted in SQLBalls on 28 June 2012

Cross Database Views and Schema Binding


One of the most interesting things I've found as a DBA is learning about features in other RDBMS platforms.  Sure we all work with and love SQL Server, but quite often there are features that you hear about that you learn about that make you go, "Wow, wouldn't that be…

Read more

1 comments, 418 reads

Posted in SQLBalls on 31 May 2012

MAGICPASS Tonight It’s All About Encryption


http://www.flickr.com/photos/shuck/3971270079/

Tonight I will be live in front of my home town crew at MagicPASS, lead by the one and only Kendal Van Dyke (@SQLDBA|Blog) sponsored by our Friends over at Idera, and located at the Disney Vacation Club in beautiful Celebration Fl.  If…

Read more

0 comments, 145 reads

Posted in SQLBalls on 16 May 2012

SQL Rally Deck's and Demo's Up

Hello Dear Reader!  I'm coming to you live from the wonderful SQL Rally in Dallas Texas.  I have two sessions today, and the Slide Deck's and Demo's are live on the Resource Page.  Feel free to download them and see if you'd like to come join me, or download…

Read more

0 comments, 97 reads

Posted in SQLBalls on 10 May 2012

Thank You to the People That Get Us There



http://www.flickr.com/photos/saygoodie/4548042971/

Hello Dear Reader starting today out in Dallas Texas at the Dallas Convention Center is the Second Annual SQL Rally.  This year Sri Sridharan (@SQLRocks | Blog) and a cast of many other volunteers, click hear to read about these great volunteers, have been hard…

Read more

0 comments, 133 reads

Posted in SQLBalls on 9 May 2012

T-SQL Tuesday #30 TOP 5 Rules for the SQL Community *Screw Ethics


Chris Shaw (@SQLShaw|Blog) is hosting T-SQL Tuesday this month.  It has been a while since I participated and this month sounded really interesting.  So time to dust off the keyboard and get back in!  So Chris What are we writing on?

For this month’s t-sql Tuesday…

Read more

0 comments, 126 reads

Posted in SQLBalls on 8 May 2012

SQL Saturday 130 Deck & Scripts Live

Hello Dear Reader, greetings from SQL Saturday 130 in Jacksonville.  This is just a quick post to say that the slide Deck & Scripts are now up and on the Resource Page, I'll follow this up next week with a longer post reviewing the event.  Click Here for the Resource…

Read more

0 comments, 301 reads

Posted in SQLBalls on 28 April 2012

Newer posts

Older posts