SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: June 2015

#SQLVacation Finale in the Music City – Nashville, TN


All good things must come to an end and, after logging almost 1400 miles on the road, the #SQLVacation road trip returns to its home city – Nashville, TN, the “Music City”. Eight SQL Server users groups, eight matching blog posts, two hundred t-shirts, and many hundreds of… Read more

0 comments, 679 reads

Posted in Kevin E. Kline on 26 June 2015

Upcoming SQL Saturday Precon Training – Columbus OH

I have an exciting training session announcement! On Friday, July 10th, I will be presenting a full-day training class ahead of the SQL Saturday event in Columbus, OH entitled “SQL Server Virtualization for VM Admins“.  (DBAs are very welcomed too!)

Abstract:  This full-day course is an introduction… Read more

0 comments, 503 reads

Posted in Technobabble by Klee from @kleegeek on 26 June 2015

009 – Sam Vanga - WaterOx Consulting

Reading Time: 2 minutes

A Friend (or Redgate) You Want To Have! In WOxPod!, episode #...

The post 009 – Sam Vanga appeared first on WaterOx Consulting.

Read more

0 comments, 313 reads

Posted in WaterOx SQL on 26 June 2015

The Whole Pie

Today should be such an exciting day, the day the speakers are announced for the 2015 PASS Summit. But as someone who has been involved with the process for the last 6 Summits, it’s a day that I usually turn my Twitter feed off because there’s always those one or… Read more

4 comments, 381 reads

Posted in SQL Swimmer on 26 June 2015

PASS Summit Selection Process

I was thinking today about why I submit sessions to speak at the PASS Summit.

My first summit was in Denver back around 2006 or 2007. We (my boss and me) saw an ad for it on SQL Server Central. We enjoyed every minute of the Summit and… Read more

1 comments, 368 reads

Posted in The Smiling DBA on 26 June 2015

SQLSaturday #410 - Chattanooga, TN - This Weekend!

Kicking off the SQLSaturday#410 event down in Chattanooga, Tennessee, is the Pre-Con event Tune Like a Guru, by SQLGuru Kevin Boles, covering a wide array of topics that form the backbone of my SQL Server performance analysis and tuning work. As a long-time relational engine consultant Kevin has repeatedly found… Read more

0 comments, 856 reads

Posted in Pearl Knows on 25 June 2015

Changes to the 2015 PASS Board Elections

PASS just posted Changes to the 2015 PASS Board Elections based on feedback from the 2014 NomCom. I was part of that team, so now that the process is complete I want to add some comments on the process and the results. They are, of course, my opinion only –… Read more

0 comments, 363 reads

Posted in SQLAndy on 25 June 2015

SSC Editorial: Culture Clashes and Arrogance

I’m a little late posting this, Culture Clashes and Arrogance was featured on June 17, 2015. One of my favorites for the lessons I learned that led to writing it. Oh, things I wish I had learned much sooner!

Read more

0 comments, 398 reads

Posted in SQLAndy on 25 June 2015

Top 3 Questions Before Submitting to a SQL Saturday

Hello Dear Reader!  We are coming up upon the 9th SQL Saturday for Orlando.  Orlando is where SQL Saturday began, and the home to some pretty amazing speakers.

We, the SQL Saturday Orlando Team, are hard at work getting ready for the event.  Our Call for Speakers ends…

Read more

7 comments, 665 reads

Posted in SQLBalls on 25 June 2015

24 Hours of PASS: The Data Loading Performance Presentation – Slide Deck and Scripts

Thanks to everyone who attended my 24 Hours of PASS session, The Data Loading Performance Presentation.

It was a lot of fun taking part in such a special event.

The slide deck and scripts I used in the session can be downloaded here.

The post 24 Hours of PASS:… Read more

0 comments, 543 reads

Posted in Matan Yungman on 25 June 2015

ExpressProfiler: say "Hi!" to new developer!

I glad to introduce new member of Express Profiler team - Chris Moore!
He has many ideas and eager to implement them.
Welcome onboard, Chris!

Read more

1 comments, 446 reads

Posted in SQL Code Guard on 25 June 2015

SQL Azure has T-SQL Jobs - Well Almost

SQL Azure has T-SQL Jobs - Well Almost
JUNE 25, 2015

One thing that has been lacking in Azure SQL Database is the ability to write database jobs in Transact-SQL. Recently, Microsoft has introduced T-SQL database jobs this functionality in Elastic Database Jobs. This article will talk about the…

Read more

0 comments, 2,508 reads

Posted in Pie in the Sky on 25 June 2015

SQL Server Infernals – Circle 2: Generalizers

Object-Oriented programming taught us that generalizing is a good thing and, whenever possible, we should do it. Complex class hierarchies are a good way of reusing code, hitting the specialized classes only when a special implementation is needed.

In the database world, the concept doesn’t play exactly well.

What they…

Read more

1 comments, 783 reads

Posted in SpaghettiDBA on 24 June 2015

oPASS June 2015: Using BI Power tools to visualize your SQL Infrastructure with Rodney Landrum

The next oPASS meeting is tomorrow night (June 25, 2015):

DBAs do not always have time to work with some of the amazing visual data tools that are becoming common place now for analysts. In this presentation I will show how in just a few very easy steps you can…

Read more

0 comments, 305 reads

Posted in SQLAndy on 24 June 2015

Working at Microsoft – A Year in Reflection

Last year after starting my new job with Microsoft as a Senior Consultant I wrote an article about my interviewing experience with many companies during my tenure at my last employer (Click here for article).  I realized it is now time to talk about my journey to Microsoft. It has…

Read more

1 comments, 597 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 24 June 2015

Seeking Full Day Seminars For The Friday Before SQLSaturday Orlando 2015

We’re planning to run one or two (or maybe even three) seminars (aka pre-cons) in conjunction with SQLSaturday Orlando 2015. What are we looking for?

  • An interesting topic. I know that’s vague, so let’s say we want a topic that will be of interest to 15+ people willing to…

Read more

0 comments, 381 reads

Posted in SQLAndy on 24 June 2015

Why does sqlpackage.exe not compare after the pre deployment script has run?

It isn't a Pre compare script

When you use SSDT to deploy your dacpac, a pre deployment script lets you run some T-SQL scripts before the script which brings your database up to date with your dacpac.

The important thing to note is that the process is:

  • sqlpackage compares the…

Read more

0 comments, 695 reads

Posted in Ed Elliott's Sql Developer Blog on 24 June 2015

Adding Extended Properties to a Table

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I had the need recently to get put an extended property on a table in a database. I could easily have done this in SSMS, and have used… Read more

2 comments, 2,942 reads

Posted in The Voice of the DBA on 24 June 2015

Some simple examples of querying xml with sql

XML is a beast if you've never tackled it. Here are some simple examples of what I discovered as I experimented and walked through obtaining values out of a XML column.

Read more

0 comments, 2,822 reads

Posted in Sheldon Hull on 24 June 2015

Use 100% Fill Factor on Insert Only Tables

SQL Server has the concept of fill factor for leaving extra space in pages to reduce the number of page splits. If you picture library shelves, it’s like leaving space for a couple new books on each shelf. It’s a trade-off though, putting in that space may reduce page splits… Read more

0 comments, 477 reads

Posted in SQLAndy on 24 June 2015

Newer posts

Older posts